Suggest copy the ddl or just doing a copy objects with the Import/Export wizard to establish the database on the other server then using the Import/Export wizard you can move...

Please do not cross post. See my response in your other thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=401086#bm401135

Did you check the EventViewer logs to see if anything unusual around the same time in them?

I did this onc and had no issues. Could have been a blcking issue if users were in the system at the time. And it took a great deal of...

If you mean can you start MSDTC without rebooting the server, I don't believe you can avoid.

Sounds like you have a corrupted backup. Do you have another sql instance you can test the restore on?

Too funny.

Description is an extended property and not part of the SQL Language so in truth you cannot use it directly in QA.

-- This is how you add.

DECLARE @v-2 sql_variant...

Parentheses will not be your issue. You also say you have quotes in the name but I don't see that?

Try look for = value and try like 'ABC%' to make...

OK so let me clarify, does the history table include the current pregnancy and does the other include any info on past pregnancies?

Still need more information to understand what you want to accomplish and that is what does each table and value used represent (some look easy to figure out but I...

How does you app code call your Proc? Is it by building a string from it or do you use Paremeter objects. If the later then check the object for...

There are several companies including Red gate and ApexSQL that offer tools to compare database strcutures (including indexes def). But as far as why did you loose the index what...

Do you use Stored Procedures to access the data. If so and you used an Output variable, did you change the variable type there as well. Usually that type of...

Shouldn't be that I recall.