you can also check this sp_who3[/url]

Try This

OR

Generate Insert Scripts[/url]

What exactly you are looking for, Share some detail the issue you are facing.

Nice question, good explanation.

get well soon.

Your WHERE Clause is causing the scan, if you replace it with below...

pmadhavapeddi22 (6/27/2014)

---

I generally use the below sql for logical name,physical name and path for any db, so this number seemed very familiar, after seeing the question, I have immediately tried...

check this http://stackoverflow.com/questions/6464601/how-to-validate-a-csv-file-before-importing-into-the-database-using-ssis

By the way how much time this query is taking, If you think index seek should be there instead of the index scan and your query is running properly then...

🙂 .... Best of luck

1st for all Highlight in yellow didn't worked.

Lets focus on the issue. This is what i have understand so far. if you have and ItemID = 57 data exists...

Grant Fritchey (6/26/2014)

---

I'm back where I was. I'd break it down into three tables, one to define the owner, one to define the competency and one to relate them to...

Okay, Glad to help. Old DEV mistake. Should be in the checklist from now on :-P.

so what you have decided in the light exciting (capabilities) and disappointing (too easy!)?

FileTables extend the capabilities of the FILESTREAM feature of SQL Server. so if you want to work with FileTables you need to enable the FileStream for that SQL SERVER Instance.