something like this:

insert into tower.nbdoc (npages, ifnds, ifnid, datatype, win, status, polnum, multi, slevel, descript, scandate, boxid, username, batchtyp, memfnam, miscflag, spare1, spare2, date1, agent, batchnam, country, qaoper, indxoper,...

No, our infrastructure guys would never let me install office on their Server. I'm leaning toward chunking the excel file up and importing as an XLS file...

Thank you so much Steve!! I'm in a new position and kind of a newbie too.. The DBA Before me granted permissions to a particular Database...

OK.. I'm finally getting around to setting up my notifications on my SQL Server 2000 Instances..

What I did was setup xp_sendmail as a last step in...

Thanks Greg! so it doesn't matter if the logical names are the same as long as the database names and the physical filenames are different???

anyone? I'm hesitating to use backup and restore becasue both databases are on the same instance. They have different DB Names and their data and log files...

Yes, it helps!!!! THANK YOU!!!

am I going to mess anything up in my table temporarily setting it to

SET IDENTITY_INSERT mytable ON

awesome! Thank you

Thanks for the input. I don't have any experience with Tape agents but I had read that they can be somewhat unreliable. In my last shop of...

I use this method:

--sp_helpdb to verify log size, FileID and recovery Mode of the log

sp_helpdb [database]

--If necessary, change recovery mode to Simple

Use [database]

alter database [database] set recovery simple

--Backup LOG...

Just an FYI. I had to drop the scheduled jobs and rescedule the packages in order for the scheduled jobs to run with the correct credentials. thanks for...

Each job has only one step - to call the DTS package like this:

DTSRun /~Z0x637BDA8A5CC107EAB7CDD570EF3BDB20B17835A82DEEBD5FA3EFC7A495BB0DD3927C0AC7A940FBD355BB4641C5607CA3C06DB9596F621C7483A5E95FC19C03683199EABEA9F29EF54F50010751779A26C40958B2EB4E203960548E8C55AC1CF6D005D2D234869A4B7470F2E43B3F0C4297EABB12C481A4735875701973C0493807550FCB4204B73EE85F0AAD3A45AE445B5030B18833167F81B61E8D25016A878E066F

Do not see the password in the job steps themselves anywhere.. only in...

Thanks Much! The owner of the scheduled job DOES have permissions to run the job and the job won't even run when I change the owner to 'sa'...

Thank you Jack - but we are not running Exchange at all in our shop so I cannot set up an Outlook Client - but I can try and get...