You can't use a text variable, but you could try breaking this up. Maybe going with the top 100, then looping through successive groups of 100.

However, I don't understand what...

Doh, I thought I corrected those typos. Must not have saved it in my ID -10-T moment :w00t:

This is a known issue and you need to create a job to run 7.0 compatible databases.

I'm not sure why, but this was a design decision to not handle 7.0...

It's hard to know. The application could support multiple names, there could be caching, etc.

I'd probably schedule this for a slow time or off hours. Change the name and try...

You shouldn't change max worker threads.

Do you mean 1000 people querying the server at the same time or 1000 connections? Both are possible, just depends on the server, app, queries,...

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.