If you wish to store login credentials within the package then you have to set the 'ProtectionLevel' package property to something other than 'DontSaveSensitive'

I normally set the 'ProtectionLevel' to...

A problem can arise if the 3rd-party code uses @@IDENTITY rather than SCOPE_IDENTITY() immediately after any INSERTs, and where, within your trigger, you insert rows into another table with an...

Run the following statement:

SELECT DB_NAME(database_id), *

FROM master.sys.master_files

...or for SQL Server 2000:

SELECT DB_NAME(dbid), *

FROM master.dbo.sysaltfiles

If the mysterious mdf and ldf files belong to a database that is attached to SQL Server...

Hi Brandon

How often do you run this stored procedure, and why?

I'm just trying to understand under what scenario you would want to shrink all transaction logs.

It would be a good...

If you don't have any luck with the suggestions so far then you may wish to consider trying one of the following options:

1.Add the LOOP join hint to each of...

In terms of the tools that can be used to identify this missing index yourself, have a look at the execution plan that you posted to the forum.

At the top...

Which...

Paul's suggestion is good, and is consistent with the missing index that was suggested by SQL Server in the execution plan that you provided.

If you almost always return rows from...

As you're having no luck in receiving a response to this query, why not post a bug report on MS' Connect site:

http://connect.microsoft.com/

Chris

.

An alternative approach, if all of your strings contain one leading " and one trailing ", would be to use the SUBSTRING function:

DECLARE @MyString VARCHAR(100),

SET @MyString = '"1234567"'

SELECT SUBSTRING(@MyString, 2,...

Just to point out...

Just having CLR enabled consumes a surprisingly large amount of VAS (I can't quantify exactly how much) - it would be worth disabling CLR then restarting SQL Server if you...

At least you can predict the behaviour now, you're one step closer. Now to try and work out why the memory is becoming so fragmented. 🙂

Have you managed to correlate...

There's an excellent blog post by Jonathan Kehayias that explains VAS reservation in SQL Server:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx

The detail contained in the post may well assist with your troubleshooting.

Chris