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 |
|
allyanne
Starting Member
18 Posts |
 Posted - 2000-09-11 : 13:41:05
|
| I've read that stored procedures in databases other than master should not be named with sp_ as a prefix because SQL Server will automatically look for that procedure in the master db. Does this happen even if I specify a different database in the connection parameters?For example, in my ASP code, if I have the connection string:Conn.Open "provider=sqloledb;data source=MySQLServer;database=MyDataBase;uid=MyUser;password=MyPassword"...and later I execute:Conn.Execute sp_NewProc,,adCmdStoredProc...will SQL Server look in master even though I specified MyDataBase? |
|
|
|
|
|
Naming stored procedures