Print ER diagram for a database in SQL Server

Hi there,
I am a newbie to SQL Server so please bear with me if I happen to ask a
stupid question.
I am trying to print the ER diagram for our database in SQL server. In
Enterprise Manager we have an option to create the ER Diagram and then to
print it. But the problem is it prints into several pages.
I want in to print on a large paper so I could stick it to my wall. We have
a 36'x36' plotter that could print huge diagrams.
Do I have to convert it into PDF to print in on page.
Please give me some ideas.
thanks,
UdayUday,
right-click on the white background on the database
diagram and select Page Setup. You can select different
page sizes and scale ratios on this form.
Rgds,
Paul Ibison (SQL Server MVP)|||You might also want to create "subject" areas by creating several individual
diagrams for the functional areas of the database instead of the entire
thing in one.
Sincerely,
Anthony Thomas
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:02af01c4dc3c$1ce5b0a0$a601280a@.phx.gbl...
Uday,
right-click on the white background on the database
diagram and select Page Setup. You can select different
page sizes and scale ratios on this form.
Rgds,
Paul Ibison (SQL Server MVP)

Preventing database access from server..

Hello,
I'm a bit new to SQL, so bear with me please.
There is myself and an assitant in charge of our SQL server. I have 2
databases attached and I want to block my assistant from accessing one of
them.
How do I actually prevent him from accessing this other DB at all?
Note that he will however need to be able to BACK IT UP.
Is it possible to block all access of him opening tables or doing quiries
but allowing him to schedulae its backups (data and logs)?
Thanks much,
MarkCreate a Login for your assistant that does not belong to a server
role. Make that login a user in a database and a member of the
db_backupoperator role in that database.
Mrpush wrote:
> Hello,
> I'm a bit new to SQL, so bear with me please.
> There is myself and an assitant in charge of our SQL server. I have 2
> databases attached and I want to block my assistant from accessing one of
> them.
> How do I actually prevent him from accessing this other DB at all?
> Note that he will however need to be able to BACK IT UP.
> Is it possible to block all access of him opening tables or doing quiries
> but allowing him to schedulae its backups (data and logs)?
> Thanks much,
> Mark