Did you restart the service?

You should be able to start the service and run that query. It doesn't do much to the database and should complete quickly.

What's on your laptop? Enterprise only installs on a server operating system.

I'm not sure if you can install 2000 as a named instance with 2005. You might need to install...

Something much be blocking it. Stop the query and run it again.

You can't do it directly with a SPROC unless you are using xp_cmdshell. The job fires dtsexec, a command utility, which loads and executes the package. The way you're doing...

Can you connect with a Data Source from the client computer?

SQLAgent runs and accesses the computer on which it is running. You cannot remotely deploy the agent.

What do you want the Agent to do? Perhaps there's a way around it.

The main risks are that someone can access resources outside SQL Server using a shell and could potentially damage the server. For bcp out, I don't know of another way....

There are ways to query an hierarchy and they get easier all the time, but if you know there are up to 3 levels, I'd build 3 tables, linking each...

If you installed express, by default it doesn't take remote connections, only local ones. Might not be listening on a TCP port. Check the SQL error log to see if...

insert x

select case when count(a) > 1 then 'All' else 'group' end 'firstcol'

, secondcol

...

from table

Two ways,

One is to create a link table, has EmpID and SupervisorID, along with dates that correspond to the timeframes. For current assignments, leave the end date open and handle...

First, please post this in a forum that makes sense for your post. You titled it SQL Server Express, so perhaps that forum.

Second, how are the data feeds coming? If...

Thanks for the suggestions and I'll second the Stephanie Plum series mentioned above. They're hilarious, even laugh out loud in places.

I actually watched some of Night at the Museum today...

Thanks and feel free to submit this as a script. We can get it out in the newsletter then.

I had a 700GB database and it ran fairly well, but we had 5 or 6 filegroups, mulitple arrays and we had to be careful with maintenance. And we...