0
votes
2answers
190 views

Concat issue has me perplexed

MSSQL 2005 Server Workgroup. I have a database that is serving as a "Warehouse" for another, older, slower cobol database/application. I've recently moved the warehouse from one SQL Server instance ...
1
vote
2answers
953 views

How to make inter-database queries with dynamic SQL Server database name?

We have two database servers with SQL Server 2005, with two databases each. The secondary server have two SQL Server instances: one for development and other for reporting. Both instances on secondary ...
11
votes
2answers
4k views

How do I change the instance name in MS SQL 2005 without installing a new instance?

I have an instance that really has nothing on it, it's merely been installed (it was intended for one project, but that never actually got done on this server, the project was done in duplicate on ...