Look at the user accounts Language settngs, if British then has to be at the PC itself that it changed, especially if using a custom app.

If your system supports RAID 10 config then that would be best as long as you can afford the loss of have the total drive space. With RAID 5 you...

I agree with you after reading that. It says you cannot use the /3GB switch with Windows 2000 Server. Without it then you are only going to be able to...

Just remember to remove holidays and weekends wouldbe the only thing extra.

See/leave responses in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=119979&app=true

The problem is the WHERE clause processes the final resultset and removes all none matches. What you need to do is handle in the join condition like so:

SELECT     customers.number, customers.name,...

Depends on what you mean by memory however. The previous person hits on the aspect of the data on the file and in the row itself in memory which pretty...

Primary thing is it gives you a maintainence window were issues you are aware of can be addressed, patches can be handled and a way to say production code cannot...

Here is the code from the VB ActiveX DLL I use currently. Like I said thou I only use Eastern so I defaulted for my needs.

Public Function CvrtToGMT(DateIn As...

Interesting enough it will not accept alias.* but will accetp alias.colname. However I notice there is a couple of columns difference between the two so you may want to use...

Ok, I will check when I get to the office tomorrow to see if I can duplicate.

First check the database compatibility level of each db. If set to 7 or lower it may not allow the syntax but don't change unless you are sure it will not...

I didn't think that would stop you. You are suing SQL 2000? And if so are your databases compatability 8 or 7? I will have to test otherwise but this...

I think sp_spaceused will help you.

Ok lets break down the facts to make sure I understand.

1) These are the columns we have the most interest in.

   AssestID is the item

   AssestStatus is its status

   StatusDate...