Here are the results:

(1 row(s) affected)

ID TheOutput

----------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1 NULL

(1 row(s) affected)

Thanks so much for such a detailed response, unfortunately that's not the issue here. Setting up a valid proxy account from AD on each of my DB servers is...

Is LocalServer the instance? If so you cannot easily rename the SQL instance after it has been installed...and it's not reccomended either

However, I did read an article once that...

Thanks for your replies, I think I had found it a few days ago but if there is a more preferred/accurate method, I'd rather use it than what I have:

SET...

I've got a related question:

I've already created the publication which contains 31 articles, the next day a report developer said they forget they needed another table added to the mix...

Unfortunately that's what I thought 🙁 Was hoping for something cool and hoping it could load the data from the UNC folder (that contains about 8GB of data from...

Another related question:

After replicating from the 2005 server to the 2008 server, I'd like to replicate to yet another 2008 server. When creating the new subscriber, will I face...

Thanks for the quick replies! 🙂

I will try this out