- do you have "torn page detection" set to ON for all databases ?

- do you perform dbcc checkdatabase on a regular basis ?

- try making your account member of the local windows administrators group. That may get you sysadmin rights for SQLServer.

- Take a full backup of all database(s).

- Isn't there something...

Jeff Moden (1/1/2009)

---

I'm not sure what you're talking about. A clustered index IS the data and adds almost nothing to the size of the table.

My feeling is that you've...

first read: http://www.sommarskog.se/dynamic_sql.html

Then : this is certainly not a best practice !

Create proper sprocs that serve exactly what they should.

Any "dynamic" part will come to a price.

... but I have...

No problem.

Keep us updated 😉

Happy 2009

We told you partitioning was a advanced topic.

You must read the mentioned white papers to get the actual details why and when you need to include the partitioning column !

It...

If you create all indexes without...

and you did shut it down by hitting ctrl+C in the cmdbox where you started it.

2008-12-28 20:37:46.09 spid7s SQL Server shutdown due to Ctrl-C or...

GilaMonster (12/28/2008)

---

ALZDBA (12/28/2008)

---

Does this point to a table that contains text or image columns ?

Try to export the data without these column, so you only lose the text/image stuff if...

it has troubles opening your AdventureWorks2008 database.

check your errorlog for e.g.:

2008-12-27 12:03:02.56 spid41s Starting up database 'AdventureWorks2008'.

I would try to get it back up and running...

I'll see what I can do ...

I'm not that the office until Jan 5th ...

- Did you follow best practices by taking a backup before you moved the datafiles ??

- if you did perform a clean shutdown and there weren't any ongoing transactions, you...

- you should check "c:\program files\microsoft sqlserver 2005\"

there should be a mssql.1 folder, that one contains a file called "errorlog" if you post its content, we may be able to...

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005:

- http://msdn.microsoft.com/en-us/library/ms143799(SQL.90).aspx

also keep in mind you need to enable TCP/IP on your sqlserver instance (server configuration manager) and restart the sqlinstance for it to be able to allow connections over tcp/ip