chuck.forbes (12/3/2015)

---

It just caught me off guard when I was searching for server-level privileges that there was a mix of 'db%' privilege names alongside pretty syntactically different names like 'DROP%'...

SQLRNNR (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

I did a similar thing some years ago.

Here's the code:

CREATE TRIGGER [TR_LOGON_APP]

ON ALL SERVER

FOR LOGON

AS

BEGIN

DECLARE @program_name nvarchar(128)

DECLARE @host_name nvarchar(128)

SELECT @program_name = program_name,

@host_name = host_name

FROM sys.dm_exec_sessions...

MMartin1 (12/3/2015)

---

So for using the error output and avoiding the fast load... Assuming this happens for every import you will get records in the error output. However you wont know...

Why are you returning results from a trigger? The ability to return results from triggers has been deprecated. From BOL:

Returning Results

The ability to return results from triggers will...

Do you have the linked server connections setup to "be made using the login's current security context"? If you do you likely are experiencing a double-hop authentication issue and...

Yes that is how it should work. The first row is inserted successfully because it won't violate the PK and the next row with the same PK values will...

The parameter "name" for OLE DB is the ordinal position of the parameter starting with 0.

So with 4 parameters you'd have parameter names, 0 through 4.

One option, which I've used in the past, is to not use fast load. Then you can use the error output on your destination to process those rows however...

So

SELECT

DES.login_name,

COUNT(DISTINCT DES.host_name) as...

You shouldn't be using sys.sysprocesses anymore. You should be using the new DMO's sys.dm_exec_sessions and/or sys.dm_exec_connections depending on what you are looking at. I'm not sure what you...

itsgaurav (11/23/2015)

---

Thanks for reply

My connection string is this where

Data Source=Gaurav-Pc;Initial Catalog=AEX15;Integrated Security=False;User id=admin;Password=a

Server Name : Gaurav-Pc

database : AEX15

User Id on Sql server and database : admin

Password : a

But message...

One thing not mentioned yet, is that an uncommitted(open) transaction will also keep the transaction log from being truncated (marked for re-use) so the transaction log will continue to grow...

Can you define "sequentially"? If it isn't processing the folders in parallel then technically it is processing them sequentially. I have to assume you want the folders to...

You should be able to query the default trace for this information, as long as you look for it before the trace file that contains the information has been rolled...

Can you post the connection string you are using for your application to connect to the SQL Server? It looks like you aren't providing a user name and password,...