Those aren't indexes. They're automatically created statistics.

You can update then using the UPDATE STATISTICS statement

Files cannot be moved between filegroups.

If you want to move partitions of a table to a new filegroup, you'll have to create the new filegroup, create files within it then...

Remove the USE statement, as the error said, the CREATE must be the first statement in the batch.

When you set up the connection string and open the connection you can...

Can you be any more specific about the kind of problems it's causing?

Well I can't figure out what problem you have with the procedure and I gave you a suggestion on how to check that a column exists. If you can give...

Firstly go and do some reading on .Net error handling and proper ways to handle errors. Your update could fail because the DB's unavailable and still you'd tell the user...

If the web page stops rendering but SQL's OK, I would be looking at IIS (or whatever your web server is), not SQL.

jerome.morris (12/7/2012)

---

That is totally embarrassing 🙁 sorry.

I do have a check like this:

try

{

...

Your caps lock appears to be stuck, and I don't appreciate being shouted at...

Now, can you explain in a little more detail what you're trying to do here?

Bombs out with what errors?

What do you mean by 'allocated CPU'?

The CPUs that SQL can use? If so, check the processor options for the affinity. It's all processors unless you set otherwise.

The amount of...

Somebody connected to the server and ran ALTER DATABASE ... SET OFFLINE

SQL doesn't set DBs offline by itself. What you...

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 6.

Ok...

Open the SQL Server configuration manager, find the instance in question (Express), right click-> properties, go to advanced, look for the startup parameters, copy whatever's there and paste it here.

When...

Chris Becker (12/6/2012)

---

If not what recovery mode is db in? Full? Are you taking tran log backups? No? Only full baks then -> do the following:

Right-click db | Properties |...