Thanks for the reply. MS was never clear on that setting. I am using Idera DM now to get the SQL memory usage and it matches what perfmon gives. We've...

Then why on an Itanium based build does it show correctly in the task manager?

I guess I should've mentioned there's 16GB of RAM on the server. So if the purpose of 64bit is not to need AWE then why would I need to use...

In the script above, change the fill factor of 80 to whatever you desire...

DBCC DBREINDEX (@TableNameToReIndex, ' ', 80)

I concurr. Verify the credentials you prived can access the DB from SSMS.

You might have some type of scheduled job running at the same time. Backup? Table Inserts? Maintenance of tables? SSIS package updating records? MAke sure all jobs that access the...

If the "sysobjects" and "syscolumns" is queryable from the account your asp application runs as, then you are volnerable 100%. Revoke access to those objects and allow only sysadmins to...

Had this issue on a SQL server that was not at SP2 level. If your SQL servers are not BOTH on SP2, install it and it should work.

If you haven't already tried this, reattach the DB and do not put an ldf. Theoretically SQL will create a new one. Sometimes in drastic measures when a DB runs...

The account that SQL runs as has Admin rights to both server and I went granular to the remote filesystem to confirm the NTFS ACLS are correct for the account.

This...

No, sorry. That example goes local to the server and it always works. My issue is trying to reach out to a file system on the network via a UNC...

Matt, Big thanks to you!

My next attempt to reclaim disk is to use Winzip commandline to script the compression of each .bak file on a nightly bassis after backups occur....

Matt, you hit on a perfectly good point and you just reminded me that yes, the TX log files are being backed up on an hourly bassis.

So, I guess one...

Lets everybody stand back a little and take a good look at this.

Assume this is a production SQL 2005 DB and the recovery model is Full.

A dB get's data into...

My applogies, it was the "BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG". It appears in my log files, see below...

I run this just before I do the DBCC SHRINKFILE.

Anyone know...