I agree, but the effects with regard to transactional replication are...

Thanks

Sudhir Dwivedi (9/20/2011)

1. What do you mean by pausing?

2. Read from this section from BOL:

If database mirroring is removed completely, the mirror database...

The ASYNC_NETWORK_IO wait type is associated with either a calling application that is not processing results quickly enough from SQL Server or is associated with a network performance issue.

Thanks

Chris

I found that the backup compression in SQL Server 2008 is better than the Redgate Backup tool we used to use. Even if the compression was not quite as...

I will try and dig out some scripts with examples, I used to have one that would script all objects from every user database on an instance of SQL...

It ships with SQL Server 7 and 2000 and is an undocumented executable. Link to resource below;

http://www.sqlserverclub.com/articles/use-scptxfr-to-schedule-sql-server-database-creation.aspx

Thanks

Chris

I love the scptfxr utility in SQL 2000, It made scripting full databases and individual objects easy!

create a directory of C:\Powershell on the server

copy the attached scripttables.txt file into the directory

rename scripttables.txt to scripttables.ps1

run powershell as an administrator

type sqlps and press enter

paste the below and...

This may be a Kerberos delegation issue.

In Active Directory / properties of the user account / Delegation Tab -Is the account set to "Trust this user for delegation...

Check the database mirroring monitor and connectivity between all parties (principal, mirror, witness). Check that the endpoints are started. Once the problem has been found and fixed the...

As Perry said, get it right first time. I learned this the hard way 🙁

Classic answer but in this case it is true "it depends". What version(s) of SQL Server are you using?

Thanks

Chris

TABLEDIFF is for use on a server in a replication topology. It is used to determine if published data for table articles at the Publisher and Subscriber are not...

Install the evaluation version, save all your scripts which you use during the trial, uninstall the evaluation and install SQL Server 2008 R2 Developer.

There should be no problems caused by...