SELECT SERVERPROPERTY('PRODUCTLEVEL')

How to determine the service pack currently installed on
SQL Server?

Question Posted / ramesh.l.v

Answer Posted / ramesh.l.v

Is This Answer Correct ?

15 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the need for group functions in sql?

1056

Explain sub-query?

933

How to throw custom exception in Stored Procedure?

1025

What is difference between view and materialized view?

926

how many bits ip address consist of? : Sql server database administration

881

What is index, cluster index and nonclustered index?

973

Explain about sql server login?

1065

Does the unique constraint create an index?

1038

What are data driven subscriptions?

112

A trigger can reference objects outside the current database? State true or false.

989

How to write an inner join with the where clause in ms sql server?

1073

How to create a local temporary stored procedure?

984

What is merge?

990

What do you understand by recursive stored procedures?

972

Is it possible to create trigger on views?

960