Loading Huge XML To SQL Server 2005
Jan 13, 2008
Hi,
I am using VS2003 and SQL Server 2005. I will get the huge size xml from the web service. I need to load this xml to sql server 2005 table as records.
I got below solution from microsoft site. Load XML to Dataset and from Dataset to SQL Server 2005.
Note If you call ReadXml to load a very large file, you may encounter slow performance. To ensure best performance for ReadXml, on a large file, call the DataTable.BeginLoadData method for each table in the DataSet, then call ReadXml. Finally, call DataTable.EndLoadData for each table in the DataSet.
Any other better solution is there to load huge XML to SQL server 2005?
View 1 Replies
ADVERTISEMENT
May 31, 2007
Hi Good morning to all,
My day started with loading huge volume of data and my data flow task failed to do so.
My data flow has a flat file connected to a OLEDB target. This is a one to one mapping. My source file contains 50 lac records and it is of 500 MB in size.
I'm processing the data with all the default buffer settings. I have 4 CPUs in my server.
the system process DTSDebug.exe is utilizing more than 2GB page size. My average CPU usage being 70% when one of those CPU s is hitting 100% utilization.
I'm very new to SSIS. So, please provide me some info how do i set my buffers and do we have any PDF for performance and tuning in SSIS ?
Do we have any bulk load transformation in SSIS to load into DB2UDB ?
If so how do i get it installed?
Thanks in advance,
Suresh N
View 2 Replies
View Related
Aug 21, 2007
Hi all,
I've faced a problem with the below error when I load 1.5m data into oracle database.
The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers.
Please help. Thanks
View 19 Replies
View Related
Dec 8, 2007
Hi there - can anyone advise on the following issue. We have recently performed some server side tracing on a particular SQL instance over 24hr period. We are now attempting to load these into a database for analysis. Here lies the problem.
When we are loading the profiler trace files (one at a time) into the database the transaction log is growing at an excessive rate. Even though the database is in SIMPLE mode.
We are loading the traces using the command:
INSERT INTO sqlTableToLoad
SELECT * FROM ::fn_trace_gettable('MytraceFileName', DEFAULT)
Can anyone advise how we could possibly get round this issue as we're running out of space due to the transaction log.
Thanks
View 5 Replies
View Related
Aug 13, 2007
Please find the code below (which I am using).
1)
CREATE TABLE rssFeeds( feedXML XML)
SELECT * FROM RSSFEEDS
DECLARE @xmlDoc XML
SET @xmlDoc = ( SELECT * FROM OPENROWSET ( BULK 'C:Test.xml', SINGLE_CLOB ) AS xmlData)
2)
INSERT INTO rssFeeds (feedXML) VALUES (@xmlDoc)
I am able to get the contents of xml file into sql server in only one field of Table. Now I am asked to make one table with the schema same as xml file's. How to proceed? Pls let me know some URL for this.
Regards,
Ashish Johri
View 1 Replies
View Related
Apr 5, 2008
Hi,
This is an urgent task came up at our i.e. Loading SAS dataset files into Sql Server 2005.
We received the various files generated from SAS from other team. Now we have only .dat files and some .sas files.
Requirment is to load them into SQL server and generate some reports out of the database.
Does any one has done this task previously i.e. SAS dataset into SQL server?
There is any documentation or steps to be followed using SSIS, please adive.
Any help is great appericated.
Thank you
NMohan
View 9 Replies
View Related
Aug 15, 2007
I am so new to SQL Server 2005 and just studying. Saying that...
We use SQL Server 2005 Express edition. Some one sent me a file (info.mdb) and asked me to load the data in this file in to a table called Products and also asked me to load in another table (ProdCat) where id = 'X05'.
So being not knowing anyting regarding data loading etc, how should I do this and proceed? The .mdb means its a Access database file? If that is the case, I dont have Access in my machine and what should I do?
View 5 Replies
View Related
Jul 24, 2006
I want to restore a backup of a SQL Server 2000 database to SQL Server 2005. Would I need to do anything after running the restore to upgrade the database?
View 1 Replies
View Related
May 16, 2008
HI
I am transferring the data from sql server 2005 to Informix 7.3.1 SE using SSIS .
I am using the OLEDB data connection for both source as well as destination databases.
I am trying to mapping the source and destination tables .I am getting the following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [184]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Destination [184]]: Opening a rowset for ""srinivas"."company"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I am using the following ODBC driver for the connecting INFORMIX 7.3.1 which is running on LINUX environment.
Openlink Generic ODBC Driver
It's creates the table in the informix 7.3.1 but it's not mapping the source and destination databases columns.
Please help me any one. it's urgent .
Thanks,
Srinivas Unnam
View 3 Replies
View Related
Jul 19, 2006
Im new to SQL server express 2005 and im having issues loading images into my tables. can anyone show me how to achieve this?
Thanks
Matt
View 4 Replies
View Related
Mar 31, 2006
Hello,
We are in need of some help around the use of SQL Server 2005 Mobile Edition.
The problem comes in when we have to import a large list of equipment ID€™s into the database.
The way that things work today is that the database only runs on the handheld computer, so we are having to process a large amount of data on the handheld therefore taking a lot of time.
If there were a way to have a €œseed€? database on the server side (running on Windows Server 2003 or similar) and import all of this data on the server side it would be more efficient and require less time.
Once the data was imported on the server side we can simply transfer this seed database down to the handheld
Could you please throw some light on the above queries.
Thanks in advance.
Jeeves
View 1 Replies
View Related
Jan 16, 2008
Has anyone done this? If so, how? I saw the systems requirement pages and web edition is not listed as as supported OS, but it's what we have. TIA.
View 1 Replies
View Related
Mar 20, 2008
Good evening:
We're porting an old app written in ASP.NET 1.1433 and SQL 2000 to ASP.NET 2.0 and SQL 2005. In the old app we have a few data grids that are populated from a dataset pulled from the database. We use a SQL query that we build based on more than 10 different user inputs, the result of which is an enormously complicated SQL string. We'd like to move this processing into a SPROC in the 2005 database.
Rather than writing stored procedures to create the SQL SELECT statement, is it possible to pass an entire select state ment to a SPROC and have it executed within? We're trying to capitalize on paging in 2005 using ...ROW_NUMBER() OVER (ORDER BY PM ASC)... and building the string using IF ELSE statements is mind numbling complex and tedious.
And suggestions woudl be great.
Thanks,
Brad
View 4 Replies
View Related
Apr 3, 2000
SQL 7 SP1 NT4 SP5
I have a TRANSACTION table with 150 million rows.
I have a USER table.
Each user has about 600 records in the TRANSACTION table.
The TRANSACTION cluster index is on USERID + RECID . The second index is on USERID + Fieldx + Fieldy.
The TRANSACTION table gets about 1.4 million inserts in a normal day and about 40,000 updates.
I want to go through the USER table and delete all users who have not visited me in a while.
I want to do this without substantially hindering performance in a production environment. I can perform this over a week period or two if needed.
The best way I thought of doing this was to grab x amount of users in a cursor and loop through deleting their corresponding TRANSACTION records.
Does anyone have any ideas on a better way. What is going to happen to my indices during this time ?
Thanks !!!
View 3 Replies
View Related
Jan 17, 2008
Hi, Experts
The project is a C/S data analysis system built with .Net 2.0 in windows environment, OS: Microsoft Windows 2003 R2 standard Edition Service Pack2, Database used in this project is: Sql server 2005. As a data analysis system, we need to load large amount of data from file to database, we do it by create a dts package and then do data loading by execute "m_Package.Execute(null, variables, m_PackageEvents, null, null)".
The problem is, we fount that DTS miss some data randomly sometimes, we can't find the rule till now. for example we've data as follows in data file, all data field splited by '|'
11234|26341|2007-09-03 00:00|0|0|0.0|0|0.011470833793282509|1|0.045497223734855652|0|0|1|0|3|2929|13130|43|0|2|0|0|40|1|0|0|0|0|0|1||0|0|3|0|0|0|0|0||0|3|0|0|43|43|0|41270|0|3|0|0|10|3|0|0|0|0|0||0|1912|0|0|3|0|0|0|0|0|0|0|3|0|0|5|0|40|0|9|0|0|0|0|0|0|0|0|29|1|1|24|24.0|16|16.0|0|0|0.0|0|0|24|23.980693817138672|0|0.0|0|0.0|0|0.0|0|0.0|11|2.0764460563659668|43|2|0|0|30|11|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|3|0|0|0|0|0|0|0|0|0|6|0|0|0|0|0|6|0|0|45|1|0|0|0|2|42|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|0|0|2|0|0|0|0|0|0|51|47|85|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||0|0|0|0|0|97.117401123046875|0|0|83|57|||0.011738888919353485|0|1|0.065955556929111481|0|4|||0.00026658669230528176|1|0.00014440112863667309|1|68|53|12|2|1|2.0562667846679688|10|94|2|0|0|30|11|47|4|13902|7024|6878|18|85|4.9072666168212891|5|0.0|0|0.0|0|0.0|0|0.0|0|358|6448|6324|0|0|0|0||0||462|967|0|41|39|2|0|0|0|1|0|0|0|0|0|0|0|0|3|0|0|3|0|0|0|0|0|0|0|0|0|3|0|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|46|0|1|0|1|37|0|0|46|0|1|0|1|37|0|0|0|0|0|0|0|0|0.0|0|0|6|4|2|0|0|2|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|1|0.012290795333683491|0|44|44.0|0|0.0|0|0|0|30|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|2|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|27|0|0|2112|411|411|45|437|2|0|2|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|4|0|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|6|6|0|3|2|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|600|600|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|6|0|0|0|0|0|0|6|0|9|1|2|2|3|0|1|0|0|0|0|0|0|0|0|0|0|0|13|3|2|5|1|1|1|0|0|0|102|0|1|1|0|0|0|3|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0||||||||||0|0|0|0|0|0|0||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|46.0|46|0.0|0|0.0|0|0.011469460092484951|1|0.0|0|0.0|0|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|100.0|100.0|0|1|0|1|0|0|0.02481505274772644|1|0.014951236546039581|1|0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|4695.5556640625|42260|7126.66650390625|62040|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||
11213|26341|2007-09-03 00:00|0|0|0.0|0|0.068584725260734558|2|0.14375555515289307|27|0|2|1|11|3966|13162|97|0|13|0|0|83|3|2|3|0|0|0|26||0|0|11|0|0|0|1|0||0|1|0|3|97|98|0|246795|0|11|1|0|3|14|0|0|0|0|0||0|1912|0|0|12|0|0|0|0|0|0|0|12|0|0|17|0|83|2|2|2|0|0|0|0|0|0|0|73|3|1|24|24.0|16|16.0|0|0|0.0|3|0|24|23.905364990234375|2|0.0040000001899898052|0|0.0|0|0.0|0|0.0|11|2.0772171020507812|97|7|0|0|80|10|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|12|12|0|0|0|0|0|0|0|0|0|41|0|0|0|0|0|41|0|0|99|25|0|0|0|0|74|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|0|0|0|0|0|0|0|0|0|177|158|332|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|3|||||||||||||0|0|0|0|0|0.0|0|0|321|198|||0.041950233280658722|0|2|0.1999288946390152|0|5|||0.00088306842371821404|1|0.00051651173271238804|1|529|113|4|8|2|2.0671226978302002|10|274|7|0|0|80|10|66|17|13934|7024|6910|31|332|4.7173333168029785|5|0.000033333333703922108|1|0.000033333333703922108|1|0.000033333333703922108|1|0.0|0|358|6448|6356|0|0|0|0||0||1609|3423|0|83|78|5|0|0|26|0|0|0|0|0|0|0|0|0|2|0|1|1|0|0|0|0|3|0|0|0|0|2|0|2|0|0|0|0|0|0|0|0|0|0|2|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|65|0|1|0|1|72|0|0|65|0|1|0|1|72|0|0|0|0|0|0|0|0|0.0|0|0|12|7|0|2|3|16|5|5|6|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|2|0.04131799191236496|0|48|48.0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|1|0|0|0|0|0|0|9|0|5|1|0|0|0|1|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|4|2|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|3|0|0|0|0|0|0|0|0|121|0|1410|6046|558|1400|192|2467|10|0|5|1|0|0|0|2|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|15|0|10|0|0|0|0|3|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|21|9|12|10|3|1|0|1|4|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|163|4|144|91|92|2|92|0|0|0|0|0|101|92|0|0|0|0|101|0|0|0|0|600|596|1|0|0|3|0|0|0|0|0|0|0|0|0|0|0|9|0|0|1|0|0|0|8|0|34|3|4|14|7|2|3|0|1|0|0|0|0|0|0|0|0|0|41|6|4|23|5|2|1|0|0|0|289|0|7|7|0|0|0|11|11|0|0|4|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|4|0|0|0|0|0|4||||||||||3|0|0|0|0|0|3||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|55.814689636230469|47.931411743164062|48|0.0|0|0.0|0|0.068584725260734558|2|0.0|0|0.0|0|14|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|1|0|0|1|0|0|0|0|0|||0|100.0|100.0|0|26|26|0|0|0|0.088263392448425293|2|0.056161552667617798|2|0|0|0|0|0|0|0|0|0|5|22|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|16308.888671875|146780|23162.22265625|184840|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||
11220|26341|2007-09-03 00:00|0|0|0.0|0|0.309184730052948|2|0.17757916450500488|0|0|7|4|18|3925|13682|172|0|19|0|0|164|10|5|4|0|0|0|2||0|0|20|0|0|1|4|0||0|5|0|4|172|172|0|1165085|0|20|4|0|20|8|0|0|0|0|0||0|1912|0|0|24|0|0|1|0|0|0|0|23|0|0|30|0|164|4|6|8|0|0|0|0|0|0|0|121|10|15|24|24.0|16|16.0|0|0|0.0|4|0|24|23.646148681640625|1|0.0040013887919485569|0|0.0|0|0.0|0|0.0|11|2.0849723815917969|172|5|0|0|123|44|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|26|24|0|0|0|2|0|0|0|0|0|192|1|0|0|0|0|191|0|0|190|12|0|0|0|0|178|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|0|1|0|0|0|0|1008|953|2758|0|5|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|4|||||||||||||0|0|0|0|0|84.418106079101562|0|0|2626|1420|||0.29022222757339478|0|5|1.5045944452285767|0|5|||0.0058597764000296593|2|0.0046600494533777237|2|1340|1114|80|119|27|2.2584490776062012|10|1180|5|0|0|123|44|953|55|14462|7024|7438|52|2758|3.0037333965301514|5|0.021266667172312737|1|0.00036666667438112199|1|0.0|0|0.0|0|362|6440|6880|0|0|0|0||0||13711|27667|0|159|149|10|0|0|1|1|0|0|0|0|0|0|0|0|7|0|0|7|0|0|0|0|4|0|0|0|0|7|0|7|0|0|0|0|0|0|0|0|0|2|3|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|842|0|111|0|102|1702|0|1|842|0|111|0|0|1703|0|0|0|0|0|0|0|0|0.0|0|0|47|26|11|3|7|37|1|20|16|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|4|0.24921548366546631|0|44|44.0|0|0.0|0|0|0|1003|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|10|0|8|2|0|0|0|0|0|0|0|0|0|0|81|1|60|10|10|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|25|16|4|2|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|53|27|17|4|5|0|0|0|0|0|0|0|0|0|421|0|8685|67179|2138|12104|80|26285|104|1|73|16|14|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|87|1|77|7|2|0|0|0|0|0|0|0|0|0|1|0|0|1|0|0|0|0|0|0|0|0|0|0|16|0|9|5|2|0|0|0|0|0|0|0|0|0|155|155|0|105|51|32|9|13|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|102|0|0|0|0|0|600|445|4|20|32|63|16|15|4|1|0|0|0|0|0|0|0|37|0|0|5|0|0|0|32|0|230|7|10|99|68|22|21|0|3|0|0|0|0|0|0|0|0|0|286|18|10|182|53|17|6|0|0|0|2528|0|10|10|0|0|0|22|22|0|0|25|25|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|30|0|0|0|0|0|30||||||||||23|0|0|0|0|0|23||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0.0|45.998283386230469|46|0.0|0|0.0|0|0.30917638540267944|2|0.0|0|0.0|0|8|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|1|1|0|0|0|0|0|0|0|||0|100.0|100.0|0|2|1|0|0|1|0.73375397920608521|5|0.41600942611694336|6|0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|98115.5546875|865520|176626.671875|1159360|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||
We found that some of the data field become 'null' after the load action finished, if we load the same data again, problem disappeared, we can't 100% reproduce this issue each time, we don't know why, Anybody here can help us to solve this issue or give us some clue?
View 3 Replies
View Related
Jun 19, 2007
Hi,
I'm dealing with loading xml data into sql 2005 relational tables
We are trying to do with C# class objects, what would be the better method to follow to load C# entity objects with xml data.
Xml has a complex 6 level heirarchy and with huge amounts of data.
please help.
-Thanks
Shiva
View 6 Replies
View Related
Feb 21, 2001
I have a huge log file (285M) on SQL Server 7.
The database itself is about 10M.
How can I reduce the log file ?
Is it possible to build it again from scratch ?
I tried the Truncate Transaction Log but it didn't help.
View 2 Replies
View Related
Nov 28, 2007
When I run the following code :
DECLARE @var1 float,
@var2 int;
SET @var1 = 32.91 ;
SET @var2 = 100 ;
SELECT CAST(@var1 * @var2 AS int);
the result is ... 3290 (whereas it should be 3291 !)
Also works for @var1 set to 33.91 34.91 35.91 36.91 37.91 38.91 39.91 but not for other values > 40.
Is that a SQL Server bug ?
View 4 Replies
View Related
Dec 16, 2004
I am writing a .NET service, and I need to insert files in a SQL DB for temporary storage.
I have never inserted a file into a SQL database before. I am thinking about using the image field type. Has anyone done this before? How did you do it?
View 9 Replies
View Related
Sep 27, 2015
I would like to migrate around 15 databases in production server to the new production server. The biggest database is 80 GB .
Wondering is there any fastest way to do that with very low downtime ?
What I can think about is shrink databases files and perform attach – detach .
View 8 Replies
View Related
Jul 12, 2007
Hey Guys
I have meet the same problem, too.
I create a table with 1,380,000 rows data,
the db real size about 114 MB.
The primary key size is nchar(6).
When I use RDA pull, I found that the primary
key in the PDA disappear. So, It took a long time
to get query response.
But when I delete some rows to 680,000 rows of data.
After I pull, The primary key can pull from the SQL Server.
PS: I didn't change any code. Just delete some rows.
Is that SQL-Mobile's bug??
PS: 1.Database and Temp Database limitation both are 384MB
2.If I use query analyzer to add primary key it works! so strange!!
3.Pull process return "S_OK".
4.After Pull process finished, the db connection still alive. It seems not like
time out problem.
5.Local Connection String:"Data Source='%s\%s';SSCEatabase Password='%s';SSCE:Encrypt Database='true';SSCE:Max Database Size=384;SSCE:Temp File Max size=384;SSCE:Temp File Directory=%s"
View 1 Replies
View Related
Jun 14, 2006
I am moving a VS 2003 Pocket PC app to VS 2005 and when I deploy the app from Visuyal Studio 2005 two sqlce cabs are deployed (in addition to the sqlce30 ones) namely
sqlce20.dev.ppc.wce4.armv4.CAB
and
sqlce20.ppc.wce4.armv4.CAB.
Now as I have documented in another thread (SQL 2005 Mobile : The file is not a valid database file) this gives me problems when I want to access the database being produced by replication. So I'm trying to eliminate the need for these cab files.
My pocket PC application uses two of my DLLs the first of which is my Business Objects. When I deploy this to my PDA I get the following build output
------ Build started: Project: BO, Configuration: Release Any CPU ------
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Vbc.exe /noconfig
/imports:Microsoft.VisualBasic,System,System.Collections,System.Collections.Generic,System.Data,Sys
tem.Diagnostics /nowarn:42016,41999,42017,42018,42019,42032,42036,42020,42021,42022 /nostdlib
/rootnamespace:MVnet.VS2005CF.MobileSeller.BO /sdkpath:"C:Program FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCE" /netcf /doc:objReleaseBO.xml
/define:"CONFIG="Release",TRACE=-1,_MyType="Windows",PLATFORM="AnyCPU",PocketPC=TRUE"
/reference:"................Program FilesIn The Hand LtdADOCE In The Hand
v1.7RuntimeInTheHand.Data.Adoce.dll","................Program FilesIn The Hand LtdADOCE
In The Hand
v1.7RuntimeInTheHand.Interop.dll",..............VS2005CFReferences
eleaseMVnetApplicati
on.dll,"C:Program FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Data.dll","C:Program FilesMicrosoft
Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.dll","C:Program FilesMicrosoft
Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Drawing.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Web.Services.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Windows.Forms.dll","C:Program
FilesMicrosoft Visual Studio
8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Xml.dll" /debug:pdbonly
/filealign:512 /optimize+ /out:objReleaseBO.dll
/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.BO.frmError.resources
/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.Resources.resources /target:library
AmtechSynchroniser.vb AmtechAP_Board.vb AmtechAP_Circuit.vb AmtechAP_Completion.vb
AmtechAP_Domestic.vb AmtechAP_DomesticPeriodic.vb AmtechAP_DomesticSupplyCable.vb
AmtechAP_EmergencyLightingInspection.vb AmtechAP_FireDetectionCommissioning.vb
AmtechAP_FireDetectionInstallation.vb AmtechAP_FireDetectionServicing.vb
AmtechAP_FireDetectionSystemRevised.vb AmtechAP_FireDetectionVerification.vb AmtechAP_Job.vb
AmtechAP_MinorWorksNIC.vb AmtechAP_Periodic.vb AmtechAP_PeriodicBoardTest.vb
AmtechAP_PeriodicCircuitTest.vb AmtechAP_PeriodicRecommendations.vb AmtechAP_ProtectiveDevice.vb
AmtechAP_StandardRecommendations.vb AmtechAP_VersionInfo.vb AmtechICDBEntity.vb basMain.vb
basSQL.vb cAddress.vb cAnswer.vb cBlockAllocation.vb cBO.vb cCompany.vb cCustomer.vb cCustomerF.vb
cInvoice.vb cInvoiceLine.vb cJob.vb cNote.vb cOrder.vb cOrderF.vb cOrderLine.vb cPaymentLine.vb
cPaymentLineF.vb cPDA_Update.vb cProduct.vb cProductF.vb cProductStock.vb cProductStockF.vb
cQuestion.vb cQuestionAnswer.vb cReceipt.vb cRep.vb cRepF.vb cRepProductPrice.vb
cRepProductPriceF.vb cRepProductStock.vb cRepStockAdjustment.vb cRepStockOrder.vb
cRepStockOrderF.vb cSalesPosition.vb cSalesPositionF.vb cSupplier.vb cType.vb cTypeF.vb cVatCode.vb
cVisit.vb cVisitF.vb Database.vb EntityHelper.vb FleetMindercMakeModel.vb FleetMindercVehicle.vb
frmError.vb GradusGradusReport.vb IEntityForm.vb IManagedForm.vb ISQLInEntity.vb "My
ProjectAssemblyInfo.vb" "My ProjectResources.Designer.vb" PageSelection.vb PDAProduct.vb
Property.vb RDAControl.vb Synchroniser.vb "Web ReferencesFeedBackWSReference.vb" "Web
ReferencesWSPDADBReference.vb"
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(152) :
warning BC42104: Variable 'TableConfig' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(166) :
warning BC42104: Variable 'ATTable' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(292) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(350) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(400) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(458) :
warning BC42104: Variable 'rstab' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(557) :
warning BC42104: Variable 'rsTab' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(611) :
warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(812) :
warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(856) :
warning BC42025: Access of shared member, constant member, enum member or nested type through an
instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(952) :
warning BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1000) :
warning BC42025: Access of shared member, constant member, enum member or nested type through an
instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1004) :
warning BC42025: Access of shared member, constant member, enum member or nested type through an
instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1009) :
warning BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1020) :
warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1078) :
warning BC42104: Variable 'oProp' is used before it has been assigned a value. A null reference
exception could result at runtime.
vbc : warning BC42206: Maximum number of warnings has been exceeded.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb(231) : warning
BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Circuit.vb(239) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Completion.vb(812) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Domestic.vb(543) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticPeriodic.vb(606
) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticSupplyCable.vb(
284) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_EmergencyLightingInspec
tion.vb(362) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionCommission
ing.vb(270) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionInstallati
on.vb(268) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionServicing.
vb(609) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionSystemRevi
sed.vb(293) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionVerificati
on.vb(277) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Job.vb(340) : warning
BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_MinorWorksNIC.vb(314) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Periodic.vb(619) :
warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicBoardTest.vb(22
7) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicCircuitTest.vb(
239) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicRecommendations
.vb(181) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A
null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(113) : warning
BC42105: Function 'Version' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(176) : warning
BC42105: Function 'RepLogOn' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(443) : warning
BC42105: Function 'ExecuteSQL_ReturnIdentity' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(513) : warning
BC42105: Function 'InitialiseServiceOrderLines1' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(585) : warning
BC42105: Function 'GetVisit1' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(656) : warning
BC42105: Function 'GetCustomer1' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(728) : warning
BC42105: Function 'GetProduct1' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(798) : warning
BC42105: Function 'GetDataSet' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(868) : warning
BC42105: Function 'GetScalar' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1012) : warning
BC42025: Access of shared member, constant member, enum member or nested type through an instance;
qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1134) : warning
BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1176) : warning
BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1217) : warning
BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(238) : warning
BC42105: Function 'SelectSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(342) : warning
BC42105: Function 'InsertSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(404) : warning
BC42105: Function 'UpdateSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(460) : warning
BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(522) : warning
BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(634) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(847) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(959) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(1083) : warning
BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :
warning BC42104: Variable 'CurrentMake' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :
warning BC42104: Variable 'NewMake' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercVehicle.vb(132) :
warning BC42104: Variable 'V' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(39) :
warning BC42105: Function 'DisplayName' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(64) :
warning BC42105: Function 'CurrentSection' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(341) : warning
BC42105: Function 'ProductTypeInList' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(419) : warning
BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'SelectSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'StockSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'CategoryValue2' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning
BC42104: Variable 'ProductSupplierJoinSQL' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(748) : warning
BC42107: Property 'SelectSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(791) : warning
BC42107: Property 'CountSQL' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(850) : warning
BC42107: Property 'Products' doesn't return a value on all code paths. A null reference exception
could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPageSelection.vb(8) : warning
BC40055: Casing of namespace name 'bo' does not match casing of namespace name 'BO' in file
'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOSynchroniser.vb(213) : warning
BC42104: Variable 'ErrorInfo' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(217) : warning BC42107:
Property 'AmtechDBPath' doesn't return a value on all code paths. A null reference exception could
occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(582) : warning BC42104:
Variable 'TableName' is used before it has been assigned a value. A null reference exception could
result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCompany.vb(848) : warning
BC42024: Unused local variable: 'Setting'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(924) : warning
BC42104: Variable 'SaveCurrentVisit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(974) : warning
BC42105: Function 'GenerateInvoices' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomerF.vb(419) : warning
BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(411) : warning BC42105:
Function 'InvoicedVisitWithNoPO' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(449) : warning BC42104:
Variable 'V' is used before it has been assigned a value. A null reference exception could result
at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(7) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain
any public member or cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(9) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.VS2005CF.MobileSeller.WebServices' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(202) : warning
BC42105: Function 'RootQuestions' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(212) : warning
BC42105: Function 'Questions_ForCompany' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(238) : warning
BC42105: Function 'AnswersForQuestion' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(244) : warning
BC42024: Unused local variable: 'sSQL'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(254) : warning
BC42105: Function 'AnswersForQuestion_IncludeUserAnswers' doesn't return a value on all code paths.
A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcRepF.vb(354) : warning BC42104:
Variable 'oRep' is used before it has been assigned a value. A null reference exception could
result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(905) : warning BC42105:
Function 'PopulateComboFromRepProductCategories' doesn't return a value on all code paths. A null
reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(917) : warning BC42025:
Access of shared member, constant member, enum member or nested type through an instance;
qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(967) : warning BC42024:
Unused local variable: 'sValue'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1228) : warning
BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference exception
could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1300) : warning
BC42104: Variable 'PaymentsSplit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1318) : warning
BC42104: Variable 'NoSignaturesSplit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1336) : warning
BC42104: Variable 'CancellationsSplit' is used before it has been assigned a value. A null
reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1356) : warning
BC42104: Variable 'NotesColonSplit' is used before it has been assigned a value. A null reference
exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1413) : warning
BC42105: Function 'VisitResultCodes' doesn't return a value on all code paths. A null reference
exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisit.vb(12) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(8) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain
any public member or cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(9) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(10) : warning BC40056:
Namespace or type specified in the Imports 'MVnet.VS2005CF.mobileseller.WebServices' doesn't
contain any public member or cannot be found. Make sure the namespace or the type is defined and
contains at least one public member. Make sure the imported element name doesn't use any aliases.
BO -> C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll
------ Deploy started: Project: BO, Configuration: Release Any CPU ------
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL
ServerMobilev2.0System.Data.Common.dll'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL
ServerMobilev2.0wce400ARMV4sqlce20.ppc.wce4.armv4.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL
ServerMobilev2.0wce400ARMV4sqlce20.dev.ppc.wce4.armv4.cab'
Deploying 'C:DevVS2005CFReferences
eleaseMVnetApplication.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand v1.7RuntimeInTheHand.Interop.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand
v1.7RuntimeInTheHand.Data.Adoce.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll'
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========
which as you can see is bringing in the two cabs.
Is there an easy way to determine what exactly requires these two cabs?
I strongly suspect that it's a third party stuff from ADOCE which I'm using to access access databases on the PDA.
View 5 Replies
View Related
Dec 13, 2007
Hi,
I created a CLR UDF that returns a large number of rows, when I run it from my VPC (XP, SQL Server Developer Edition and 1GB Memory) it takes approx 2 min and 30 secs to start displaying the rows (Using Management Studio), when I run the same query in our development server (Win 2003, SQL Server Enterprise Edition, 8 GB Memory and 8 Processors) it takes more than 15 min to start displaying the results, does anybody have an idea why is this happening?
Thanks in advance
View 2 Replies
View Related
Jul 6, 2015
I have a CTE query against a table with 32K rows that runs fine in 2008R2. I am running it in 2014 Std Ed. against the same data and it runs very slowly. Looking at the execution plan I think I see what's contributing to the slowness.
Note that the "actual number of rows" is some 351M...how is this possible?
the query:
declare @amts table (claim int,allowed decimal(12,2),copay decimal(12,2),deductible decimal(12,2),coins decimal(12,2));
;with unpaid (claimID) as (select claimID from claim where amt+copay + disct+mm + ded=0)
insert @amts
select lineID, sum(rc), sum(copay), sum(deduct),
case when sum(mm)>0 and (sum(mm)<sum(mmamt)) then sum(mm) else 0 end
from claimln
where status is null
and lineID not in (select claimID from unpaid)
group by lineID
it's like there's some massively recursive process going on?
View 5 Replies
View Related
Dec 21, 2005
In
one of our forth coming projects, with ASP.Net/C#/MSSQL Server, We have
to deal with a Business table having about 15 millions of records. We
want to know, that which methodologies should we adopt, both regarding
front end and back end perspective, so the site could give optimised
performance. Also in place of a Dedicated Server, the Hosting Company
provides MSDE (that come with .net). Will this create any problem with
this project, that have such a huge table? Should we go for some
advanced database technique, such as, Clustering, Spliting Tables, etc.
Followings are the fields that the business table contains:
ID, Category ID (which comes from a Category table, each business is
under a category), BusinessName, SignupDate, Address1, Address2, Phone
Number,
Hours Of Operation, Years in Business, LicenseNumber, DiscountCoupon, Website
View 3 Replies
View Related
Oct 22, 2015
I am copying data from database to an excel file through SSIS. database is MS SQL 2005 and BIDS is also 2005.However, the job doing this task fails every time.As per investigation, the result of the query is more than 100,000 rows and we know that excel has a limit of 65000 rows of data.Is there a way of setting the limit up? or something? a better approach maybe so that everything will be copied to the excel file successfully.
The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error Error: 2015-10-22 04:34:58.05 Code: 0xC0047021
Source: Data Flow Task
Description: SSIS Error Code DTS_E_THREADFAILED.
Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:30:00 AM Finished: 4:35:05 AM Elapsed: 304.844 seconds. The package execution failed. The step failed. "
View 1 Replies
View Related
Feb 20, 2014
We have a Customized share point application with Very minimal data usage and we have used only 5 to 6 lists and libraries only in the share point.
Configuration is
Clients -- fire wall --- Load Balancer ---- WF1 and WF2 --- SQL DB
ROUTING IS VIA FIRE WALL.
SUDDENLY THE SITE GOT DEAD SLOW AND UNABLE TO TRACE THE PROBLEM AS EVERY THING LOOKS FINE.
Checked with the firewall Team and they stated its fine from their end & even we have verified the counters, CPU, Memory & Page life expectancy, buffer counters all looks good and even we do not have huge data in the database. We have only 50 concurrent users are working...
View 2 Replies
View Related
Jan 26, 2006
What is the fastest way I can load data into SQL SErver -- it seems to me it's with Bulk Copy and minimal logging. But that seems very slow when I look at Orace's Data Pump and DB2's LOADer. Does SSIS help here -- from what I can tell, you help me tons and tons on the ET part, but the L is what I'm wondering about...
View 5 Replies
View Related
Sep 18, 2000
hi
I am loading from Mainframe to Sqlserver.
Right now i am truncating the tables in sqlserver connecting to mainframe and downloading the tables to Sql server. The problem is sometimes i fail to connect to Mainframe. So is there any way of checking whether i can connect to mainframe and if succesful truncate the tables.
Thanks
View 1 Replies
View Related
Jun 7, 2006
I need to periodically import a (HUGE) table of data from an external data source (not SQL Server) into SQL Server, with the following scenarios:
Some of the records in the external data source may not exist in SQL.Some of the records in the external data source may have a different value at different imports, but this records are identified univocally by the same primary key in the external datasource and in SQL Server.Some of the records in the external data source may be the same in SQL.
Due to the massive volume of the import, I would like to import only the records which are different from what I have in SQL Server (cases 1 and 2 above). In fact case 2 is the most critical.
I thought of making a query with a left outer join between the data in the external data source table (SOURCE) and the data in the SQL Server table (DESTIN). The join is done on the respective primary keys (composed keys of up to 10 columns) and one of the WHERE conditions will be that the value in SOURCE is different from the value in DESTIN.
The result of this query would be exactly what I need to import.
How to do this in SSIS??? I couldn't figure out how to join tables in different data sources yet.
In fact I cannot write a stored procedure to do that, since one of the sources is in a datasources not SQL Server.
I have seen the Lookup transformation in this article http://www.sqlis.com/default.aspx?311 but this is not exacltly what I want to do.
Another possibility is to use the merge join, but due to the sorting I believe its performances would be terrible!
Thanks in advance for your suggestions!
View 9 Replies
View Related
Oct 5, 1999
I looked for an answer in the archives and could not find one.
Does anyone know if it is ok or works loading a database dump
from one SQL server running SP 5a (production server) onto another SQL server running SP 3 (backup server)? We were not planning to upgrade our production and backup servers simultaneously unless there would be a problem loading the
database dumps.
Thanks you in advance.
View 2 Replies
View Related
May 14, 1999
I am trying to setup 2 SQL servers (ver 6.5) - A live server and a standby server. The plan is to have regular transaction logs dumps from the Live server databases to the standby server and then have these logs automatically applied.
I have managed to get the logs dumping automatically but when I tried to apply them I keep getting synchronisation/sequence errors.
Has anyone done/tried anything similar. Any advice on this would be very useful.
Thanks
Samir
P.S I can't do this via replications as most tables in the database do not have primary keys.
View 5 Replies
View Related