check the Service Broker and endpoints

-- Enable Service Broker:

ALTER DATABASE [Database Name] SET ENABLE_BROKER;

-- Disable Service Broker:

ALTER DATABASE [Database Name] SET DISABLE_BROKER;

--Check for the specific database

SELECT is_broker_enabled,* FROM sys.databases WHERE...

SQL Server Agent Service is available with SQL Server if edition is not express,if you have express edition then go for SQLCMD and then schedule on the OS level

Go to SQL Server configuration Manager and then check the Protocols for both Client and instance NAME PIPED is enabled or not,if not then enable it

declare @driveName varchar(100)

declare @query varchar(1000)

declare @fsinfo varchar(1000)

set @driveName = 'C'

set @query ='fsutil volume diskfree '+@driveName+':\'

set @fsinfo = 'fsutil fsinfo volumeinfo '+@driveName+':\'

exec xp_cmdshell @query

exec xp_cmdshell @fsinfo

check this T-SQL

bounce the services and then check again

first test the client SSMS connectivity to the other server across the domain,is it working fine ?

there is no memory pressure on your server,memory allocation based on the load of the Server,your page life is 1644 secs that is good and no need of memory,now come...

Install the updates for your Operating System first

we have required a recent one check with the recent date and time

Install the recent service pack of Windows 7 and updates and then try again

you can use audit and database audit specification on the required table,there is an audit available for the UPDATE only also for the specific user as well as schema

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

http://technet.microsoft.com/en-us/library/cc280404.aspx

another option...

your OS version and bit ? and recent service pack ?

that is the DML intensive table ?

Still need of DBAs for a company which one offering Cloud Services but All organization will not adopt because there is a problem of data security and privacy,some restriction also...

On which SQL Server setup window ? paste the setup log file here

Select * from sys.dm_os_performance_counters

where counter_name = 'Page life expectancy'

Send result of this query and check OS performance monitor as well CPU utilization

Select st.text,sp.* from sys.sysprocesses sp

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

where sp.status...