michael vessey (5/21/2012)

---

why would dbmail be an issue in an import routine?

does the table $Sheet1 get created? if so does it need to be deleted before you can run the...

Lynn Pettis (3/14/2012)

---

Have you looked up sys.indexes and sys.dm_db_index_physical_stats in books online? The object_id is the id of the table on which the index is defined and the index_id...

Thanks ,

Import/Export it is then 🙂

Thanks 🙂

Right .

So that means i need not configure database mail to send out alerts for agent jobs , right ?

Am i going in the wrong direction here ? Or...

Yup , i guess so 🙂

Ill check it out and let you noe .

Thanks in advance !

😀 sure sure ... although i wish u were actually here looking over my shoulder 🙂

Heres the message i got from the jobhistory ...

Message

Executed as user: NAPA\ENTDB_SVC_NOITAR. ...20 ...

Thanks 🙂

Done, Sp_droprolemember it is ! 🙂 Thanks . And the profiler solution was useful too , can be used for a variety of purposes.

Cheers !