I've found config manager opens a connection - kill it, restart sql service, try again

Hi,

Short of Redgate Data Compare, check this out for generating Tablediff command lines...has saved my bacon a few times, and is surprisingly quick.

(I've got Red Gate tools (which are cool!),...

Hello SQL-ers,

It would seem that the very exact sounding error message is misleading...

"The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier'...

Simple and works is welcome in a complex world 🙂

Assuming you haven't renamed machines (which brought me great pain ! even after sp_dropserver / sp_addserver etc)

I had to enable SQL browser on my SQL express (subscriber) instance, which then...

Transactional replication is what we use for a similar scenario.

Hello all,

I found that number of columns further influenced the rows/page density thinking (sometimes for legacy support reasons we needed to keep an 'award-winningly' de-normalised table)

Small addition to SSC...

All in all, quite a civilised lack of agreement there - I even found the explaination interesting 🙂

My opinion = having regex, bcp, bulk insert, transact..and a copy of excel...