encryping is useless. because you can find plenty of tools to decrypt them.

So it makes no sense.

that is why I want to protect them with user privileges

how can I revoke the permission to generate the edit script?

Because I don't wan't them to see the source code

I'll tell the whole story.

I have got 3 scripts.

1==> creates db + tables and users

2==> creates objects (functions and stored procedures)

3==> sets user rights.

I believe The 3 scripts are...

when I login as nagios I am able to edit the stored procedures

and I am not able to edit the tables used in the script.

thanks.

I fixed it thanks to you guys

Carl Federl (5/20/2008)

---

Looks like the first time you run the SQL, the database context is unknown but the second time, the context is the user database.

Move the "Use [nagios]" statement...

I've found the solution @ http://www.sqldev.net/sqlagent/SQLAgentDateTime.htm

Thanks!

Owkey, but there's nothings said over a run_time with a value of 0 or 1 :/

Oke, i've used the sys.database_files table to get information about the data files of the database that is currently in use (with the USE statement you can change it).

So i've...

:w00t: nice it works ! 🙂

OMFG that's very stupid ... but now:

IN my real project I need to divide 2 integers to calculate the % of log space used so:

(@used / @max-2)*100 ==>...

Thank you verry mutch :)\0/

A last question: when I use more than 1 data file, will sql server automatically use the next file if one is full ? or does...

Nice I see there a column named "max_size", but at the moment i've set my data file to 100MB restricted growth, and the value in de column max_size is 12800,...

Thank for al this answers, I'll implement a few of them tomorrow, the cpu, memory monitorring is easy as hell in Nagios. For us it's more the part of database...