Sorry, somehow that named instance was on 1434. We changed it to other port, and things are back to normal.

Following link may help you for troubleshooting this issue, even though you have counter in PM.

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/18/what-should-we-do-when-the-sql-server-performance-counters-are-missing.aspx

Basically, you need to look at following things

1, PM DMV in SQL

2, Reg key

3, Ini...

Please don't confuse and misuse this feature. CDC is a good tool for data analysis purpose, but not auditing.

If you are working on DW and trying to analyze user bbehave...

You do need license to run SSIS on your local PC. The solution should be purchase a Developer edition of SQL which cause about $100, or if you have MSDN...

Thanks for reply. I manually added two parameters to replication meta table, and got my query through. However, I still couldn't see them from agent profile tab on replication monitor....

Then try this

Create table T (ModifiedDate Datetime, Ignition BIT)

INSERT INTO T (modifieddate,Ignition)

Select '2010-07-05...

Try this

Create table T (ModifiedDate Datetime, Ignition BIT)

INSERT INTO T (modifieddate,Ignition)

Select '2010-07-05 13:36:24.470', 0

UNION ALL

SELECT '2010-07-05 13:37:28.513', 0

UNION ALL

SELECT '2010-07-05 13:38:33.560' ,1

UNION ALL

SELECT '2010-07-05 13:39:38.623' ,1

UNION ALL...

Code-1029433 (6/23/2010)

---

Thanks for the reply. I’m having trouble coming up with the correct syntax for your solution, can you help? This is the direction I was going, but I could...

You may call sp_stop_job in step to stop job, and you can check job history from log or directly from job history table to identify which time the job was...

aroatenberry (6/23/2010)

---

Once I click on "surface area configuration for features" I get a message that it cannot connect to server localhost, and I'm assuming that is due to this being...

I think Eugene got the answer. Flag column in address...

I had been worked on CommVault a while, and as a DBA, I think CommVault is working well for SQL 2005, but not for 2000, and no advantage for SQL...

GilaMonster (5/20/2010)

---

Interesting, not quite what I was expecting.

That's a table that stores info on what columns exist in what objects. Latches protect the physical structure of the page, so that...

GilaMonster (5/20/2010)

---

Could you run this and post the results? It's an undocumented command to look at a database page's raw structure (in this case, just the header)

DBCC TRACEON(3604)

DBCC PAGE (5,1,11099981)

DBCC...

GilaMonster (5/20/2010)

---

That's not what I asked for. Need the wait_type and wait_resources please for processes that are waiting (ie suspended).

How many CPUs on this system? Is there only 1 file...