July 1, 2008 at 6:40 am
Hi,
I want to get the release version and number of servers for SQL Server 2005.
Can anybody tell how to get these details.
Thanks,
Preetha SG
July 1, 2008 at 6:48 am
Hi,
You find in microsoft.com and search in sqltips.com long back i got the list of version there.
sql 2005 has
1.compact edition
2.standard edition
3.workgroup edition
4.Express edition
5.Enterprise edition
for more information check in google.
Thanks:P
July 1, 2008 at 6:51 am
To add to the above list: http://www.krell-software.com/mssql-builds.asp
Maninder
www.dbanation.com
July 1, 2008 at 6:56 am
Mani,
The link provided by u is good.
🙂
July 1, 2008 at 7:02 am
Let me first explain my scenario clearly. Because,U understood wrongly.:P
I want to retrieve the following information from SQL Server 2005.
1. Release version as "SQL Server 2005"
2. Number of servers available now
Thanks,
Preetha S
July 1, 2008 at 7:07 am
select @@version
check SERVERPROPERTY in BOL.
to check for Servers, OSQL -L or SQLCMD -L
Also check this Link for more info.
http://www.sqlteam.com/article/finding-sql-servers-running-on-a-network
Maninder
www.dbanation.com
July 1, 2008 at 7:08 am
you mean u want the version information from sql server 2005
run
select @@version.
u can find the version.
July 1, 2008 at 7:37 am
Not version. I gave already right.
Actually, I want to get these information using C#.Net. I don't know how to get in SQL Server 2005. That's y I asked. Now I got those information using C#.NET
Thanks for all for ur help.
Preetha SG
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply