perhaps these 2 can help getting you started:

SQL Server 2005 Books Online: How To: Encrypt a Column of Data

or a sql server central article:

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/

i wondered about what i missed. i learned some time ago that you (as in me) can think you know a lot ... but later to learn you (me again)...

george sibbald (9/15/2009)

---

Dangerous way of thinking. SQL needs the resource database to function, so have a copy of it. What do you prefer, sliding a copy of it back into...

about the tempdb ... that's a "it depends". it mostly depends on how much your tempdb is used.

if your upgrading your sql box and the behaviour stays the same...

george sibbald (9/12/2009)

---

nice to have a copy of it though in case something happens to the original. Also saves having to re-apply service packsd if you have to run rebuild...

i wonder about which version of sql your talking about ? 2000 ? and if it's 2005/2008 how you got the db on the server.

cause for restores in sql 2005...

i read 2 types of books:

books that give you a "helicopter view"and books that dives deep into the material. the latter is the "inside sql server" series.

the issue with some...

And yes, the whole troubles arose from a severe disk problem, when two disks of a four disk RAID 5 system crashed within 24 hours

the application worked fine, and everybody...

did you only fix the msdb database or were you able to find out the cause of the corruption ?

else you may run into it again ... i have my...

what about:

select distinct to a temp table

truncate source table

get the temp table data back in

or

select distinct from a to b

drop a

rename b to a

?

there is no info about the size...

i learned one simple lesson:

everybody has his / her own opinion about things. i can think of things a dba should be able to do but who says the person...

we had a situation where a job on a server was performing in a couple of minutes while on a remote pc (wan connected) it took 30+ minutes. changing this...