When logging on as SA, there is no matchning LanManName.

Thanks! I hope the code works out for you.

If you have the time and courage, I would suggest another environment for you, since your environment has a number of flaws....

There is a tool named SQLIOStress that can be downloaded from Microsoft's site.

So the tables are the files as well? You do not use .vfp or .dbf files either?

Ok, do you then have the right permissions on the server to query (read...

I think Tim meant that it is not really a T-SQL problem. It's rather a problem with OPENROWSET usage.

Select * from openrowset('VFPOLEDB.1','C:\Client Data';;,'Select * from cm')

I can see that...

Here is the breakdown of the test data

Your trigger TRIGGER1 on MyTable self-triggers!

Please use UPDATE() function and exclude columns LastUpdateDate and LastUpdateUser.

Alternatively, set these columns with default values GETDATE() and SUSER_SNAME() and use trigger only when updating.

Books...

No, it will not change the fact that you sometimes have time with '1899-12-30' (ms access standard) and sometimes time with '1900-01-01' (ms sql server standard).

The problem arises when adding...

See Last Post!

No offense, but it is how SQL treats trailing spaces, not leading spaces.

select            len('     g'),

           datalength('     g'),

                  len('G     '),

           datalength('G    ...

2 + logindate + loginzeit

is for that you have altered the default date for smalldatetime/datetime values from 1 jan 1900 to 30 dec, 1899. This is two days...

Here is a solution that works for your environment.

This is not an environment I recommend.

See Last Post!

How do you count a work-day when logging in 21:30 saturday and logging out 06:30 sunday, where saturday is the last day of september 2006 and sunday is first day...

If you use an "everyday" table, you will not have to worry about a massive checks for "special days" as vacation and week days.

Extend "Everyday" table with two columns. One...