3ms is the smallest unit of time a datetime field can capture. So by subtracting 3ms from midnight, you get the latest possible time that could be captured on the...

look in books online at the set dateformat command.  But you should always try to get dates in a non-ambiguous format, such as YYYY-MM-DD (or better yet, as a native...

I agree - superb article.  All good points - must remember them if I am ever in such a situation in the future  ...

hahaha

Sorry, meant to say it was like the central part of your SQL Server installation.  It itself is essentially another database on SQL,...

Is it true that no matter what app they are running on '98 you get that same app name string?

OR, do you just get a rubbish app name string running...

Thanks for posting the solution - nice to know how these problems are solved.  Didn't occur to me that you were using remote proc execution - even then I wouldn't...

The textcopy utility is a program you run from the command line (cmd.exe) - kind of like copy, dir, etc...  As such, it is not useful for continuous use in...

We had the same problem and i determined it was probably due to our indexed views or computed columns.  We did the workaround suggested by Rudy, but I do like...

David, you have the same problem, although manually created by yourself.  The FULL database backups WILL interfere with your customised log shipping for the same reason that the SQL native...

Master is the "heart" of your SQL installation   It's hard enough to restore a backup of it - I can only imagine the...

You are using a group by to do a record count - perhaps it is joining back to itself to do the grouping?  Could you add an index on these...

There is also a command line utility you can used called textcopy for your bulk imports if it is a one-off job.

Backup & restore is usually the easiest way... Or detach/attach their DB files.

The appname is an optional parameter on your database connection string.  If you are using a custom-written app, you need to pass this as part of your ODBC or OLEDB...

There have been a couple of articles in the past month about this issue and how to use triggers to store the data, management of the history tables, etc.  Search...