Re: Generate SQL scripts in Management Studio

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

One option for you that doesn't involve installing SP2 would be to use
this console app: http://www.codeplex.com/scriptdb

it will generate a separate file for each object, for any 2000 or 2005
database.

On Sep 7, 10:14 pm, "Michael MacGregor" <nos...@xxxxxxxxxx> wrote:
What I want to be able to do is to select the database andgeneratescripts
for each and every object in the database, onescriptper object. This was
possible in Enterprise Manager but not in Management Studio.

Due to time constraints, a third party software is not suitable.

Thanks.

MTM


.

Relevant Pages

  • Re: login security question
    ... Say the password for the Application role is found, can a user access the database through the ... Query Analyser or Enterprise Manager using the application rolde/password.>> ... The user name, however, will be the app role name. ...
    (microsoft.public.sqlserver.server)
  • RE: Strange SQL Server Timeout Problem
    ... > scenario, SELECT statements are successfully processed, but the first INSERT ... > Evan stranger, the situation can be corrected by simply accessing the ... > the database takes much longer than usual, ... > once Enterprise Manager accesses the database, ...
    (microsoft.public.sqlserver.server)
  • Maybe the Records Are There After All
    ... The indication that the records were DELETED is that Server Enterprise ... Type in Server Enterprise Manager and then was making notes and documenting ... the larger database from last night STILL SAYS that it has ZERO records ... Is there some way to monitor the things that SQL is doing in the BACKGROUND ...
    (microsoft.public.sqlserver.server)
  • Re: Viewing default db role permissions
    ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
    (microsoft.public.sqlserver.security)
  • Change Column Size
    ... table1 alter column column1 varchar" and the command ... logged in using Windows Authentication (My ... I changed to the MyDB database, ... Enterprise Manager say one thing about the column length ...
    (microsoft.public.sqlserver.tools)