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...

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

---

Query used:

select

m.first_name, m.last_name, gh.*, pro.*

from enterprise.dbo.members m

inner join enterprise.dbo.group_header gh

on gh.group_num = m.group_num

left join dim_programs pro

on pro.program_code = m.program_code

where

m.group_num in ('SFVA00', 'SFA000', 'SFPA00', 'SFN000')

and date_effective =...

Kurt W. Zimmerman (7/15/2009)

---

Although SQL Server isn't supported on an NAS I managed several database servers that used NetAPP for a storage device. Stability was always an issue....

I see, you are remoting into the server and using...