i'm not sure for sql 2008 but for older sql's i simply reinstall as it's relatively painless.

about changing a collation of a database later:

changing the collation of a database doesn't...

isn't it:

- Acceptance that your 'circle of influence' is...

about:

- Many DBAs don’t work typical 40 hour weeks. Many work weeknights, weekends, and holidays, all without any overtime pay.

i think dba's can blame themselves a bit also. if...

simplest way is using the enterprise manager. i assume a simple db with 1 mdf and 1 ldf and the owner is sa or not relevant. if your unsure use...

and if you were able to reduce the size it may be smart to try to figure out what made it grow cause it may happen again. if it's an...

assuming you typed the path+filename correct:

perhaps it's still in use and some program has exclusive lock on it ?

abit more info about 0,2,3:

http://www.sqlservercentral.com/Forums/Topic241886-5-1.aspx#bm241943

i dont know how your backup goes but if you use backup jobs your transaction log backup will fail if you do a transaction log backup on a database with...

removed post.

Schadenfreude-Mei (11/25/2009)

---

Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.

You also...

Chandu-212374 (11/16/2009)

---

I logged into Windows machine using local administrator account. But when i tried to login to SQL Server 2008 , i get 'Login failed for the user <machine>\Administrator'.

How...

bell282 (11/18/2009)

---

(and one of the columns is an image)... If we delete all the records out and re-run the process it completes in about 2 minutes (previously about 30...

do the numbers have to be 1,2,3,4,5,6,7,9 or can they be 1,2,3,4,51,52,53,91,92 ?

assuming you have no option to adjust how this was build you could reserve an area of numbers...

could you be more specific ? what's the issue you try to solve ? what goal you want to achieve ?

in general a starting pointer can be:

SQL Server 2008 Books...

dont they like that "their" table is changed or dont they like that you add a table for auditing purposes ?

if it's the first situation i would consider triggers which...