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...

Very strange. could be fragmentation.

How much data is in the table?

Troy,

I sympathize and I'd really recommend looking at 2005, even in 8.0 mode. The architectural enhancements will help with the load, especially if you can move to 64-bit.

That aside, a...

Be sure you're not one of the connections. Don't open a query window to that database, have one to master instead.

SSMS should do fine.

If this is only a SQL server, then I would probably set Min and Max to the same value. My impression for 64bit is that you would...

SQL_oracle has my caveats for network backups. Don't do it.

If you have bandwidth issues, then you're somewhat stuck as the bandwidth is required to do the backups.

What I'd recommend is...

Did you attach the master database?

might have a naming conflict.