We should also take a look in the transaction log to see what transactions are being execute - but, that is going to be a lot of data to search...

There is definitely something filing into the model database. Run the following to see if there are any user objects in this database:

Use model;

Select *

From sys.objects o

...

Well, the only other thing I think it could be is that the operator is not set to the right email address. Try executing sp_notify_operator to test the operator...

I wouldn't use schemas in that way - you really should be looking at using schemas to separate out objects by category/department/etc...

You would still use roles to define the different...

The model database is a system database in SQL Server. It is the database that is used as the 'model' for a new database when you issue a create...

I am not sure what you are asking - but if you lookup GRANT in books online it has several examples of how to grant security.

I believe what you are seeing is the report created from the maintenance plan. Open the maintenance plan and click the little button to the right of manage connections....

Are you sure the column definitions are the same? Could one be varchar and the other char?

I would recommend using Redgates SQL Compare tool to perform a schema comparison...

Steve Jones - Editor (7/15/2009)

---

My guess is your database is in the full recovery model and you are not making log backups.

The short answer is that you should:

1. Backup the...

Let's say you have 90 procedures in myschema. You want to grant execute rights to a role all the procedures in that schema. And, you know the developers...

You have to zip the execution plans up - we can't do anything with them when they have the .sqlplan extension.

Edit: Nevermind - I was able to download them as...

J.D. Gonzalez (7/15/2009)

---

date_effective is set up as a datetime.

Just for clarification, hard coding the date or using a parameter seems to be very efficient. It's when I...

No bother - glad you were able to figure it out. Be careful, if you are going to be running this long term you will be much better off...

Are you looking for an automated way to do this? If so, the only thing I know of would be to build a server side trace to capture it....

zenrigar (7/15/2009)

---

Thanks for the fast replys, i used both suggestions and both worked,

the diference is that sp_helptext gives me rows with fragments of code, and those look like a...