Filter Audit Specification by Principal - social.msdn.microsoft.com
Feb 28, 2014 · You can try to exclude the security principal by specify filter on the SQL Audit. For example: USE [master] GO ALTER SERVER AUDIT [TestAudit] WHERE (server_principal_name …
Permissions on sp_helprotect - social.msdn.microsoft.com
Jan 5, 2009 · SQLSTATE: 01000, Native error: 3621, Message: [Microsoft] [ODBC SQL Server Driver] [SQL Server]The statement has been terminated.. Until this is resolved ADPro won't be able to verify …
call cobol from MS SQL stored procedure - social.msdn.microsoft.com
Jul 7, 2015 · Nonetheless you can try to call COBOL program from within a windows batch/command file and then invoke this batch file from a stored procedure using xp_cmdshell (Although we don't …
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Aug 1, 2016 · The environment I am running within is using SQL Server 2012 - SQL Server Data Tools for Visual Basic 2010. All of my OLE DB connections are using windows authentication. I have …
Database already exists when trying to connect different computers in ...
Feb 6, 2009 · 2) In class they have SQL Server 2005 installed in each computer for development purposes, but the objective is to release small programs and use it in computers with only SQL …
How to prevent uncommittable transaction when error occur?
Feb 21, 2014 · In my case, I have a table contain many of dynamic sql, and I use the cursor to get the dynamic sql from that table and execute the sql one by one, and I have used begin tran at start and …
Rebuild Index In a partitioned DB with ReadOnly filegroups
Jan 22, 2017 · USE [DB]; GO ALTER INDEX [IX] ON [dbo]. [TBL] REBUILD PARTITION =? GO Sunday, January 22, 2017 9:59 AM 0 Sign in to vote DECLARE @TableName sysname = 'MyTable'; …
Limiting the number of concurrent sessions per user
Feb 12, 2019 · As following to my local security policy, I have to establish the limit appropriate to the type of user account accessing the SQL Server instance on SQL Server 2014 Enterprise.
Convert UTC to Local time or retrive TimeZone / LocalTime from audit ...
Mar 25, 2011 · I have enabled auditing in SQL 2008 and retrieve audit records via sys.fn_get_audit_file (). It returns the " event time" (in DateTime2) in UTC date & time, as opposed to local date & time. …
SQL Server High memory usage - social.msdn.microsoft.com
Apr 30, 2019 · Due to high memory usage database connection lost errors occurring and fail-over happening.