You may want to find a different way to meet your goals. Microsoft is discontinuing Notification Services in SQL Server 2008, so if you're just now planning to start...

The easiest way is to look at the job history in Management Studio, it's the last line of the "selected row details:" section. Or you can see it by...

The answer depends on how the database is set up, check if the following query returns 1 for is_auto_update_stats_on or is_auto_update_stats_async_on:

[font="Courier New"]select name, database_id, is_auto_update_stats_on, is_auto_update_stats_async_on

from master.sys.databases[/font]

When auto...

At the most basic level, there are 2 types of queries in a SQL Server stored procedure. There are ones that set the value of a variable such as:

SELECT...