Recent content by joshuaguilty

Thank you again. First your suggestion works perfectly, besides I have to drop/remove those not needed. And my data is large and within the same database I have "companies" which means that a company having the same table structures but different name. That is why I try to have a dynamic SQL...

One more question. Is it possible to copy the table's contraints WITHOUT involving EM or the Studio, and just play under T-SQL !? Because I would like to plan to have a dynamic SP to copy tables (looping based on a table list). I am doing this to copy tables between databases, and the only...

Thanks for the response. I am copying some selected tables from DB1 to DB2. Using DTS does not copy the constraints, therefore I would like to find a way to copy table structure and data at the same time using T-SQL SP. Please tell me a way I can accomplish this. So that the files to copy and...

DTS does not transfer constraint (primary/foreign keys ..), is there a way to use T-SQL to copy whole table, this includes format, structure and data together !?. I have a table to include all tables to be copied and I would loop through this table for all copying. Thanks.

You are the best always trying to give me answers with patience. I would definitely try with this tip. Thanks again.

Thanks. I would do more testing.

It is within Outlook. Thanks.

When I open the Outlook 2002/3 on any computer, there is a name besides the "Mailbox - xxxxx", is there a way to obtain this name when running a VB object !? I have searching like "GetDefaultFolder" and it is still not successful. Thanks.

Thank you very much for expressing your personal thought. I would surely follow your suggestions, and at the same time accepting any other ideas from this site. Thank you again.

Can I use VB6 to communicate with Outlook PST file? How ? Any ideas !?

Thank you for the information.

I apologize for NOT being clear. The data collected to run the dynamic SQL is from the Reporting Services (2000). User check the list to request data. If this is not the right place, could someone please direct/guide me to the right place and get the right answer? Thank you!

Yes, awaiting for your next instructions. Thanks.

Thank you for the response. The dynamic SQL query actually is declared as @SQL1 varchar(8000)/@INVOICE varchar(8000), is needed 1st because of the unknown number of invoices being requested, second is the number of companies (databases) involved. Therefore, users could ask for...

I have a varchar variable (@INVOICE) which contains a field from user's input. Users would choose Invoice # to retrieve information. As long as @INVOICE is within 8000 characters (together with the dynamic SQL) the SP is running smoothly. BUT when it exceeds its limit then I got an error "...