You need an IF statement.

If x = 1

select y, z from my table

else

select y, z, from table2

You cannot change the from statement with a case.

Interesting, and I thought objectname was broken as a filter. Thanks for the info, scott.

It's highly frowned upon and could cause problems. In SQL Server 7, triggers on system tables were not guarenteed to fire.

I'd setup a job that runs every hour to look...

The app might have been an admin on the nondedicated machine and you were not aware of it. Being an admin and named pipes v TCP should not have anything...

Hopefully you can track an IP or hostname. If you can't, you might need a network sniffer to find the traffic.

Agree with above. The login failures are being caused by something else if your app is working.

Should fix them all, report how many were fixed. Are you running Auto fix?

Who owns the tables? If you own the tables and stored procedure, then you can grant execute on the procedure and the developer will be able to run it. If...

Are the Novell clients runnng Windows or Linux? Trusted connections are only available from Windows machines.

Sorry, only English here, but it seems like something errored out during the install. Since it's in another languange, I can't figure out the issue. You might need to call...

Something went wrong with the installation. You might need to remove and reinstall. Are you an admin on the remote box? I'm assuming this was a remote install of SQL...

Are you sure that the same version of SQL is on each? And the same version of XP? It sounds like either the SQL version, XP version, or SP is...

Allen's advice is the best way to do this.

Or at least the collation for master got set that way.

This is true, although it's a good thing. Don't want objects to exist without an owner.