I have no clustered index on the table. Will the order of the copy from OpenQuery affect fragmentation even without a clustered index?

I was able to open up the SSIS package using Visual Studio and run it from there

The package is being saved to the SQL Server. The query you mentioned doesn't return anything

Hi Ness,

I ran your query and there were no results. I just saved a test package and didn't get a result after running your query. I am guessing...

Lowell, what exactly is a "tagname" in XML?

That option is only available if you choose "Backup databases across one or more files". I am using the option "Create a backup file for every database"

isnull did the trick, thanks

Hi, mail profile is enabled for SQL Server Agent. The test e-mails I've sent are present in the system mail tables. The e-mails that are supposed to be...

I've tried success, failure, and completion (with corresponding T-SQL script that completes or errors out). No e-mail sends on any of them

Hi, I am referring to the "Maintenance Plans" section under "Management" ? "Maintenance Plans" in the Object Explorer panel. When you create and schedule "Maintenance Plans" using the wizard,...

Thanks G2 and Dan, I like the BEGIN and ROLLBACK statement combination.

Jeff, this seems like a particularly painful subject for you. I hope someday you'll get over the scars...

I found the job that does the nightly backup. It is using a SSIS package; although I am not sure where this SSIS package is saved. How do...

Thanks Lowell. Is there anyway to find where backups are being saved to? I took over a server cluster so I am not sure what network location the...

Yes, multiple objects can have multiple borders. Thanks for the enlightment. Does anybody with experience with this know how to fix this?

I've tried editing the border settings, but the outline is still present