Code for SQL Scripts

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

I'm trying to acquire code that produces a script of a stored procedure,
view, table, etc. I would like to run this code through a query window vs.
going through the gui to create the script.
.

Relevant Pages

  • Re: composite key question
    ... Each time you do an insert SQL ... it's probably not a stored procedure. ... queries to perform slower, however. ... Seeing as how that script you sent was not a stored proc, ...
    (microsoft.public.sqlserver.programming)
  • source text file as input parameter from a stored procedure
    ... I am using an active X script in combination with a global ... transform task that loads data from a .txt file to a table. ... I can also tell that the stored procedure is correctly passing in the ... EXEC sp_OAGeterrorinfo @object, @hr ...
    (microsoft.public.sqlserver.dts)
  • RE: Error 207 doing Transactional replication via Internet
    ... stored procedure from the script we were running. ... Some of them you didn't want to move to the subscriber so you ... For the QQRMGR user you ...
    (microsoft.public.sqlserver.replication)
  • Re: What does the .run method return
    ... 'stored procedure', yet your example is a VBS script. ... I have a batch job that calls a VBscript. ...
    (microsoft.public.scripting.vbscript)
  • Re: Newbie - Stored Procedures/ASP Question
    ... I tried shortening the Stored Procedure, and using the script from your ... The SQL Stored Procedure is below. ...
    (microsoft.public.inetserver.asp.db)