Viewing 15 posts - 38,881 through 38,895 (of 39,456 total)
Is this for all queries? My guess is your driver between the two servers is corrupt and throwing an exception.
Steve Jones
November 20, 2001 at 10:41 am
Is SQL Agent running under a different account? This looks like a security error, or perhaps, the restoration of master may cause issues because the name of the server has...
November 20, 2001 at 10:40 am
November 20, 2001 at 9:58 am
Check network rights. Log in as the account under which SQL is running and see if you can access the file.
Steve Jones
November 19, 2001 at 7:52 pm
November 19, 2001 at 7:50 pm
There are load testing tools from Rational and Quest software, but they can be expensive. Some vendors also "rent" the tool for a test.
Steve Jones
November 19, 2001 at 7:47 pm
You have to manually format it. You can use a table to do this or a complex select statement. If you post what you want, we can try to help...
November 19, 2001 at 7:45 pm
November 19, 2001 at 7:43 pm
There are a few things that can happen. Check the stored procedure in QA. Does it still take 40min?
If so, try sp_recompile on the stored procedure and re-run it....
November 19, 2001 at 3:53 pm
I am not sure what you mean. Can you provide more informaiton, maybe some sample data?
Why not use a CASE statement for the warehouse? I am confused as to why...
November 19, 2001 at 3:37 pm
What about checking syscolumns, information_schema.columns, or even sysobjects.
Steve Jones
November 19, 2001 at 3:36 pm
I am not sure of what else would cause a failure on the SQL side. Networking of course, must be up. If security changes, then that could cause an issue....
November 19, 2001 at 3:33 pm
Keep reading on this site. We are all a collection of DBAs and try to provide guidance and advice.
Please also feel free to email any of the authors and let...
November 19, 2001 at 3:32 pm
November 19, 2001 at 3:30 pm
November 19, 2001 at 1:28 pm
Viewing 15 posts - 38,881 through 38,895 (of 39,456 total)