I think we've all encountered an Eric. I worked with one a few years ago (not the first, and I'm sure it won't be the last) who was in the...

If I remember my Oracle right (and it's been a year or two!), even when you use ODBC to connect to Oracle, it just sits as an extra layer on...

The DBA team that I work on couldn't function without TS. We use it to adminster a number of servers based at various locations throughout the US, while our team...

In a similar solution to Mark's, you could use the "ASCII" function to search through the string for a particular character.

The following code snippet shows what I mean:

DECLARE

Don't forget to output the "last_updated_time" from the "Execute SQL Task" to a package global variable, then use that variable in the "IF" statement in the "ActiveX Task".

I spent a...

I wrote this script only recently to use the sp_spaceused stored proc to return the space data for each table in the current database, the output is ordered in ascending...