Viewing 15 posts - 211 through 225 (of 5,842 total)
July 21, 2017 at 2:36 pm
The linked servers are using an account with SysAdmin privileges. It's a SQL-only login.
I'll...
July 21, 2017 at 11:54 am
July 20, 2017 at 8:13 pm
I have a highly normalized Dynamics...
July 20, 2017 at 10:40 am
Sunitha, you have enough visits and points on SSC.com to know how to post a question on the forum. We need create table scripts, inserts and expected output. There probably...
July 18, 2017 at 6:50 am
tcronin 95651 - Monday, July 17, 2017 9:47 AMnot a choice with this one so will have to wing it.
Good luck. I...
July 17, 2017 at 11:34 am
July 17, 2017 at 9:40 am
July 16, 2017 at 5:06 pm
July 16, 2017 at 9:07 am
July 14, 2017 at 4:56 pm
July 13, 2017 at 1:55 pm
If you have dynamic SQL in play there is no way to know what tables were affected, at least with any certainty. A grep of the plan cache would get...
July 12, 2017 at 8:18 pm
If you are just doing one row operations just pass in the remote row values as parameters for the sproc. Then you can use MERGE if you wish. NOTE: MERGE...
July 12, 2017 at 8:16 pm
Look up Itzik Ben-Gan Gaps and Islands TSQL to find a number of solutions to this classic problem.
July 12, 2017 at 8:13 pm
Viewing 15 posts - 211 through 225 (of 5,842 total)