Script to check the Syntax on all stored procedures in a database - stored procedures - order by pertinence

Global Data Center Services Provider CyrusOne Continues to Expand Largest Digital Energy Campus for Oil and Gas Industry in the U.S.

Land purchase signals continued expansion of Houston geophysical center of excellence.

Press published on the April 23rd, 2013 - 9:06 AM ET

Accuvant Named as Top Aruba Networks’ Partner for Third Year in a Row

Accuvant, the authoritative source for information security, today announced that it has been named as a top Aruba Networks’ partner for the third year in a row. Accuvant was selected as Aruba’s 2013 U.S. and ...

Press published on the March 27th, 2013 - 9:05 AM ET

Research and Markets: BYOD Policy Template - Bring-Your-Own-Device

Research and Markets (http://www.researchandmarkets.com/research/4q5lp9/byod_policy) has announced the addition of the "BYOD Policy Template - Bring-Your-Own-Device" report to their offering. BYOD ...

Press published on the February 13th, 2013 - 4:51 AM ET

Swivel Secure Enhances Operational Agility for Customers and Channel Partners

Introduces flexible pricing for channel partners, shortens platform release cycle.

Press published on the January 29th, 2013 - 2:30 AM ET

Hamilton Microlab 300 Redefines Hand-Held Pipetting

Hamilton puts the accuracy and precision of its automated liquid handling systems in the hands of laboratory technicians.

Press published on the December 4th, 2012 - 9:38 AM ET

Genetec Unveils Its Plans for Cloud-Based Video Surveillance, Access Control and License Plate Recognition

Genetec enters into strategic alliance with Microsoft to develop powerful Windows Azure-based security solutions designed to bring high-end security applications to a broader market and enhance current on-premises offerings.

Press published on the November 14th, 2012 - 8:00 AM ET

Mega puts their first Web page online

Kim Dotcom has put his first web page online dedicated to Mega. The successor to MegaUpload is on its way and future partners have been asked to show expressions of interest.

News published on the November 2nd, 2012 - 9:10 AM ET

Script to check the Syntax on all stored procedures in a database

Is there a script or functionality in SQL Server 2000 that can check the syntax on all stored procedures in a database? A column was dropped from a table and the list of stored procedures using that column was identified and fixed using sp ...

Message posted on the November 6th, 2009 - 3:18 PM ET

Securing Stored Procedures from being seen

Hi, First, excuse me if I use the wrong terminology. I am a programmer first and work with databases only occasionally, so I might use the wrong terms. Second, its my first post and hopefully it's in the right section. With that being said: I'm ...

Message posted on the July 30th, 2009 - 10:23 AM ET

data types of certain parameters in stored procedures

I have some stored procedures that have a signature of things like this: CountNews(@Type varchar(50)) SearchArchiveByKeyword(@Keyword varchar(200), @IsByDate bit, @Year as int) GetNewsArticles(@Type varchar(50)) GetTopNewsArticles(@Type varchar(50), ...

Message posted on the April 21st, 2009 - 6:04 PM ET

Using Stored Procedures With Access Data Project

SQL backend - Access front end. Have built several SQL Stored Procedures into database, but have not found how to pass the parameters required by the Stored Procedures. I know this has got to be simple, but I can't figure it out on my own. How do ...

Message posted on the April 13th, 2009 - 4:00 PM ET

How to script all Stored procedures as Alter

I am trying to script all my stored procedures to a query window. And I am using the Scripts Wizard which by default does a Create for all my procedures. I tried changing the "Script Create" option to false but it didn't work. It ran as ...

Message posted on the March 1st, 2010 - 12:08 AM ET

SQL 7 and last time stored procedures was ran

Is it somehow possible to determine in MS SQL 7 when a stored procedure was last ran? I know I could add logging to determine this but we have lots if stored procedures here that would require us modifying the code to do this so looking for an easy ...

Message posted on the May 26th, 2010 - 12:03 PM ET

Compare stored procedures

Is there a way to compare stored procedures from one database to another (without having to buy a 3rd party product)? At the company I am at, we have our development server and our production server (as it happens one is 2005 and one 2008). If I ...

Message posted on the October 22nd, 2009 - 3:33 PM ET