Viewing 15 posts - 39,136 through 39,150 (of 39,717 total)
greyed out in the help in Enterprise Manager? or in the BOL?
Probably you are missing files. If you let me know where, I will search my server and post a...
November 20, 2001 at 7:20 pm
November 20, 2001 at 7:19 pm
Not clear what you mean (JAw1977)? You want to write a stored procedure that will insert what? The data from Tables 2 and 3? You would do a join from...
November 20, 2001 at 7:18 pm
November 20, 2001 at 7:18 pm
I'll try to be clear and concise.
Public and System are roles, similar to groups in network administration. You can assign rights to either, both, or neither. I recommend neither and...
November 20, 2001 at 7:15 pm
Try making a connection from Control Panel | Admin Tools | Data Connections. This should be the same driver.
Steve Jones
November 20, 2001 at 11:45 am
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
Viewing 15 posts - 39,136 through 39,150 (of 39,717 total)