Task view did not give me Unused DB and log space are the amount of space in your data and log files respectively that don't have data in them. 

Why ?...

Will you please give more detail on  unused DB and Log size  is using taskpad View ? Thanks.

I am preparing for test. but I do not think test center matter no much since all need to be certified to be test center.

Will you please post your active script task code to call EXCEL macro?

Thanks.

Also I have error to run the DTS. it said syntax error in the drop table or drop...

It take time to open the ms file and format the excel . Sometime the end user will confused , too.

When you use DoCmd.TransferSpreadsheet  , it will lost the format of the date. Like you want the data format as date , most of the time , it export as...

I am thinking about that. I am wondering whether MS ACCESS have that capitality. Otherwise it seem over kill. Import the MS ACCESS table to SQL server and export the...

I am pretty new to DTS. but I have problem to name the active script and sql connection with the authors table.

I have ACCESS database. I am curious how I...

how about this one, I tried to update the another table while Quiz Log update.

so I can have current quiz data from the report. Thanks. so many join.

CREATE TRIGGER [Update Quiz...

And 2 Frances:

Don't use variables in triggers!

NEVER!!!

Why ? Thanks.

Thanks.

Thank you for the article. It is eye opening for me. Our company user name first letter of the first name and last name + one random number they generate....

I do not understand I run the process

select bucketid, cacheobjtype, objtype, objid, dbid     

 from master.dbo.SYSCACHEOBJECTS

 where  objid = 1718297181.

It still lock the  process. My other scheduled task aplication in...

Yesterday I run

select bucketid, cacheobjtype, objtype, objid, dbid     

 from master.dbo.SYSCACHEOBJECTS

 where  objid = 1718297181

at 10:30 am.

I do not understand why it keep lock the other process.

I think you need to login in to your account and change the subscription. There are some check boxes there.