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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 a trouble with sp_configure

Author  Topic 

hornet
Yak Posting Veteran

96 Posts

Posted - 2006-04-26 : 01:22:25
Hi all!
I need to include support managed objects in SQL2005. I've read that neccessary execute sp_configure with param 'clr\ebabled'.
I'm entering in SQL as admin using SQLAuthent, but when I'm selecting
procedure sp_configure itsn't enabled for executing. Why it is?
Thanks in advance!

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-04-26 : 01:25:44
What's the exact error you are getting. Just copy and paste it. Try to login as the user the SQL Server 2005 service is running with. Make your sp_configure change at that point.

Post the exact statement you are using also. It will help.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -