Hi all!
I am writing an online remote database migration tool.
I need to write a stored procedure which can connect
to a remote SQL Server entered by the web-user.
The user will enter ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20157977.html
HI,
How can I copy a whole table and some certain records from one DB to another.
The two DB are identical, but run under a diffrent Ip address.
I execute the SQL commands in MFC application, an...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20294929.html
I just realized that I need to be able to execute stored procedures in the master database. What permissions do I need to set to get this and moreover, what permissions do I need to access the lin...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21356127.html
I have a stored procedure that will run daily. This SP will need to call another SP on a different server. To do this, I believe that I should be using sp_addlinkedserver, correct? The SP on the re...
http://www.experts-exchange.com/Database/Data_Manipulation/Q_22677135.html
I have a SQL 2000 and a SQL 6.5 server that need to be able to issue RPCs to each other.
I have followed the following steps on each:
1)Create a suitable SQL login for all remote logins to use
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20177811.html
I would like to Import data in dBase III format to sql server. I am trying to use sp_addlinkedserver to achieve this.
when i run
sp_addlinkedserver 'dbf', '', 'MSDASQL', 'dBase Files', Nu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21129617.html
I am migrating our SQL 2000 databases over to new hardware bceause the old server is dying. I just used the backup/restore feature and moved the "non built in" databases without a hitch.
We hav...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21884699.html
Zones:
DatabasesDate Answered: 08/06/2006 Grade: A Views: 5
I have never used the sp_addlinkedServer stored procedure and do not fully understand what it does. I am also new to stored procedures.
Purpose for using stored procedure:
I would like to cre...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2256...
I need to do selects, inserts and updates over more than 1 sql server.
On the one server I added the server 'NT4-WEB' using sp_addlinkedserver. I am at the other server 'NT4-ONTW' and type 'select...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10337269.html
I have over 10,000 DOS FoxPro database tables that I need to import into our data warehouse every night. I have a solution for bcp & isql that works, but I have been trying to work with the OpenQue...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_20217526.html
Zones:
FoxProDate Answered: 11/07/2001 Grade: B Views: 4
