Thank you. That works well!

If you need to automate this then you may need to create a table with all user tables and permissions on it and then grant the permissions. Sorry, but I...

You can configure SQL Mail to send you any type of email based on any SQL Server event.

As for the status of Replication, just what exactly would you like emailed?

Thanks. I'll give it a go.

Ok. Thanks.

Sure have. I have a work around by using a Physical Table. I just wanted to see if it was possible using a temp table.

1 more question, how do you...

Thanks to all for the input but this is how I have mananged to get it working.

DECLARE @StartDate VARCHAR(20), @EndDate VARCHAR(20)

SET DATEFORMAT DMY

SET @StartDate = '01/01/2005'

SET @EndDate '31/01/2005'

SELECT * FROM...

SET DATEFORMAT does not work!

Michael Du Bois,

I have no choice but to parse the 2 input paramaters as dmy. Your example does...

No worries thanks.

No need to perfrom a convert/cast Ron K. WHERE CURRENT OF will do the trick. The SET BASED solution from PW is attractive as well.

Thanks for your help folks.

I forgot to mention that the the CRED_ID COLUMN is a VARCHAR(10)

I thought that the initial select for the cursor would have catered for that but nevertheless I have changed it now to;

UPDATE WorkSite SET CRED_ID = @Value

 WHERE CRED_ID IS NULL

but...

Thanks for that PW.

Are you saying that It would be better to allow NULL on the Column and let the Application test for NULL and make it an empty string...

Thanks for the solutions guys! I have performed PW's method of converting it to a varchar.

Let me explain a few things that you guys have asked!

1) Firstly, a Company may...

I'll have aread of the article however, I'm able to retrieve fragmentation info for the IndexID of 0. I must say, it is very fragmented.