Have a read through this[/url].

110 is the compatibility level for SQL Server 2012. You need to change to it to ensure you can use all the new features.

You can...

You'll need SQL Server to be running under a domain account on the source server and for that account to have write permission on the share.

RESTORE FILELISTONLY won't restore the...

Unless there's something I've missed, I think you just need to use the REPLACE function.

John

Don't know whether this[/url] helps?

John

To make it more flexible, you might consider doing it like this:

SELECT 'databaseA', columnlist FROM databaseA.dbo.table UNION ALL

SELECT 'databaseB', columnlist FROM databaseB.dbo.table UNION ALL

SELECT 'databaseC', columnlist FROM databaseC.dbo.table UNION ALL

etc...

I...

Have you looked at extended events? I don't know if it's possible to do what you're trying to do, but it's worth investigating.

John

Why not just set all databases to have the increased timeout? Is there any reason for any database not to have it? If you can only set it...

sknox (4/10/2015)

John Mitchell-245523 (4/10/2015)

I would argue that either is correct. If you interpret "116...

Yes, putting a column from the outer table into your WHERE clause turns your outer join into an inner join. Try turning WHERE into AND so that it becomes...

http://www.connectionstrings.com/%5B/url%5D

John

Yes, that "Mobile Equipments" category has appeared from nowhere. But all you need is a LEFT JOIN between the two tables, so that all rows from the left hand...

No, it's not as simple as that, and the more you look at it, the more complications you'll see. What about tabs, carriage returns, schema names, comments and other...

I would argue that either is correct. If you interpret "116 characters" as a...

If you're determined do this, you'll need to write yourself a parser. As far as I know, Microsoft haven't published the code for their SQL parser, so you'd be...

I've been through an exercise like this across multiple servers before, although I was lucky enough that the type of operation wasn't a requirement as it is here. I...