Viewing 15 posts - 2,776 through 2,790 (of 6,216 total)
Cool, thanks for finding it! Gotta find a way to avoid the stop/start service thing though.
Andy
December 30, 2002 at 6:11 pm
Should checkpoint automatically unless you have the recovery interval set pretty high, default is about a min.
Andy
December 30, 2002 at 1:53 pm
I'll have to look for where I saw the rebuild log originally, but I think you do have to do the step of creating a db, stop/start service, other voodoo.
Andy
December 30, 2002 at 11:04 am
December 30, 2002 at 11:03 am
Dont think so. Not sure if you can't hook in, but have not tried it. Might be easier to build an app that just gives you what you need. Not...
December 30, 2002 at 11:02 am
Its used for storing diagram info. Seen Brians article:
http://www.sqlservercentral.com/columnists/bknight/transferdiagram.asp
I read somewhere that when DTS was being designed it was done by a team outside SQL, so the tables got treated...
December 30, 2002 at 9:03 am
Somewhere on MSDN they have a couple articles about building MMC add-ins. Not a simple process, but doable I think. If you're looking to put a lot of time into...
December 30, 2002 at 8:59 am
Triggers fire per transaction, not per row. You need to either use a cursor (not the best idea) to apply your code to each record one at a time, or...
December 30, 2002 at 3:55 am
It can use either. Easiest way to see which you're using is to check the job for the distribution agent. It has the option to specify a userid/password if you...
December 28, 2002 at 5:46 pm
Passwords are stored as varbinary in sysxlogins in master, no big deal to either move, or you can use sp_addlogin, it has the option to move a password already encrypted....
December 28, 2002 at 5:41 pm
Interesting task. It's pretty low intensity (how many changes can their be?), not sure it's worth consolidating and replicating. I think I'd approach this initially from the one publisher (db)...
December 28, 2002 at 10:10 am
Cant think of a better way so far. If I can restate the problem - you've got 8 servers that each replicates to a reporting server, on any of those...
December 28, 2002 at 6:17 am
Sysprotects maybe? Getting your login SIDs synced up front will save a lot of hassle, beyond that not bad to write a job to sync the data. Dont know if...
December 27, 2002 at 12:26 pm
You can try DBCC Rebuild_log, one of the many undocumented ones. Have it on my list to experiment with, have not done so yet.
Andy
December 27, 2002 at 12:24 pm
I think its still in pre-release and under NDA. You can post to the MS groups for now, once released we'll have some coverage.
Andy
December 27, 2002 at 12:23 pm
Viewing 15 posts - 2,776 through 2,790 (of 6,216 total)