Hope you get well soon Ken. We miss you in the twitters.

Could also be a permissions issue. Does the account running the SQL Server Service have access to that folder?

Is the Server 64bit? I haven't tried it in a while, but I know when SSIS first came out you couldn't export to Excel on a 64bit install.

I'm...

Well then, Congratulations back at ya.

I have an instance of Express Edition and Express Edition with Advanced Services installed and both have the Storage folder. So that isn't it. I would try reinstalling. You also...

Add one more for using a hybrid. We us Maintenance plans on our 10 SQL 2005 databases and we have custom scripts for the index maintenance.

The ORDER BY has to come after the WHERE. Also there is already a where clause so you'll want to just add to that.

SELECT customerid,

firstname,

lastname,

SUBSTRING(phone_numbers, n, CHARINDEX(' ', phone_numbers +...

+1

This probably isn't it, but what is the size of the database and/or log file? Is it growing the files every time you run this insert?

When you run dynamic sql, it runs in it's own scope. I don't think you'll be able to use the table variable, but a temp table should work.

create table...

Excellent! I may still look at Powershell to do something with this as I have to loop through all of the...

So I guess I should have looked a little longer before posting. I have figured out how to add the Operator (sp_add_operator), but i am still looking for the TSQL...

Coming form more of a development background I enjoyed seeing a basic article on why SHRINK is bad. A quick Google search will show you that it is considered bad...

I think there are two conversations going on here. The first being "Is it OK to treat people unfairly based on gender?" and I think everyone here has shown they...