sp_help_log_shipping_secondary_database @secondary_database = ''

Run that on the secondary server in master and it will tell you the last restored file, then you can investigate what went on.

You will need to do the LS configuration in one day if you are doing daily full backups. If you cannot do this then I would suggest taking a...

With something like the below

--CREATE A LOGIN WHICH WILL BE USED AS AN IMPERSONATION ACCOUNT FOR PEOPLE TO SEND MAIL FOR THIS TRIGGER ONLY

USE [MASTER]

GO

CREATE LOGIN [mail] WITH PASSWORD='', DEFAULT_DATABASE=[msdb],...

The LSN's are out of sync, it looks like either a manual transaction log backup was taken and not shipped or something deleted the transaction log before it was copied...

IP Address changed on the server, DNS not updated?

If you can connect via the IP locally but not the name it sounds like DNS to IP translation isnt functioning correctly,...

Its someone trying to impersonate someone.

Maybe a DDL trigger of some sorts.

Investigate the database in the error message for any objects using EXECUTE AS

Something like the below

SELECT

ClientNo,

[AAL],

[AAC],

[QPL]

FROM

(

SELECT * FROM #BaseData

) AS SourceData

PIVOT

(

COUNT(Code)

FOR Code IN ([AAL],[AAC],[QPL])

) as piv

Depends, could be either, if the space is used by temp objects, sorts etc and an extra temp object comes in and theres not enough space to store the temp...

Thanks Mike, this is sent via sp_send_dbmail as we use a 3rd party for hosting and we dont have SSRS installed on the 3rd party environment yet, but it is...

Not a problem at all sir.

Like this

CREATE TABLE #TEST(

ID int identity,

COL1 varchar(10))

DECLARE @ID INT,

@COL int

SET @ID=0

SET @COL=65

WHILE @COL<90

BEGIN

while @id<27

Begin

set @id=@id+1

insert into #test

select char(@COL)+cast(@ID as varchar)

end

set @ID = 0

set @COL = @COL+1

end

Thanks Gents, I didnt explain the situation clearly enough, by re-reading the originial post.

The idea is to show the earliest date on the left and the latest date on the...

Take a look at these links http://www.sqlservercentral.com/search/?q=cellnumber@txt.att.net or do a search in a search engine for SQL SMS GATEWAY

The system is out of memory then, I suggest limiting the result set or adding more RAM to the machines

Are you running SSMS locally or on the server.

Which ever it is that system doesnt have enough free memory to display the result set.