Hi,
I have recently upgraded my OS to Windows 7. After upgrading I have patched my SQL server 2008 to SP1. After that I am not able to create any table from Management studio. I am contineously getting "The parameter is incorrect" from context menu.
Please suggest.
Thanks Shoeb
There's a Microsoft Connect discussion about the same error message (http://connect.microsoft.com/SQLServer/feedback/details/252279/cannot-create-or-modify-tables-in-any-database-the-parameter-is-incorrect).
Last post in that thread claims to have a solution:
"I had this problem but I seem to have fixed it, although I can't get back to the original error to prove what I did was the answer.
The fix: On installation I'd selected "Network Service" as the account SQL Server should run under. I changed this to "Local System", restarted and now I can add tables to diagrams.
I then changed back to Network Service and restarted the service again - and it's still working. One thing I noticed was that when I changed to "Network Service", the services applet told me it had granted "Logon as a service" right to "Network Service". I don't understand how it came to be running as a service before this though.
Ayway it's worth a try - it worked for me."
