Dear Friends,
I have SQL Script...
How to find out the Sql Server version?
PLease let me know...
Thanks,
ArthiTo get edition on a SQL 2k box - select serverproperty('edition')
To get service pack level on SQL2k box - select serverproperty('productlevel')
For SQL 7 box - select @.@.version
HTH|||Thanks for your reply...
I have only the SQL Script...
How to find out the SQL Server version...
Thanks,
Arthi|||You have only the SQL script...what does that mean?
Do you mean you have some SQL code and you are trying to figure out what version it was written for? If so that will be difficult as most code that will work for SQL 6.5 will work on SQL 2000 but there are additional keywords for SQL2K and SQL 7 that would not work for 6.5. If this is what you are looking for, feel free to post your code and see if anyone can figure it out, if I am still not understanding your question, please provide more details for what you need.|||Like he said .. very hard to look and tell from scripts.Unless you mean SQL Query tool .. you can use Select @.@.version command
No comments:
Post a Comment