The group of COM/DBA should be added to the windows user groups (Administrators )

Then add that group to SQL Server as a Login.

Note: that group should exist in your active...

I see this issue many times in my old environment so many times as the server is already busy with tons of requests, Activity monitor hangs and displays timeouts for...

If it was me I would ask

1. what is the cost less or high compared other similar tools and what the benifits if it high?

2. What the benifits tool provide...

Nope Noproblem.you are welcome

Activity monitor, Script to find Head blocker- SQL Server 2005, 2008 and later[/url]

Hope fully helps find the headblocker and you can point them who is blocking ...:-)

Thanks Roy but that din't helped in my case.

The link says grant connect to login but I'm already sysadmin and the owner of the database.

I have connect permissions.

I have tell more that I verified CDC is enabled on database and cdc tables are created but not able to enable on the table. I hope its clear to...

I think this would be the solution for your issue

Follow Link: SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a...

select Count(*) from table -Returns the Total Number of rows in a table

select Columnname, Count(*) from table group by columnname having having count(*) >1

Gives the number of...

Take out the specs from the above query and replace it with your column name

I had a similar Issue and I prepared the below query , hope fully it helps you too.

CREATE FUNCTION dbo.udf_select_concat ( @c varchar(255))

RETURNS VARCHAR(MAX) AS BEGIN

DECLARE @p VARCHAR(MAX) ;

...

Should I install the version of BIDS that comes with 2008 R2?

Its up to you

Will I still be able to develop the 2005 SSIS packages?

yes,you can developin 2005 and...

As far as I concern,

If you are creating a package any way you define a connection to the actual server. so it deosn't

matter I guess.

all new versions...

Exec Sp_changedbowner '<loginnAme>'

My Approach will be monitoring for the queries

which are consuming high memory usage and tune them.

or switch more memory to SQL also won't help if you have bad queries...