home go links go books go opinion go gallery go projects go resumé go
about this site
archives
book reviews
"to read" list
tech books
search books
books archive
last 10 posts
quotes
cluetrain
cluetrain (mirrored)
randobracket
image auth
search engine hits
  hit history
indexer stats
user agent list
HTML (view)
  (most up-to-date)
MS Word (dl)
code examples
doesntsuck.com
doesntsuck.com

April 13, 2006

mssql stored procedure garbage   (geekin)

since nobody on the internet seems to need to know this, or i just don't know how to search for it, here we go:
in order to execute a stored procedure in mssql from a database other than the one it exists in, you need to create a synonym for the stored procedure you want to execute in the database you want to execute it from. index that.

Posted by yargevad at April 13, 2006 11:29 AM


This weblog is licensed under a Creative Commons License.