I would agree with the post above.

But i had to do that.

We did a full backup on the old server, restored it to the new server and left...

See, that is the danger of titles. They don't know the SQL Server technology as well. They don't know the underlying hardware, network, ect. The DBA team...

thank you very much. I will be reviewing and testing this over the next few days.

I will post updates and my final solution.

Joe

I am looking at various DMV to see when there is activity. Pointing out when there is activity is easy. Punching holes in the data is the hard...

I have found that the number of fields in the xml field vary from 50 to over 300. I am creating dynamic sql to add the fields to a...

thank you! I will use that and start from there.

The field containing the xml code above is a text field. Not sure if that matters at this point.

CREATE TABLE [dbo].[ABC_forms](

[f_int_id] [numeric](9, 0) NOT NULL,

[e_int_id] [numeric](9, 0) NOT NULL,

[f_type_in_id]...

We try to disable/remove SA every where. You can also create a AD service account that way you have a user that can be used every where and...

I came into a situation where the number of dba is 3 and the number of production systems alone is over 600. I was pursueing going down the path...