|
We have to get the definition of a view in order to reproduce it in another server. The problem is that the view is in SQL 7, and SSMS can't connect to it. I can get data using oldb or odbc but not the definition. Also I'm connecting from a clients production server, so I can't install programs. And the SQL 7 server is not available using RDP. Any ideas on how to get the definition?
(comments are locked)
|
|
I'm with sp_helptext, but first, you have to connect to to the 7.0 server. I'd try using sqlcmd.exe first. If that doesn't work, you'll need to find a 7.0 utility. It's been a VERY long time since I needed one, so I'm not sure what's worth getting. Here's one example, but I have no clue if it's good or not.
(comments are locked)
|
|
I am not sure if the objects exist but you could get it from a later version by using this code [edit] Some others have suggested some other options 125 +1 for sp_helptext.
May 11 '12 at 08:12 PM
ThomasRushton ♦
(comments are locked)
|
125

Jonathan Allen Solution doesn’t work. I think those objects are in sql 2005 and above