Maybe this will help.

http://codingpad.maryspad.com/2007/06/29/splitting-large-csv-files/

Well, after all that my specifications has changed. My users would like to be able to specify mutiple accounts or multiple groups or a combination of groups and accounts.

I...

GilaMonster (3/1/2010)

---

emily-1119612 (3/1/2010)

---

I have seen code so concise that I couldn't even understand it with my mere-mortal tsql skills. And of course I have seen bloat. For me this seemed...

RBarryYoung (2/26/2010)

---

emily:

Why do you want to cram two different functional tasks into one procedure? Thats been bad design in software development for over forty years. This obviously belongs...

RBarryYoung (2/26/2010)

---

It's sad, when the cure is worse than the disease.

Oh well, I'll be killing swine and birds all weekend...

mister.magoo (2/26/2010)

---

Agreed, the WHERE clause can combine both, but also you can do away with the @Account_Or_Group variable and associated lookup code.

You said the two lookups are mutually exclusive, so...

Other possibilities include package configurations http://www.sqlis.com/post/Easy-Package-Configuration.aspx or maybe calling DTEXEC and using the SET parameter to dynamically set a variable http://consultingblogs.emc.com/jamiethomson/archive/2005/02/28/1085.aspx

Can you base your package on a view and then change your view through VBA.

DoCmd.RunSQL "ALTER VIEW...

http://www.databasejournal.com/features/mssql/article.php/3622746/Monitoring-SQL-Servers-Availability.htm

Do you mean operator in the SQL Sever sense, that is, the operators listed under SQL Sever Agent in Management Studio?

If the server /agent services are down you won't...

Drill down into the specific maintenance task and open the 'View T-SQL' window. If you run the command directly you might get a more descriptive error message.

http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell

It looks like this can be adapted to the SQL Server service itself.

Does this help?

http://en.wikipedia.org/wiki/SQL_Server_Full_Text_Search

I'm actually querying a view in a vendor provided database. The underlying table seems properly indexed from a cursory review. I won't be able to change any of the indexing...

Wow, subsecond! thanks.