I am by no means an expert on services/console apps, but you can see if it is running as a service by opening Control Panel or Administrative Tools and then...

If I understand your question, not being able to change the logical filename in the restore won't be a problem.  Give the database a new name, and new names for...

Ach, du lieber!

I had a long response typed in and clicked the post reply button and lost it!  I'll keep it shorter this time, and copy it to the clipboard!

Farrell,...

But...

By the same token, 8 days does not constitute a week. Its 1.132857 weeks.  What we're talking about here is a business rule.  You have to decide whether your week...

Just a little FYI -

This comes from Microsoft's website

http://www.microsoft.com/sql/howtobuy/faq.asp

A Processor license gives you the right to install any number of copies of SQL Server 2000 on a single...

Hey, Frank!

Ok, so I'm a little slow on the draw, but I couldn't resist another analogy to Aye Yi Yi...

ACH! du lieber!

(spelling???)

Steve

I agree completely with DCPeterson here, if there is a problem with the database, regardless of what it is, or how the symptoms can be treated, I'd want to know...

Thanks, DCPeterson, for straightening me out on that!  Sorry if I came across beligerently!  And I would agree that if there was a corruption in the tlog, there would most...

Does iTopicsQuery_id exist in the outer query????

Try it like this...

select * from GC_topics_TopicsQuery where itopicsQuery_id  in (

select GC_Topics_Topics.iTopicsQuery_id from GC_Topics_Topics  where iuser_id in ( 271,264,331,332,434,438,440,396,421,397))

Steve

One other thing, I'm not sure that LiteSpeed is the answer.  To me, unless its proven to be a problem with the native backup routines (which LiteSpeed uses behind the...

Also, before trying the detach reattach method, make ABSOLUTELY sure that you have a GOOD backup that you can recover from.  The single file attach method is really for disaster...

Check Books Online for the OSQL command prompt utility.

Steve

And again, the transaction log file stayed constant at 4.5GB?  Have you seen a pattern as to when it is happening?  Is there any indication in the logs (SQL error...

I recently discovered that Yahoo was filtering out some, but not all, of my reply notifications from SQL Server Central.  I get about 100 SPAM e-mails at that account each...

Several times over the past several years, I have tried to set up a Hotmail e-mail account.  It always fails by telling me "You have entered an invalid last name. ...