This works. But be careful in your format as Lynn stated.

SELECT convert(datetime,'20061230',105)

The error message (severity level 0) you showed in an informative message. You should not worry abou it. This error has been discussed before on this forum.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=247019

You may have...

The database on your standby server may be different from the database you would like to restore.

It might be a deadlock issue. See the link below.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=89701&SiteID=1

You can check the log history in replication, but not for one transaction.

Steve:

Could you tell me why you wrote "Never turned this on"? My understanding is that it should have its advantage since it is a default setting.

Many thanks in advance.

It is most likely a problem on your own machine. Check your ODBC connection.

Attached please find two links. Hopefully, they are helpful.

http://www.dbforums.com/showthread.php?t=701211

http://forums.databasejournal.com/archive/index.php/t-32271.html

You may use vbscript, which has datadiff function, and combined with the object, filesystemobject.scripting.

I cannot see any relation between checking polling sessions and server crash. Checking polling session only have a little more internet traffic (neglegible from my personal point of view).

To run the tasks on your list, you do not need to have users logged off. However, the objects may be locked while some of tasks are running. Users may...

sysadmin (sa) is needed to configure replication. But if the replication is across servers, you need to have more privilege to access other server. The first thing before starting is to...

I would like to check whether or not the windows cluster is in a good shape. Try to move or failover the nodes and see whether or not the cluser...

JDixon:

I am referring running jobs from the SQL Agent. I knew there is no built-in settings to set priority of jobs.

Please share if you know the detail.

Thanks in advance.

I believe the poster would like to have a standby server not a cluster server. I believe that we can use log shipping. Enterprise edition has this function built-in. If...