Viewing 15 posts - 38,881 through 38,895 (of 39,466 total)
November 20, 2001 at 10:03 pm
The linked server will access based on the rights of the server, not you. You need to check the rights that the server has, so log into the network as...
November 20, 2001 at 7:25 pm
Search your WINNT folder. There should be a sqlsp1.txt or something similar. Find all files changed in the last day and you should find it. It will help clue you...
November 20, 2001 at 7:23 pm
November 20, 2001 at 7:21 pm
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
Viewing 15 posts - 38,881 through 38,895 (of 39,466 total)