Attached the SQL Dump log that was created just now when i attempted to perform DB Backup. Its strange why SQL Dump would be created for a simple operation like...

Never seen like this before. Looks like everytime DB Backup is attempted, a SQL Dump is getting created.

Date,Source,Severity,Message

07/03/2014 07:12:31,Backup,Unknown,BACKUP failed to complete the command BACKUP DATABASE SDStat. Check the...

I was handed this SQL Instance 2 days ago so I have no clue who installed SQL on this box. Anyhow, the below blog solved my issue.

http://blogs.technet.com/b/pfelatam/archive/2011/08/08/sql-performance-counters-are-missing.aspx

Collation: SQL_Latin1_General_CP1_CI_AS

Version: Microsoft SQL Server 2014 - 12.0.2000.8 (X64)

thanks a ton.

That solved my problem

SET @FromSQL = 'SELECT @FromLSNOUT = fromLSN FROM OPENQUERY ('+@AcquisitionServerAlias+',

''SELECT '+@AcquisitionDBName+'.sys.fn_cdc_map_time_to_lsn(''''smallest greater than or equal'''','''''+convert(varchar,@begintime,121)+''''')as fromLSN'')'

SET @FromParam = N'@FromLSNOUT binary(10) OUTPUT'

EXECUTE sp_executesql @FromSQL, @FromParam...

Thanks a lot.

yes i do have xp_cmdshell enabled. All i see in the job log is Access denied. Its does not say anything else.

Thanks a lot the issue is resolved now. Dropping an recreating worked. It looks like its a sure mismatch of SID.

Now i have another issue.

SQLCMD is having Access denied error.

when...

Issue 1: Login failure

Severity: 14, State: 11. is what it shows in the logs.

In ring buffers below are the error codes.

[highlight=#ffff11]ErrorCode: 0×534

CallingAPIName: LookupAccountSidInternal

APIName: LookupAccountSid[/highlight]

Which indicates that SQL Cant resolve...

Hi.thank for response.

Yes, we are using built in CDC mechanism in SQL Server 2008. i just wanted to know if i can do only 1 insert into CDC Tables for...

Its 300 GB as of now, but we have 2 million updates happenning every 4 hours on the tables.

can you help me understand this DMV better. I'm getting confused with...

I figured it out. Thanks a ton.

IF OBJECT_ID('TEMPDB..#CPUUsage')IS NOT NULL

DROP TABLE #CPUUsage

CREATE TABLE #CPUUsage(NetworkName varchar(20),startTime Datetime,Value...

Basically what I'm trying to achieve is, Based on selected parameter of the report, Query used should change.

I have only 2 Queries.

Query1 should be used when @ApplciaitonName 'Informatica' is...

Below is what I came up with. Please help me get the right one. I'm getting NULL when i run it.

DECLARE @ApplicationName Varchar(50) = 'Informatica'

DECLARE @EnvironmentName Varchar(50) = 'UAT'

DECLARE @ServerName...

I go it. Thanks a lot. I saw a view in Youtube which helped me figure out how to do this.

Thanks all for the support.