Tend to agree with what Steven posted. Go Dual-core and 2GB. Big HDD or if not, an external for backing up. Decent sized USB ones are $100-150.

First I'd drop this in the T-SQL discussion (moved).

Second, are you getting the average like this?

select ip, avg(time)

from mytable

group by ip

If so, you can wrap that.

select avg(a.ipavg)

from

...

You probably need some sort of password recovery tool for the DBF files if you don't have the password. This wouldn't have anything to do with DTS.

This might help.

First, please post in the appropriate forum. Every forum name is above the threads.

Second you likely have objects that are in another schema or the user does not have permissions...

Couple things. First, what version? Second, what's NMS?, third, please post in the appropriate forum. I'm moving to SQL 2005, Performance.

For monitoring, I just do the basics for a baseline....

DO NOT DO THIS.

Using a column for more than one value is bad, bad design. It makes it hard to write queries, violates normal form, can't do RI, etc.

Better off...

If it's production, they shouldn't create test databases. If they need to copy over the production database for testing, create them a database, and let them have rights to restore...

EM is a client side tool, so it EM freezing on your workstation or on any/all workstations?

Are you rebooting your machine or the server? I can see the logs taking...

I don't believe that the script is what is executing for the file copy. It's still the SQL Agent service that's running. The EXECUTE AS is a SQL command for...

Sent a note to a few people over at MS.

For a workaround, there are bunches of scripts here on the site that do backups of all databases.

Looks like a bug. I'd report this to PSS. I'll ping some people, but not sure if they'll respond.

Use the above advice to restore the db.

You could remove, or uninstall, the default instance, but you might run into issues. They should be separate, but you never know. If...

Ahh, my fault.

Please send me a note (PM or email, sjones at sqlservercentral.com) with the old and new and I'll switch it. I was kind of expecting this to get...

John,

Thanks and can you let me know which browser, OS, Office versions? I'll pass along to the developers.

1GB will run SQL. It all depends on load. I'd still expect a buffer cache ratio above 0, might be 10, but 0 doesn't make sense.