you should have an RTO in place and if logshipping of the primary server fails you need to fix the problems within the RTO or bring the secondary database online,...

just a thought but do you need to send 20 messages in one session? could you not store the individual email

bodies in one table then at the end...

as vinu pointed out you will need to use alter table drop constraint and the drop index commands

please ensure that you know what the definition of these objects are before...

anything specific you want to know or just in general, google has a lot of good links based on your term

open management studio --> expand databases --> expand the database --> expand tables --> expand the table -->

expand keys --> right click the key --> script key as...

first off ask you smtp admins what the maximum mail per session is set at

you should be able to limit the amount of mail it sends in one go by...

Its all personal preference.

Personally I am in favour of creating brand new groups for SSRS access so that you know exactly what the groups are called and you can give...

SQL 2008 is the version, the edition is Express, Standard, Developer, Enterprise.

Is this a named instance?

Can you ping the server by IP, Name and FQDN from the machine...

what edition of sql is this?

have you run through the sql server configuration manager and enabled tcp/ip, named pipes etc?

Sean Lange (5/1/2012)

---

anthony.green (5/1/2012)

---

couple of ways

SELECT TOP 1 MAX(dbo.BookedFinance.GrossProfit) AS GP,

dbo.BookedFinance.FinanceID

FROM dbo.BookedExtrasList INNER JOIN

...

couple of ways

SELECT TOP 1 MAX(dbo.BookedFinance.GrossProfit) AS GP,

dbo.BookedFinance.FinanceID

FROM dbo.BookedExtrasList INNER JOIN

...

Bananaman

are you sure thats the correct spelling of the interview questions and the correct terminology used?

quite a few options on this

create a central management server and write a query which loops through the MSDB tables to get the information you need, that way you only...

you will firstly need to detach the database due to SQL holding a lock on the file which will prevent you from doing anything with it (sp_detach_db), you will then...