How about something like this?

IF OBJECT_ID(N'tempdb..#SSISLogging') IS NOT NULL

DROP TABLE #SSISLogging;

DECLARE @ImportPackage VARCHAR(160),

@ImportPackageString VARCHAR(170),

@ImportPackageStatus INT,

...

Sounds good, happy to assist! Just to drive the point home about connection pooling...any difference between two connection strings will cause them to be viewed as different connections by your...

Purely using T-SQL? You would need to use xp_CmdShell and pipe the output into a table :sick:

You could look at the option Koen provided, and I'll add one more to...

Sean, you beat me to it on the Application Name post by 4 minutes! Tsk tsk on the use of sys.sysprocesses here 😉

Option 1: Use Windows Authentication.

You're describing the whole premise behind Windows Authentication! ...why are we using SQL Logins? Is this for a public-facing web app or an app with many...

SQL Server 2008 and SQL Server 2008 R2 both offer the same maximum compatibility level, 100, so T-SQL that runs on SQL 2008 will have no issue running on SQL...

If you setup a trace to capture the SQL:BatchCompleted event with the TextData column and add a filter on only the login name, i.e. do not add a filter on...

You can change the max memory setting and it takes effect without requiring a restart. Here is a good guide on what to set it to:

Suggested Max Memory Settings for...

Eugene Elutin (3/12/2012)

---

opc.three (3/12/2012)

...

Table '#test_objects'. Scan count 1, logical reads 1174, physical reads 0, read-ahead reads 0,

lob logical reads 0, lob physical reads 0, lob...

Eugene Elutin (3/12/2012)

---

opc.three (3/9/2012)

Re: "you should try to make trigger as lightweight as possible"

I could not agree more, Eugene. Unfortunately your example will force a full scan of the...

george sibbald (3/10/2012)

---

opc.three (3/10/2012)

---

Note: my comments pertain to 32-SQL Server Standard Edition running on 32-bit Server 2003 R2 with 4GB physical RAM and the /3GB switch enabled.

george sibbald (3/7/2012)

---

As...

I also failed to mention that the original symptom I was seeing that led me to go down the path of adding the 3GB switch and setting up LPIM was...

Note: my comments pertain to 32-SQL Server Standard Edition running on 32-bit Server 2003 R2 with 4GB physical RAM and the /3GB switch enabled.

george sibbald (3/7/2012)

---

As you only have...

That's two :hehe:

Re: AWE on 32-bit...I thought you had to enable it if you wanted to enable LPIM, which also requires a trace...

Eugene Elutin (3/9/2012)

---

1. To check the count you do just this (you should try to make trigger as lightweight as possible):

if (select count(*) from inserted) > 20 -- change...