|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
01-07-2004, 02:02 AM
|
#1 |
|
Member (8 bit)
Join Date: May 2000
Posts: 219
|
MS SQL backup help...
Hi there, I wanted to generate the SQL script for an entire database that I have in SQL server 2000, this includes the database, tables, relationships, stored procedures, but how do I go about doing this?
|
|
|
|
01-08-2004, 08:04 AM
|
#2 |
|
Professional gadfly
Join Date: Jan 2002
Location: Minneapolis, MN
Posts: 6,364
 |
I think you can do with with the SQL Query Analyzer. Right-click on an object, and select "Script object to _____ (file, window, whatever) as CREATE). I believe this is how I did it before, but I am not sure and I can't check at the moment.
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
