Thank you.

I am looking to create extended events on the whole db. It might increase the size of the files.

Where we can give the option if the event is older...

Yes.

Thank you all.

When I tried again using notepad ++

I got the msg File is too big to be opened by Notepad ++

Down side I can see the length:225449251.

Any idea but the...

Thank you.

How do we know it is encrypted or compressed?

When I try to edit with Notepad ++ I can see only one line

<?xml version="1.0" encoding="utf-16"?>

With Note pad also I...

It is opening in the notepad but not readable. So I can't able to copy the content

Yes.

Also I see the tasktime under the actions.

ADD EVENT sqlserver.sql_statement_completed

(

ACTION (sqlserver.sql_text, sqlserver.tsql_stack, sqlserver.transaction_id, sqlserver.database_id, sqlserver.username))

but I want ADD EVENT sqlserver.sql_statement_completed

(

ACTION (sqlserver.sql_text, sqlserver.tsql_stack, sqlserver.transaction_id, sqlserver.database_id, sqlserver.username, tasktime))

To aleter this event...

Thank you all.

I disabled the login but the login has mapped to database as DB Owner still when I look for DB owner the user is still coming.

Do I need...

It worked fine but after the upgradation it is showing 64bit.

Thanks everyone

This is not cluster.

Is it ok to change to X86 in the installation media and run the upgrade? It should work right

In place up gradation. 64bit operating system

Yes powershell is running on Node1 and Node2

SQL Agent is running because the remaining jobs are running fine.

Error: Unable to start execution of step 3 (reason: The PowerShell subsystem failed...

I followed the step2 from MS but though it is failing.

Do we need to restart agent for any method?

I followed the same

https://www.mssqltips.com/sqlservertip/2041/why-syspolicypurgehistory-job-fails-in-sql-server-2008-failover-cluster-instance/

But didn't find helpful. Still failing with...

How the SSIS packages deployments works in SQL 2014.

Do the developers provide the packages to DBA for the deployments?

I tried the following

CREATE TABLE XMLwithOpenXML

(

Id INT IDENTITY PRIMARY KEY,

XMLData XML,

LoadedDateTime DATETIME

)

INSERT INTO XMLwithOpenXML(XMLData, LoadedDateTime)

SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE()

FROM OPENROWSET(BULK '\\Networkpath\inventory.xml', SINGLE_BLOB) AS x;

I am getting the...

Thank you.

We have only option in place upgrade. We have only 1db. I don't need to worry about the SQL Logins (Due to in place).

In case if there is...