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 PoolingAsp.net Interview Questions for 2 years or 3 years experiancesql server agent backupCould not load file or assembly SystemServiceModelDomainServicesHosting Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 or one of its dependencies The system cannot find the file specifiedsql server free spaceThis page contains secure and none secure information Do you want to display the none secure itemsDo you want to display nonsecure itemsThe shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005ms sql versionError The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B The Transaction Manager is not available The DTC transaction failed to start This could occur because the MSDTC Service is not runningms sql slowSql server cpu utilisationclient server communicationasp net image uploadOLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this sessionOLE DB provider SQLNCLI for linked server returned message The partner transaction manager has disabled its support for remotenetwork transactionsMS Sql Random selectms sql newid functionAn unhandled exception of type systemstackoverflowexception occurred in mscorlibdll

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

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Comments