No, I didn't try to restore it with undelete.. Two weeks have passed and many people walked all over the place.. it's like a crime scene and evidence is already...

Guess what I am doing now? Making SQL Agent jobs to back up all the databases on the production server. I run that useful query that some nice person offered...

Anyway,

he had to sign a paper... one strike...

still there is no backup job that runs SQL on the regular basis. DB files just get backed up physically on the...

Guys,

all that you said is correct. I checked the recycle bin on the server. No db files there, in fact it's empty.

The database suppose to be setup on the disk...

My co-worker should have had guts to say "No", I don't know what I am doing and I don't want to poke around when I am in the middle of...

I am SMART!

I found that SQL server should be set to the mixed authentication mode.

Right click on server name, properties, security, set to mixed authentication mode, no only windows.

This is very smart...

Is there any tutorial or example or an article regarding the intelligent/ stupid uses of temporary tables vs table variables as well as dynamic SQL?

Jeff,

I am really confused now. Yes, I use bulk insert into the temp table and I copy it into table variable and then drop temporary table and I do it...

Can I use table variable with the dynamic SQL?

Do you have any simple code snippet for database mail in SQL 2005 ?

Yes I realized that. Thanks

It doesn't allow you to bulk insert from a file if file name is a variable.

Declare @path varchar

@path = 'file_02042008.txt'

BULK INSERT myTable

FROM @path

with (FIELDTERMINATOR = '|' )

So bulk insert doesn't...

OK you are right. It is not possible to bulk insert from the file into a table variable. It is possible to bulk insert from the file into a temporary...

Can I do bulk insert into a table variable or I can only bulkinsert into a real table?

DECLARE @myTable TABLE(

[id] [varchar](max) ,

[empl_name] [varchar](max) ,

[empl_id] [varchar](max) ULL,

[date] [varchar](max)LL,

[punch_in] [varchar](max) ,

[punch_out]...