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

Jon,

That's a great question, but there's no way I know of. I'll ping a few people and see if they have an idea.

Steve

Wow, that is very interesting. It doesn't seem to give great specs on the process in terms of energy required vs energy received, but it seems somewhat self sustaining.

This would...

Which project? Building the agents or the script?

GPF2^192 wins for the best post of the day!!!!!

I like Remi's solution. Might want to add another column to order by

Select col1, col2, col3, 1 'ord' from dbo.OracleTable

UNION ALL

Select cast(count(*), null, null as SameDataType as col1), 2 'ord'...

Which tool are you using? I'm sure Lumigent or the other firm's tech support could work with you to recover the data.

And one of ours

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