I do not think you can delete Excel data using an OLE DB connection but I read you can use the DROP TABLE followed by CREATE TABLE syntax to accomplish...

inHouseDBA (6/4/2012)

---

Greeting All:

Using SQL Server 2005 (9.00.5000.00), but moving to SQL Server 2008 in 4 months.

I am in the process of updating my Weekend Maint scripts..

Currently I Reindex Clustered and...

Please do not enable OLE Automation procs unless absolutely necessary...which is only if a third-party vendor requires it in my opinion.

May I recommend using PowerShell for this task? This...

Try something like this. Running it with the -WhatIf will only report what would be deleted by this command. Remove the -WhatIf when you're ready for it to do work.

#################################################

#init...

dbdmora (6/5/2012)

---

Hello opc.three, I apologize for not replying sooner. I been putting out a lot of fires out.

We have run sp_validatelogins on all our servers and found a few orphan...

I am not sure you can do that when storing packages in msdb, I would need to test it. However, if you are storing your packages as files and executing...

Fly Girl (6/4/2012)

---

Every project has its own considerations. As a contractor I'm here for a limited amount of time. Training someone to take over this process at a 'very small...

You do not need to drop and recreate the index. You can use ALTER INDEX to specify the new NORECOMPUTE value.

ALTER INDEX [index_name]

ON [schema]....

If your target workplace is in a corporate environment, which it...

You can export them from SQL 2005 to disk using dtutil (2005 version) if having them as files as a middle-step makes more sense for your migration. You could then...

I recently saw this on another post...

You can use PowerShell from within SSIS using this[/url] (works well). Or you can call an SSIS package from PowerShell by invoking DTExec (no...

Doubtful.

Can I use SQL Server Partitioning to Optimize Fulltext Searches?

Troubleshooting SQL Server: A Guide for the Accidental DBA[/url]

Is it your proc? Does it need to exist, and if so do you need to preserve it's interface because it has other uses? What is the proc doing? Depending...