what version of SQL are you on? I see this error occasionally but can never find any evidence there was a problem or the drive was out of space. I...

try command line utility sqldiag.exe, this is the tool MS support would want run to extract complete info on the server set up (OS and HW)

Nikhil, thanks so much for your input, its so good to have a second opinion when under pressure.

I looked at creating a new location, but had doubts about going for...

this is in the 2005 forum so I presume you are on 2005, therefore use the DMVs

http://msdn.microsoft.com/en-gb/magazine/cc135978.aspx

If you are in fact on 2000, a lot more difficult, you are stuck...

I think you mean a data NDF file then. As the Db is mainly read only you could get performance improvements by adding a new FILEGROUP and moving the most...

do you mean another transaction log file? the log file is a write ahead file , by which I mean it completely fills the first file before writing to the...

julie(?) this resolves backup history and jobhistory problems? Because I am at 9.00.3200 (CU4), so maybe...

yes sorry remembered syntax wrong, see BOL for create table, use the collate clause for the column definitions to specify the collation you want...

with no table schema or query info its hard to say, but a covering index on all columns in the where clause usually gives best result. remember clustered index is...

sa has sysadmin access and therefore full rights in all the databases whatever you do, so as long as you have stopped the app connecting using sa, you are done.

thanks, you are right, I have a 9.00.3200 (CU4) server and it turns out it is working there.

still leaves the history cleanup task though. maintenance plan history delete seems to...

were you trying to drop db_owner role or sa, neither of which you can do.

use sp_changedbowner to change the dbo to the login you want. The login cannot already be...

by truncating the log you have broken the lsn chain. You will be able to backup the log again but as the message says you wont be able to roll...

Steve Jones - Editor (7/30/2008)

---

If you monitored the mpg, was that not at least interesting?

quote]

yes, the touch sensitive screen was the best bit of the car, I almost had a...

Andy, agreed, and I wish it wasn't so, but public transport has been made such a mess of through greed, incompetence, privatisation, and governments caving in to the car lobby,...