In SQL you grant access permission to WinNT loggins, not create.

If you know a DOS command prompt command to create a Login, maybe you could run it with master.dbo.xp_cmdShell.

...

Well if you are acceding your databases frecuently, then you should live them opened all time. Imagine that if you live auto close on, then every time a users want...

Yes, that is because of the Auto Close option. If it is set, SQL server automatically closes the database when the last user connected to the database disconnets.

Normally, all...

If you have everything configured, then check that SQL mail profiles.

From EM, over Support Services, SQL mail, right click, properties.

And SQL Server Agent, properties.

To be able to use mail you must use a Domain login account for your sql serverices.

Once you have configured that log on into windows with that account and create...

with sp_dropextendedproc 'xp_name'

If think that if you add a variable c(number of last column, like 12), before the bitmap variable it ahould work.

Maybe you should let SQL to built it. If you...

I would like to help you, but my English is not so good yet. If you use another word for thawing may be i can help you.

Sorry...

Exec sp_dropextendedproc 'Xp_name'

Any problem with your network?

That would give the free disk space. Is there a dos command to see the total disk space (used and not)

Only when the sa executes CREATE TABLE, SQL uses dbo to specify the table owner. Any non sa DB owner, to get his table like dbo.name should specify it explicity...

This is a great idea. But unfortunately, everybody post their questions in the Administration forum, what ever the question is.

that role doesn't exists by default in any sql server edition

You can't just resotre one db from sql 7 to sql 2000. You can, upgrade your sql server 7 to 2000 or make a complete database script of your sql...