Viewing 15 posts - 2,011 through 2,025 (of 6,216 total)
Anything that helps SQL use a previously compiled query plan will help. You can accomplish much the same thing by using sp_executesql and parameterizing the query. If you're just running...
June 23, 2003 at 12:21 pm
Logical names don't matter other than for restore. The right way (to me anyway) to make a copy is to run the backup, then restore using the 'with move' to...
June 23, 2003 at 12:13 pm
Afraid I don't pay much attention to that space. If you find one please post, Im sure there are others that share your interest.
Andy
June 23, 2003 at 11:14 am
Different MDAC maybe. Got the error logging turned on? Might be worth a call to MS if you're in a hurry.
Andy
June 23, 2003 at 10:49 am
If you can identify the rows, you could manually do the inserts/deletes to the subscriber, then update all affected rows on the subscriber to let the changes propagate. Are you...
June 23, 2003 at 10:48 am
I agree that security is getting tougher (wait, it was always tough!). I'm hoping that the tool vendors will fill in the gaps. Locking down the enviroment is fairly mechanical,...
June 23, 2003 at 4:31 am
June 23, 2003 at 4:23 am
Take a look on here and on MSDN for information about the ADO stream object. Getting stuff in/out is not bad.
As for why, the biggest reason I do it is...
June 23, 2003 at 4:23 am
Not sure I agree about not backing up to same drive. You run the risk of it not getting pushed to tape no matter where the backup resides. A better...
June 23, 2003 at 4:21 am
Correct. As long as the drive letter/path are the same, it works.
Andy
June 23, 2003 at 4:17 am
That's a better answer. Bill, if you do the revokedblogin, you have to reset the permissions. SP_Change_users_login will fix the problem more directly. Lot's of information on the site about...
June 23, 2003 at 4:15 am
This one?
If you click on your profile it shows the last few posts.
Andy
June 22, 2003 at 12:03 pm
In general I'd vote for code reuse, but not at the expense of acceptable performance. If a 1 second delay is bearable, why not keep it reusable. Acceptable being the...
June 20, 2003 at 7:08 am
I use XP Pro everyday, no issues connecting to SQL2K SP3.
Andy
June 19, 2003 at 5:25 pm
One way is to script out all the objects using DMO. Another would be to just sto the service, FTP the files directly. Might also look at freeware tools.
Andy
June 19, 2003 at 5:24 pm
Viewing 15 posts - 2,011 through 2,025 (of 6,216 total)