That's strange.

sp_configure 'allow updates', 1

reconfigure with override

update the table

reverse the first two statements.

I had an issue similar with an AS/400 driver, but it was an amount of data that was being returned, xx bytes, before it cutoff. If you can select different...

Backup using a product like SQLBackup (Red Gate) or Litespeed (Imceda). they support encrpytion

Thoughts and prayers to those in London and their loved ones.

Apologies. This was submitted and I missed the database name. I've awarded back points for those answering C and fixed the question.

That's $200 an hour

Yep, apologies, this one is incorrect. It slipped by me and we had a similar one a few weeks ago.

According to the engine developers at MS, they both are instantiated...

I also see consultants just hired as bodies. Sometimes just to take on some work that you might not be sure if you want to hire someone full time or...

I'm not sure where all of these are used. Probably a security site, like SANS.org might have some info. The system account is used for local services that need an...

1. I think this is OK, but I can't be sure. If someone had a real license and wanted to give it up, I think this should be allowed because...

Got this from the Red Gate folks:

You could probably look at the live log (SELECT * FROM ::fn_dblog(default, default)) to see if there are any transactions after the last backed...

select * from information_schema.columns

BCP will do it. I like DTS as a quick tool to do this easily, set the properties for the text file to have column names in the first row.

Ray has good advice with the nightly db backup. It's simple and easy. If you want to just grab one table, I'd run a quick DTS pacakge to export to...

There are some articles here as well on DBAs

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp