Thought it was beamer?

Alternatively xp_sendmail can be used to send an email to anyone that can be resolved by the integrated mail services.

A net send message can be sent to a user who is connected to MSSQLServer, by using enterprise manager. Look under management, current activity, process info, and then right click...

OOOps, was supposed to reply and became a new topic. Code 18 i guess.

Not as far as i know. This is one of the reasons why MS recommend that Windows authentication is used - more protection.

I guess that you could run a...

There are often problems with the MAPI profiles, even when they have been set up correctly. You must log on to the server with the accout that is being used...

ALTER DATABASE [msdb] SET RECOVERY Full

This will change the recovery model.

This will return the players in order of the number of points they have attained, assuming that player can be used to join the tables.

select player,sum(points) 'Sum of points'

from tbl1.player...

The database users should expect to having their work load and activities traced. i think that it is always a good idea to keep a track of what is going...

You could consider calling the procedure from a loop, and then using a variable to determine the values being used. Lots of overhead for the server, since loads of results...

You could consider calling the procedure from a loop, and then using a variable to determine the values being used. Lots of overhead for the server, since loads of results...

Check with profiler that the SQL code you think is being passed to SQL Server is the code that is actually being sent to SQL Server from the asp page.

Also,...

You could consider using the triggers to perform the remote updates. To do this you can look at building distributed transactions to perform the actual updates. Remember to set xact_abort...