Answer Questions
Boricwa SQL CE Merge Replication
Hello All, I have a server with SQL Server 2000 installed on it. I have created a tool that runs on a Pocket PC with SQL CE backend. Multiple clients would be using the tool on diferent Pocket PCs. I would have to use Merge Replication for synchronization and since the Pocket PCs would not have internet / network access, I understand that I would need to use Merge Replication synchronization technique throu ...Show All
StevDobr Fuzzy Grouping: Any success with > 3 million records?
I have tried to process > 3 million Fuzzy grouping records on two different servers with no success. 3 mill works but anything above 4 mill doesn't. Some background: We are trying to de-dup our customer table on: name (.5 min), address1 (.5 min), city (.5 min), state (exact). .8 overall record min score. Output includes additional fields: customerid, sourceid, address2, country, phonenumber Without SP1 installed I couldn't even ge ...Show All
CodeRipper Calculating % in Text Box
Hi I'm On the "Layout Tab" and I'm trying to calculate a percentage in a text box. This works: =((Fields!THIS_QTD_LBS.Value - Fields!PREV_QTD_LBS.Value) This Does Not work: =((Fields!THIS_QTD_LBS.Value - Fields!PREV_QTD_LBS.Value) / Fields!PREV_QTD_LBS.Value) * 100 All I get back when I "Preview" the report is "Error" Why It seems like I should also be able to do the following, but cannot: ...Show All
JustAnAverageJoe what hte use of SQL Native Client??
do every client that execute web application that connected to SQL 2005 need to install SQL Native Client I am having prblem that the client pc that going to access the SQL 2005 through web based application would not able to do so.... thanks http://msdn2.microsoft.com/en-us/ms131002.aspx http://msdn2.microsoft.com/en-us/library/ms130828.aspx http://support.microsoft.com/ kbid=910016 To access data in SQL Server 2005, you mus ...Show All
peejuk Using Current User Name in Report Builder Filter
If I create a report in Report Builder that shows some data connected with usernames (e.g. work items assigned to my team members), how can I filter the report data by the current user In Team Queries I do this by specifying @me but it seems it does not work with Reporting Services ... We don't expose the account that RS uses to issue report model queries against SQL Server. What is it that you're trying t ...Show All
Pedro A. Rico Web Wizard
I used the web wizard to create a html file with specific information. It worked for while and now is giving me problems. I want to stop the process but can't seem to do this. I delete the procedure that the wizard created and still get errors. Can you tell me how to 'undo' what the web wizard did thanks David Ferguson Hi David, I'm not aware of a "Web Wizard" in SQL Server. Can you provide more ...Show All
bnn Formatting text in using Report Designer
Hello, I am designing a report which has some static and dynamic data. The static content is a huge text and I want to highlight certain portions of the text with bold font and in some places with different color. I am using textbox report item to draft the static text. But unfortunately, I am not able to change the font of a portion of the text. If I change the font, by highlighing some text, it changes for all the text in the text box. Can y ...Show All
apclogan Creating a DB script
Somebody knows a tool able to generate DB scripts from a .mdf file SQL Express runs as the Network Services account, which is a limited access account that doesn't have permissions for a number of things, including User Profile directories. If this is a one time operation, I would suggest detaching the database and moving it to a location where you can access it (such as the MSSQL\Data directory), attaching it there and then using Man ...Show All
gongxia649 Can't debug DataFlow Script task
I have debugged a Control Flow script task and everything went as expected. I put a breakpoint somewhere in my script code, press F5 and execution will break there. However, when I try the same in a Data Flow script, execution does not break! Moreover, when I reopen the code right after I closed VSA, the breakpoint is not there anymore... Any help would be appreciated. Regards, Henk For me for the minimum usef ...Show All
Jacques 316 Reporting Services funny
I have a really wierd one here. I have generated several reports that work wonderfully for me but will not work for others under certain conditions. The difference appears to be the fact that I am an author, publisher, etc; and others are just browsers. Now this wouldn't be too bad to resolve BUT, everything works fine as long as I have run at least one report before anyone else runs it. If I do not run a report then anyone in ...Show All
abesaz Print is not allowed in UDF
I want to put some trace in the a UDF, so I put print in the function. IT gave error. Can anyone please explain why this happen. But this work with SPs. Cheers Shimit Hi, this is just simply one of the limitations UDFs take, like not being able to execute something via EXEC or executing a SP in common, or using GETDATE() in functions... HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Ping06 Display UniqueIdentifier's in Output window
Why won’t uniqueidenfiers display in the output window of VS2005 I execute a simple Select * … statement via a stored procedure that contains a column of type guid and it does not display. …yet it works in the SQL Query Analyser! ...Show All
elezegarcia Report/Query Parameters
Hi Group, I'm getting a bit confused as to how Reporting Services work with parameters. I've got a query that uses 8 parameters 4 are optional(i.e is not required). I've applied all the necessary settings and am able to run the report via the Report Designer without inputting the optional parameters and the correct results are returned. However when I deploy the report and try running the report without the optional parameters I get a mess ...Show All
LiveAa Is there any downside having the SQL-server installed on the main server?
Is there any downside having the SQL-server installed on the main/domain server Or should you have a separate server just for SQL Like I said, it depends on the workload of the server, but if there are only sporadic and non heavy workloads on the server you can put it on a exsiting server, but I would always suggest NOT to put it on the domain controller (just from my experiences). Aas far as I can evaluate your situation form my 15000 f ...Show All
nicksmaddog Using result sets from a stored procedure
Is it possible to access the result set returned from a stored procedure For example, begin set @cursor_list = sp_spaceused 'a_table' ...loop through here... end I can't seem to find any information on accessing the "default result set(s)". Returned from a stored procedure. What I really want is the output of sp_spaceused for all tables for a particular user. Thanks Tory http:/ ...Show All