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,

...

If you're just doing this to follow along with an exercise, set the value of the variable by typing it into the pane. If you're doing it with the...

Well, then you need an identity column in your table and a cast-iron process for making sure the data goes into the table in the same order that you receive...

That will bite you very hard at some point. What happens when someone creates a clustered index on p2p? The rows will (or are most likely to) go...

So you want to fetch the unique identifier for the user that's running the report? This relies on users running the report using their own Windows credentials. You...