dbTalk Databases Forums  

Is (local) always default instance

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Is (local) always default instance in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hlop2002@hotmail.com
 
Posts: n/a

Default Is (local) always default instance - 12-12-2006 , 02:53 PM






Quote from a book:

Using (local) for the server name ensures that this package can be
easily migrated from a development computer to a production computer
without editing the DTS package, because this connection object will
always attempt to connect to the default SQL Server instance on the
computer on which the package is executed.

Q: Is always (local) - default instance?

Is there are possibility to use (local) as poiter to itself?

Thank you,

Volodia.


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Is (local) always default instance - 12-12-2006 , 03:32 PM






Hello hlop2002 (AT) hotmail (DOT) com,

Yes (Local) is the default instance as is localhost

(local) = Named Pipes
localhost = TCPIP




Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
Quote from a book:

Using (local) for the server name ensures that this package can be
easily migrated from a development computer to a production computer
without editing the DTS package, because this connection object will
always attempt to connect to the default SQL Server instance on the
computer on which the package is executed.

Q: Is always (local) - default instance?

Is there are possibility to use (local) as poiter to itself?

Thank you,

Volodia.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.