Viewing 15 posts - 39,211 through 39,225 (of 39,800 total)
Alternatively, you could install SQL 2000 and run it in v65 compatability mode. that will make the database run the same, though not the server.
Steve Jones
November 21, 2001 at 9:56 am
Thanks for the followup. Let us know what happens and I am sorry we could not be more help.
Steve Jones
November 21, 2001 at 9:54 am
One thing: Use roles!!!!!
http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp
Steve Jones
November 20, 2001 at 10:08 pm
I think I understand. You want to give a user rights to bulk insert data using a stored procedure, correct?
If so, I would create a permanent table and use BULK...
November 20, 2001 at 10:06 pm
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
Viewing 15 posts - 39,211 through 39,225 (of 39,800 total)