This for a user logged in via VPN. I have been able to log in locally as this user and it works fine. She has created a very simple report....
The following insert query is taking around 7 minutes to handle 4000 rows. The select runs in less than a second. At the end of the run it gets a...
When one of our users clicks the ReportBuilder button, it asks him if he wants to run the installation, then nothing seems to happen. There are no...
I have a task where I need to call about 7 stored procedures for each company in our database. The stored procs need to be called in a different...
I have configured Reporting Services on 2 servers, on one everything runs fine and reports can be generated. On the other, I get the following error...
We have an issue where a COM+ component is calling a Stored Procedure in SQL 2000. The Stored Procedure makes a call to a Linked Server table on a...
I get an error when I try to run the following comand in 2005 exec sp_MSForEachtable @command1='select count(*) from ''?'' ' the error is Msg 102,...
We are about to convert to SQL Server 2005 EE on a new server machine. The question came up about hyper-threading and how it can affect performance....
We are having a problem when doing a Select count(*) on a table. The result returns the wrong number of rows. When I do a select * on the table it...
Separate names with a comma.
