question

Shoeb avatar image
Shoeb asked

"The parameter is incorrect" while creating new table

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

sql-server-2008sqlssmswindows7
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

please post the code you are running so we can help you
1 Like 1 ·
Agreed with fatherjack. We need to see the code you are using.
0 Likes 0 ·
sp_lock avatar image
sp_lock answered

Does the link below help?

link text

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered

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."

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.