Hi,
I have been able to view the databases and all of their tables but now when I cilck the "+" next to the database or try to connect a new one i get an error message:
"Generating user instances in SQL Server is disabled. Use sp_configure 'user Instances enabled' to generate user instances"
I don't know what I have done and I don't know how to fix it, Please help me!
Best regards,
Elliot
I would do a backup first, before trying anything! Two backups!
It sounds like Sql Server wants you to enter the following command in a query window:
exec sp_configure 'user Instances enabled'
But you might want to google on that first...
|||
Thanks you didn't answer it 100% but I googled it and found the answer in another forum:http://www.mydatabasesupport.com/forums/sqlserver-faq/339672-generating-user-instances-sql-server-disabled.html
Thanks for your help,
Elliot
No comments:
Post a Comment