how to make fast forwad only cursor updatable

SQL Server Data Access

Index ‹ SQL Server

- Previous
  - 1
    - Dynamic Connection String Check if your datasource name has a space in it - it won't work once deployed! Same thing happened to me! Tag: how to make fast forwad only cursor updatable
  - 2
    - code!func to get values in header only works in IDE and not deployed report (also worked ok in RS2000) I tried your suggestions but to no avail. I don't think it is a data problem as both the IDE and the deployed report are pointing at the same db. (the rest of the data is identical) I have deleted the cache of .data files locally. I am going to try reimporting from 2000->2005 to see if anything got corrupted. Also, when I changed + to &, it started returning N2 instead of the value (!) Tag: how to make fast forwad only cursor updatable
  - 3
    - Boilerplate activation SQL for high-throughput OK, so assume I am recycling dialogs in my client code, and assume I am doing something similar to get a dialog handle in my TSQL. What should the activated stored procedure that is processing my queue look like if I am expecting thousands of messages per second Assume also that there is a small bit of logic need to process each individual message I am building for a high-throughput scenario and would like to get as much as possible out of each second-tier service broker server as possible before the aggregated data is moved up the chain to a master. The first tier is Express on a web server and exists primarily only as a forwarding mechanism. Tag: how to make fast forwad only cursor updatable
  - 4
    - I can't get SQL Server 2005 Enterprise Edition working Hi, Thanks fo your reply. But the question is that I want to install Microsoft SQL Server 2005 Enterprise Edition on My notebook which has Microsoft Windows Vista Business. I tried installing Microsoft SQL 2000 Server on my machine and it works fine while it is specified on Microsoft Website that Microsoft SQL 2000 Server is not supported on Microsoft Windows Vista ( Of Any Edition ). I installed SQL 2000 Server on my notebook when I got frustrated installing SQL Server 2005 Enterprise Edition on my notebook. I am really frustrated, i should have not gone for windows vista, let the Windows Vista features go to hell. I am not able configue .NET 1.1 or .NET 2.0 on my notebook. I wish there was some magic which can fix all these issues. Hope to read you soon... Regards, Syed Abbas Naqvi Sr. Software Developer. Tag: how to make fast forwad only cursor updatable
  - 5
    - Pivot fields into a single column Thanks, but I can't use create table or insert. Appreciate the effort though. Tag: how to make fast forwad only cursor updatable
  - 6
    - Can a non-admin user generate "Create database" script using SMO? Thanks Mitesh for your help. The user who connect to the server will be using it ONLY for generating the script. He is not going to create the database on the same server. Once the script is generated, the database will be created using the earlier generated script on other server, where the user has proper permission. There is no way user can be made SA, ONLY for generating the script (and that too only for CREATE DATABASE script). There is no chance of getting sa password on the first server from where user is trying to generate the script, as it is a production server. Tag: how to make fast forwad only cursor updatable
  - 7
    - Is there a way to loop through tables in update TSQL statements, based on name criteria? could you show me an example of how this would be done, or point me in the direction of where I can get more details of how to use this. Tag: how to make fast forwad only cursor updatable
  - 8
    - Migrating Excel Spreadsheets to MSSQL What kind of conversions are you trying to do Reason I'm asking is because I pull information from Excel spreadsheets all the time into SQL using packages I've built. Let me know what you're trying to convert. Tag: how to make fast forwad only cursor updatable
  - 9
    - Help with Oralce 8 - Multi-Value Parameters I see what you are trying to do and I have read the paper "dynamic SQL" but I cannot even get a simple ="Select Company as CNO from cono" to execute. It does not like the =. Is there some setting I have to set or do you have to do this as a stored procedure. Tag: how to make fast forwad only cursor updatable
  - 10
    - substring what do you need The DB is hosted by a third party and the field I am querying is a var char field. I am baffled to why I am having issues with syntax Tag: how to make fast forwad only cursor updatable
  - 11
    - date function/tool to determine future business days/ holidays Thanks but I am still unclear. If I'd like to know if today's date + 100 days from now would fall on a business day . Is there a ready-to-use MS SQL function that I can use or should I write it on my own Tag: how to make fast forwad only cursor updatable
  - 12
    - Restore does not leave database in usable state...... Allen, I am also facing the same problem but in my case NoRecovery is set to False. This is my code snippet : restore = new Restore (); restore.Action = RestoreActionType .Database; restore.Database = dbName; restore.Devices.AddDevice(sourceFileName, DeviceType .File); restore.ReplaceDatabase = true ; restore.PercentCompleteNotification = 1; restore.PercentComplete += new PercentCompleteEventHandler (UpdateDatabase_PercentComplete); restore.Partial = false ; restore.NoRecovery = false ; ........... ............ ............................ restore.SqlRestore(server); Can you please help me out !!! -Vinay Tag: how to make fast forwad only cursor updatable
  - 13
    - OLE DB Source Adapter & variables. ...but this will be the first step in each of 4 logical threads of processing (e.g. select max(LastChangedDate) from TblA, select max(LastChangedDate) from TblB,...), and I intend executing each of them in parallel, which I can only do within the Data Flow. Surely there must be a way persisting the result (in a variable or in the buffer), to pass amongst other source/destination adapters, and transforms Hope you can elucidate, Tag: how to make fast forwad only cursor updatable
  - 14
    - floundering in half an inch of water - tweak an mdx recordset to show only those dates that actually have values. Saved me from drowning Tag: how to make fast forwad only cursor updatable
  - 15
    - Problem with role-based security Hi Dave Thanks for the response. No, th user is only part of one role so he cannot be overiden by another. The user is also not part of the Domain, I dont know if that changes anything. The user is only added on the local-mashine fo the reporting services. Cube security work when I use the test cube security via the link in the cell data tab. G Tag: how to make fast forwad only cursor updatable
  - 16
    - DROP DATABASE problem I can certainly do that. But I am keeping that as the last resort. Mainly because, that will involve querying the registry to get the instance names, then the data folders for those instances and then going to that location to check for the existence of mdf files. This would do my job, but then I beleive this is not the standard way to do that. Such processes may go out-of-sync very easily. I was just trying to figure out why these files aren't deleted when database is in a restoring state. Or is it possible to correct this in any way Tag: how to make fast forwad only cursor updatable
- Next
  - 1
    - Incremental process based on Action Code JayH wrote: I think reading the table three times is negligible compared to executing individual statements. If you wanted to only read it once, yet serialize the statements, you could use a script to execute the statements instead of splitting them to different OLE DB commands, but I wouldn't do that. I don't know if it will work, but the most efficient way is to join between your target table and the transform table for the INSERT, UPDATE, and DELETE statements and not bring the statements through SSIS at all. How about a compromise Load the file to a staging table while splitting off the inserts to an OLE DB Destination using fast load. Then back in the control flow, execute two "Execute SQL" tasks. The first to update the destination table by joining to the staging table. The second deletes from the destination, also by joining to the staging table. Tag: how to make fast forwad only cursor updatable
  - 2
    - Trouble with temp tables I wrote a stored procedure that does the following. Selects records into a temp table. If no records are in temp table after select I execute another stored procedure, drop the temp table and reselect records into the temp table. I'm getting the following error and I don't think I should since I am dropping the temp table before creating it again. Msg 2714, Level 16, State 1, Procedure sp_Alerts_GetFeedSubscriptions, Line 30 There is already an object named '#FeedSubscriptions' in the database. When trying to execute the following sql USE [ProblemTracker] GO /****** Object: StoredProcedure [dbo].[sp_Alerts_GetFeedSubscriptions] Script Date: 04/19/2007 14:54:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_Alerts_GetFeedSubscriptions] -- Add the parameters for the stored procedure here @NBID char(7) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here IF Object_ID('tempdb..#FeedSubscriptions') IS NOT NULL DROP TABLE #FeedSubscriptions SELECT a.UID AS FeedUID INTO #FeedSubscriptions FROM Alerts_Feeds a, Alerts_UserFeeds b, Alerts_User c WHERE a.UID = b.AssociatedFeedUID AND b.AssociatedUserUID = c.UID AND c.NBID = @NBID DECLARE @FeedSubscriptionsCount int SET @FeedSubscriptionsCount = (SELECT COUNT(*) FROM #FeedSubscriptions) IF (@FeedSubscriptionsCount = 0) BEGIN EXEC sp_Alerts_AddUserNew @NBID = @NBID DROP TABLE #FeedSubscriptions SELECT a.UID AS FeedUID INTO #FeedSubscriptions FROM Alerts_Feeds a, Alerts_UserFeeds b, Alerts_User c WHERE a.UID = b.AssociatedFeedUID AND b.AssociatedUserUID = c.UID AND c.NBID = @NBID SET @FeedSubscriptionsCount = (SELECT COUNT(*) FROM #FeedSubscriptions) END IF (@FeedSubscriptionsCount <> 0) BEGIN SELECT * FROM #FeedSubscriptions END END Tag: how to make fast forwad only cursor updatable
  - 3
    - RUNNING A DTS PACKET FROM WITHIN TSQL Here is my problem: I don't have permissions to the 'master' db, thusly I don't have permissions to 'xp_cmdshell'. However, I need to output several small tables that I have created from one large table into individual text files. Now, from the documentation I have read this is easily possible with the use of dts packets. However, my knowledge of dts packets is non-existent. So, I have created a dts packet that will take the data from a table and export it to a text file. Here is what I need to know how to do: I would like all the small tables to go to their individual text files based on the file name I provide from within tsql. I would also like this to be done with the use of local tables (i.e. #tablename). I am trying to alleviate human interface and the resulting errors from the sql statements we have now. We have an elaborate db system with tables and permissions all over the place, and thusly I want this done and removed with the use of local tables. Is this something that anyone could assist me with Tag: how to make fast forwad only cursor updatable
  - 4
    - Error After installing SQL SERVER 2005 SP2 Hi Adam, I updated my SQL Server 2005 with the SP2 and had no any problem. I get this error message mostly when my SQL Service doesn't work. So i suggest you to check your SQL Services. Ekrem Onsoy MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE www.ekremonsoy.net Tag: how to make fast forwad only cursor updatable
  - 5
    - Different behavior between DTExecUI and Scheduled Job I will do more searching as you suggest. I have done the following prior to my orginal post: - Restarted Agent - Restarted SQL Server - Rebooted Server None of these have done a lick of good for me and still get the error. Thanks! Brandon Tag: how to make fast forwad only cursor updatable
  - 6
    - Merge Replication - SQL Server 2005, Windows Vista and MSVisual Studio 2005 Hello everybody! I hope that someone could help me. I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem... I configure the connection to use the IUSR. The source code that i use: repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll" ; repl.Publisher = @"laptop" ; repl.PublisherDatabase = @"database" ; repl.PublisherSecurityMode = SecurityType .NTAuthentication; repl.Publication = @"Pubdatabase" ; repl.Subscriber = @"SQLMobile" ; repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'" ; The error that returns is: "Failure to connect to SQLServer with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect" Does anybody knows what i can do HELP I NEED SOMEBODY TO HELP! Thanks! Tag: how to make fast forwad only cursor updatable
  - 7
    - Update/Insert Date field, which did not import from Access I Imported data using the DTS Wizard, which for the most part worked great... with a few exceptions that I knew about because of a table redesign. I am in the process of checking out the Migration Assitant for Access.. perhaps that will shed some light. Tag: how to make fast forwad only cursor updatable
  - 8
    - Need Help: For Cube data in Multi Languages. Thanks for your reply. What I'm understanding here that in dimension editor I will have to set NameColumn for another Lenguage Atrribute in Source. But doing that I will have to maintain two Dimension/Hierarchies for Two Languages e.g.: English and Japanese. I donot want like this. I want only based on lenguage selection data should come for that lenguage without duplicating hierarchies for the languages. Or if I'm not understanding what you said please clear. Looking positive response.. Tag: how to make fast forwad only cursor updatable
  - 9
    - How to display?? Hi Sudip, If you want all those values in a variable (as comma separated).. then you can change your procedure like.. Code Snippet CREATE PROCEDURE dbo.test( @number varchar(8000) output ) as Declare @Result varchar(8000) select @Result = IsNull(@Result +', ','') + gw_instance from fix_lvts..fix_exec_reports where gw_instance like '%PORTWARE%' return 0 Regards, Tag: how to make fast forwad only cursor updatable
  - 10
    - Remote connection to database on same PC? Hi, when you say you turned user instances off, do you mean that you installed the default instance and not a named instance What Data source, Servername and log on type did you choose when you tried to add the SQL server to the server explorer Are you running VB.Net in the same windows account you installed SQL Express with -- SvenC Tag: how to make fast forwad only cursor updatable
  - 11
    - Updating the variable inside the dataflow Is it possible to update the value of a user defined variable within the DataFLow in SSIS. I am aware you can update a variable using a script task in the Control Flow, but how about the DataFlow Thanks for any help in advance. Tag: how to make fast forwad only cursor updatable
  - 12
    - A Simple Problem. But.... Locks can be a good thing and they can also be devastating if mismanaged. You can tweak the isolation level to help most situations. How long do you plan to hold these locks Why do you need to manage them What is your objective Please provide a little more detail and depth on your situation and needs. Tag: how to make fast forwad only cursor updatable
  - 13
    - how do i save a file from the report viewer control Hi, How do i save the file when the user clicks on export to Pdf in the report viewer control Regards, Karen Tag: how to make fast forwad only cursor updatable
  - 14
    - Generates Msg 107, Level 16, State 2, Line 2 - column prefix does not exist (Oh yes it does.. anyone got a solution ?) hi All, Following code generates error 107 (SQL Server 2000, SP3a): SELECT * FROM dbo . AssessmentItemHierarchy Parent INNER JOIN dbo . RaterCategory INNER JOIN dbo . RaterType ON RaterCategory . ID = RaterType . RaterCategoryID INNER JOIN dbo . AssessmentRater ON AssessmentRater . RaterTypeID = RaterType . ID INNER JOIN dbo . AssessmentItem ON AssessmentItem . ID = Parent . ChildItemID INNER JOIN dbo . Assessment ON AssessmentItem . AssessmentID = Assessment . ID INNER JOIN dbo . AssessmentResponse ON AssessmentResponse . AssessmentItemID = AssessmentItem . ID ON AssessmentResponse . AssessmentRaterID = AssessmentRater . ID INNER JOIN dbo . ImageInstance ON ImageInstance . ID = RaterType . ImageInstanceID INNER JOIN dbo . AssessmentItem ParentGUID ON Parent . ParentItemID = ParentGUID . ID Error on Run: Msg 107, Level 16, State 2, Line 2 The column prefix 'Parent' does not match with a table name or alias name used in the query. The only work-around I have found is a rewrite of order: SELECT * FROM AssessmentItemHierarchy Parent INNER JOIN RaterCategory INNER JOIN RaterType INNER JOIN AssessmentRater INNER JOIN AssessmentItem INNER JOIN Assessment ON AssessmentItem . AssessmentID = Assessment . ID INNER JOIN AssessmentResponse ON AssessmentItem . ID = AssessmentResponse . AssessmentItemID ON AssessmentRater . ID = AssessmentResponse . AssessmentRaterID ON RaterType . ID = AssessmentRater . RaterTypeID ON RaterCategory . ID = RaterType . RaterCategoryID INNER JOIN ImageInstance ON RaterType . ImageInstanceID = ImageInstance . ID ON Parent . ChildItemID = AssessmentItem . ID INNER JOIN AssessmentItem ParentGUID ON Parent . ParentItemID = ParentGUID . ID Not very pretty... anyone know why I'm getting this error message with the first version of my query Tag: how to make fast forwad only cursor updatable
  - 15
    - turn report auto-scroll feature off when toggling drill-down Thanks for replying. You are exactly right, the display centers on the item that I toggle. Neither our client, my boss, nor I find this behavior helpful, and wish the newly-visible rows in the report would become visible but not scroll after becoming visible. We just find this scrolling disorienting. If, on the other hand, this scrolling was much slower and smoother it would probably be acceptable, but not this jerky behavior. I'm extremely surpised that most everybody in our office doesn't like this, but it seems like everybody else in the world prefers it (I can't find any other posts which complain of this). I guess it takes all kinds. Tag: how to make fast forwad only cursor updatable
  - 16
    - Dimension Design Question Thanks Chris. Sorry I was not clear in my first post. Is it possible to have an attribute with following members ==> Balance, Attribution, Both from which the users can select either of them to filter the data across The problem here is that when "Balance" member is selected, it should filter data for combination (Balance = 1, Attribution = 0) and (Balance = 1, Attribution = 1) . Same thing should happen for Attribution too. Tag: how to make fast forwad only cursor updatable

Baihao Yuan

In the msdn SQL server document(http://msdn2.microsoft.com/en-us/library/aa172573(SQL.80).aspx), it states:

Transact-SQL cursors can specify the FAST_FORWARD clause on DECLARE CURSOR. This opens an optimized forward-only, read-only cursor.

But in the following section 'Implicit Conversion of Fast Forward-only Cursors', it states:

If a fast forward-only cursor is not read-only, it is converted to a dynamic cursor.

Now I am confused: is it possible to make a fast forward-only cursor 'not read-only'(updatable)

A fast forward-only cursor by definition is read-only. Am I wrong

Thanks,

Baihao Yuan

Top

Re: how to make fast forwad only cursor updatable

Anton Klimov - MSFT

The newer article mentions that In SQL Server 2005, fast forward-only cursors are never converted.
The article on ODBC says If a result set contains a text, ntext, or image column, a fast forward-only cursor is implicitly converted to a dynamic cursor and SQL_SUCCESS_WITH_INFO is returned to the application. SQLGetData is enabled for the dynamic cursor.
I think the wording of the article you mentioned is confusing, if I'm not mistaken the idea is that you might get a different cursor type than the one you asked for under certain conditions. So strictly speaking you cannot make a fast forward-only cursor updatable, but you might be in a situation when you asked for a read-only cursor, but instead received an updatable cursor.

Top