Viewing 15 posts - 37,621 through 37,635 (of 49,566 total)
You've got the 'automatically fix minor errors' option checked. Uncheck it, no job should automatically be running a repair statement, it's a stupid option that fortunately was removed in SQL...
July 16, 2009 at 9:55 am
If someone gets hold of the data file they don't need to hack the windows password to use a trusted connection. They just have to attach the data file to...
July 16, 2009 at 9:50 am
Agreed, though I have seen a case where someone got an error when trying to create an index because that limit had been hit. Table was a denormalised mess with...
July 16, 2009 at 9:42 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2009 at 9:37 am
Do you have a backup of master?
How did you rebuild the master database and how did you verify that it really did get rebuilt?
July 16, 2009 at 9:27 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic753955-5-1.aspx
July 15, 2009 at 10:42 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic753955-5-1.aspx
July 15, 2009 at 10:39 pm
Excellent. I suspect, in this case, the immense amount of log entries that SQL had to 'unmark for replication' was the reason that the simple create-drop failed.
You should now be...
July 15, 2009 at 10:26 pm
Before you run all that, can you run this in the DB in question.
exec sp_helppublication
If it returns anything other than the name of your snapshot publication, can you paste...
July 15, 2009 at 3:29 pm
Odd. That normally works perfectly. Think this is first case that I've seen where it hasn't.
Try creating the transactional publication again then, instead of dropping it from the gui, run...
July 15, 2009 at 3:20 pm
Ken Watson (7/15/2009)
July 15, 2009 at 10:25 am
Ok. What you've got there, and I really wish I knew how this happened, is a partially created transactional replication setup. The fix is fairly simple.
Create a transactional replication publication.
Add...
July 15, 2009 at 9:14 am
Do you have transactional replication configured on this database, or is it just snapshot replication?
July 15, 2009 at 8:35 am
CheckDB doesn't take locks regardless of what database options are on or off. The point of torn pages, which you would know if you'd read the link I provided for...
July 15, 2009 at 8:11 am
Mel, can you try rebuilding that index, see if it makes a difference.
July 15, 2009 at 8:09 am
Viewing 15 posts - 37,621 through 37,635 (of 49,566 total)