elite*gold: 0
Join Date: May 2010
Posts: 197
Received Thanks: 66
|
here try this:
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=127.0.0.1,1433;UID=user here;PWD=here;'
This is the SN just put your SQL user and PW in it. Run SQL Query and that should get you going.
|