Help on code in a SP
From: Chris V. (tophe_news_at_hotmail.com)
Date: 11/30/04
- Next message: Des FitzGerald: "Re: SQL Replication"
- Previous message: Des FitzGerald: "Re: SQL Server Client Tools"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 10:01:35 +0100
Hi,
I'm currently auditing some SQL servers to have an overview on what's
running/existing in the different databases.
On one of the server, I found User's Stored Procedures in MSDB databases
(which, I think is already not a good idea). My problem is that I can't get
the usage of the SPs.
All are built on the same model : all the code is written on 1 line only.
Here is the full code of one the SP:
------------ beginning of the code --------------------
create procedure <SP_Name> (@IntID binary(8),@Z_BranchID_Z int,@Z_VS_Z
int,@IconLibrary varchar(255)=null,@IconID int=null,@ShowCollections
bit=null,@Z_VE_Z int=2147483647) as insert RTblClassExtension values
(@IntID,@Z_BranchID_Z,@Z_VS_Z,@Z_VE_Z,@IconLibrary,@IconID,@ShowCollections)
GO
------------- end of the code ------------------------
If someone would have any clue abotu what's this SP is doing...
Thanks,
Chris
- Next message: Des FitzGerald: "Re: SQL Replication"
- Previous message: Des FitzGerald: "Re: SQL Server Client Tools"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
