Dynamic Management View. It provides DBAs with a lot of information on server side of things, like statistics on cpu, memory, index usage, etc., etc.

Very good Olivier, glad it worked out for you.

Haidong

Olivier,

Thanks for your compliment. I'm glad you like this article.

In addition to -c -q -S switches in my code, try adding -w in both bcp scripts. -w is the...

Thanks Brain for pointing out that link. Steve's articles are my favorite, especially the one that talks about procrastination:

http://www.dexterity.com/articles/overcoming-procrastination.htm

Haidong

You are correct Salim. Yes, timestamp is introduced into Oracle since Oracle 9i. Maybe I should have mentioned that in my article.

Jose,

Pat is right. You will not see Calc started unless you are running SQL Server as a console application, because Calc is going to be a subprocess that has an...

Yes Pat. I agree. xp_cmdshell can handle many automation jobs. I use it a lot in my environment.

You mentioned FTP files using xp_cmdshell. One of my articles in the past talked...

Thanks guys for your comments.

Yes, my objective is to provide enough just to get you started. I may write another article on WMI in the future.

Happy Holidays guys.

Haidong

Thanks Calvin for your compliment. I appreciate it. I am glad you find the article helpful.

Thanks guys for the compliment.

As to trigger in system databases for patches/service packs, it's hard to tell. I think it also depends on each individual patch/SP. Some patches/SPs might modify...

awu,

I am happy it worked out for you. Glad to be of help.

Haidong

awu,

I suggest you DO the following:

1. Stop both SQL Server Service and SQL Server Agent service;

2. Start SQL Server Agent service. Then verify to see if SQL Server service starts...

awu,

Tracing and profling have been totally redesigned for SQL 2k, that's why you couldn't see xp_trace_setqueueautostart and other extended stored procedures for tracing.

When you start SQL Agent, SQL Server Service...

awu,

Assuming SQLSERVERAGENT service starts automatically, you can create a job that runs this procedure. When schedule this job, under Schedule Type, pick the "Start automatically when SQL Server Agent starts"...

Hi,

Thanks for reading my article and offering questions and comments and pointing out my mistakes.

I am in China on vacation now. I'll be able to better respond to your questions/comments...