You have RTM, SP and CU's in SQL.

The RTM is the first release which is ready to manufacture / market (forget the actual term), then MS release CU's (cumulative updates),...

Many different ways

1. Right click the login, select script login as, then create to new query window

2. Google "sp_help_revlogin"

3. SSIS Transfer logins task

4. Manually recreate them on the second server

Also...

I would recommend reading chapter 3 of the Accidental DBA Guide (link in my signature below).

USE MASTER

GO

EXEC sp_resetstatus '<databasename>'

GO

ALTER DATABASE <databasename> SET EMERGENCY

GO

ALTER DATABASE <databasename> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

DBCC CHECKDB (<databasename>, REPAIR_ALLOW_DATA_LOSS)

GO

ALTER DATABASE <databasename> SET MULTI_USER

GO

Or restore the database from a backup and apply...

DBCC DROPCLEANBUFFERS - Removes all clean buffers from the buffer pool.

DBCC FREESESSIONCACHE - Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.

Yeah thats by design, as the retention period has expired and therefore SQL will delete the file even if it hasn't been copied to the secondary.

Typically in this situation where...

But be sure you dont run that on a production server, unless you can live with the performance bottleneck while SQL rebuilds the cache.

Something like this?

SELECT

TD.*

FROM

[#TransactionDetail] TD

INNER JOIN

#Version V

ON

TD.VersionID = V.VersionName

WHERE

TD.PERIOD >= V.StartMonth

AND

TD.PERIOD < V.EndMonth

AND

V.IsActive = 1

If not, based on the sample data you provided, what should be the...

Are the system databases in the default location or have they been moved to a different drive than the SQL binaries?

Hi

Welcome to SSC.

Would you be so kind as to read the second link in my signature below on posting code and data for the best help?

With the information you provide...

No it doesnt as technically its 1 row of data so it displays it as 1 row.

If you change the query output to text you will see it with the...

A simple concatination will do the trick adding in CHAR(10) + CHAR(13) for CR & LF

declare @table table (ColA char(1),ColB char(4))

insert into @table values ('A','The'),('B','iss'),('C','uout')

declare @variable nvarchar(max) = ''

select @variable...

Run DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS and post the results.

Why nolock? Do you know the consequences of using that hint?

Also if you need to use nolock make sure its WITH (NOLOCK) and not just (NOLOCK)

I've only found one topic on this, but it said it is OK to delete from sysssislog manually

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/ef333ad4-d370-4cea-8055-227d402ba65b