URGENT. Need .txt backup of VIEW statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr. Smith - 14 Mar 2008 10:11 GMT

Hi.
I have an (really) old SQL 2000 server. It's getting very unstable, having
critical hardware errors when booted. Among other things, I need to copy the
SQL statements to all of the view on two-three databases. It's some 50 views
and I desperatly need to backup the design/statement.

Please help me....

Kind regards
Mr. Smith

Reply to this Message

Tibor Karaszi - 14 Mar 2008 10:24 GMT

How about scripting them from Enterprise Manager? I believe it is:
Right-click the database, All tasks, Generate Script...

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi.
> I have an (really) old SQL 2000 server. It's getting very unstable, having
[quoted text clipped - 6 lines]
> Kind regards
> Mr. Smith

Reply to this Message