For creating a new role check sp_addrole in BOL.

About handing out permissions to a role or user search for GRANT

First of all I'd like to say it shouldn't make any difference when restoring a database from another server if it's a from a named instance or a default instance....

Not sure if I understand your problem.

Apart from the comma before the "For XML" your query looks good to me.

This should work (can't test it right now), at least if...

Since I have no idea in which format you want the XML output I can only advise to read up on the "FOR XML" option of a select statement.

The basic...

Simon_L (9/12/2008)

Does this mean each and every insert or update to this table will fail ? Or does it refer only to rows above the page size ..

Can I...

Since you're errorlog is from a SQL 2000 server it would help if you post it in the correct forum the next time.

Check this article for more info about your...

Have a look at this site:

http://vyaskn.tripod.com/fn_get_sql.htm

Oliver,

I know this can be very confusing for users who are new to SQL 2005 but you cannot add a user the the data_reader schema only grant rights on that...

There's no such thing in SQL Server as a maximum space limit for users.

Could you explain a bit more what you need.

Do you want to limit the amount...

In order to give the best answer we need to know how the table is queried, what kind of indexes exist, what datatypes are the columns which are typically...

The CONVERT function offers lots of different data styles. See Books Online for details.

Sorry but it's not easy to give you any syntax without knowing what exactly you want to know and why. If it's simly the info about which trigger was fired,...

Unless you add some audit logging inside your trigger there's no way to determine which trigger fired last.

In case you have more than one trigger on a table for the...

Sorry Mike,

but running performance monitor has no effect on you're database size or the transaction log unless you write the results directly to a database. Since you used a...

Dave

unfortunately you don't post the syntax for you're job. But the way I would go is executing the job in response to the alert and in the jobstep run sp_send_dbmail.