MS SQL server service pack

MS SQL server service pack
 Below query will tell you about version of MS SQL server installed and service pack version.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel') as [service pack] , SERVERPROPERTY ('edition')


Satalaj

Tags:

MS SQL server shutdownMS SQL server service packgodaddy hosting MS SQL server configurationMS SQL server mirroring remove end points master keyMS SQL server Transaction commit rollbackMS SQL server 2005 attach databse without ldf filesql server default portsbackup sql databaseConnection Poolingsql server agent backupAsp.net Interview Questions for 2 years or 3 years experiance

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.