The time-difference between the two computers are to large. See if the answer on these two websites give you the solution:

http://support.microsoft.com/kb/297234

http://suppot.moonpoint.com/os/windows/domain/clocks-skewed.html

I thought putting the integer value 500000 into a varchar(5) would result in a string with value '50000' (removed last 0). Now I learned it's resulting in a string with...

You can try to periodically run a job that checks if a new database is added. If so, grant users the permissions to that database (using dynamic SQL?).

You need a network-service account when the service needs to read from or write to a network location. When this is not required you can use a local account.

Did it ever run correct? If so, what has changed?

Under what service-account is the service running? Try using the same account as the SQL Server Engine Service.

Matt Miller (9/26/2008)

---

Actually - no. A row is only updated once in each operation, so if a join might yield the same left rowmultiple times, the row is updated...

If you mean a 'Carriage Return' by CR then look at the "char" function: char(10) = linefeed, char(13) = carriage return.

Replace the '~~' with the technique Lowell showed in a...

It's easier to add filters to your reports to only use data before {today}-00:00hr.

Even when you start a job at exact 24:00hr it can take some time before the action...

try this:

SELECT *

FROM [Option]

LEFT OUTER JOIN

(SELECT VehicleOption.OptionID, VehicleOption.VehicleOptionID, VehicleOption.VehicleID, VehicleInfo

FROM VehicleOption

LEFT OUTER JOIN Vehicle ON VehicleOption.VehicleID = Vehicle.VehicelID

WHERE VehicleInfo = 'TOYOTA' --...

To prevent loss of speed with your queries without the WITH (NOLOCK) option, you must keep all exclusive locks (INSERTs, UPDATEs) to a minimum. That means optimizing the code to...

swapshines9 (9/24/2008)

Now I need to create sp that insert values in to the third table and save, but the EmpDeptName should not be visible in the backend. Actually I had...

I quess a UPDATE-trigger would be fired multiple times, but I'm not sure. You can test this by letting the trigger add a row with the updated values to a...

Your environment is working at this moment, so you could leave it as is. But invalid...

If you have to change several columns, try to split up the changes in portions you can handle. Begin with adding 1 (empty) column. Fill this column with converted datetime...

Primary Key can only contain unique values. You second insert tries to add value 1, 2, 3, 4 and 5 to the primary key but these values allready exist, thus...