Thanks. From you post i can see that you perfer to use the MSX feature. The reason why i am removing this type of db managment is we need each...

We no longer need the MSX/TSX setup on our db systems that is why i am removing the MSX/TSX setup. What specific script are u refering to? Job Script generated...

Try this (personally, i haven't tried it before but i think it should work). Define a view on top of the base table (target table) and use bcp with the...

Use DTS package. Create a DTS package that has a "Transform Data Task". Define your source connection to the source file and a SQL Server  connection to the instance/db that...

No you can't from what i know, but there is a work around. Create a new operator that contains email or Pager for both Operator1 and Operator2 like this DBA_Group(Email

can you provide a sql script? Thanks

I think you can schedule each report as a subscription which will convert the report into excel/pdf and put it on a file server (destination directory) or email it to...

This may help you but not that much. Try use LogPI or Entegra 

dbcc log(mydatabase_name, 2)

IF YOU HAVE VISUAL STUDIO 2003, THEN IT CAN GENERATE AN XSD SCHEMA BASED ON THE XML DATA FILE/DOC.

Why not use the SQL Server Diagram Wizard. I am not exactly sure what you want to generate. but i think using the Diagram tool in SQL will help. Let...

You should be aware that both of these products DO NOT AUDIT stored procedures execution(who executed which procedure and with what parameters). We are currently in the process looking for...

Kepr00 is right...but you can use DTS too. Use the ActiveX Task in DTS, this way you will have control over both the logic and the steps involve. Should define...

No the agent wasn't stopped. I checked the SQL Log and there was no error. That is why i don't get it.

This is exactly what i was going to ask. Any please answer. Thanks

Thanks to everyone for you response. I think the DBCC statements suggested by noeld. I get exactly what i want but the...