Good utility - required for clean-up activity of database. Thanks to Author

It is a good trick and could be difficult to implement - RMJ:-D

There is one Reporting tool, called 1key from Maia Intelligence. It can work with SQL 2000 and 2005.

R. M. Joseph

Dear Mr. RoB

How to use/open SQL 2000 DTS in the Management Studio?  Would you please guide me!

R. M. Joseph

Thanks Peter.  It is very good procedure and I shall use it.

R. M. Joseph

Like Microsoft Query, can we run sql query and return the results in Excel sheet?

Why Micro soft not including this feature in the Query analyser?

R. M. Joseph

Thank you Mr. Greg,

As you advised, I have replaced the single quote with double quote and inserted the sql statement in the column.

Again I update the column by replacing the...

Dear Mr. Mathew,

Your idea is good.  I want to how to insert the long sql statement in column of varchar (2000).

I could not insert more than 256 char.  Why?

Then, I...