Well I passed, was doubting myself a little while I was in there, and was glad that I reviewed a couple of the questions otherwise I bet it wouldnt of...

that's because sp_send_dbmail exists in the msdb database, so you need to do msdb.dbo.sp_send_dbmail

i believe google might be broke today

some post installation steps

click here[/url]

i dont get how the foreign key is working, thats if a foreign key has been recreated

how can a column with values

1

2

3

reference a row with value

1,2,3

just not possible.

To follow on from this, there will be an additional charge for SQL licences should...

Prerequisites, Restrictions, and Recommendations for Database Mirroring

http://msdn.microsoft.com/en-us/library/ms366349.aspx

In that case I would set the memory available to SQL to 22GB for server1 and 10GB for server2, I wouldnt usually do this via sp_configure, yet the GUI

right click...

what are the servers going to be doing

as it will all depend on what you need to configure.

are they just the SQL engine, or do they have SSAS/SSIS/SSRS as well...

you could but a group by or a distinct in the query to rollup the data so that the duplicates are removed.

group by

select

...

what do you need to configure?

first thing would be show advanced options to get the full list of configurables.

sp_configure 'show advanced options',1

go

reconfigure

go

Sorry Lowell is that to myself or to Halifaxdal?

halifaxdal (12/8/2011)

---

Works for majority of the sp and fn but throws out some exception:

Msg 4606, Level 16, State 1, Line 1

Granted or revoked privilege EXECUTE is not compatible with object.

Can't...

you wont be able to see anything in the securables section unless you search for a type of database.

i just did the same as Lowell and looked at my test...

you could just do grant execute on database::databasename to rolename if its going to be for all procs in that database forgot about that

edit

ah that works too Lowell, didnt know...

I would loop through the system tables

something like this

SELECT

'GRANT EXECUTE ON '+

obj.name +

' TO RoleName;'

FROM

sysobjects obj

WHERE

xtype = 'p'

Returns a single column, then its just copy and paste into the...