There is nothing stopping you changing the values of the primary keys at either the publisher or subscriber.

You can't change the structure or definition of the primary key at...

This comment should have been posted under QotD for 1 Nov, not 8 Oct.

That said, a transactional replication replicates changes made at the publisher to all the subscribers, not...

It's not a syntax error. The code is valid and executes.

It may well be a logic error, but syntaticaly it's fine.

According to BoL, the method is called ListAvailableSQLServers, not ListAvailableServers. Hence, no such method exists.

Or is BoL wrong?

I've always used CAST(FLOOR(CAST(getdate() AS FLOAT))AS DATETIME)

Watch out if you use round. Floor truncates the floating points so 2004/10/06 16h00 becomes 2004/10/06 00h00.

If however you use round, 2004/10/06 16h00 becomes...

Or if you can't access the second server from the first

Package->Save As

Change the location drop-down to 'Structured storage file'. That way you can save the dts package to the...

What you can try (no guarentee) is to change the collation of the model database. Since that is used as a template for new databases, in theory any new databases...

Thanks, I'll bear that in mind if this happens again.

I had to remove the replication this morning, as I was no closer to a resolution than yesterday and the...

What error did you get? Did SQL refuse to attach the db, attach but mark as suspect?

Check IIS and see if it allows anonymous access

Thanks. That's great

I don't think you can. I spent a day or so looking into exactly that issue. That long string of numbers and letters is a one way hash of the...

Detach the database, delete or move the ldf and then from ent manager attach database. The dialog will note that the ldf is missing. Click OK and db will be...

Could you give us more information? It this an existing replication setup? Are you configuring replication for the first time on these servers? If so, what have you done so...

Wouldn't that also pick up instances of #mytable created by other users?