Thank for this simple view into the world of data type conversion. Would the same thing happen if comparing two varchar's of different width ? (example varchar(30) to varchar(255) )

In my experience the changing of schema owners is not a common practice. I can see this applying more to a QA system. Good information however.

I wonder if making use of XACT_STATE(), within the body of the TRY can help. Something like issuing print statements or logging into a table to see the before and...

A old handy tool you could use, if still around, is Microsoft Visio. I think the earlier before 2005 versions are quite nice. Otherwise you can make do with the...

AS mentioned, file "copy" the certificate you created on prod to QA and register it there. Else you are just creating a different one on the QA system regardless of...

"

"

What problems is this causing exactly ?

from...

Old post , but

Using the tmp table suggested by another, you can use bcp with argument -f, -l for first and last rows from this table. Used in a loop...

"The maintenance installation script that creates all of the stored procedures is over 9000 lines. I am not going to spend the hours reviewing that "

I dont review the...

I'm curious on the solution details. If you have a login already for this one windows account, could you not just...

Many times a developer may model a new stored procedure by copying an existing one as a template. This may leave variables that are not used and calls to other...

AS time goes by and the backup table become larger how will this scale ? Should there be a date cutoff on the Exists clause in the inserts ?

How would...

Very insightfull and easy to read. Thank you.

Insightful , thank you for the information. One comment I do have

"If the database is accessible, take the backup. The backup might be used to restore the data which is...

MSSQL has a similar function, but at the DB level, so we have an associated database to the main one, which contains something like logs and performance monitor data....

Simple and to the point, thank you. Another interesting exercise would be where you have a table partitioned across file groups. It would be interesting to see how restoring (for...