Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update SQL 2000 From SQL 2008 Stored Procedure

Status
Not open for further replies.
Auguy

Auguy

Programmer
May 1, 2004
1,206
US
We are updating one of our db from 2000 to 2008 on a new server. However we are keeping another db in 2000 on a different server. I'm assuming I can run a stored proc on the 2008 server and update the db on the 2000 server as long as I don't use any syntax not supported by 2000. These are procs currently running on the same server that have both of the db's. Would it be best to set up a linked server in this case? Any other issues I should be aware of?

Auguy
Sylvania/Toledo Ohio
 
Status
Not open for further replies.

Similar threads

gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
561
pjw001
pjw001
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
529
Volvere
V
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
335
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
307
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
379
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top