Viewing 15 posts - 1,861 through 1,875 (of 6,216 total)
Seems like there should be an easy way. One way would be to check for a row in MSdistpublishers I think.
Andy
July 24, 2003 at 5:48 pm
Pkey clustered? Dropping PK and/or cluster first or last?
Andy
July 24, 2003 at 5:42 pm
July 24, 2003 at 3:45 am
Patience! lol
Never tried. Think pass through will work if you have the same login/password, but typically you get a prompt, not sure there is a way to enter it ahead...
July 24, 2003 at 3:44 am
Look at the proc and see if the params match the subscriber schema. Most often it happens because someone changes something on the subscriber, not understanding the impact. Reinitialzing the...
July 23, 2003 at 4:16 pm
That's a nice trick, wish I had known it a few months earlier!
Andy
July 23, 2003 at 4:15 pm
Are you sure it's the number of tables and not something else? I dont have a db with 2k tables so you might be dead on, but good to check...
July 23, 2003 at 4:12 pm
Not sure I agree about the locking mechanism being a bad practice. Most modern apps are designed to work without a constant connection (very optimistic locking), so there is no...
July 23, 2003 at 4:11 pm
Anything with similar power will probably have similar liabilities. I'd recommend against Query Analyzer, for some reason users find it pretty daunting. When you say edit, is it just find...
July 23, 2003 at 4:09 pm
No good books that I've seen. Usually happens because pending transactions have been picked up and applied. Query msrepl_command to see what is open, or sp_browsereplcmds (I think).
Andy
July 23, 2003 at 4:06 pm
July 23, 2003 at 4:04 pm
Should not be replication. Query sysprocesses to see anything connected to that db.
Andy
July 22, 2003 at 9:51 am
I've got it on my list, we do have a lot of questions about it. Probably see something in the next couple weeks. I'll post a note here when its...
July 22, 2003 at 9:50 am
Glad you found the article helpful. We have a good bit of other DMO information here.
Andy
July 22, 2003 at 9:49 am
Used for data integrity. Not going to make joins faster, indexing is where you get speed - if anything foreignkeys may slow down operations slightly. You can update/delete rows using...
July 22, 2003 at 9:47 am
Viewing 15 posts - 1,861 through 1,875 (of 6,216 total)