Those are pretty old catalog tables now from SQL Server 2000. They've since been replaced by the likes of sys.database_principals and sys.database_role_members.

For more information, I'd suggest having a good...

Column aliasing is perfomed at selection, not as part of the column metadata (though you could do this via extended properties, I'm not sure how practical that would be to...

What you're describing you want to see sounds more like a fixed width file rather than a tab delimited file.

The purpose of delimited files is that you only need to...

GilaMonster (5/14/2013)

---

It is possible to have the mirror a higher version, but as I said it's a stupid thing to do and iirc it takes extra work to even set...

What messages, exactly? Are you sure that they're messages and not simply the results of the query being displayed to text?

Can you please provide the DDL statements for...

Try using the SQL Server Migration Assistant instead; it can be downloaded here:-

http://www.microsoft.com/en-gb/download/details.aspx?id=28763

With the values in your case statement provided with that dataset, that will simply produce 'N' for every row!

The only problem with this is that it doesn't produce the required dataset as there are rows with the value 'N' for the Response value of 15053.

So either the desired...

In the sample data you have provided, you are actually attempting to insert a string into your column rather than a NULL value, which then fails because your Respons and...

Heh, it's just yet another thing on my list of why upgrading to enterprise would be advisable.

I may just float the idea that regular transactional replication is effectively what they...

Ah I didn't realise you could use transactional replication with the simple model.

Unfortunately, we have the Standard edition of SQL Server, so snapshots are unavailable. 🙁

Thanks for the reply!

Some of the reasons for not using transactional replication is that a number of the databases that are only updated monthly use the simple recovery model (should...

This is the code for what I was referring to earlier; but I agree that Itzik Ben-Gan's gaps and islands techniques are well worth checking out.

CREATE TABLE #tmp

(ID int primary...

You're better off having two seperate queries, which are controlled by the parameter you put in.

Something like:-

/*Parameter Area*/

declare @StartDate as datetime

set @StartDate ='09-MAY-12'

declare @EndDate as datetime

set @EndDate ='09-MAY-12'

declare @With_MonthYear as...

Thanks, I'll check it out this afternoon!