That's right - unless IMPLICIT_TRANSACTIONS is ON for your connection. It's not the default, so it's unlikely to be on unless you consciously set it to be.

John

The best way to find out is to try it, of course. If you did, you'd get a message saying that the ROLLBACK has no corresponding BEGIN TRANSACTION, which,...

That's right. But don't take my word for it - do some reading on merge replication, and then set up a test if you think it fits your requirements.

John

No, with merge replication you read and write against your local database and the conflicts are resolved and changes merged so that the two (or more) databases stay in sync.

John

Sounds like a job for merge replication. Have you looked into that?

John

OK, so the schema thing is a red herring. Do you want to move all objects? Do you want to move data, or just create empty tables? ...

As Thom said, all objects have a schema. However, you can refer to an object without using its schema name if, I think, your login's default schema is the...

So you have a schema called AdventureWorks2014 that has objects in it, and you have an empty schema called AdventureWorks2019 that you want to move those objects to. Is...

First, your USE statement only changes the database context for the batch in which it's executed, which, in your case, is only the USE statement itself.

Second, creating a database called...

Do you mean can you run reports against databases on a 2012 server? Yes, you can. If you mean can you have your Reporting Services databases on a...

OK, fair enough.

The OUTPUT clause goes before the WHERE clause. Are you not getting a syntax error?

Some sample data would be very helpful here. If the StartTime to...

Not sure whether this is an option for you, but my suggestion is just to ditch the loop. You can replace the whole lot with something like this:DELETE FROM...

I'm not sure exactly how it works, but I don't think I've ever had a restore fail on database in use after setting it to single user. I suppose...

Or this:ALTER DATABASE SQLTRIX SET SINGLE_USER WITH ROLLBACK IMMEDIATE

You can use RESTRICTED USER instead of SINGLE USER if that's more appropriate (in other words if none of the processes that...

J Livingston SQL (12/2/2016)

---

sac.nan (12/2/2016)

---

J Livingston SQL (12/2/2016)

---

maybe...???

WITH C1

AS (SELECT id,

...