Dave,

Thanks for the challenge. Looking forward to seeing the entries.

Do you mean have SQL Server connect to a web service, not a client connect to SQL Server hosting a web service, correct?

There is a task in SSIS that can...

Cast the data first to char, then replace, then cast back. However I didn't think CHAR(13) was valid in a datetime field. I'd do a SELECt first aftetr casting to...

I don't think that SQL Server publishes SNMP information, but I thought What's Up could monitor some things in SQL Server.

I did find this no Windows SNMP for SQL Server:...

Cars are tempting, but with my dream car in the garage, hard to argue for funding for another 😛

I do mess with wood, have built some pens and would like...

Don't shrink it too far. As you add logins and objects it needs to grow a little. I'd give it a 10% pad over what's used and you should be...

I hate in place upgrades. It's a gamble to me, and one that's not usually worth taking. Better to have a second system in place.

What do you mean by autogrowth going above a certain percentage? The autogrowth is by a number or a percentage and is fixed. Do you mean the total size of...

Thanks for the update, and glad you got your SPN error resolved. Those can be tricky.

Thanks for the update.

The default trace also might have more information for you if it has not rolled over.

Bru brings up a great point. The Dev edition is equivalent to Enterprise, with all features enabled. However if you use something like compression, it may not be there in...

Snow http://twitpic.com/rueuy

Service Broker kicks things off. If you have a stored procedure or other process that receives the message and can connect to Oracle, then you are fine. Or if you...

Gus has a good solution. If you want absolute days, maybe enclose it in an ABS() function?

Hmmm, hammer and screw. I might have to try that one. Gotta go have another cup of coffee to get ready 😀