Prev: How to Call an SSIS package from SQL-server.
Next: delete a record
From: Mecn on 18 Jun 2010 14:26
hi is sql 2005 named instance is same as sql server virtual server?


From: John Bell on 18 Jun 2010 15:51
On Fri, 18 Jun 2010 14:26:05 -0400, "Mecn" <mecn(a)yahoo.com> wrote:

>hi is sql 2005 named instance is same as sql server virtual server?
>
No they have the convention servername\instancename see
http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspx

If this a virtual server then the SQL Server name could be incorrect
if it was cloned. Check SELECT @@SERVER in a query windows to see if
this is the case. If so then use sp_dropserver and sp_addserver as
detailed in http://support.microsoft.com/kb/303774

Jiohn
 | 
Pages: 1
Prev: How to Call an SSIS package from SQL-server.
Next: delete a record