Restart is not required to turn off C2 auditing. To stop C2 audit tracing, set 'c2 audit mode' to 0.

-Regards

To check if C2 Audit mode is enables, use the following query:

Select value

From sys.configurations

Where name='c2 audit mode';

GO

--Value '1' indicates C2 Audit mode is turned on and '0' indicates it's...

It could be a Stored Procedure set to start running on SQL Server Startup. Try the following query to list all Stored Procedures set to start on SQL Start up.

Select...

May be there is a Default Trace running already? To find out default Trace file location, please try the following script:

SELECT [value]

FROM sys.fn_trace_getinfo(NULL)

WHERE property = 2

If there is one...

Increasing query time out may not help. A Trace should help you figure out what exactly causing the issue. Is it running a Stored Procedure?

-Regards

"Select * from Tracing table" cause Table scan which in turn cause lock escalation leading to deadlock. Please see MS article on this with much more details and examples.

https://support.microsoft.com/en-us/kb/323630

SELECT...

See this article on Hypothetical indexes >> https://msdn.microsoft.com/en-us/library/ms190172(SQL.90).aspx

Use this query to list Hypothetical indexes:

SELECT *

FROM sys.indexes

WHERE is_hypothetical = 1

-Regards

Have you tried YourMachineName\InstanceName on sqlcmd command on job step?

-Regards

There are couple of options you can try. Please check this out:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/48621876-11a0-468c-95b4-2a682f0134aa/bulk-insert-not-working-through-an-agent-job?forum=transactsql

-Regards

Not sure which version of SQL you are using. Please see if this KB article helps:

https://support.microsoft.com/en-us/kb/934396

A race condition is an undesirable situation that occurs when a device or...

You may want to use a WHERE CURRENT OF clause with this. Please check this out: https://technet.microsoft.com/en-us/library/ms188713%28v=sql.105%29.aspx

Please see if that helps in what you are trying to achieve.

-Regards

See if this is what you are looking for(Suggested by

Vishal.Gajjar): http://www.sqlservercentral.com/Forums/Topic1199718-266-1.aspx

-Regards

You may need to use a specific Database Role for this requirement.

It could be worth trying this option suggested by Roi Gavish: http://dba.stackexchange.com/questions/21733/allow-user-to-do-anything-within-his-own-schema-but-not-create-or-drop-the-schem

I haven't tested it myself. Please let us...

You may want to use a Table variable.

See M.Ali's post >> http://stackoverflow.com/questions/21760969/multiple-rows-to-one-comma-separated-value

See if it helps.

-Regards,

Please check this out: https://support.microsoft.com/en-us/kb/955726

This helped me some time ago.

Cause:

This problem may occur if the syspolicy_purge_history job uses the computer node name instead of the virtual server name for the...