Missing sp_executesql in SQL2005
-
Not sure whats going on, but i had to do an install of our Admin tools (daily checks, sql checks, monthly checks etc) onto a server at a clients. All our scripts utilize sp_executesql. Trying to create the Admin database and got error saying could not find sp_executesql.
I checked the master database and its not showing in the stored proc list.
Any ideas on why it would not be included?
cheers
-
If you run a query against the sys.sysobjects system view in the master db, do you still see it?
SELECT * FROM sys.sysobjects
WHERE NAME = 'sp_executesql'
If so, note the type. It's an extended stored procedure. Look under there. If not, you have an issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply