Apologies. Editing the names from the test system resulted in the = being missed. Points have been awarded back for D and the question changed to fix the syntax error.

I'm sitting at Starbucks this morning, writing a little on my book. Since I work at home, sometimes I get out and this is a great place to work.

However,...

I'm slightly confused, why one login? If the Windows logins are used, then use them to auth to the db.

I do like the idea of storing config data in the...

On my XP desktop, I had 2000 Personal installed. Added 2k5 Dev and taskpad still works in EM.

So you would advocate pulling all data from the database server, running it through a utility and then putting it back for further querying?

I would venture the guess the best tool is the database since that's where most of the data is. SED, AWK, etc., apart from not being on Windows in general...

That appears to be a .NET and not a SQL error. I suspect you may need to insert it as <"http://...

Since these will be static when this runs, I'd calcualte them and store the values in variables and then include the variables in this query.

select @a = getdate()

select * from...

Look at DATEPART and DATENAME in Books Online for hints on formatting.

Tobias,

If you get there, call me. That sounds wonderful to me as well!

Scott,

Thanks for the clarification. I think it's a good idea, but one thing more to think about is that the IRS and associated schemes also employ a lot of people....

I don't mean to imply I mind paying taxes. I don't want to pay more than I need to, but I love the US and am happy to support it.

The...

Thanks for the grammar notes , it was a long weekend.

The Guest user has access to read tables in msdb, where the DTS packages are stored. You can remove the permissions to the stored procedures used to scan for the...

Can you update the table?

Doesn't look like the system procedures are really detailed.