Viewing 15 posts - 39,031 through 39,045 (of 39,605 total)
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
Don't know if this is a problem as I don't use replication that much. I'll ask around.
Steve Jones
November 19, 2001 at 1:28 pm
Viewing 15 posts - 39,031 through 39,045 (of 39,605 total)