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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2014-11-17 : 18:16:24
|
| Hi,This new 2012 server has a name that's 19 chars long.When I run SELECT @@serverNAME the last 4 chars dont show but in Management Studio, the full name shows.This is a default instance, not named.Should I be concerned, will this cause any issues down the road?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2014-11-24 : 21:07:29
|
| Thank you, Tara. I'll look into this further. It may not be a problem with Windows Server 2012 R2 and SQL Server 2012 though the fact that @@ServerName doesn't return more than 15 chars bothers me. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-11-25 : 12:13:11
|
| Well Windows/SQL 2012 support more, but NETBIOS doesn't. I remember we had an issue on Windows 2008 with a server name over 15 characters. I don't remember the issue, but I remember having to shorten the name. I think it was an issue with a software package though. I'm no longer at that job, otherwise I'd ask around if anyone remembers that issue.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Server Name More Than 15 Characters