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 |
|
rbrickey
Starting Member
2 Posts |
 Posted - 2010-10-26 : 11:22:59
|
| Hey everyone. Hope you can offer some insight. I have a stored proc that reports the database name as Master, when I know its not. Any ideas what would cause this? maybe how the proc runs or how it connects to the server?Any suggestions are appreciated.Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-26 : 11:40:36
|
What do you mean when you say that a stored procedure "reports the database name"?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
rbrickey
Starting Member
2 Posts |
Posted - 2010-10-26 : 11:52:57
|
| the profiler trace of an event shows a different database (master) than the event really ran against(production). |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-10-26 : 12:51:12
|
| ouch your prod sproc might be referring to tables on your dev box. make sure you are not referencing dev objects in your sproc. sounds like someone forgot to clean up sproc when moving it to production. meaning you could havedevserverdb.dbo.master or devserverdb.dbo.chickenwings when it should be productionserver.dbo.chickenwingsdo you have your production database on same box as dev database?do you have your dev server linked to prod serverdo you have your prod server linked to dev serverIf you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Stored Proc reports Master as database name