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?
asked May 11 '12 at 02:06 PM in Default
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.
answered May 14 '12 at 12:19 PM
Grant Fritchey ♦♦
I am not sure if the objects exist but you could get it from a later version by using this code
Some others have suggested some other options 125125