Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Chris Morton,
run the script as it is on your server.
inspect the database tables and structure. notice a table called 'gautengdata' that does not have a primary key.
inspect the store procs.
DECLARE @return_value int
EXEC @return_value = [dbo].[_SPLOG_SPConstructor]
SELECT 'Return Value' = @return_value
with default parameters
refresh the stored procedures
inspect the stored procedures.
think about this:
a true programmer knows that the path of least effort (resistance) is usually the road to rapid application development and successful delivery.
all of this means lots of money...
Today we have a guest editorial from Andy Warren. Are you ready for an inspection at work? Are you r...
Stored procedure returning wrong value ... -1
Calling Oracle stored procedure with return parameter from SQL2005
Call Another stored procedure which returns muliple rows
Stored procedure which has problem with the function return value