What

you

"Screeeeeeeeeech"

If you two don't stop bickering, there will be no dessert and no Spongebob Squarepants tonight. 

So you're saying that men aren't entitled to diatribes? 

I guess I'm one of those 'sensitive' males that you somtimes read about. 

Remi,

Definitely not...I was just tossing a bit of gasoline on the fire between you two. 

sushila,

I'm acutally in Fort Lauderdale.  Nice place,and I've lived in...

Or...'she speaks'??? 

Sorry...it's shorthand for 'If I remember correctly'.  Here is the good ol' U. S. of A.  And it looks like I bit at the bait that time and didn't even...

LOL...'master' or 'mister-ess'?  But IIRC, there's a very popular television series here that is not called Desparate House Husbands. 

Thanks for the yucks,...

Now, now you two.  Don't make me stop the car.   

I know...I got a kick out of 'married with mistress' as well.  Who on earth would put that on a credit application or purchase?  But...

To be honest, I haven't had a lot of experience with changind a clustered install so I'll leave that to someone who's already gone through it if they care to reply. ...

I don't know the structure of your network, but if DNS and everything else is cool with it, you should be okay.  We've changed server names and IP addresses on a...

Scott,

The article you referred to did in fact appear on SSWUG yesterday and the subtitle was 'Fact or Fiction'.  If you read it to the end you'll find the conclusion...

Oops.  Hit the post button too quick.  The T-SQL for the method described above is as follows:

1.  EXEC sp_detach_db @dbname = 'mydatabase'

2.  Delete the offending *.ldf file

3....

Assuming that this is a test server and you don't need to recover the data, the simplest thing would probably be to detach the database, then re-attach using the sp_attach_single_file_db...