If you are using SQL Server 2005 you have 2 procedures:- msdb.dbo.sp_send_dbmail and sys.xp_sendmail.

Database Mail is easy enough to set up to use the msdb.dbo.sp_send_dbmail procedure.

Calculate the date in a stored procedure or view, load that procedure/view as a dataset and call that in a parameter in reporting services.

If the server security is set to mixed mode then you can add a fixed id to run the report and use a specific user name and password in the...

Points noted thanks.

You can use the xml file:-

In Reporting Services create a new blank report and from the top menu select View then Code. Replace all the XML displayed...

In Management Studio under Management/Database Mail right click and see if you can send a test email. If not, check you have entered the correct mailserver_name.

In SQL Server Agent add...

The easiest way is to set up database mail, use the following script:-

/*==========================================================================

-- Purpose: Used to create Database Mail in SQL Server 2005

-- Author:Carolyn Richardson

-- Date:24/09/2007

-- ***Important***

--Alter the ServerName...

You can get the data from the error log with xp_readerrorlog, and extract as many rows as you need to send, as you may only want a day or so...

If you have the available time, you could script out the database without any of the collation statments, you could then create the new database with the script and migrate...

To change the collation at server level I believe you need to rebuild the master database, to handle the query:

SELECT ID

FROM ItemsTable

INNER JOIN AccountsTable

WHERE ItemsTable.Collation1Col COLLATE DATABASE_DEFAULT

= AccountsTable.Collation2Col COLLATE DATABASE_DEFAULT

The following will list all the settings, works in 2000 and 2005

SET NOCOUNT ON

DECLARE @DatabaseName sysname, @Servername varchar(Max), @Counter int

SET @DatabaseName = db_name()

SET @Servername = @@Servername

IF EXISTS (SELECT * FROM...

Script to add operator and add operator to alerts. You will need to alter the operator name and email address. You will also need to go into SQL Server Agent...

Not quite sure if it will help but you can use sp_helptext procedurename to get the text of the procedure, so you could loop through all the procedures select name...

How did you perform the upgrade? Have you reindexed after the upgrade?

I did mean SET TRANSACTION ISOLATION LEVEL READ COMMITTED, that would produce a result set containing only committed transactions.

Can you put locking hints on? ie:-

SET TRANSACTION ISOLATION LEVEL READ COMMITTED