This will show you all allocations against VAS:

SELECT type,

SUM(virtual_memory_committed_kb) AS virtual_memory_committed_kb,

SUM(multi_pages_kb) AS multi_pages_kb

FROM...

Do you have another server where you can restore the database and try shrinking the files there?

Here is a WQL Query Tool for you to develop your queries:

WQL Query Runner[/url]

In using a drive letter, are you sure the drive letter will exist for the service account...

You'll have a For Loop Container with a condition of "where 1=1" so it loops indefinitely. In the For Loop Container you'll have the WMI Event Watcher Task waiting for...

In your SSIS Data Flow, you can issue SQL that looks like this in your Data Source Component (e.g. OLE DB Source) to get the data out of the database...

Ditto. Interested to see if the 32-bit runtime runs clean. Thanks for posting back.

Craig made some good points about why not to have a package running all the time. If you are fine with it and want to proceed, or are bring forced...

Neat tidbit. It looks like sp_addalias was dropped from the product in SQL 2008, but on SQL 2005 you can check for orphans with this:

select *

from sys.database_principal_aliases dpa

left join...

Lock memory is allocated from the buffer pool, but it is still suspicious that you cannot see lock memory rising above ~800MB. Are you running the 3GB switch?

What are the...

I read that lock memory will never exceed 40% of total SQL Server memory. I see you have AWE enabled, however could it be that since you are on 32-bit...

I noticed that despite the nice writeup you had no responses so far. I am no expert in this area of SSIS but figured I might try to lend a...

Evil Kraig F (4/2/2012)

---

opc.three (4/2/2012)

---

To summarize, in Oracle, in single-column unique indexes NULLs are completely ignored. In multi-column unique indexes NULLs are considered if one or more of the columns...

You could interrogate the results of setspn for your hostname:

You should see an entry for MSSQLSvc/<FQDN>:<tcpport> if it was successfully registered.

Here's a good discussion on Oracle's handling of NULL within unique indexes that pretty much says it all from every angle and perspective. Some posters even have DB2, MySQL and...

It's a start! Happy to...