That definitely sounds like a good idea, but I don't think we'd be able to buy another software just for that. Isn't there a T-sql way to do this?

Thanks. I also realised that I need to use the following to access file attributes.

Imports System.IO

I'm working on this now, and will let you know if I can copy...

Thanks. I also realised that I need to use

Imports System.IO

I'm working on this now, and will let you know if I can copy in same step where I set...

You can try using the SSIS import export wizard. That should definitely get all the data exported. You can then use this to compare the package you created. 🙂

Yes, we had a discussion and I realised that the users perfer to see the data in an Excel spreadsheet. So, I'm going to create an SSIS package and will...

Thanks everyone. I just wanted to make sure that there was no 'guaranteed' way to get the data ordered by C without asking the user to do so. Thanks for...

So, either I ask the user to use the "Order by" or create a table TABLE2 and have the columns in the order requested by the user and ordered by...

Yes, i've even tried the top 100 percent, but still no good.

So, just confirming - Index is only for performance. It has no hand in sorting the data, right? I...

Thanks Guys, I understand what you are saying. I will talk to my manager about it.

At the same time, I am really interested in knowing about the database design behind...

have you tried what happens if you don't type in the password. This is a hit and try method. The other thing could be that it is not recognizing that you have...

Sorry Jeff. I know I did google it (while I was still pregnant), perhaps I didn't use the right words/terminology. I was expecting to recieve it in my SQL Magazine subsiption, and...

hey guys, does anyone know where I can get the chart of system tables and how do they relate to each other?

Thanks heaps guys. I will start doing that.

I have a bit of a problem though- I learn better with examples, does anyone know any website that can help understand the...