Cheers guys.

I'm going to suggest we add the columns to the end of the table as it is not worth the hassle adding them in a given order in the...

One thing you may want to do is check the Collation of every database on every server as some databases may differ from the server collation?

Thanks for the replies.

We are going to live with it as it is so messy to rollback. As I say there is nothing clever like CLR/Complicated TSQL...

Cheers guys. That's what I was thinking but I didn't know whether I would be best to rollback to SP2 which is messy!!

The other Devs are all on SP2,...

The TCP/IP protocol settings are the same as another server which is listening on the default port for the DAC?

Hi John.

The port is set to 0 which is the default.

Thanks for your help John, but I'm still no wiser on why it isn't listening on port 1434?

Sorry John. I am just wondering why it is listening on a different port than the default port?

I haven't tried to use it.

Hi John.

The DAC is enabled by default. I think you are getting confused with enabling the DAC to allow remote connections via the Surface Area Control Tool?

Regards

Carl

Here is some more information about it:

http://www.microsoft.com/technet/security/advisory/961040.mspx

and some further reading:

http://blogs.technet.com/swi/

Regards

Carl

It could potentially be the incorrect column delimiter in the file?

Hi,

Take a look at the following link it explains that you need to detach and re-attach the model database after starting sql server in minimal mode:

http://support.microsoft.com/kb/224071.

I have found...

😉

Thanks again David.

I think I know what you mean. So the security fix has been developed against the base build of SQL Server 2005 SP2. As oppossed to the Cumulative...

Thanks for the replies.

Regards

Carl