I agree with Gail.  Don't forget there are only two RDP connections to each server, and if someone wants to do some genuine maintenance work, they don't want to have...

Possibly a parameter sniffing problem.  Why are you staging the parameter values in @meter_table instead of passing them directly to the function?

John

Yes, you can do that.  Make sure you back up all your user database first, and script out important system stuff such as jobs and logins.  Bear in mind that...

If you must use triggers, put them on the base table(s) instead of on the view.  But consider first whether there's an alternative solution - maybe a job that polls...

Assigning a value to a variable sets @@ROWCOUNT to 1, so @@ROWCOUNT will always be 1 at the end of the loop and hence you'll be looping indefinitely.  I have...

Why not just change the view definition so as not to display any rows for inactive customers?

John

If you're on SQL Server 2012, you can use either of these.  You need the "-1" so that it gives the beginning of the previous month on the first of...

Yes, please try the SQL Server 2016 Upgrade Advisor.

John

No, sorry.  Just make sure that you've removed all traces of replication, not just the ones you can see, and try again.  There's lots of resources that tell you how...

The subscriber version has to be less than or equal to the publisher version.  Therefore your Web server needs to be the Publisher.  I recommend that you research how to...

EXEC xp_msver

Are you saying that whichever server you make the publisher, you attempt to create a subscription on the other and you get the same error...

This is how you do it.  You need two separate accounts, one for SQL Server and one for SQL Server Agent (you can use the same for each...

I don't recommend using an environment variable - there are too many problems such as the one that you're seeing.  And you have to restart your computer - fine in...