thanks.

I actually found it after I posted this. I just used an openrowset

I knew I had done this before.

thanks for the reply though.

I had an add on question for this. I run into a similar issue, I have everything set and the value in sp_configure is set to 1 in the...

Yeah, we figured it was a lost cause. I have since implemented a plan to backup msdb and master. I was shocked when I found out there wasn't...

I will read that. Thanks for the info.

I am going to touch on the hardware side of this. I am going to make a few assumptions first to make the point work.

Assuming your schema is the...

that was it.

So when I tried to run dbcc checkdb

it gave me this

Server: Msg 7995, Level 16, State 3, Line 1

Database 'mydatabase' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further...

I'll do it for you tomorrow. I have to reattach the db and I am about to head out for the night. thanks for the reply.

oops, I lied, this isn't perfect. but it's close, the problem is, we don't know our low end and high end before hand. so we need to calculate...

this is perfect,

thanks so much

OK that's what I thought. There is a way to do it without downtime, but it's a huge pain, but for anyone else wondering, here it is.

basically the process...

I did try that tool once before, pretty good, but it does some pretty scary scans on the network and get's our Firewall Admin all in a tizzy.

I think he means (this is a big guess), you can query the registry for services that match MSSQL%.

sure, I actually was able to do it all in dos (with osql)

but it is an ugly file. I didn't have time to pretty up the results

but here is...