I'd recommend select * from information_schema.routines

As Carl mentioned, each hot fix includes the fixes of all items before it (all previous hot fixes). This is because the latest build is used to add the new...

Gail has some good advice there.

The practice comes from add/edit/delete of each object, so maybe you want to make a list of the combinations (new user, schema, login, etc.) and...

There is no Windows 2007. There is a Windows 2008, and there will be exams for that.

However, this site is primarily for SQL Server. If you have Windows questions, you...

A CTE also doesn't permanently exist. It's only in the batch code itself. A view exists as a separate object and can be called by anyone. Granted, a stored procedure/UDF...

Which updates exactly did you install and which did you not install?

My Windows edition is on one DVD, so I'm not sure what's missing. Was there any reason give...

I guess I'd disagree with that. Under his leadership the BI group became quite a force and the platform grew by leaps and bounds.

A DBF file is essentially a table. I assume these are from DBase/FoxPro.

You import each one separately. You could write a loop, but how many tables are there and is...

When you are in full recovery mode, you can do log backups.

I think you have to have made at least one full backup for a filegroup backup, but I'd have...

To use it, no. As mentioned, it's close to 2005, but with stuff added on. As you get into new features (PBM, resource governer, compression, etc.), there are things to...

The single quote (apostrophe) is a delimiter in SQL Server. You might need to escape it by passing 2 where there are one. so ...

Select MyID from mytable where MyCol...

Tim,

I tried with one kid at 5, didn't work well, but we tried it.

The other I asked every once in awhile from 5 until he finally got interested last year...

There really is no right or wrong here. Not sure of the tools available for Sybase, though BCP is there. Oracle?

DTS/SSIS works great and could easily move data from Oracle...

Well I'm not sure the bike commute would be much help here. Also not sure the wife would put up with the bike tracks in the hall 😉

However Rick has...

Glad you guys like the topic and great to see so many people active. Just got back in from walking about 1000 yards to drop hay, so that's a big...