I tried to embed the entire query in sp_send_dbmail in different ways as parameter but getting many syntax errors:

Please advise where it;s going wrong?

exec msdb.dbo.sp_send_dbmail

@recipients = 'abc@abc.com',

@subject = 'Error(s) found...

I'm getting the required results but need to get those details in an email..

can you please advise me..

thanks Nj-dba!

It worked. I'm getting the results.

EW1\INS1Aug 16 2013 2:28PMError: 60000, Severity: 16, State: 1.

EW1\INS1Aug 16 2013 2:28PMError while executing Usp_ErrorLogCheck procedure...

Can you please tell me how to...

We have a column data type as DATE in Oracle table

NEW_AGENCY_DATE13YDATENone

The data looks like the below in NEW_AGENCY_DATE column.

NEW_AGENCY_DATE

2/1/2002

I tried all available date formats in SQL Server that are available...

Thanks Hanshi,

But we do not have backup device. Every 15 mins, log backup creates a new log backup file under the backup path

Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG

So in the @filename, I'm giving the log...

After running the below script, I'm able to generate the script:

Script:

SELECT 'exec master.dbo.xp_restore_log

@Database=''WSS_Content_DB1'',

@filename=''Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG'',

@with = NORECOVERY,

@with =''STATS = 10'''

FROM [msdb]..[backupfile] bf

INNER JOIN [msdb]..[backupset] bs

ON bf.backup_set_id = bs.backup_set_id

WHERE database_name = 'WSS_Content_others' AND

bs.type...

What out put should we expect here?

I'm getting the below command when I execute the given script. I'm not getting all log backup commands? Please advise..

(No column name)

exec master.dbo.xp_restore_log ...

One of our application needs to be tested the policy rate effects by referencing future dates

I tried to implement the steps mentioned in below link but the command-line steps tmuser...

I checked those 2 columns values and both are showing same value as 1000 & 1000.

So how we know statistics were updated with full scan or with sampling?

Thanks a lot!

how to find which indexes are generating huge log while performing index defrag (I'm using index reorganize maintenance plan)?

thank you

I looked at transaction replication and it requires primary key for each table. But some of the tables in our database do not have primary key

Is implementing any replication, avoid...

I restarted the sql server service before starting the performance test and I noticed that Memory\Available MBytes

is very high (12 GB out 16 GB, Max memory is configured to...

the performance test will be 1 hour and I want to gather performance statistics for that hour only ?

SO do I need run some queries continuously or configure Profiler?

We need to configure SQL Server alias on Client servers NOT on SQL Server box.