It might be in the mailbox for the account that is sending the email. That would be the account used in the profile for SQL Server 2005 and up...

Or the 64 bit 32 bit issue.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b1d5de28-b80b-4f34-a135-c68e87039c58/[/url]

This could be a permission issue for the SQL Agent account on the location of the Excel file.

I think they need to own the job in addition to being a member of the applicable msdb role. I don't think there is any way around having them own...

We recently found that some of our code was not closing transactions when errors were encountered. The only way that we found that was because we have a trace...

It's kind of interesting, but you may be better off following up with the Powershell solution that you looked at. If you put this in a text file and...

We recently had serious issues develop with just 90 days retention on one table in a busy database. The change table was 333 GB for a 31 GB source...

This gets a little complicated with mount points and I think you'll need to get that info from Windows. We use a WMI query to capture this.

Select * from...

There's an ISO week function on this page that may be applicable too.

http://msdn.microsoft.com/en-us/library/aa258261(SQL.80).aspx

I think that the only way that you're going to resolve this is to have date table with a week column that, in this case, would hold 52 for 12/25/2011...

For deployment.

http://sqlblog.com/blogs/eric_johnson/archive/2009/12/08/ssis-package-builds.aspx

You can either drop the existing index and create the new one on the new file group or use WITH (DROP_EXISTING = ON), instead of explicity dropping it first.

I encountered an example where, due to space considerations, bitmask columns were used to store up to 63 values such as user preferences or actions in one column. It...

Can't you just drop and add the article and then run the snapshot?

I think that you're either going to have to use ownership chaining or grant select on the tables in the other database. If you could add the users to...