Code for SQL Scripts



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: 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)
  • Re: Looking for data dictionary/definition integrity checking utility
    ... That script could come in handy in some situations. ... (or in a stored procedure using the field). ... >>database, i.e. all table names, field names, etc. ... >>the identifier in each location. ...
    (microsoft.public.sqlserver.programming)