prasanna_pathangi (9/26/2008)

---

Actually, there is a script which kills all the processess and instances in sqlserver. The requirement is to that this should not kill one particular instance where some other...

Jeff Moden (9/26/2008)

---

Heh... yep... I understand all of that. But the obvious intention of generating the dynamic SQL is to make it possible to protect the user from accidental...

The NChar, NVarchar and NText datatypes are Unicode and are built-in.

I don't know, if you do a little corrective formatting, it doesn't seem to bad to me:

strSQL = "SELECT " _

...

Milu (9/26/2008)

---

when i run this query editor i found its doing the "Table Scan" rather than "index scan". i had a misconception that if i declare a identity column its...

Can you please post the views and the SELECT command being used?

And this is unreliable also.

Then they should use SQLBulkCopy, and implement their own IDataReader class around their input ByteStream to provide the input. IDataReader looks pretty easy to implement.

You should also be aware that none of this works on procedures that use Dynamic SQL.

That is what I do, but I have heard some say that that does not always work either, and I have definitely seen it miss some stuff.

From SQL Server itself, the sysdepends table is the only way that I know of, but it is unreliable.

This is exactly what I said before, Karthik. BULK INSERT will work only if the Server can see the file. If the Server can not see the file,...

The article here: (http://www.eggheadcafe.com/articles/20060318.asp) has a code example of how to use SQLBulkCopy from ADO.net to load a CSV file.

I believe that SQLBulkCopy is the class that you want to use from ADO.net. I have never used it myself, but hopefully, someone else here has.

BULK INSERT works on files that the server can see. If the file(s) being chosen by the user are on a client system, BULK INSERT probably will not work.