I did use DBCC INPUTBUFFER(spid)...

Initially, there were multiple jobs connecting to one database. After killing all other jobs connecting to this database except one. The remaining job is still in sleeping status forever and...

May the following link help

http://msdn.microsoft.com/en-us/library/bb677622.aspx

Thank you so much WayneS!

Is it possible to generate the script from an existing profile?

You are right. I got it. Thanks again.

I came across the following issue:

The following scripts give me correct returns:

SELECT COUNT(a.colA) FROM TableA a

SELECT COUNT(b.colA) FROM TableB b

However, the script below is syntax correct, but returns incorrect result.

SELECT...

No. sp_who2 does not show it.

What I do not understand is why we cannot use SQL Agent in SQL 2008 express edition since the service is running.

Does it make sense?

A certificate is significantly helpful. But it is not necessary. I would like to recommend you to post your resume on internet and find recruiters to help.

Some recruiters still send...

First of all, thank you for your time and kind explanation.

My cluster system has cluster IP, node IPs for the two nodes, and the SQL Server instance IP. There are...

I believe that I might not explain it clearly.

The SQL instance differs from those of nodes. However, I could use the SQL instance IP to access the server box via...

Have you ever tried to use IP? Maybe DSN was incorrectly setup?

Did you check whether or not the IP 1433 is open?

I do not want to any other tools to be installed. I would like to get the info using script(s).

Thanks.

Both sys.tables and sys.objects return the date of modifying table structure, not the date of modifying table data.

S.K. (1/26/2010)

---

I would say the quickest way to do it would be to generate a series of dtuil scripts for each package, dump them into a .bat file and execute...