saved much of my time, thanks for the reply @twillcomp

I got it resolved. Thanks for the help.

All the records should be taken to a table ? Is there a way to read each loop from ssrs report?

my sql provided is working fine in SSMS, where it...

Soundex worked.

Thanks

Foxxo,

Can you please share the details how to select t-sql replay template?

I tried selecting show all events, show all columns->TSQL->select all the checkboxes in it. and filtered the tempdb excluding...

How can we capture whatever hitting tempdb in profiler?

There is enough space for backup file. Disk has 150gb where backup file comes around 56gb.

Any clues?

Sql Maintainance plan which takes Full backups of 6 databases is failing with the following error:

Error Number: -1073548784

----------------------

Executing the query "BACKUP DATABASE [DatabaseName] TO DISK = N'\\\\BackupLocation" failed with...

Can anybody suggest a good third party software?

I was trying t go with redgate. ANy advise please.

Sorry!!

Good One.!

I want to capture specific events like column level modifications on a table. Is it possible to go granular in capturing this by enabling audits at database level?

I want to...

Thanks A lot.

Can you please also make an article how to take the sql audit logs to a sql table using ssis/whichever way is easier?

Thanks.

Thanks A lot.