Posted in MS Sql Server on May 29, 2013| Leave a Comment »
How to copy data from one table on another machine to my local machine in sql:
INSERT INTO [mydbname].[dbo].[mytablename] SELECT * FROM [myservername\myserverinstancename].[mydbname2].[dbo].[mytablename]
EXEC sp_addlinkedserver ‘myservername\myserverinstancename’
EXEC sp_addlinkedsrvlogin ‘myservername\myserverinstancename’, ‘false’, NULL, ‘myusername’, ‘mypassword’
You might get error if you have some foreignkeys in the table, but for tables that don’t, this approach works well.
Posted in MS Sql Server on September 21, 2009| Leave a Comment »
Trouble getting your db connection strings right? Create a text file with the ending .udl and double click it. Now, you will get a gui for entering values as well as a button for testing the connection!
Posted in MS Sql Server on June 2, 2009| Leave a Comment »
How do you identify your sql server? It’s simple (but I always forget how :-)), just run the command:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Check out http://support.microsoft.com/kb/321185 for more information.
