I do not understand your answer,what does PerfMon has to do with Profiler?

Unfortunately, we live in a world in which perception is evething, take the 2005 and then the 2008. in the eyes of all hiring you will look at two certifications...

Mr. Journeyman

there are several things to consider here, One the table may not be the only issue, you have to look at the store procedures and tune the store procedures...

if you have not solved the problem yet, the most logical option is to link the servers, the use the openrowset or just use the format which I use which...

Where is the Query being executed, in the access database side or in SQL Express? and do you have the tables linked via ODBC CODE using VBA or VB6 or...

Thanks for the Correction, Please understand I was very busy at the time. thx:w00t:

Found it on SQL 2000

Guys

All Issues where resolved. here the answer was to use a non documented store procedure called xp_FileExist and catch the reurtn code.

exec xp_fileexit 'c:\tst.txt', @catchcode Output

if...

First of all I need to appologize for the wrong info I provide you with. that happens when switching from VB to CS.

Solution: Server=".\\DBName;" +

The "\\" well think...

Guys!

I solved the problem. the answer is simply "Default"

insert into tt99(Datetime2, description)

values (default,'Testing the Default')

simple is it not?

😛

Having Worked in the World of MainFrames, both as an Operator and Applications developer, I am familiar with the problem you face that is not Unique. fact this is another...

Did You test it?

Yes I did tried it.

thanks

string conStr = @"Server = .\sqlexpress" _

& ...

Q. have you solved this problem? let me know. thanks :hehe:

Are You talking Link Tables, LinkServers or Linked tables is Access. can you clearify the Q.

😎