This is usually due to the account which is running SQL server. It would appear that your service account does not have access to the local system file. Check the...

Is the SQL Server service even running?

Jack Corbett (3/11/2008)

---

It does add...

Ashwin M N (3/11/2008)

---

Yes the procedure name is same in all the database. But there are around 45 databases of which I have to execute the procedure only in 40...

Jeff Moden (3/11/2008)

---

Adam Bean (3/10/2008)

---

Ok, I'm creating a couple custom proc's (one for 2000, one for 2005+), and I'm trying to figure out once and for all, how SQL determines...

Than you'd need to do either a cursor or a loop ... if the proc name is the same in each database, than simply loop through the databases and call...

sp_spaceused sums up the value for the whole value of the tables indexes, and as stated, does some different logic for clustered indexes (same as sys.sp_msindexsize - which both "exclude...

Just out of curiosity, why? What is it you're doing that would require executing a proc in all user databases?

Anyways, do they have to run at the same exact time...

So would it in fact be dpages * pagesize?

In 2k5, I took a different approach, and ended up with the same results as the M$ proc ...

This is what I...

That's why I was thinking that should I simply...

This will give you all your i/o since your last SQL restart:

SELECT

DB_NAME(database_id) AS database_name

,FILE_ID

,sample_ms

,num_of_reads

,num_of_bytes_read

,io_stall_read_ms

,num_of_writes

,num_of_bytes_written

,io_stall_write_ms

,io_stall

FROM

sys.dm_io_virtual_file_stats(NULL, NULL)

The better question is, would you rather have two separate servers and pay for two sets of licensing, or have them consolidated into one if you had the option?

Instancing provides...

Sounds like SQL is dumping ... check your SQL Server Error Logs, they may contain more information.

You do not get the query text, transaction count, lock count, etc. and you can only...

Couple quick things to check ...

- boot.ini

-- Is the /pae switch enabled?

- sp_configure

-- Post your output here

- Lock pages in memory (are you using it?)

- SQL Error logs

-- Might want...