Gail, dbreindex or alter reindex is not single unit of transaction? is it? So if we...

I suggest just deattach and attach it, so replication entry may be removed.

seems space problem. can you check this url.

http://blog.sqlauthority.com/2007/08/02/sql-server-fix-error-945-database-cannot-be-opened-due-to-inaccessible-files-or-insufficient-memory-or-disk-space-see-the-sql-server-error-log-for-details/

have you tried Psexec.exe?

You can use -m switch in sqlcmd.

http://msdn.microsoft.com/en-us/library/ms190737.aspx

Hi Matt,

Shall we get any update over this issue? You sorted it out?

You have only 2 processor?. In OLTP, this wait is not typical, but in OLAP.

Find out the query which is running in parallelism and taking high cpu usage.

I would recommend a constant monitoring of BPool usage by the same query for a couple of days (particularly Peak Hours) to get a usage limit. So that you can...

stehoban (4/25/2013)

---

The sql server has 24Gb and the server's max memory is set to approx 19Gb.

From the 1st query listed above (to return the objects in the buffer) i get...

SELECT

p.[object_id],

p.[index_id],

pc.[partition_column_id],

pc.[modified_count]

FROM sys.system_internals_partition_columns pc

JOIN sys.partitions p

ON pc.[partition_id] = p.[partition_id]

WHERE p.[object_id] =...

Wont recommend "clear" of that object from Buffer Pool.

Whats your max memory server setting? what is size of that big object in BPool? Do you face any performance problem...

along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.

SP_START_JOB 'YourJOBname' will do it. also follow Lowell's instruction.

Have you tried Proxy Accounts ?

http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

Google "sp_msforeachdb".