I didn't think with regards to that, that anything was different. Might watch both with profiler to see if anything happens on the backend under the hood. But considering they...

So far I have not seen any jobs requesting an MCDBA without experience. I made myself a position during our Y2K roleover is how I got my foot into the...

Question duplicated in the following thread please see both for future reference http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8571&FORUM_ID=19&CAT_ID=3&Topic_Title=How+to+run+a+dts+package+by+a+user+who+is+not+in+u&Forum_Title=Data+Transformation+Services+%28DTS%29

I thought DBF was a sturtured file, not delimited. Try using DTS to pull in with the FoxPro provider. Don't think Bulk Insert can do it.

Ok, setup profiler on the server and see if it shows anything specific would be my next spot to look. Watch what happens and see if any events occur taht...

No, but you could build a mechanis into your app to capture the user, timeofstart and spid each time someone starts the app.

I believe if you are talking about dynamicSQL method it will be based on either the users login account (which would have to be a windows account) or the servers...

I haven't seen any major hits on resources in my solution. Let me know if you need help, should be interesting to try that way.

How are they accesing the information. You maye just need to create a VB DLL to get the file creation or modified date and pass to them. But as to...

I believe thou you can create a temp table instead liek

CREATE TABLE #var (x int)

and use a reference inside the UDF to #var. As long as in the same...

Actually I do this with a schedual adhrence app that I created to verify a person is on the phone when they should be and not when they should not.

Since...

Look at your execution plan for each and make sure are the same. Also, consider other loads and a stored plan can effect overall performance on queries. I have never...

DYnamic mean can be change at runtime. In the case the variables are dynamic in that the compiled code expects these twos values to change and needs that input from...

You might also want to try using profiler to catch what is happening with the database. A few notes, Temp tables, order by and suqueries make inserts into that database...

Besides on the row level I believe varchars physically vary and there is a pointer object to define next column. So unless all your data does not use any of...