More things to consider:

If you are using Enterprise Manager and open Query Analyzer to run the ALTER DATABASE command - that is two connections. You must close EM and run...

Malka,

You say: "BTW, the server was working fine for a good few months till the other day when this occured and since then I cannot connect to it."

Are you the...

Can you give us samples of the type of data you have?

Basically, you could use PATINDEX or CHARINDEX to find each comma and separate it that way. For example:

1. put...

We are using Symantec/Veritas' I3 software. It monitors all of our databases and alerts us when thresholds are exceeded. It sets default SQL Server thresholds, but you can adjust...

The one thing I hope RedGate does with this site is fix the time-out issue. I am tired of finding myself with the "Access denied" page. And it's...

This year I had fun talking to a help group for a 'pay as you go' cell phone company. Over several days, I ended up talking to three different people....

I was at a job fair a few years ago and while I was awaiting my turn to talk to a company's rep, this occurred.

A young man, wearing slacks and...

That's not a very hard set of queries. Why don't you open the BOL (Books OnLine) that comes with SQL Server and at least make an attempt to solve...

First thing to do....go to the server itself. Open Query Analyzer and see if you can connect to the database. If not, then you aren't using a valid login...

Brian,

Thanks for your response. I think you either misunderstood me or I didn't make myself clear. Let's try again.

1. We can't change anything. We can't. Steve, et al. sold the...

Brian,

You might be right, you might be wrong. But as others have said, you are beginning to sound like 'sour grapes'. We have all posted our concerns and...

I posted this in another thread (Editor in Chief by Steve Jones), but I think it fits here also.

Steve,

Just keep up the fine work you've been doing so far. ...

Steve,

Just keep up the fine work you've been doing so far. It's up to RedGate to prove that this site will remain independent. One thing I have noticed...

Depends.

Things to consider:

Detach/Attach:

FOR: Quick

AGAINST: Database is taken offline and can't be used until it is attached.

BACKUP/RESTORE:

FOR: Database is still in use.

AGAINST: Backup...

Can you try updating the MDAC version (the latest is something like 2.8)? That might solve the issue.

-SQLBill