When I try to modify a table that I just created I get the following error message: - Unable to modify table ODBC error:[Mircrosoft][ODBC SQL Server Driver] Invalid cursor state.
SP3 has been applied to SQL Server 2000.
Can anyone help explain what is causing this error? There is sufficient space for the database and transaction log.
Does anyone know what this means ??
thanks
When I change the Identity in a table in EM (undependend on which DB and table) the result is: invalid cursor state.
I have a productive server running SQL Standard version and an play area running SQL Personal.
The funny thing is, when I run the update over QA it works without a problem.
With EM the Profiler tells me an error 16954 after droping a table, and it start to roll back.
I tried hunderts of things to make it work but with no success. Except one thing. I've reinstalled the Personal SQL, restored my DB's and everything works fine now.
This happened first after installing the latest security update from Microsoft on the 10th of February.
I don't want necessarily to reeinstall the SQL server on the productive server, because there are hundreds of Databases on it, and a lot of security settings.
Any help is very appreciated.
Hi,
I have a stored procedure that calls 2 other stored procedures and combines the results into a temporary table. The results of the temporary table is then returned from the stored procedure.
When I execute the stored procedure in Query Analyzer, I get the exact data I want in the correct format - no errors.
When I execute that stored procedure in Omnivex SQL Link 3, I get an "Invalid Cursor State" error.
I did some digging on that error, and found that it could be related to print statements within the stored procedures. I removed all print statements from all 3 stored procedures and the error is still occuring.
Any suggestions?
I know other people have posted stuff like this before, but I am stillto see a definitive answer. I have created a table in Enterprisemanager called tblUsers. I later added a column in EM and saved thechange. I then noticed I had misnamed the column, so I renamed andwhen I tried to save the change I got the following message:-'tblUsers' table- Unable to rename column from 'fldepCode' to 'fldRepCode'.ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor stateThis is now regularly happening to me, and I am tired of having torecreate tables.I am using SQL Server 2000 with all the latest service packs andpatches. Has anyone any idea what is causing this and how I can cureit or avoid it?
View 2 Replies View RelatedI have written a routine to search a unique record using prepared statement. Its my first sql coding with c++.
I am not using / importing any dlls.
I connect+allocs handels , then use SQLPrepare(StmtHandle, SQLStmt,SQL_NTS); to generate a guery.
I have written bind parameters and sqlexecute +sqlFetch in a loop and loop gets executed till ESC key is pressed.
First time when I bind paramaters using SQLBindParameter it works perfect.
When loop gets executed secondtime onwards, it gives an error.
SQLState: 24000 [ODBC Client Interface]Invalid cursor state.
If I open connection, handles, and prepared starement in same loop, THEN it gives correct record without 24000 error.
I want the advantage of prepared staement. So I do not want to close and open connection and prepare statement every time.
Have I missed any step?
Where & when I should code the cursor type? Any specific libraries I need to link?
Thanks
Hello experts. Excuse my SQL newbie status. I was writing a stored procedure to crunch some data against an MS SQL 2000 database. I didn't entirely know what I was doing so I was using Crystal Reports 11 as an "application layer" pulling against a stored procedure. Well I guess ODBC connections don't support temp table output from stored procedures, or at least I don't know how to do it.
So I've rewritten my stored procedure so it inputs and outputs data using BCP, rather than just sending a simple select query.
My problem is that I cannot get CR to add the stored procedure back in to the report. Everytime I try I get an 'ODBC 24000 error - Invalid Cursor State.'
Where is this current set of records? How do I find it and close it? I've recreated my ODBC connection, every related table and SP to no avail. This is my crusial question.
Less crucial but helpful: How do I write an SP so it can be called from a report program like CR and will return its result set to the application? What's a good, simple "application layer" I can use if I'm doing all the logic in native SQL stored procedures? ASP.NET looks like a pain in the ass, and SQL Reporting Services requires Visual Studio .NET 2003. Is Perl my answer, since I can build web interfaces and forms in my sleep?
These errors occur at the subscriber. First, "The merge process could
not query the last sent and received generations" is generated, then
immediately afterwards, "invalid cursor state" is generated. We are
trying to pull a new subscription snapshot from the republisher. The
subscriber has been added and removed from the replusher's pull
subscriptions a number of times for testing. Now, we cannot get the
subscriber to re-sync with the republisher.
Any ideas?
can some on tell me which is better to use. the new TABLE data type in 2000 or cursors ????
thanks
Howdy Folks,
Our site has been experiencing this issue for a couple of months now.. Hopefully someone else can assist, as I’ve got to a point where I think issue lies within the application or a Microsoft bug. Web searches have reveled a number installations that have also had this error but its has not revealed an actual fix.
I understand this error code basically means data being returned to the client is getting either corrupted or the data is too large to fit into the buffer on the client side. Client in our case is the terminal server, here after called a application server
As the user base has increased form 5 to 20, I have noticed that the issue is occurring more frequently in comparison to when the company first started using the application /database. Its just about daily now...
The db server also has 8 other db's residing on it - but they are all less than 300 meg.
The attached PowerPoint doc has the trace info & the surrounding code for each process that has suffered a buffer error over a period of a week.
DB Server Environment: Win2000 SP4, SQL2000 SP3a, MDAC 2.7 SP1 refresh.
Application Environment: Written In house in VB.NET Framework 1.1 – setup as a published app on a terminal server – running windows 2000 SP4
Common features of the issue, that have been omitted from trace output for visibility reasons are:
-Involves 1 particular DB (thats accessed by VB app) & its developement db
-All connections are coming from 1 application server
-Issue does not relate to any particular site connecting to the application server using this application
I have reviewed & fixed several potential server side causes but this error still is occuring with in the environment:
MDAC versions must be common on application & server:
- Removed from equation by updating MDAC version on App server to be the same as DB Server: 2.7 SP1 Refresh
Network related
- Considered unlikely; we are also not experiencing network card errors on either server; also all db's would be experiencing connectivity errors.
Which leaves us with Application related options to review:
- Compilation error of application
- App parameter definitions to stored procedures are the correct data type
- Ensure values being passed do not exceed 4000 characters as that has also been known to create this error message
- I've asked the developer to review MS KB 827366 article, as it may be a valid test
- In regard to MSKB 832977 - I am not using pssdiag & have a later version of the MS Analyzer. But what I thought was interesting, is the statement that this problem occurs more frequently when an application submits a large remote procedure call (RPC) input buffer, especially when the RPC input buffer is greater than or equal to 8 KB. However, this problem may occur even if the input buffer is less than 4 KB
- A is using datatypes varchar & char - not nvarchar & nhar
Any assistance with this issue would be appreicated as server performance is being effected - these processes hang around for 1 - 5 mins before terminating (refer duration times in the powerpoint traces)
Thanks In advance
Suze.
hi
I have a float column . only in cursor I get a type missmatch.
does any one knows it ?
the error
Msg 8114, Level 16, State 5, Line 14
Error converting data type varchar to float.
the code
DECLARE @RON_FLOAT FLOAT
DECLARE RON_CURSOR CURSOR FOR
SELECT RON_FLOAT
FROM RON_TABLE1
OPEN RON_CURSOR
FETCH NEXT FROM RON_CURSOR
INTO @RON_FLOAT
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'VALUE IS ' + @RON_FLOAT
FETCH NEXT FROM RON_CURSOR
INTO @RON_FLOAT
END
CLOSE RON_CURSOR
DEALLOCATE RON_CURSOR
the code for the table
CREATE TABLE [dbo].[RON_TABLE1](
[RON_FLOAT] [float] NULL,
[RON_CHAR] [nchar](10) COLLATE Hebrew_BIN NULL
)
Hi - Im migrating packages in dts 2000 to SSIS 2005 using package migrator wizard. It loads a CSV to a table in DB. I need to change the server and file location paths after migration. While changing this, im encountering error - "the acquireconnection method call to connectionmanager failed
View 1 Replies View RelatedHello friends,
I am new to the SQL Server 2005 development.
From last 1 week or so, i have been facing very strange problem with my sql server 2005s database
which is configured and set on the hosting web server. Right now for managing my sql server 2005 database,
i am using an web based Control Panel developed by my hosting company.
Problem i am facing is that, whenever i try to modify (i.e. add new columns) tables in the database,
it gives me error saying that,
"There is already an object named 'PK_xxx_Temp' in the database. Could not create constraint. See previous errors.
Source: .Net SqlClient Data Provider".
where xxx is the table name.
I have done quite a bit research on the problem and have also searched on the net for solution but still
the problem persist.
Thanks in advance. Any help will be appreciated.
I have some rather large TSQL scripts I'd like to schedule as jobs. Unfortunately, the SysJobSteps table in the MSDB Database is limited to 3200 characters while I need it to be 5000. Does anyone know if it's possible to increase the size of this to allow for larger TSQL scripts?
Thanks!
I have two tables, a data table (MainTable) that contains a user initials and other empty rows and then i have a user table.
I also have an inner join view with the initials from both tables as the joining field.
I want the users to be able to modify the data table (MainTable) but also display the users name field.
here is the sql of the view:
SELECT dbo.MainTable.DateCreated, dbo.InitialsListing.Initials, dbo.MainTable.CustomerNumber, dbo.InitialsListing.AdvocateName,
dbo.MainTable.Supervisor, dbo.MainTable.Complete, dbo.MainTable.FirstNotify, dbo.MainTable.SecondNotify, dbo.MainTable.ThirdNotify,
dbo.MainTable.AdvocateInitials
FROM dbo.InitialsListing INNER JOIN
dbo.MainTable ON dbo.InitialsListing.Initials = dbo.MainTable.AdvocateInitials
I have a field called "assescode9" in a table called "Assessment" which has the length of "6" and I want to change this length to 7 or 8 in SQL. I tried right click on the field and modify but when I want to save it says you can not save the changes because it requires a Drop table and recreate or you do not have an option enabled to recreate the table, how do I do this?
I have never done dropping a table and recreate it?
Hi There,
I am trying to add a new field to a table using enterprise manager by right clicking on the table, choosing design table and adding the new field/column. But when I choose save changes, I receive an error message:
------------------------------------------------------------
Errors were encountered during the save process. Some of the database objects were not saved.
'Comments' Table
-Unable to modify table
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL SERVER] ...
... Cannot drop the table 'dbo.Comments' because it is being used for replication
-----------------------------------------------------------
If it helps I am trying to add a binary (bit) field and a text field of 50 characters. I think the replication it refers to is a merge replication (not sure though is there a way i can find out in EM?)
I have read some articles which refer to this problem and suggest using stored procedures but I really dont know how to do that, having never used them before. I need an idiots guide please!
Let me know if I need to provide more info. Thanks.
HI everybody need help badly on the following
have to recordsets with the following with the following SQL
SELECT place, count(minus)as countminus
order by place
group by place
THE RESULT WOULD BE
PLACE countminus
ABC 10
DEF 50
HIJ 5
KLM 2
MNO 0
MY OTHER QUERY IS
SELECT plus, count(plus) as countplus
GROUP BY plus
ORDER BY plus
THE RESULT WOULD BE:
PLUS COUNTPLUS
ABC 10
DEF 20
my problem is i need to add another column to the first resultset (if possible) or create a table with the same field and values of the first result set with the additional column OF THE second resultset COUNTPLUS...
with this condition..
I need to loop with single row from the column PLACE on the first result set and compare it with the column PLUS on the second result set. if there is a value of the PLACE=PLUS get the corresponding value of the COLUMN COUNTPLUS AND WRITE it on the COUNTPLUS ON THE NEW TABLE.. ELSE THE VALUE IS 0 this i would do it up to the END OF FILE EOF...
THE RESULT WOULD BE THIS.....
PLACE countminus COUNTPLUS
ABC 10 10
DEF 50 20
HIJ 5 0
KLM 2 0
MNO 0 0
I WAS WORKING ON THIS BUT COULDN'T GET THROUGH IT ANYTHING WOULD BE A BIG HELP FOR ME FROM YOU GUYS
By default, I constructed my database using the dbo Schema. I have since created new Schemas, and want to change some of the tables from dbo.
Is there a way to change the existing schema of a table without disrupting the data that is inside the table?
For example:
Current: dbo.Products
Desired Change: NewSchemaName.Products
Thanks.
part 1
Declare @SQLCMD varchar(5000)
DECLARE @DBNAME VARCHAR (5000)
DECLARE DBCur CURSOR FOR
SELECT U_OB_DB FROM [@OB_TB04_COMPDATA]
OPEN DBCur
FETCH NEXT FROM DBCur INTO @DBNAME
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @SQLCMD = 'SELECT T0.CARDCODE, T0.U_OB_TID AS TRANSID, T0.DOCNUM AS INV_NO, ' +
+ 'T0.DOCDATE AS INV_DATE, T0.DOCTOTAL AS INV_AMT, T0.U_OB_DONO AS DONO ' +
+ 'FROM ' + @DBNAME + '.dbo.OINV T0 WHERE T0.U_OB_TID IS NOT NULL'
EXEC(@SQLCMD)
PRINT @SQLCMD
FETCH NEXT FROM DBCur INTO @DBNAME
END
CLOSE DBCur
DEALLOCATE DBCur
Part 2
SELECT
T4.U_OB_PCOMP AS PARENTCOMP, T0.CARDCODE, T0.CARDNAME, ISNULL(T0.U_OB_TID,'') AS TRANSID, T0.DOCNUM AS SONO, T0.DOCDATE AS SODATE,
SUM(T1.QUANTITY) AS SOQTY, T0.DOCTOTAL - T0.TOTALEXPNS AS SO_AMT, T3.DOCNUM AS DONO, T3.DOCDATE AS DO_DATE,
SUM(T2.QUANTITY) AS DOQTY, T3.DOCTOTAL - T3.TOTALEXPNS AS DO_AMT
INTO #MAIN
FROM
ORDR T0
JOIN RDR1 T1 ON T0.DOCENTRY = T1.DOCENTRY
LEFT JOIN DLN1 T2 ON T1.DOCENTRY = T2.BASEENTRY AND T1.LINENUM = T2.BASELINE AND T2.BASETYPE = T0.OBJTYPE
LEFT JOIN ODLN T3 ON T2.DOCENTRY = T3.DOCENTRY
LEFT JOIN OCRD T4 ON T0.CARDCODE = T4.CARDCODE
WHERE ISNULL(T0.U_OB_TID,0) <> 0
GROUP BY T4.U_OB_PCOMP, T0.CARDCODE,T0.CARDNAME, T0.U_OB_TID, T0.DOCNUM, T0.DOCDATE, T3.DOCNUM, T3.DOCDATE, T0.DOCTOTAL, T3.DOCTOTAL, T3.TOTALEXPNS, T0.TOTALEXPNS
my question is,
how to join the part 1 n part 2?
is there posibility?
I'm currently storing session state in a sql 2000 server for my vs.net 2002 projects. I'm currently developing a new project using vs.net 2005 and was wondering if I could store the session state in the same sql server. Does anyone know if this is possible? If so can someone point me in to an article or code example. All of the examples I have come across are for sqlExpress.
Thanks in advanceJason
Hi there,
Completely new to the world of databases. I'm a designer who works primarily in Flash. In any case, I'm trying to manage an application that uses MS SQL and learn about the wonderful world of databases.
Ok, I modified a table (e.g. I added a column called "Rate") that had associated views (created by another developer). Noticed that my application went a little wonky as some of my variables within my app took on the value of the data in the "Rate" column. I checked one of the views and noticed that a column within the view (e.g. TutorID) was assuming the values in the "Rate" column. Note: The column TutorID had been blank before the change to the table. I'm completely lost as to why this is happening. Do I need to rebuild the view? Can I just reset the original view?
Thanks.
Oh yeah, I'm using SQL4X Manager J from Mac Guru (if that helps).
Hi,
I've my database, testdb, ended up in Suspect state. The SQL log shows " I/O error 38(Reached the end of the file.) detected during read at offset xxxxxxxxxx in file '<path> estdb_Data.MDF'" during recovery. I do not have backup to restore the database from. So to run DBCC CHECKDB, I tried to put the database in emergency(bypass recovery) mode using
update sysdatabases set status = 32768 where name = 'testdb'
DBCC CHECKDB showed some allocation and consistency errors and suggested "repair_allow_data_loss" as minimum repair level.
Now to run
DBCC CHECKDB('testdb', repair_allow_data_loss)
I've to put database in SINGLE USER mode. For that I started SQL server by command
sqlservr.exe -c -m
Now when I try to run DBCC CHECKDB with repair option it says "Attempt to BEGIN TRANSACTION in database 'testdb' failed because database is in BYPASS RECOVERY mode."
So it seems I need to change the status of database such that it will allow me to repair it. If I try to reset the status, the database again goes in Suspect state and it seems DBCC commands don't run on database in Suspect state. Does anybody know how to recover the database in this state? Is there any other way to repair it?
Thanks in advance,
Yojana
Hello, without going into the politics of why I'm asking, does anyone have a compiled list of functionality that only sysadmin's could do in 2000 that VIEW SERVER STATE permission opens up in 2005?
From the documentation, so far I've found fn_get_sql (and it's dm view) but I'd really like a complete list.
I have a problem where my connection always has an open transaction as viewed by activity monitor.
I am using the latest MS SQL Server 2005 JDBC driver (1.1) and connecting to SQL Server 2000.
This issue arises only when selectMethod=cursor and autoCommit is set to false. This issue does not exist when I connect to SQL Server 2005.
Has anyone else seen this issue?
How can this issue be resolved?
Thanks
Peter
Thanks in advance.
I installed SQL 2000 Client Portion in my local computer: No server functionality. I selected my computer name as an instance name. Installation went OK.
Now, I am trying to install MSDE in my computer. Error comes in early part of installation: It says, "The instance name specified is not valid"
Please, any advise and suggestion.
Hi All,
We have installed Two SQL 2000 servers.
DB1 (main database) configured as a distributor and
publishers and DB2 configured as a subscriber (backup
database). The procedures I did the replication:
1. full backup the whole database said "test" on DB1
server.
2. Create a new database "test" on DB2 server
3. restore the full backed up database to "test" database
on DB2
4. create transactional publishes (select all tables) on
DB1 and "push" the articles to DB2
The results of replication monitor for replication all
database's table:
1. sanpshot suceeded A snapshot of 100 articles was generated.
2. LogReader Idle No replication are available.
3. DB2:TEST Failed Invalid column name "TYPE"
If I only select saying 5 articles (tables) to replication
at the same database "TEST". That the result was
successful without any error.
Strange... the "TEST" database was restoring from the full
backup (latest data) of DB1. Suppose that all the tables'
column should be same. How come the error is "Invalid
column name TYPE" and number is "207"
By the way, some of "unpublished objects" including tables
couldn't be select for publishing which is default locked
by a "key with red cross". How can I release such tables
(articles) allow selecting for publishing
Any idea and help?!
vw
Anyone have a script to create a table of US States?
I'd rather not type in all 50 states if possible :)
Thanks!
The forums search page returned no such script :(
Michael
<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
I have this table that I thought I could just do a normal update to because I need to add a state and ID.
How do I add a state to a table that is already created?
Here is the behind the scenes. I have never had to deal with something like this.
This is what it looks like
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RegionStates](
[RegionID] [smallint] NOT NULL,
[code]....
I have a vb 6 program that has been running for several years against a 6.5 db. I convert the db to 2000, and now when I repoint the software to the 2000 db, I get "Invalid Authorization Specification" when I try to open the connection. The connection string is:Dim conn As ADODB.ConnectionSet conn = New ADODB.Connectionconn.Open "Provider=SQLOLEDB" & _ ";Data Source=" & sServer & _ ";Initial Catalog=" & sDB & _ ";User Id=" & goProcess.UserID & _ ";Password=" & goProcess.Password & ";"All of the variables are filled out correctly, when I go against a 6.5 it works, Sql Server 2000 doesn't.
View 2 Replies View RelatedHi,I used SQL Server 2000 Personal Edition. I created a stored procedurehaving input parameters as smallint,tinyint,char,varchar andsmalldatetime. When I executed it by Query Analyzer, it's ok. But whenI executed it by ASP code that used ADODB.command, it showed error:Invalid character value for cast specification .Though SQL Server debugger, it showed:[Microsoft][ODBC SQL Server Driver]Invalid character value for castspecificationWhat did I do wrong? How do I fix this problem?TIAKrungPS: One of input parameters was smalldatetime, but I casting it in ASPas date as:Const adDate=7datetxt='2004/6/28'cmd.Parameters.Append cmd.CreateParameter("CoopId",adChar,adParamInput, 8, coopid)cmd.Parameters.Append cmd.CreateParameter("Addr",adVarChar,adParamInput, 100, addr)...cmd.Parameters.Append cmd.CreateParameter("Cdate",adDate,adParamInput, , datetxt)....cmd.execute
View 3 Replies View RelatedHi
I'm trying to copy a s2k db to s2005 64 bit db.
I setup the copy db as a schedule but it keeps failing which invalid object name which i think would suggest that the import table is not there?? even thought it is there I have checked the structure of the table which looks fine.
Does anyone have any ideas to get around this?? Or can I do some other checks?
Many Thanks
Robert
OnError,SEA-SRV-00009,NT AUTHORITYSYSTEM,sea-srv-00008_SEA-SRV-00009_Transfer Objects Task,{524DBB9C-783A-4989-8239-7825B10BF060},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "
CREATE view [dbo].[vw_tf_stock_take_scanned] as
select dbo.i_st_stakedt.inputref, dbo.i_st_stakedt.whse, dbo.i_st_stakedt.stockcode, dbo.i_st_stakedt.ticketref,
dbo.i_st_stakedt.bin, dbo.i_st_stakedt.checkqty, dbo.i_st_stakedt.updated, dbo.i_st_stakedt.status,
dbo.i_st_stakedt.createdon, dbo.i_st_stakedt.createdat, dbo.i_st_stakedt.filler
from dbo.i_st_stakedt inner join
dbo.i_st_stakehd on dbo.i_st_stakedt.inputref = dbo.i_st_stakehd.inputref
where dbo.i_st_stakehd.status not in ('X','P')
" failed with the following error: "Invalid object name 'dbo.i_st_stakedt'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnError,SEA-SRV-00009,NT AUTHORITYSYSTEM,SAS_mig,{40DA50FD-2E47-4B84-99D8-6FFDB0A4DD8D},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "
CREATE view [dbo].[vw_tf_stock_take_scanned] as
select dbo.i_st_stakedt.inputref, dbo.i_st_stakedt.whse, dbo.i_st_stakedt.stockcode, dbo.i_st_stakedt.ticketref,
dbo.i_st_stakedt.bin, dbo.i_st_stakedt.checkqty, dbo.i_st_stakedt.updated, dbo.i_st_stakedt.status,
dbo.i_st_stakedt.createdon, dbo.i_st_stakedt.createdat, dbo.i_st_stakedt.filler
from dbo.i_st_stakedt inner join
dbo.i_st_stakehd on dbo.i_st_stakedt.inputref = dbo.i_st_stakehd.inputref
where dbo.i_st_stakehd.status not in ('X','P')
" failed with the following error: "Invalid object name 'dbo.i_st_stakedt'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnProgress,SEA-SRV-00009,NT AUTHORITYSYSTEM,sea-srv-00008_SEA-SRV-00009_Transfer Objects Task,{524DBB9C-783A-4989-8239-7825B10BF060},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,0,0x,Database transfer failed for 1 database(s).
OnProgress,SEA-SRV-00009,NT AUTHORITYSYSTEM,sea-srv-00008_SEA-SRV-00009_Transfer Objects Task,{524DBB9C-783A-4989-8239-7825B10BF060},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,100,0x,Transfer objects finished execution.
OnTaskFailed,SEA-SRV-00009,NT AUTHORITYSYSTEM,sea-srv-00008_SEA-SRV-00009_Transfer Objects Task,{524DBB9C-783A-4989-8239-7825B10BF060},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,0,0x,(null)
OnPostExecute,SEA-SRV-00009,NT AUTHORITYSYSTEM,sea-srv-00008_SEA-SRV-00009_Transfer Objects Task,{524DBB9C-783A-4989-8239-7825B10BF060},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,0,0x,(null)
OnWarning,SEA-SRV-00009,NT AUTHORITYSYSTEM,SAS_mig,{40DA50FD-2E47-4B84-99D8-6FFDB0A4DD8D},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,-2147381246,0x,SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
OnPostExecute,SEA-SRV-00009,NT AUTHORITYSYSTEM,SAS_mig,{40DA50FD-2E47-4B84-99D8-6FFDB0A4DD8D},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,0,0x,(null)
PackageEnd,SEA-SRV-00009,NT AUTHORITYSYSTEM,SAS_mig,{40DA50FD-2E47-4B84-99D8-6FFDB0A4DD8D},{91AA3955-85BF-4DA1-B2BC-0A14787BE06D},11/2/2007 11:02:24 PM,11/2/2007 11:02:24 PM,1,0x,End of package execution.
I have a SQL statement stored in a SQL varriable (after a lot of conditions)
Code:
declare @sql char(100)
set @sql = 'select ma_kh, ten from _khang'
Now, I want to create a cursor to recalculate some values
I've tried:
Code:
declare cur_T cursor for exec(@sql) open cur_T
but it doesn't work.
Can I have another way to do that???