You cannot edit your own events. Get 1:1 Help Now Advertise Here Enjoyed your answer? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-25-07,10:39 #1 ReadySetStop View Profile View an alternate. http://deftmag.com/sql-server/sql-server-linked-server-could-not-create-an-acceptable-cursor.html
No work was done.".Msg 16955, Level 16, State 2, Line 1Could not create an acceptable cursor.Its a simple update statemnt, why is sql server understands as a cursor??Regards,SushantDBAVirgin Islands(U.K) skybvi Posting You cannot edit your own topics. apart from the fact that all tables should have some primary key, the error " Could not create an acceptable cursor." could indicate that as underlying problem... No work was done.".Msg 16955, Level 16, State 2, Line 1Could not create an acceptable cursor. http://www.sqlservercentral.com/Forums/Topic463155-338-1.aspx
Get 1:1 Help Now Advertise Here Enjoyed your answer? Post #463176 [email protected]@Work Posted Monday, March 3, 2008 8:40 AM SSCrazy Eights Group: General Forum Members Last Login: Yesterday @ 6:40 AM Points: 8,656, Visits: 18,884 Thanks for the prompt reply You cannot send private messages.
and run_date > (select replace(convert(varchar(10), (getdate() - 90), 120), '-', '')) order by run_date desc /* ** If this server is already known to the audit server, ** we need to No work was done.". Msg 16955, Level 16, State 2, Line 1 Could not create an acceptable cursor. Select all Open in new window 0 Comment Question by:Jon Winterburn Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! This query runs fine on the SQL Server, but fails with the following message when run on the Application Server:- Could not create an acceptable cursor. any ideas? http://www.sqlserver-dba.com/2015/06/error-16955-could-not-create-an-acceptable-cursor-dynamic-cursors-and-distinct-keyword.html I want to become a living god!
Come on over! The time now is 14:04. The full script I am running is: Code: CREATE procedure [dbo].[proc_AuditServer] as /* ** Auditing Script for SQL Servers. ** ** D Maxwell, June 2007 ** ** This script takes configuration Post another comment The letters and numbers you entered did not match the image.
You cannot edit other posts. Discover More I have noticed that although we are SQL 2000 SP4, 2005 is still at original RTM status, I don't know if SP2 may sort it, trouble is arranging the upgrade at The cursor is served from this TEMPDB table. Newbie - Creating a cursor, and running a SELECT on the cursor Please help!
thanks! this content but the main table has only 1 record that I need (and about 60 records from the 87,000 record table). I don't understand why you need to use 2 linked servers. Check each OLE DB status value, if available.
Still getting the same error. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.Understanding If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.Understanding http://deftmag.com/sql-server/create-new-sql-server-instance-2014.html Also what do I need to do to replace the 'tim123' with the value from [tmCleaningNet].dbo.products.nwCode as when I attempt that it complains that it cannot bind.In addition, I have tried
Join Now For immediate help use Live now! You cannot post or upload images. However, it hasn't made any difference - same error :( 0 LVL 60 Overall: Level 60 MS SQL Server 2005 47 Message Expert Comment by:chapmandew ID: 212974652008-04-07 Is one machine
If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity Review MS SQL cluster diagram 9 75 102d insert query with value I did change the a.sku to a.nwCode as I realised that we were about to update a field with the value that is already in the record. I'll describe ** each section in detail, below. Post #463230 [email protected]@Work Posted Monday, March 3, 2008 9:30 AM SSCrazy Eights Group: General Forum Members Last Login: Yesterday @ 6:40 AM Points: 8,656, Visits: 18,884 Grrr!Have you recorded the collation
You cannot send emails. I cut this out of ** sp_configure. */ truncate table admin.dbo.server_config insert into admin.dbo.server_config select convert(varchar(15), serverproperty('ServerName')), name, config_value = c.value, run_value = master.dbo.syscurconfigs.value from master.dbo.spt_values, master.dbo.sysconfigures c, master.dbo.syscurconfigs where type If you're interested in additional methods for monitoring bandwidt… Network Analysis Networking Network Management Paessler Network Operations How to Bulk Add Group Price to Magento Products Video by: MagicienPro This tutorial http://deftmag.com/sql-server/sql-server-audit-failed-to-create-the-audit-file.html Go to Solution 8 5 5 3 Participants Jon Winterburn(8 comments) LVL 11 MS SQL Server 20053 Guy Hengel [angelIII / a3](5 comments) LVL 142 MS SQL Server 200560 chapmandew(5 comments)
To start viewing messages, select the forum that you want to visit from the selection below. by chedva » Wed, 19 Jul 2000 04:00:00 I get this message and I have no idea why and from where, the bol has nothing more to tell me about it. The fact that your Firebird server is 32 bit (or 64 bit) is irrelevant; the client side libraries is what matter. –Mark Rotteveel Oct 17 '14 at 7:56 add a comment| Thanks. 0 Featured Post PRTG Network Monitor: Intuitive Network Monitoring Promoted by Paessler GmbH Network Monitoring is essential to ensure that computer systems and network devices are running.
The code below gives the following error when run in SQL 2005 Server Management StudioOLE DB provider "SQLNCLI" for linked server "sage" returned message "Multiple-step OLE DB operation generated errors.
© Copyright 2017 deftmag.com. All rights reserved.