Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-03-16 : 06:22:02
|
| using a bcp command I have to pass in the server name.My server has an instance i.e.server1\instance1I now know how to get the server name but not sure how to get the instance name if there is one.p.s. I am trying to avoid using DMOthanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-16 : 06:52:49
|
This will give you the server_name\instance_nameselect serverproperty('servername')
KH |
 |
|
|
|
|
|
instance name