That's the only way that I am aware it can be done.

Because of the registration of the data files in the Master, you can just rename files without consequences. ...

It would be helpful if you would post the Query in its entirety and more of the results set. I don't see anything in the post that you have...

In this case you can use Triggers and a Database Link. The link will allow you to refer to the Database located on the other Server just the same...

I'm not sure why you would want to do that, but I expect that MSSQL would not let you do this. You've already go the Server installed, add an...

Funny how that works out. I am pleased to hear that the solution I posted was further recommended by M$

I posted that some time ago and it seemed that...

[font="Tahoma"][/font]

Masking the problem is probably not the best way to go. Sure, this modification is working for this application, but now your users are waiting up to 10 seconds...

What we found was related to a security feature added in Windows 2003 Service Pack 2. It is something called TCP Chimney. It all cropped up after applying...

We are still working on this one.  From what we have been able to discern, it appears to be the combination of SQL 2005 SP2 and 2003 SP2.  The investigation...

By far this is the most frustrating issue that I have been dealing with lately!!

We have a number of Services that connect to...