Tag: SQL Server

Find EDITION, VERSION and SERVICEPACK information of SQL Server

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Hello Friends Generally, we choose the  @@VERSION to get the version information for SQL Server, but using this function we can’t get the Service Pack information installed… Alternative way Get Editions of SQL Server SELECT SERVERPROPERTY(‘EDITION‘) AS EDITION Get Version Detail of SQL Server SELECT SERVERPROPERTY(‘PRODUCTVERSION‘) AS VERSION Get the Service Pack installed on SQL Server SELECT SERVERPROPERTY(‘PRODUCTLEVEL‘) AS SERVICEPACK

» Read more
, , , ,

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY not working with Linked Server or Remote server ???

SQL, SQL-Linked Server, Varinder Sandhu

Hello Friends, I have faced a problem using SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY with Linked server Let me explain with example as below Question: We have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now the few applications running on SQL 2008 and few on SQL 2000, applications running on SQL 2008 using some of databases which lie on SQL 2000 with Linked server Now

» Read more
, , , ,

SQL Server 2011-Denali

SQL, SQL-General, SQL-Server 2011, Varinder Sandhu

SQL Server code-named “Denali” Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. With SQL Server code-named “Denali” customers will benefit from the following added

» Read more
, ,

SQL Live Monitor

SQL-Utilities, Utilities, Varinder Sandhu

Hello Friends, I have tried the Utility SQL Live Monitor, it really helpful for me…. That’s why I am sharing with you all … Features This tool is designed to provide realtime performance data on SQL Server, as well as data capture for offline analysis. The tools features are: Realtime SQL and System performance data Colour coded alerts Capture data logging to CSV – sample interval configurable PAL Perfmon counter logged to .blg or .csv for offline analysis using PAL

» Read more
, , ,

Migrating Logins from One SQL Server to Another

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

As I need to migrate the databases from one server to another server. I have to deal with migrate not only the data, but the SQL Server logins that access that data as well. There may be different ways to migrate SQL Server logins like you can manually re-enter the entire existing login on the new server. You can use DTS to transfer logins. But here sharing one of other way of migration of SQL Server logins, by using the

» Read more
, , , ,

Linked Server

SQL, SQL-General, SQL-Linked Server, SQL-Query, SQL-Scripts, Varinder Sandhu

——————————————————— Create  Linked Server through Scripts ——————————————————— USE [master] GO EXEC sp_addlinkedserver @server=’dsql2k’, @srvproduct=”, @provider=’SQLNCLI’, @datasrc=’source_name’ GO USE [master] GO EXEC master.dbo.sp_serveroption @server=N’dsql2k’, @optname=N’rpc’, @optvalue=N’true’ GO EXEC master.dbo.sp_serveroption @server=N’dsql2k’, @optname=N’rpc out’, @optvalue=N’true’ GO select * from master.dbo.sysservers ————————————————————————— Alternative Script to Create Linked Server and Mapping of Users ————————————————————————— Use Master go EXEC master.dbo.sp_addlinkedserver @server = N’dsql2k’, @srvproduct=N”, @provider=N’SQLOLEDB’, @datasrc=N’testserver’ GO EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N’dsql2k’, @locallogin = N’sa’, @useself = N’False’, @rmtuser = N’sa’, @rmtpassword = N’sa’ GO

» Read more
, , ,
1 … 7 8 9