I would suggest you update your client tools to the same service pack applied to the server.

I've come across this one before. Re-installing the client tools on the offending PC resolved the issue.

I've used this configuration many times especially when upgrading SQL Server 7.0 to SQL Server 2000. You need the install 7.0 as the default instance and install 2000 as a...

If you are thinking of exporting to a text file to make a mailing label, you could do that with ActiveX scripting in your DTS package. You may need the...

There are many ways to skin a cat. Depending on your source you could select only rows that are not already in your target table (assuming there are ways to...

Personally, I think modifying a system table this way is a bad idea. First off, there is no guarantee that your trigger will persist if you upgrade or apply service...

You could create a DTS package to do that.

Could you check that the user DOMAINNAME\me has SELECT rights to your table DPEVENTD? SQLSTATE 42000 is for "syntax error or access violation"

I found that changing the @query variable to the following format helped solved a similar problem in the past.

SELECT COUNT(1) FROM database.owner.tablename

Will this do it?

<code>

SELECT employeeAccident.TrackingNumber, AccidentInfo.dateOfAccident, AccidentInfo.timeOfAccident, AccidentInfo.caller, AccidentInfo.operator,...

I solved a similar problem a while back using DTS in conjuction with ActiveX scripting. Is this an option for you?

I doubt if you could do this. But it's possible to simulate using TRIGGERS.

I'd suggest you use the return value from a procedure in this way only to indicate the success or failure of execution. Although many developers use it this way...

You could create a UDF that accepts two dates (and the day of week you want to count between the two dates) and returns the number of the count. ...

If you have Outlook as the client on your server, it is probably installed in the 'Internet Only' E-mail service option. You may need to change this to 'Corporate...