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...

what is the goal?

to have 63 different copies of the MDF file on the archive server?

to have 63 different copies of a backup of the database on the archive server?

to...

way 1

SELECT

Ref

,MAX(TransactionDate) AS [Transaction Date]

FROM

Transactions

JOIN

BFlights

ON

BFlights.TransactionID = Transactions.TransactionID

WHERE

(Ref = '129577')

GROUP BY

Ref

way2

SELECT

Ref

,MAX(TransactionDate) AS [Transaction Date]

FROM ...

where does the column TransactionDate come from, its not in any of the two tables?

is there more at play here than the snippit you provided?

can you please post the create table statements for each table, will hopefully help us understand a bit more to whats going on

also are BFlights and Transactions in the same...