Hi

I just randomly clicked on this post and now I'm really glad I did. The resources mentioned are awesome. I regret that I didn't post something like this when I...

Hi

Don't know if this is a stupid idea (you are welcome to point and laugh) but it might work...

- Log the errors into a table

- write an on insert...

Hi

Consider using the Who is Active v11.11 script from Adam Machanic. It has helped me a lot in the past.

Hi

Check out Redgate SQL monitor software. Very easy to set up and use and can monitor everything you mentioned.

Hi Andrew, yeah thanks that makes sense. It must be new in 2012 I don't see it in any of my 2008 boxes.

Thanks again.

Hi

This link might help:

http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

I will check the collation, thank you for the suggestion.

This is exactly what I was looking for thank you!!

This works perfectly inside a sql Task.

By running the command in your post I found out that my .mdf and .ldf files were read only so it did help me.

Thank you!

Here is how I do it:

"C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe" /S 127.0.0.1 /E /N dtspackagename

ah.. Understood.. Thanks

you can make it a uniqueidentifier field (GUID)

http://www.dailycoding.com/Posts/generate_new_guid_uniqueidentifier_in_sql_server.aspx

Hi

I know this is an old post but I had the same problem and we run a SAN an VMware so I thought it's related to that but then I...

Run this in SSMS

USE yourDB

GO 1000

When the command succeeeds you will be able to put the db back into multi user mode.

http://blogs.msdn.com/b/dfurman/archive/2012/01/20/getting-out-of-single-user-mode.aspx

Thanks for the help everyone.

I created a test db, backed it up restored it on the mirror while making changes on the principal and it caught up fine on the...