Viewing 15 posts - 33,391 through 33,405 (of 39,736 total)
Whichever you are more comfortable with. For your own work, or with a small group, I don't think it matters much. For 2005, since most things are SMO NET assemblies,...
December 30, 2005 at 10:18 am
I wish I had a full fledged test system. Maybe I should ask Andy and Brian for one for Christmas next year![]()
December 30, 2005 at 10:16 am
Insert it like any other field at first. To update/rewrite, you'll want to search on this site for WRITETEXT.
December 30, 2005 at 10:14 am
If you use with TRUNCATE_ONLY, you need an immediate full backup.
December 30, 2005 at 10:14 am
This is difficult to do in T-SQL. Recursion is an option and works well in 2005, but I'm wary of it in 2000, plus you might hit a nesting limit.
Check...
December 30, 2005 at 10:13 am
Ah, many people use multiple publications and it works well. Andy has a large box with over 200 dbs, and runs quite a few replications from one master db to...
December 30, 2005 at 9:24 am
December 30, 2005 at 9:22 am
Didn't see the Montana game, but yeah, that stings.
Brett Favre's win might have been mine, but I didn't see that one either.
December 30, 2005 at 9:19 am
Apologies. The original question was changed later by the submitter and I was supposed to switch around the answers. I've added back points for 3 and 4 answers.
December 30, 2005 at 9:16 am
osql from the command line with a script might be easier, but it's not T-SQL.
December 29, 2005 at 10:46 pm
I think it would help, but are you talking about using other servers? Not sure you can have multiple publishers on one instance.
December 29, 2005 at 10:45 pm
Agree. Call PSS and don't mess around with this data.
December 29, 2005 at 10:44 am
Let us know how it works. I put it on my laptop, but a little chicken to put it into production ![]()
December 29, 2005 at 10:43 am
Indeed. I'd think if you got over 10k tables you'd be asking for trouble.
December 29, 2005 at 10:42 am
You might have forgotten users. Search sp_help_revlogin on Google for the script to help you move users. It's an MS KB item.
December 29, 2005 at 10:42 am
Viewing 15 posts - 33,391 through 33,405 (of 39,736 total)