If you are looking at the wait time in the Current Activity window in Enterprise Manager, wait time is given in milliseconds.  So a wait time of 15 is virtually...

Are you wanting to monitor changes to the table structure, data, or access to the data?

A Log Explorer tool would allow you to see changes to the data and structure.  Another way...

I agree with David.  A year should never be included in the name of a product, unless by its very definition, it will be obsolete at the end of that...

These both appear to be OS errors, as the corresponding errors in SQL Server have messages that don't seem to apply.  I will assume that when you get the error...

You could set your log to the minimum size where you know it won't grow under normal operations (600mb?), create an alert to fire when the log fills, and optionally automatically fire...

Another possibility would be to restore a backup of your database from the beginning of the year, and compare the stored procs in the old with the new.  I'll leave...

Not sure how much help this is, but I vote for sa ownership.  We try to ensure that all production databases are owned by sa.

Steve

Greg,

I'm confused.  This post doesn't seem to correspond to the rest of the thread.  In any event, try putting parens around @sqlString...

EXEC (@sqlString)

Steve

Rich, The whole purpose of differential backups is that you do NOT need all of them.  You only need the most recent.  If you needed all, they would be the same...

Low-Cost??? and YOU are the delusional one????  I haven't seen the price, but somehow I bet it costs more than my truck.

Steve

Somebody attempted to execute the xp_MSADEnabled extended stored procedure, and it failed.  xp_MSADEnabled is undocumented and is executed during the execution of sp_ActiveDirectory_Obj, which is documented is Books Online.  Perhaps...

In each RESTORE statement up until the last transaction log restore, you must specify WITH NORECOVERY.  This tells SQL that you will be applying more backups.  When you execute that...

MSDN (Microsoft Developers' Network) or MSDE (Microsoft Data Engine) or Developer's Edition?

In any event, you won't have any trouble migrating from one to the other.  A backup and restore should...

Hmm.  You know, I have absolutely no doubt that Todd is right.  Why can't they do that with SQL???????????????????????

Steve

Here's a little example to get you going...

create table #who2

 (

 #SPID int NULL,

 #Status varchar(30) NULL,

 #Login sysname NULL,

 #HostName sysname NULL,

 #BlkBy varchar(128) NULL,

 #DBName sysname NULL,

 #Command varchar(128) NULL,

 #CPUTime int NULL,

 #DiskIO int NULL,

 #LastBatch char(14) NULL,

 #ProgramName...