Viewing 15 posts - 37,231 through 37,245 (of 49,566 total)
MR (8/7/2009)
I can break it up if need be, but majority of my calls are in the 'else' part - basically, the @componentType is null in most of the cases...
It's...
August 7, 2009 at 12:06 pm
The main problem would be with the LSNs. Remove a entry completely and SQL will believe the LSN chain is broken (and it is). Modify the LSNs and suddenly the...
August 7, 2009 at 10:46 am
Anyone really know their way around replication?
http://www.sqlservercentral.com/Forums/Topic766992-146-1.aspx
August 7, 2009 at 10:31 am
Charles Kincaid (8/7/2009)
Richard M (8/7/2009)
Charles, copy-only backups were introduced SQL Server 2005...... See here
None of my 2005 SSMS installs have the magic check box. Not even recent Express instsalls....
August 7, 2009 at 10:25 am
Charles Kincaid (8/7/2009)
I'm looking forward to the 2008 option of taking "copy only" backups that don't crap on my log chains.
Maybe I'm misunderstanding you, but if you're talking about full...
August 7, 2009 at 10:20 am
Alvin Ramard (8/7/2009)
GilaMonster (8/7/2009)
Example:
A maintenance plan should be set up to truncate, shrink, and backup the transaction...
August 7, 2009 at 10:18 am
GilaMonster (8/7/2009)
August 7, 2009 at 10:07 am
What error?
If it's complaining about the DB not been shut down cleanly then you should restore your latest backup.
If you don't have a backup (and why not), have a look...
August 7, 2009 at 9:59 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic767047-391-1.aspx
August 7, 2009 at 9:56 am
Not possible
For someone to even begin to edit the log, the database would have to be detached and they'd have to use a hex editor. I doubt there's anyone outside...
August 7, 2009 at 9:56 am
See this article for posting the exec plan for SQL 2000. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 7, 2009 at 9:47 am
Warren Peace (8/6/2009)
August 7, 2009 at 9:45 am
Do the tables have primary keys? It's required for transactional replication.
August 7, 2009 at 9:37 am
Does the database contain any objects that can be replicated?
What type of replication have you selected?
August 7, 2009 at 9:20 am
The method to decrypt a proc in 2000 does not work at all in SQL 2005.
Google for SQL 2005 stored procedure decryption. You should be able to find a tool...
August 7, 2009 at 9:07 am
Viewing 15 posts - 37,231 through 37,245 (of 49,566 total)