Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Stored Procedures, Metadata Rss

   Items 1 to 5 of 5   
 

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...
By Chris Morton 2013/01/08 | Source: SQLServerCentral.com | Category: autogenerate parameters
Rating: |  Discuss |   Briefcase | 3,050 reads

Encrypt All Stored procedures at once

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.   Read more...
By Chris Morton 2009/09/10 | Source: SQLServerCentral.com | Category: with encryption
Rating: |  Discuss |   Briefcase | 3,209 reads

Encrypt All Stored procedures at once

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.   Read more...
By Chris Morton 2009/09/10 | Source: SQLServerCentral.com | Category: with encryption
Rating: |  Discuss |   Briefcase | 3,209 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

use metadata to generate basic create procedure statements for insert update and select  Read more...
By Chris Morton 2008/11/21 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 3,592 reads

Searching Objects for Text

When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.  Read more...
By Solomon Rutzky 2008/05/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,699 reads
   Items 1 to 5 of 5   
 
Tags
chris morton (2)    
codrakon (2)    
insert (2)    
select (2)    
update (2)    
autogenerate (1)    
autogenerate parameters (1)    
encryption (1)    
object_id (1)    
parameters (1)    
with encryption (1)