Ok, forget using the maintenance plan. You could use a DTS package if you like using the GUI, or read through some options for SQL2000 here:

http://msdn.microsoft.com/en-us/library/aa213832%28v=sql.80%29.aspx

However, here's my opinion...

Is the starting problem due to error 26014 ?

If so, read this:

http://nickstips.wordpress.com/2010/09/08/sql-ssl-and-sql-server-2008-service-doesnt-start-error-code-2146885628/

If dynamic SQL fixes the slowness issue, then it's due to paramater sniffing - most likely due to having default values specified for the stored proc parameters.

To fix, declare new...

Are you asking how to restore a database?

Following up to this in case anyone ever reads it.. a simple fix.. add the user "NT Service\MSSQL$InstanceName" which then appears as "MSSQL$InstanceName" to the DATA folder NTFS permissions....

SQL service wouldn't restart.. so I ended up doing a repair option from install media. Funny enough, it repaired the problem with master and was then able to start,...

I don't use full text indexing with Sharepoint and can't seem to find any good info on whether to turn it on in Sharepoint Admin or not. It's not...

To resolve, I took the database offline, brought online, DBCC CHECKDB and found no alllocation or consistency errors. Very weird.

Was this ever resolved? I've had the exact same issue:

Midday: Restored a database which had autoclose enabled.

to

1:31:43 pm: Starting up database 'xxxxxxxx'. (repeatedly due to auto-close)

1:31:45...

You'll need to write a query first to get the data in a format you can use. Then output it to a flat file destination using SSIS.

I was thinking...

Either turn on identity_insert or exclude the id field from the excel file and instead use the auto populated identity field in the sql destination table.

So you need 5 rows in the text file per row row from the partmaster table?

There's no simple way to automate the retrieval of the email attachment in SSIS specifically. You could write a custom PowerShell script and execute that as a custom task...

You can filter at the publisher, see here:

http://msdn.microsoft.com/en-us/library/ms151775(v=sql.105)

Remove the database from the replication publication if it still exists. Only stopping the distribution agent will cause the tran log to grow continuously, no matter of a full...