You really can't do it without dropping the table and recreating it as Allen says. Even if you use Enterprise Manager, it will still drop the table and recreate it....

You need to put the database into SINGLE_USER mode if it already exists.

ALTER DATABASE db_name SINGLE_USER WITH ROLLBACK IMMEDIATE

WITH ROLLBACK IMMEDIATE, immediately rolls back any on-going transactions and kick's everyone...

Try this....stop the MSSQLSERVER service (and the SQLSERVERAgent service if it's running) and then restart them.

That will rebuild the TEMPDB. It will start at the same size as MODEL.

TEMPDB is...

You don't give the sizes of the different drives.

But it does sound reasonable, unless you have a lot of transactions.

One thing to change is the way the TEMPDB grows....

1. If the TLog disk is damaged, SQL Server won't know where to store transactions. So I believe the answer is yes, a failure of the TLog disk will cause...

I've posted this once before in answer to someone else, but here goes again....

-SQLBill

This is from http://www.tek-tips.com and the author is Terry Broadbent.

How to Use Batch Size to Speed Mass...

Ianscarlett,

Actually, not using a time defaults to 12:00:00 AM. Which in 24hour format is 00:00:00. So there won't be any entries from 8/31 since the query would default to:

BETWEEN '08/01/2003...

No suggestions, since I don't know your setup and how you clustered everything.

But something to think about...when you 'pull the cable' you may not be doing something that requires a...

I can't figure out what could be wrong. That's directly from the book. You can even find the actual sp in Enterprise Manager (go to Master database, expand it, click...

What's DRP and what kind of documentation are you looking for?

The Books OnLine (BOL) is my main source of information for SQL Server.

Do you mean documentation from management on how...

quote:

---

Now, I've done this before, but on a different machine

---

Did the 'different machine' have the...

Is this how it looks when you added the whereand?

exec sp_MSforeachtable @command1 = 'select col_name, col_date from ?',@whereand = ' and datepart(year,col_date) = "2003"'

-SQLBill

There's an undocumented Stored Procedure that can help:

This is from The Guru's Guide to Transact-SQL by Ken Henderson.

Procedure:

Sp_MSforeachtable

@command1

@replacechar = '?'

[,@command2]

[,@command3]

[,@whereand]

[,@precommand]

[,@postcommand]

Purpose:

Execute up to three commands for every table in a database...

You are welcome.

I emailed this to you, but here's my response concerning how to change a column's datatype in case anyone else is curious.

The way to change the column...

You posted this for the wrong day...this is for the QOD for 2 October.

But, to answer you the schema provided (CREATE statement) showed it was a TIMESTAMP column not a...