Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-16 : 20:42:16
|
Hunter writes "Hi,
I take over another person's work on SQL 7 Admin recently. In one of our database, there are 20+ store procedures, and we don't have documents. So I want to script these SPs to better understand them.
However, in SQL Enterprise Manager, I found a SP with the name of sp_ftp; when I export the script, it looks like below:
Create Proc sp_FTP4
@v_ID AS VARCHAR(50)
AS
SET NOCOUNT ON
.....
I also found a SP with the name sp_ftp5, and the script says 'Create Proc sp_ftp'.
I'm really confused. When I call a sp in TSQL (like EXEC SP_FTP 5), it will call the first one or the second one?
Thank you very much for your help!!"
|
|
|
|
|
|
Confusion in SP display name & script name