CAB Files

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - Running SSIS package (.dtsx) from a ASP.Net web service Where do I find about running an SSIS package (.dtsx) from a ASP.Net web service, particularly issues to do with permissions cheers Rob Tag: CAB Files
  - 2
    - ExecuteNonQuery hangs in Timer event notification If I call ExecuteNonQuery() in a timer event callback in a console application, it hangs. Why is that .B ekiM class Program { static SqlConnection conn = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NONEOFYOURBISUINESS;Data Source=localhost"); static void Main(string[] args) { NativeMethods.MEMORYSTATUSEX mem = new NativeMethods.MEMORYSTATUSEX(); NativeMethods.GlobalMemoryStatusEx(mem); Console.WriteLine("{0} bytes", mem.ullAvailPhys); System.Timers.Timer aTimer = new System.Timers.Timer(); // Set the Interval to 2 seconds (2000 milliseconds). aTimer.Interval = 1000; aTimer.Enabled = true; // Hook up the Elapsed event for the timer. aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent); Console.ReadLine(); } private static void OnTimedEvent(object source, ElapsedEventArgs e) { NativeMethods.MEMORYSTATUSEX mem = new NativeMethods.MEMORYSTATUSEX(); NativeMethods.GlobalMemoryStatusEx(mem); SqlCommand cmd = new SqlCommand( "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (1, @When, @AvailPhys);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (2, @When, @AvailPageFile);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (3, @When, @AvailVirtual);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (4, @When, @AvailExtendedVirtual);\n"); DateTime dt = DateTime.Now; cmd.Parameters.AddWithValue("AvailPhys", mem.ullAvailPhys); cmd.Parameters.AddWithValue("AvailPageFile", mem.ullAvailPageFile); cmd.Parameters.AddWithValue("AvailVirtual", mem.ullAvailVirtual); cmd.Parameters.AddWithValue("AvailExtendedVirtual", mem.ullAvailExtendedVirtual); cmd.Parameters.AddWithValue("When", dt); cmd.ExecuteNonQuery(); Console.WriteLine("Inserted {0}", dt); } } Tag: CAB Files
  - 3
    - Cannot get access to my Access 2003 database tables I developed a database with Access 2003 and everything was working good until my tech came in and reformated my hard drive and install a new Ghost image that met our company standards. Now I cannot go in and make any changes to any of the tables, queries and forms. All of this started when a new Ghost image was installed on my pc. The message I get when I try to open my database is "You do not have permission to run "tblSwitchboard." I get the same error message when I try to do anything at all on the database. I am at a loss as to what to do. Please help. Tag: CAB Files
  - 4
    - Combine two stored procedure results Hi, I have two databases DB2006, DB2005.I have the Stored Procedure getdata which has the 2 parameters startdate and end date.This Stored procedure exist in all databases. STored procedure CallGetdata @startdate datetime @enddate datetime If startdate < 1/1/2007 the call getdata in the DB2006 if startdate <1/1/2006 then call getdata in the DB2005. Here the problem is if startdate is 6/1/2005 and Enddate is '3/1/2006' then combine the stored procedure results from the DB2006 and DB2005 databases. I have one idea i.e create a temp table and insert the two Stored procedure results into it. Create #table1(name varchar(20)) insert into #table1 exec DB2006.dbo.getdata insert into #table1 exexc DB2005.dbo.getdata Select * from #table1 drop table #table1. Anyone please give me better idea than creating temp table. Thanks in advance Tag: CAB Files
  - 5
    - soap message exchange between .NET Webservice and stored procedure Hello, is message exchange between a .NET Webservice and a SQL stored procedure possible And if, could you please explain me how Or give me a tip where i can get more informations and maybe samples thanks for your help regards pamelia Tag: CAB Files
  - 6
    - Shared Connections and Stored Credentials for Subscriptions? I can't seem to get this to work and have to resort to a custom connection for each report in Server Manager. The problem with that is that I have to re-do it every time I re-deploy the reports. Is there a secret to this that I have not found yet Dick Campbell Tag: CAB Files
  - 7
    - T-SQL / varchar truncate solutions Why does SQL Server truncate the data being stuffed into "@vt" without throwing some kind of error or warning The print statement puts "123456" into the output window. Believe it or not .. our development team is actually trying to use this minor issue as justification for going with Oracle on this project, because they deem this as a data integrity issue and PL/SQL does throw an error. They would prefer to have an error thrown, instead of just silently truncating the data. declare @vt varchar(6) select @vt = '12345678' print @vt Is there a way that I can get T-SQL to throw an error or warning when this occurs I thought a UDT with a rule applied to it might do the trick, but that hasn't worked for some reason. Or any other creative solutions that you can think of Thank you, Mark Tag: CAB Files
  - 8
    - Data Flow Task Stuck I have a simple data flow task setup... 2 ADO.NET connection managers, each referencing a DSN pointed to a Unidata database. 2 DataReader sources, each using a single ADO.NET connection managers, running a simple SELECT statement from a table. I have a Union All transform setup to merge the data and write to a OLE DB Destination (SQL05 database) When I run the package, each source will validate, but only one will execute. The other source will do nothing. The data source will be colored yellow, and will just sit there. The package will just sit, almost like it is waiting for input. This behavior is not consistent, however. It varies which data source will hang, pretty much 50-50. About 25% of the time, both sources will execute, and all rows will be written to the destination. Any help is appreciated. thanks Tag: CAB Files
  - 9
    - Reporting Services Preview View different from Print Layout I'm currently using Sql server 2005 Reporting Services. I'm trying to take data and fill in a form that I'm making a background image. When I go to preview all the textboxes filled with data align with the fields in the background image form. When I go to print they are off by a inch or so horizontally. Can anyone help me on this topic. Tag: CAB Files
  - 10
    - Delete row where a particular field value is not in a list I have a table which has a field called filename, thus the data in the field would look something like this: FileName.doc FileName.txt FileName.foo I need to delete several rows from this table where the filename field DOES NOT contain the following extensions (e.g. row with FileName.foo would be deleted): .txt .pdf .rtf .doc .htm .html .mht .mhtml .dot .wk1 .wk3 .wk4 .xls .xlw .asc .olk .pab .scd .ans .wri .mcw .wpd .wps .ppt .pps .xls .xlt .xlw Tag: CAB Files
  - 11
    - SSRS Performance Hi All, I am facing an issue while working with huge data in tables. I have a stored procedure which when exceuted on SQL Server Browser takes little time to display the output on the screen. The same stored procedure is used by the application with SQL Server Reporting Services to generate the report. When executed, the application stops responding after sometime. After debugging steps by steps, I found that the dataset fetches the records from database using stored procedure takes around 11 mins and application stops responding while generating the reports. Now, does this happens with some performance related issue with SQL Server Reporting Services or Do I need to modify stored procedure Tag: CAB Files
  - 12
    - Does fragmentation changes after backup/restore operation? Hello, If i backup a database and then restore it, would physical structure remain the same specially fragmentation. I'm concerned about output of DBCC SHOWCONTIG. Senario: I want to check if client database needs defragmentation, so he's sending db backup file. But is it possible that when i restore it fragmentation info has got lost Thank you. STG Labs Tag: CAB Files
  - 13
    - sp_spaceused equivalent in CE? I am looking for a way to programatically determine the size of the data contained in a table, much like the sp_spaceused proc in SQL Server. Thanks. Tag: CAB Files
  - 14
    - Wat's the effective way to improve performance in table using indexing? Hi guys , assuming there's a table called 'transactions' which contains more than 1 million records and normally will retrieve the records for monthly/yearly summary report. There are 5 fields within the 'transaction' table which are : - transaction_ID (PRIMARY) - transaction_Name - transaction_Date - transaction_Amount - transaction_reference Right now I would like to add indexing feature and I was wondering which use I take it as index for the effective way. Normally those summary report will sort by date. Is it take transaction_Date as non-cluster index n transaction_ID as unique cluster index. Hope able to get any assistance here. Thx a lot. Best Regards, Hans Tag: CAB Files
  - 15
    - How to verify installed license I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals. Thanks, Skip Berry Tag: CAB Files
  - 16
    - How to rename a column or table on the desktop? I am using the compact edition on a desktop using VS2005 as well as SQL Server Management Studio. None of those tools allow me to rename a column or rename a table. Can someone point me a tool the runs on the desktop (as opposed to running on a CE device) that allows me to do the renaming Thanks Tag: CAB Files
- Next
  - 1
    - Executing an SSIS package containing Analysis Services from ASP.NET I'm trying to execute an SSIS package from an ASP.NET web page. Using some code from http://msdn2.microsoft.com/en-us/library/ms403355.aspx I have managed to get this working when executing a package that contains a stored procedure, however it does not work when there is an Analysis Services cube to build. Here is my code for the webservice Code Snippet Public Class SCCBuildDW Inherits System.Web.Services.WebService ' LaunchPackage Method Parameters: ' 1. sourceType: file, sql, dts ' 2. sourceLocation: file system folder, (none), logical folder ' 3. packageName: for file system, ".dtsx" extension is appended _ Public Function LaunchPackage( _ ByVal sourceType As String , _ ByVal sourceLocation As String , _ ByVal packageName As String ) As Integer 'DTSExecResult Dim packagePath As String Dim myPackage As Package Dim integrationServices As New Application ' Combine path and file name. packagePath = Path.Combine(sourceLocation, packageName) Select Case sourceType Case "file" ' Package is stored as a file. ' Add extension if not present. If String .IsNullOrEmpty(Path.GetExtension(packagePath)) Then packagePath = String .Concat(packagePath, ".dtsx" ) End If If File.Exists(packagePath) Then myPackage = integrationServices.LoadPackage(packagePath, Nothing ) Else Throw New ApplicationException( _ "Invalid file location: " & packagePath) End If Case "sql" ' Package is stored in MSDB. ' Combine logical path and package name. If integrationServices.ExistsOnSqlServer(packagePath, "." , String .Empty, String .Empty) Then myPackage = integrationServices.LoadFromSqlServer( _ packageName, "(local)" , String .Empty, String .Empty, Nothing ) Else Throw New ApplicationException( _ "Invalid package name or location: " & packagePath) End If Case "dts" ' Package is managed by SSIS Package Store. ' Default logical paths are File System and MSDB. If integrationServices.ExistsOnDtsServer(packagePath, "." ) Then myPackage = integrationServices.LoadFromDtsServer(packagePath, "localhost" , Nothing ) Else Throw New ApplicationException( _ "Invalid package name or location: " & packagePath) End If Case Else Throw New ApplicationException( _ "Invalid sourceType argument: valid values are 'file', 'sql', and 'dts'." ) End Select Return myPackage.Execute() End Function End Class This is the code from my page Code Snippet Protected Sub btnBuildDW_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles btnBuildDW.Click ExecutePackage() End Sub Protected Sub ExecutePackage() Dim launchPackageService As New SCCBuildDW.SCCBuildDW Dim packageResult As Integer Try packageResult = launchPackageService.LaunchPackage( "file" , "c:\ssis" , "PackageTest" ) Catch ex As Exception ' The type of exception returned by a Web service is: ' System.Web.Services.Protocols.SoapException lblResult.Text = "The following exception occurred: " & ex.Message End Try lblResult.Text = CType (packageResult, PackageExecutionResult).ToString ' Console.ReadKey() End Sub Private Enum PackageExecutionResult PackageSucceeded PackageFailed PackageCompleted PackageWasCancelled End Enum I'm using windows authentication and impersonating an identity. The identity has access to the analysis services role but the package still fails to run. Can anyone offer any help or advice on this Thanks Tag: CAB Files
  - 2
    - Upgrade SQL 2005 Standard to SQL 2005 Enterprise Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place. Tag: CAB Files
  - 3
    - SQL Reporting Services performance on navigation pages. I am experimenting with SQL Reporting Services on a machine with SQL Server 2005 loaded and deploying reports to a different server. both servers are equivalent in resources. In the browser on the Reports machine when I first go to the Reports address, it takes a very long time to build and load the page. it then takes a long time for each drilled down page. Subsequent calls to the same pages are very fast if done within a certain amount of time. This implies that there must be some form of caching going on and that the cache expires after a period of time. I have seen in the RSReportserver.config file that there are parameters relating to report caching, but they all appear to reference the actual reports being generated. My issue is simply being able to build the start page and other navigation more quickly and to keep it active so it does not have to perform that build each time. Any information related to managing this situation would be very much appreciated.. Thank you, Ray Tag: CAB Files
  - 4
    - Determine if a column is indexed (and the index name) Is there a slick way to determine if all the indexes (if any) for a particular field let's say: tbPeople ID (bigint) FirstName (varchar(50)) LastName (varchar(50)) I need to determine if [FirstName] in indexed anywhere, and if so, what are the name(s) of the indexes. thanks ahead of time. Tag: CAB Files
  - 5
    - Personalize Reports for Each User Hello Everyone, I am trying to personalze my reports for each user, for example: Say I have a report which takes in userName as a parameter and then generates the report. Is it possible to use the same userName that the user used to login to the reporting services enviornment. This way the user don't have to enter their userName to see the report, it will be entered by default. Thanks a lot, -Rohit Tag: CAB Files
  - 6
    - excel data mining add-in for categorical data Thank you very much for your previous answers conserning clustering algorithm. I change a bit my data and now I can get two and three clusters as I wish. But now I have a different question. I wish to keep my Structure and Model for further trials with different algorithm values, like cardinality. I tried the following I selected in excel Data Mining and then the option cluster button. Then in the cluster wizard I chose analysis service data source and I reform the query as I need adding only at the end where "STAFF_YES" = 1. Then I choose the needed columns and target value. Finally I select browse model, enable drill through only and I finish the wizard and get some results, rather good. But i need to try again with different parameters. I tried Business intelligent Studio to check my Analysis service. The structure were here but when I changed any parameter and I tried to reprocess I got the following messages Processing Mining Structure 'try Structure_1' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension 'try Structure_1 ~MC-__RowIndex' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute 'EPI_CELL_SINO_GOOD' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute 'EPI_CELL_SINO_LOOSE' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected error occurred (file 'pcprocbinding.cpp', line 6645, function 'PCDBProcBinding: electOrChangeCartridge'). Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'try Structure_1 ~MC-__RowIndex', Name of 'try Structure_1 ~MC-__RowIndex' was being processed. Errors in the OLAP storage engine: An error occurred while the 'EPI_CELL_SINO_LOOSE' attribute of the 'try Structure_1 ~MC-__RowIndex' dimension from the 'DMAddinsDB2' database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected error occurred (file 'pcprocbinding.cpp', line 6645, function 'PCDBProcBinding: electOrChangeCartridge'). Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'try Structure_1 ~MC-__RowIndex', Name of 'try Structure_1 ~MC-__RowIndex' was being processed. Errors in the OLAP storage engine: An error occurred while the 'EPI_CELL_SINO_GOOD' attribute of the 'try Structure_1 ~MC-__RowIndex' dimension from the 'DMAddinsDB2' database was being processed. And no change to the structure take place. Please help me if you can Thank you in advnce Best regards. Manolis Tag: CAB Files
  - 7
    - HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005 SQL 2005 DOES NOT HAVE THE SAME FEATURE THAT WAS IN 2000 TO DELETE OLDER FILES OLDER THAN CERTAIN DAYS. I DO HAVE A JOB THAT CREATES A FULL DAILY BACKUPS BUT SINCE I DON'T HAVE ENOUGH SPACE, I WOULD LIKE TO FIND A WAY TO DELETE ALL OLD BACKUP FILES OLDER THAN X AMOUNT OF DAYS AND ALSO DELETE TRANSACTION FILES OLDER THAN X AMOUNT OF DAYS. IS THERE A TOOL TO DO THIS. CAN ANYONE HELP PLEASE. EMADKB Tag: CAB Files
  - 8
    - Embedded image does not appear Hi there! I've an embedded image (logo) in my report, and in the preview it looks wonderful, but after deploy the logo doesnt appear in the report (report server). The url of the dead-link-image is http://hamsql1/Reports$BI/Reserved.ReportViewerWebControl.axd . I thought that an embedded image is stored "in" the report, but it seems to be an other place. Is it nessecary to deploy an embedded image too Is it a problem of permissions (i read it in another threat) How to set these image-see-permission Or is there an other problem Every idea is very welcome! Thanks, Torsten Tag: CAB Files
  - 9
    - can't (re)start SQLServerAgent after changing its logon credentials Since Copy Databas Wizard failed to copy anything from remote SS20005 (both are with SP2 3054) in any combination, I changed SQLServerAgent(myinstance_name) to run under Network from Local System with the help of SQL Server Configuration Manager For this change it was restarted, failed to start again and continues to be stopped giving "SQLServerAgent could not be started (reason: Unable to connect to server '<mymachine_name>\<myinstance_name>'; SQLServerAgent cannot start)." I changed SQL Server Agent (myinstance_name) back to Local Service, then to Local System and still can't start it. So, my questions: 1) What has happened and how can I start SQLServerAgent 2) Why cannot I start it under Network Service since it apparently should access remote resources for CDW to copy from remote SS2005 This is on MS Windows XP SP2 PS After few trials I amnaged to restart it again under Local System but still cannot change to any different one Tag: CAB Files
  - 10
    - I have a VB script that works in WinXP sp1 but not in WinXp sp2 hello all, I have the following script that does not work in windows XP SP2 //Script sub UpLoad (UploadFileName) dim b1 b1=&H4000000 set objStream =CreateObject( "ADODB.Stream" ) set objRecord =CreateObject( "ADODB.Record" ) set cnn =CreateObject( "ADODB.Connection" ) cnn.Open "provider=MSDAIPP.DSO;data source= http://192.168.0.100" objRecord.Open UploadFileName,cnn, 3,b1 objStream.Type = 1 'adTypeBinary objStream.Open objRecord,3,4 /////// Error line ////// objStream.LoadFromFile "c:\" +UploadFileName objStream.Flush objStream.Close objRecord.Close Set objStream = Nothing Set objRecord = Nothing cnn.close set cnn = nothing end sub Error Message is "No such interface supported" Any idea whoud be appreciated highly Tag: CAB Files
  - 11
    - Correlated subquery in UPDATE - Where am I going wrong? Hi, I'm sure I'm missing something obvious, but I'm trying to get the following update to work on SQL2000, but it keeps complaining about the where clause. UPDATE Table1 SET Col_A = t2.Col_A, Col_B = t2.Col_B FROM Table1 AS t1, (SELECT TOP 1 Col_A, Col_B FROM Table2 WHERE Col_C = t1.Col_C) AS t2 WHERE t1.Col_A is Null I'm fairly certain I can get it to work with a cursor, but that's not the best way to go, is it. Do I need to use a join TIA, Menthos Tag: CAB Files
  - 12
    - Inconsistent OLE DB Failure when running SSIS packages I have a series of SSIS packages which populate 12 different databases. Which data source & target they use is controlled by values passed down from the SQL Agent Scheduler Job Step using "Set Values" These values are passed to Variables which are used in the Expressions in the connection manager for the database to change the connection string and initial catalog. e.g. REPLACE( @[User::ConString] , "Royalty", @[User::RoyDb] ) These jobs run successfully the majority of the time but each day I get a significant number of failures where one or more target or error trapping table cant be found. They are all using the same connection manager and most of the tables in the database get updated correctly but the job fails on trying to access one or two of the tables, with the following message in the On Error event: -1071636248,0x,Opening a rowset for "[dbo].[RIGDUE_DAY]" failed. Check that the object exists in the database. This happens both when I schedule the jobs in parallel with other jobs running the same packages & when I run the job by itself using the right click, start at step option. e.g. I had one fail last night, I ran it by itself this morning, it failed, I ran it again, it succeeded. Nothing concerning the data it was transforming had changed. I have applied the hotfix to service pack one concerning the paralel use of variables in a package as referred to in the following link. http://support.microsoft.com/kb/918091#appliesto Any ideas welcome Tag: CAB Files
  - 13
    - Replicating Primary Key value onto the Foreign key value Hey Guys, I am just new to SQL Server. I have just created 2 tables Table1 and Table2. Table1 has a primary key (Table1.ID), which has been set on identity values.Both tables have different columns except the ID columns. I have also used Table1.ID as foreign key and primary key on Table2 as Table2.ID. I am just wondering guys if it is possible that when I enter or insert a data on Table1, can the same value (Table1.ID) be instantaneously copied to Table2.ID for the next data entry for Table2. Please could you show me how this can be done using SQL Server Express 2005. Tag: CAB Files
  - 14
    - SSIS performance Hi, I have 4 execute packages say A, B, C, D. These packges contains packages for data transfer in turn. Package A - 15 packages Package B - 15 packages Package C - 20 packages Package D - 20 packages When i run these packages one at a time in the order A, B, C, D then the execution time is around 17 mins. If I make a parent package and put A, B, C, D in sequence in it, executing this parent package increases the execution time to arnd 50 mins. Pacakge A, B, C, D doesnot run in parallel. They run one at a time. So i was wondering why the there is so much time difference. Please let me know if theres some configuration settings to make the parent package efficient. All the test conditions are same in both the cases. The source and the target are SQL server which are on the same machine as the SSIS. Thanks, Vipul Tag: CAB Files
  - 15
    - BCP in sql server 2005 Hi, 1 Is it Bcp supported in Sql server 2005 2 Instead of using BCP, Is there any other alternative options in 2005 Thanks Altaf Nizamuddin Tag: CAB Files
  - 16
    - ssis and vba I converted sql 2000 package to ssis. I had flat file to table and i had some activex script for formatting of columns in the dts. hence when i migrated to sql 2005 ssis those steps are converted to execute sql 2000 package task and when i try to execute the package from vba all other steps execute except these steps. Can anybody can tell how to make this step run from VB or how to run the dtexec from VB. thanks Bhu Tag: CAB Files

FarnazB

Can anyone Please point me to a place that I can find some documentation on what the sql.ppc.wce5.armv4i.CAB does

I basically need to know which files are being placed in the handset by deplyoing the CAB file.

Thanks,

Farnaz

Top

Re: CAB Files

ErikEJ

The cab file contents are documented here: http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx

Top