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 |
|
kool
Starting Member
2 Posts |
 Posted - 2007-02-26 : 02:14:12
|
| Sorry if this seems trivial, but is it allowed to add hyphens in a physical server name?eg: PC-01Will this cause any errors (when connecting from VB to sql server, etc)Thanx. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-26 : 02:23:05
|
| It should be ok but why do it?Will mean referencing the server in square brackets a lot.Much easier to stick to alphanumric names (and underscores).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kool
Starting Member
2 Posts |
Posted - 2007-02-26 : 02:37:41
|
| So that means we need to put square brackets to reference the server?We advised our clients to change the name without the hyphen, but they insisted on using it..;(Ok, thanx for your help! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-26 : 02:52:38
|
| You shouldn't find any problems with VB and sql server but may find some applications that don't like it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Physical Server Name