No. The linked server would have to exist with the same name on every server in the group.

Edit: Of course, the query batch could create a linked server, use it,...

All of the differences between Standard Edition and Enterprise Edition are not published. Those that are published is too long of a list to try to write out from memory....

Thanks Kevin!

Technically, truncate is a fully logged operation. It deallocates pages and those are logged. Every action it performs is logged. The confusion is that record deletions are not logged, but...

Are they going to create newer versions of their log tool? I read that it won't be updated for SQL 2012 or 2014 because MSFT is no longer giving anyone...

For the events, you have to define which columns of data to capture. If you go back to Profiler, you will see it.

Bad news is you didn't select all columns before you selected the events so the data you need wasn't captured. These trace files do not contain the columns of data...

Can you post the trace files?

Look at the commands (TextData column) and other relevant columns in the trace files using either the SQL Profiler tool or by querying the files directly with the built-in system...

KTurkes (5/16/2014)

---

I have very little knowledge about AlwaysOn, and according to our SAP on MSSQL docs it should be in a MSCS environment. Alwayson servers will be in a cluster...

You can't use the secondary server for backups and reports with clustering. You can only do that with Availability Groups.

Also, MCSC doesn't exist any more. It was renamed to WFCS...

If you are using Availability Groups, why are you using mirroring too? Why not have an asynchronous replica in AG?

Until the database is changed to single user again.

The query text will be in the TextData column. So on the Filters tab, enter a filter of LIKE 'ALTER DATABASE' for the TextData column.

If there isn't an equivalent event to Object:Alter, you can do SQL:StmtCompleted and filter for an alter database statement.