This seems to me like it might better be accomplished with DTS. Especially since you want to transform the NULL data to have spaces. Other than what spongemagnet stated I...

The biggest gotcha I have found is if you use linked servers you need to enable DTC manually by changing the security configuration in Component Services. Other than that I...

I don't know if this can be done in t-sql but I would simply use a profile trace in profiler and have the output saved to a file.

Gary Johnson

Microsoft Natural...

This sounds like you are doing something like the following...

INSERT INTO Foo

SELECT * FROM Blah

But Blah and Foo don't have the same number of fields. Classic case of why you...

It would seem to me that if you have all these databases on one machine that the overhead of replication would be overkill. Instead what I would do is decide...

Actually I like them in cronological order like they are now. I'm just used to using other BBS software that allows you to go straight to the last post.

Gary Johnson

Microsoft...

Sorry about that! That's what happens when you don't read what you write!

You need to add a group by clause for the organisation_shortname field.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr....

Although the topic that Steve pointed you to is very nice I think you could do this with a single subquery. If I understand what you want correctly you might...

Hmmm, that is really interesting. I wonder if the query plan is taking the literal string that you have on the like and changing the like to = instead? What...

Without having a schema with sample data to see how the join might work you could probably rewrite this as follows.

SELECT 

   ...

It could actually be a huge difference in effort if you have dynamic subscriptions set up.

BTW: see sp_dropmergearticle in BOL

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

While your replication problems are interesting I'm stumped as to why you didn't just use your subscription table to update the publisher using a simple update query against the subscriber...

I find myself wondering why on earth you would want to do this with your servers!?!

But yes you can restore replicated databases without trouble. We do this all the...

One point to add to this is that you MUST set your rowcount to 0 after the loop! Not doing so will limit all your following queries to the same...

While you can certainly use a recordset to return the value using the connection object I am pretty sure the overhead will be less to use a command object and...