May 16, 2007 at 9:34 am
Could anyone tell me what the maximum length of an SQL Server instance name is?
How about an SQL Server cluster?
Are there any difference in SQL Server 2000 and SQL Server 2005?
Where can we get the information?
Any input will be greatly appreciated.
March 11, 2011 at 12:42 am
Hi
This composed name server\instance in old versions could arrive to 30 characters, limited by own SQL table in SQL 2000.
http://support.microsoft.com/kb/310639/en-us
Daniel
May 4, 2011 at 12:13 pm
Please refer to the following links:
http://stackoverflow.com/questions/5260650/max-length-of-sql-server-instance-name"> http://stackoverflow.com/questions/5260650/max-length-of-sql-server-instance-name
http://msdn.microsoft.com/en-us/library/ms143531.aspx"> http://msdn.microsoft.com/en-us/library/ms143531.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2011 at 12:22 pm
Here's Microsoft's data on max-whatever in SQL Server. The one you want is the "Max Identifier Length", if I'm not mistaken.
http://msdn.microsoft.com/en-us/library/ms143432.aspx
I haven't tested instance-name length, but it should follow the rules here.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 4, 2011 at 12:24 pm
I was wrong.
I just tried installing a new instance, and when I went to name the instance, it stopped letting me type when I got as far as "MyInstanceNameIs". That's SQL 2008 R2.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 4, 2011 at 12:51 pm
Browser continues to hang, sorry duplicate post.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2011 at 12:58 pm
You could test like GSquared did and you will find out.
I can't get to machine that I can test at the moment or I would do it.
Regards,
Welsh
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply