Are the two files that SQL's looking for there?

And the error log after SQL restarted?

Are there any IO-related errors in the windows event log?

Can you check the versions that I asked about above?

And the error log from after the restart? When the DB went into recovery?

Does the G drive still exist? Can you see it, can you read files on it?

SQL's looking...

Do you have showplan_all or showplan_text on?

That option means the query won't get executed, just parsed and optimised. The query's not actually running, so there's no stats output.

You've got disk problems.

It's a text file...

Can you please post the contents of your error log? (it's a file just called errorlog, text file)

An 823 error is a hard IO error. It means SQL requested an...

Can you do a maint plan to backup to disk (not to a backup device)?

Did you turn statistics io on?

Are there rows in both of those tables?

Please run SELECT @@version on the server and post the results. Please go to the help menu in management studio, select About Management studio and copy the version listed there...

umanpowered (12/3/2008)

---

If I'm understanding SQL 2005 DBMS correctly, the DBMS "engine" has some impact on the the underlying system tables. Maybe I'm way off base here, so I apologize...

It's an ebook and Simple Talk was distributing it. Drop a PM/mail to Tony Davis (here or over at simple talk) and ask.

What's a form id?

Your questions aren't making much sense by themselves. Can you please explain, in detail, what you're trying to do and what's not working?

Mine had that problem too, before I remembered about Ceiling.

smunson (12/3/2008)

---

I'm talking about ALL the service accounts that can be assigned during the installation process. I'd like to follow best practices for a server environment, despite...

nazaninahmady_sh (12/3/2008)

---

because the ntext is pointer and it save data in different places i can not write a query for transfering data of body ntext from source table to body...