Thanks Guys!

I will be modifying what Paul wrote to make is a bit more dynamic and suit what my App needs.

Cheers!

Paul,

Thanks for your reply. Your way works, but is there a way to have a "OR" in the RegEx?

1234 OR 4444

Here is a small example of what I am trying to do...

--*********

declare @String varchar(300)

set @String = 'here is my phone number 1234567890. but my cell is 4444444444, and my work...

I think what i am going to have to do is create a job that runs every 20 min or so iterating through the db's and checks to see if...

That worked for a database that is newly created. Is there anything that I could do for databases that are restored from a backup, to super seed the backup...

Hey George,

Thanks!! That did it.

Hey Steve,

Databases are created on the fly... Its not as simple as a DBA creating the database and adding the group to db_datareader.

Try changing the permision on the two folders for RS in IIS to integrated windows authentication only.  Then upload your new reports, then change the permision back to anonymous access.