Hmm...You might want to post some information about your configuration to see if someone more knowledgable that I am can pick this up. It might be a good idea to also try a forum that is specifically for SQL Server.
Try Here. This is more of an asp.net fourm and we don't really care too much about the configuration of that SQL server thingy.
Off the cuff, I'd first make sure it wasn't a permissions issue (try running as local admin). Then, I'd say it was an installation issue (try reinstalling or repairing the installation).
Are you running SSMS on the server that the database sits on or are you running it from a remote computer? That could make a difference also....
Marked as answer by Vince Xu - MSFT on Aug 06, 2010 03:12 AM
mkubaryc
Participant
980 Points
271 Posts
Re: How to increse the performance of query in sql server2008
Jul 20, 2010 01:05 PM|LINK
Hmm...You might want to post some information about your configuration to see if someone more knowledgable that I am can pick this up. It might be a good idea to also try a forum that is specifically for SQL Server. Try Here. This is more of an asp.net fourm and we don't really care too much about the configuration of that SQL server thingy.
Off the cuff, I'd first make sure it wasn't a permissions issue (try running as local admin). Then, I'd say it was an installation issue (try reinstalling or repairing the installation).
Are you running SSMS on the server that the database sits on or are you running it from a remote computer? That could make a difference also....