How about

DBCC DBREPAIR(database_name, dropdb)

Steve

The first thing that comes to my mind would be an audit table which would record the old price and when it was changed.  Could be updated via a trigger.

Steve

Have you tried sp_detach_db or taking it offline in Enterprise Manager?

If your file locations are consistent, here's a little script that will give you the physical file names on the server.  From there, you can query sysfiles to learn which...

You can see the virtual log files within your log by running

dbcc loginfo

A log must have at least 2 virtual log files, and when SQL creates a log, it creates...

You can't apply logs from one database to another, which is what you would be trying to do by applying the 2K logs to a fresh upgraded 7.0 db.  You...

The proc

create proc test

@id int,

@name char(10) output,

@city char(20) output,

@state char(2) output

as

select

  @id = id,

  @name = name,

  @city = city,

  @state = state

 from test_table where...

Load the results from sp_helptext into a temporary table, one record per line of text.

Steve

I think you should just wait.  "Killed/Rollback" in your processes means that the process WAS killed and it IS rolling back.  You really shouldn't stop the rollback.  Could wind up...

I had always heard "release to manufacturing" also.  But I thought that doesn't really make sense.  Release to marketing makes more sense.  So, I decided to go do a search...

Why do you need to shrink it?  It would be best just to leave it at the larger size. Your job will run more efficiently and you will have less...

Better test it!!!

Steve

Well, you could script the tables without the foreign keys.  Build the tables, then go back and script the foreign keys.

Steve

Run profiler to determine "who" is executing the command.  Might give you some clues as to where its coming from.

Steve

DBCC SHOWCONTIG will give you what you need.  The main thing to look at is Scan Density.  The lower the value (from 100) the more fragmented the index.  Also look...