Hi Chrissy:

Try:

EXEC sp_MSforeachtable "SELECT '?', COUNT(*) as 'number of rows' FROM ?"

I agree with you that the difference in behave of DTS designer vs. the wizard is odd.  Maybe its fixed in SQL Server 2005.  It may be worth checkm out...

For the DTS Designer try using DateTime String as the type of transformation as opposed to Copy Column.  It should work.  Using the DTS designer is more flexible but it...

Just some thoughts.  You could force people to fill in a form with predefined info on it and call that the resume.  The advantage is you are more likely to...

If you are taking transaction log backups as well you have the ability to restore to any point in the day.  The full backups just make the restore process faster. ...

This article and this discussion are completely inappropriate for this site.  Steve your insights into SQL Server and related technologies are appreciated but rememberances of individuals whether they be actors,...

Slow Running.  Eiterh use SET SHOWPLAN_TEXT ON

GO

your query goes here

GO

SET SHOWPLAN_TEXT OFF

GO

or else use CTRL-L (Query\Display Estimated Execution Plan) from the QA menu.  The difference is a text plan vs...

Slow Running : Check the estimated execution plan on each server for differences.  (from Query analyzer)

Duty roster:  Maintenance jobs should be run on all databases,  that is Backups, Reindex tabales,...

Hey Adam, your defrag script sounds great.  Have you considered uploadeding it for others to look at?

It would be better if your test database were on a completely separate machine.  What if you need to restart the box for some reason or if you do something...

Lily I noticed that you WHERE clause being:

Name LIKE '%parameter%'

will not use the index becasue of the % in front of the parameter.  If you code Name LIKE 'parameter%'  SQL...

If @EmployeeID  is set to NULL this would return all rows in table.  I'm not sure this is what is wanted  ... or is it?  I thought if @EmployeeID (or...

See http://www.sqlservercentral.com/scripts/contributions/632.asp for a sample of the function fnStringCompare .  This function helps simplifie the code.   Now if you want to pass more than region,  that is pass lastname, city...

Are you running SQL Server 2000 SP3?  What MDAC version is on the server?  (Check the registry under HKLM\SOFTWARE\Microsoft\DataAccess)

Is this the same as the MDAC on the new XP wiorkstations?

Another alternative is ApexSQL Log.