SQL Server : Find File Location for All Database
Here is the quick script I use find file location for all the database in my server instance. SELECT Name, FileName FROM sysdatabases if you have any other way to find please share!!!
» Read moreTag: SQL Server
SQL Live Monitor
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
» Read moreMigrating Logins from One SQL Server to Another
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
» Read moreSQL Server – Transaction/Sec
Windows based Performance Monitor to find Transaction/Sec for SQL Server Go to Control Panel –> Administrative Tool –> Performance
» Read moreLinked Server
——————————————————— 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
» Read more