Home Forums SQL Server 2005 Administering db script for all storedprocedures,functions and tables for one time in database RE: db script for all storedprocedures,functions and tables for one time in database

  • You need to generate the script. You can use SQL Server Management Studio (SSMS) to generate the script. It's the easiest way. If that doesn't do what you need, you can use SQL Server Management Objects (SMO) with a programming language (I prefer PowerShell) to generate scripts differently. But no one can give you the script for your database. You need to generate it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning