No announcements
Found 51771 threads
-
0 VotesFiltered Scopes and SelectChanges stored procedures
a row getting selected by the SelectChanges sp doesnt guarantee that it's going to be applied. it's just what it is, a detected change.Answered | 2 Replies | 2345 Views | Created by chuck the greek - Tuesday, June 18, 2013 6:32 PM | Last reply by chuck the greek - Wednesday, October 23, 2013 7:48 PM
-
0 Votes
Creating multiple scopes on same table
I forgot to mention, scope names must be unique.Answered | 3 Replies | 7730 Views | Created by AjinathWaghmode - Monday, May 31, 2010 10:38 AM | Last reply by JuneT - Monday, May 31, 2010 12:37 PM -
0 Votes
Problem with dynamic row filtering in Sync Framework 2.0
There is of course an initial provisioning of the server (I use the base name SCOPE for this) followed by the customization of all of the selectchanges SPs for dynamic ...Answered | 20 Replies | 10662 Views | Created by PuzzledBuckeye - Wednesday, March 17, 2010 6:24 PM | Last reply by Speedware - Tuesday, July 6, 2010 2:31 PM -
0 Votes
Problem with selectchanges on a large table
The ability to apply changes in batch transactions (as opposed to a stored procedure call per update) looks particularly appealing.Answered | 8 Replies | 9993 Views | Created by PuzzledBuckeye - Thursday, December 2, 2010 6:17 PM | Last reply by jigu2014 - Thursday, December 23, 2010 12:56 AM -
1 Votes
Debugging stored procedures with temp tables
How to: Debug Stored Procedures How to debug stored procedures in Visual Studio ...Answered | 4 Replies | 1976 Views | Created by JFBconsul - Wednesday, May 21, 2014 11:37 AM | Last reply by Dave Patrick - Thursday, May 22, 2014 1:38 AM -
0 Votes
create a oracle stored procedure
how to create a oracle stored procedure - 1. select statement insert/update and delete and how to write a code to ...Answered | 1 Replies | 6345 Views | Created by Sathishkumar.spsk - Wednesday, September 14, 2011 6:33 PM | Last reply by Jens K. Suessmeyer - - Wednesday, September 14, 2011 9:08 PM -
0 Votes
SqlSyncScopeProvisioning - How to add complex filter
If you look at the SelectChanges stored procedure, the FilterClause that you specify is actually concatenated as an extra condition (using AND) to an existing WHERE ...Answered | 6 Replies | 7837 Views | Created by AjinathWaghmode - Wednesday, May 26, 2010 6:01 AM | Last reply by AjinathWaghmode - Tuesday, June 1, 2010 10:04 AM -
0 Votes
SCOM store procedure
Hello, This is question on MSMOM 2007 or SCOM, our application user store procedure p_AlertUpdateByAlertIdAndCreateHistory to close MSMOM alarms in MSMOM2005.Answered | 1 Replies | 8121 Views | Created by Matt Cusson - Monday, November 2, 2009 10:01 PM | Last reply by Tagore Bandlamudi - Thursday, January 28, 2010 10:55 AM -
0 Votes
ado.net how to pass parameter using stored procedure
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?Answered | 2 Replies | 1221 Views | Created by anil bhadke - Wednesday, March 9, 2016 7:24 PM | Last reply by Dave Patrick - Thursday, March 10, 2016 4:20 PM -
0 Votes
NHibernate - Simulate a stored procedure
I want stop using stored procedures and begin to use ORM.Answered | 2 Replies | 1398 Views | Created by juanchiy2k - Monday, April 6, 2015 10:41 PM | Last reply by Caillen - Wednesday, April 8, 2015 5:05 AM -
1 Votes
Updation of stored procedures in CRM report
Hi Scott, My mistake i was using alter procedure ... instead of create procedure first and then alter ...Answered | 3 Replies | 3049 Views | Created by Simran08 - Wednesday, January 11, 2012 4:52 PM | Last reply by Simran08 - Thursday, January 12, 2012 11:50 AM -
0 Votes
How does a CRM report use a stored procedure
User Id - you can both pass and get in the body of stored procedure (like in sample).Answered | 7 Replies | 5797 Views | Created by mardukes - Monday, October 4, 2010 3:44 AM | Last reply by mardukes - Monday, October 4, 2010 4:01 PM -
0 Votes
Problem with Provisionig scope with Static Filter using SyncFx 2.1
I provision the scopes executing the script generated from SqlsyncScopeProvisioning.Script().Answered | 5 Replies | 7333 Views | Created by AjinathWaghmode - Wednesday, November 17, 2010 12:10 PM | Last reply by Jandeep - Friday, November 19, 2010 10:08 PM -
1 Votes
Issues with multiple scopes/filters.
can you check how many SelectChanges stored procedure do you have?Answered | 2 Replies | 2951 Views | Created by The_Big_Steve - Monday, January 28, 2013 4:57 PM | Last reply by The_Big_Steve - Friday, February 1, 2013 7:12 PM -
0 Votes
stored procedure in the db
Hi, I would like to know if there is any impact, issue to create a stored procedure in the database?Answered | 1 Replies | 5150 Views | Created by BUGS Bunny Race - Thursday, December 23, 2010 8:01 AM | Last reply by Julio Luque Cuba - Thursday, December 23, 2010 2:32 PM -
0 Votes
Additional Stored Procedure with Bi Directional Filtered Scope.
as I have mentioned, that's how it is. the insert, update and delete are shared by the scopes. those stored procedures don't need the filter value.Unanswered | 5 Replies | 2897 Views | Created by sakulkarni83 - Wednesday, May 8, 2013 6:39 AM | Last reply by JuneT - Thursday, May 9, 2013 11:28 PM -
0 Votes
Dynamic Filtering
Hi Jason, Sync Framework database Providers supports only static filtering..once filter is defined, it cannot be changed later.Answered | 1 Replies | 12108 Views | Created by Jason Podwojski - Friday, September 18, 2009 10:23 AM | Last reply by Gayathri TK - Wednesday, September 23, 2009 6:11 AM -
0 Votes
Stored Procedure Priming and Identity Reseeding
The first is "MSCRM Stored Procedure Priming", which fails with the following error: Date 9/28/2009 ...Answered | 2 Replies | 8731 Views | Created by Sean W. McGinnis - Monday, September 28, 2009 7:02 PM | Last reply by ckeller - Wednesday, September 30, 2009 3:25 PM -
0 Votes
MSCRM 2011 Custom Stored Procedure
If you need to access Stored Procedures for your reports, please create a new database and change the report to access the SP from the custom Database.Answered | 1 Replies | 3178 Views | Created by HonKuan - Monday, June 11, 2012 11:17 AM | Last reply by Sam - Inogic - Monday, June 11, 2012 11:28 AM -
0 Votes
SqlSyncScopeProvisioning - Rename stored procedures generated
Hello, Is it possible to give the different names to the Stored Procedures generated by ...Answered | 1 Replies | 6794 Views | Created by AjinathWaghmode - Friday, May 21, 2010 12:05 PM | Last reply by JuneT - Friday, May 21, 2010 2:59 PM - Items 1 to 20 of 51771 Next ›
No announcements
