Keep it Simple and Smart
Whenever we create any SQL instance and after that if we want to access from our network. We need to setup some setting on Client Machine also! This is only point that people missed Now we need to install the Client Network Utility on Client Machine and following setting needs
» Read more——————————————————— 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 moreDECLARE @day VARCHAR(5) DECLARE @month VARCHAR(15) DECLARE @year VARCHAR(5) DECLARE @hour VARCHAR(5) DECLARE @filename VARCHAR(500) SET @day = DATENAME(DAY, GETDATE()) SET @month = DATENAME(MONTH, GETDATE()) SET @year = DATENAME(YEAR, GETDATE()) SET @hour = DATENAME(HOUR, GETDATE()) SET @filename = ‘D:DATABASE Backupdb_name_’ + @day + @month + @year + @hour + ‘.bak’
» Read more–How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server –Prerequisites –Note You can determine the name and the current location of all files that a database uses by using the sp_helpfile stored procedure use go sp_helpfile go –Detach the database
» Read moreVarinder Sandhu is using WP-Gravatar