Viewing 15 posts - 1,741 through 1,755 (of 7,187 total)
March 1, 2017 at 2:30 am
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...
March 1, 2017 at 2:24 am
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...
March 1, 2017 at 2:17 am
Why not just change the view definition so as not to display any rows for inactive customers?
John
February 28, 2017 at 9:08 am
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...
February 28, 2017 at 8:25 am
Yes, please try the SQL Server 2016 Upgrade Advisor.
John
February 28, 2017 at 3:30 am
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...
February 28, 2017 at 2:09 am
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...
February 27, 2017 at 5:45 am
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...
February 27, 2017 at 4:42 am
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...
February 27, 2017 at 2:30 am
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...
February 27, 2017 at 2:23 am
You don't actually say on which server you created the publication? By the way, the specifications you posted are for SSMS, not for the SQL Server database engine itself.
February 24, 2017 at 8:44 am
If I understand your requirement, you want all rows that have a Wait or Wrap Category that are followed by a row with a Logout category. Is that right? Does...
February 24, 2017 at 8:33 am
I think you're looking for the LAG and LEAD functions. Read about and experiment with them, and please post back if there's anything you don't understand.
John
February 24, 2017 at 6:47 am
Have you tried running SQL Server under a named Windows account (either domain or local) instead?
John
February 24, 2017 at 5:19 am
Viewing 15 posts - 1,741 through 1,755 (of 7,187 total)