sp_spaceused equivalent in CE?

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - Help in Query? i have a table for staff allocation.i need to allocated them for class input table Staffid Class Subject Priority Hours hrspday 2 7 1 2 10 2 1 7 5 2 10 2 2 1 1 3 10 2 1 5 1 3 10 2 3 1 31 3 8 2 o/p must be in first row staff id is 2 goes to class 7 for 10 hrs in week 2 hrs per day so output must be like this staff id class subject 2 1,1 7 1 2 1,4 7 1 2 2,1 7 1 goes on.............. here id 1,1 represent mon first peroid similiarly 1,4 means mon 4th hour so plz me tell query to generate output like this ... Tag: sp_spaceused equivalent in CE?
  - 2
    - x64 version of Microsoft .NET Data Provider for mySAP Business Suite Hello Hans, please have a look here: www.xtract-is.com The Xtract component suite for SSIS fully supports x64. Maybe this is an alternative tool for you. Kind regards, P. Tag: sp_spaceused equivalent in CE?
  - 3
    - How do I automate removal of reports? By 'everything' I mean the connection string to the sql server and the published report scripts. You ask why I don't 'just use' different connection strings. Is there a way of doing that automatically I want to install a new set of reports and I want to do it automatically. You suggest I 'just use config mgr'. Is there a way of doing that automatically I have been told that I cannot expect any new .config/.rds values to take effect if there is already a published report with a connection string (for the data source). I know how to install reports from scratch (by using rs.exe). But I try to find ways to free our I.T. people from having to do lots of little, routine, manual things like editting .config files. I need there to be a solution to this. Tag: sp_spaceused equivalent in CE?
  - 4
    - User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails Yes, I did. The login to SQL Server works when I try to access the website using http:\\localhost\ but fails when I use IP Address. Appreciate your time. Thanks. KKos. Tag: sp_spaceused equivalent in CE?
  - 5
    - 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: sp_spaceused equivalent in CE?
  - 6
    - ExecuteNonQuery hangs in Timer event notification Is the problem solved then, or you you want to elaborate on the error message Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: sp_spaceused equivalent in CE?
  - 7
    - 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: sp_spaceused equivalent in CE?
  - 8
    - Combine two stored procedure results if you are stuck with the stored procedure as-is, then your idea is the best one. Unless the proc is extremely complex (and with a name like getdata, it is not going to be easy for us to guess :) then building a database for queries that span databases is a better idea and union the results together. Or consider the ideas that Adam has given also. I would consider not having databases with the year in the name, and just have one database that spans years, personally. That is clearly the most solid answer and will make your reporting easier. If this wasis a performance idea, there are ways to make this work far better than with multiple databases. And if both databases are on the same drive, you are possibly not saving much... Tag: sp_spaceused equivalent in CE?
  - 9
    - soap message exchange between .NET Webservice and stored procedure hi, i would like to send informations from a CLR stored proc to a .NET web-service and get some back. ist it possible pamelia Tag: sp_spaceused equivalent in CE?
  - 10
    - Shared Connections and Stored Credentials for Subscriptions? Hi Jarret, I didn't reaaly explain very clearly. I have used a Shared Connection (for the obvious maintenance advantages), with integrated Windows security, from the start and everything worked perfectly until I needed to create subscriptions for some of the reports. As I am sure you know, you must store credentails on the server to do this. Again, for ease of maintenance, I eleceted to store the ceredentials with the Shared Connection using the SQL Server Management studio to configure the Report Server. Even though I used the same login details, all reports failed on security grounds and the same happened when trying to create subscriptions. Naturally I checked and double checked that the user name and password were correct. About the only option I didn't try was to simply tell it to use Windows security, which means not actually storing the credntials on the server. While this seems a bit of a contradiction, I guess the oprion is there for a reason and I presume that it allows subscriptions to use Windows secuirty without actually storing credentials on the server. This seems to be a circular argument I must say. Reading between the lines, the whole "store credentials securely on the server" feature is to avoid embedding the user name and password (in plain text) in the connection string so I guess one work around is to do just that. Dick Campbell Tag: sp_spaceused equivalent in CE?
  - 11
    - 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: sp_spaceused equivalent in CE?
  - 12
    - Data Flow Task Stuck No, they are not pointing to the same database, and I have tried independent data flows with the same results. Tag: sp_spaceused equivalent in CE?
  - 13
    - 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: sp_spaceused equivalent in CE?
  - 14
    - Delete row where a particular field value is not in a list create table mytable(filename varchar(20)) insert into mytable(filename) values('FileName.doc') insert into mytable(filename) values('FileName.txt') insert into mytable(filename) values('FileName.foo') create table allowed(ext varchar(8)) insert into allowed(ext) select '.txt' union all select '.pdf' union all select '.rtf' union all select '.doc' union all select '.htm' union all select '.html' union all select '.mht' union all select '.mhtml' -- etc delete from mytable where not exists(select * from allowed where filename like '%'+ext) Tag: sp_spaceused equivalent in CE?
  - 15
    - 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: sp_spaceused equivalent in CE?
  - 16
    - Does fragmentation changes after backup/restore operation? And i hope it's same for tranferring .mdf file to be attached later Tag: sp_spaceused equivalent in CE?
- Next
  - 1
    - Wat's the effective way to improve performance in table using indexing? I see. What if I do index partitioning on it as well The purpose of this transaction is table is to keep track all the transaction made by the users daily and able to use for reporting. (Total for daily,monthly and yearly report). Therefore, it needs to be available in the longer lifetime. Thx. From, Hans Tag: sp_spaceused equivalent in CE?
  - 2
    - How to verify installed license Don't know if you had better luck with that... but with the patches I've been using, I still get Disabled and NULL for license information. Following this http://support.microsoft.com/default.aspx scid=kb;en-us;291332 however, does correctly direct me to the SQL 2000 Licensing Setup applet in control panel, which WILL display what is currently being used. (Now, all my instances are running on the default instance... not certain what you will get back if you have something other than the default instance.) Tag: sp_spaceused equivalent in CE?
  - 3
    - How to rename a column or table on the desktop? I have published an article on this subject that you can adapt to the desktop: Renaming a SQL CE Table From a .NET CF Application Although some of my products do that (I am affiliated to that company ), you don't have to purchase one just to rename a table or column name. The code I published on that article can be easily adapted to the desktop. If you have problems with it, just let me know. Tag: sp_spaceused equivalent in CE?
  - 4
    - CAB Files 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 Tag: sp_spaceused equivalent in CE?
  - 5
    - Executing an SSIS package containing Analysis Services from ASP.NET Tag: sp_spaceused equivalent in CE?
  - 6
    - Upgrade SQL 2005 Standard to SQL 2005 Enterprise Michael, Just one more question, Can this be done by just executing the setup.exe on the cd and selecting the instance I want to upgrade correct Andy Tag: sp_spaceused equivalent in CE?
  - 7
    - SQL Reporting Services performance on navigation pages. Teo, Thanks for this response, it sends me in a direction I had not yet been. I now see that the SessionTimeout setting is set to 600 (10 minutes). is it OK to simply change that setting in the table I would have assumed there might be a better utility or something that would handle that. I saw another post that discussed some of this and it implied that the setting could be changed via an API or even the rs.exe utility. I also thought it referenced the SessionTimeout in th RSReportserver.config file, but I don't see it there. perhaps it can be added to override the default I'm not sure that this is even what I really want to do. My issue is not that a given report takes too long, but that it takes way too long to build the navigation pages the first time and I don't see any reference to that in the ExecutionLog Table. I'm not clear on what all is occuring during this build phase that should take that long. I'm on a pretty fast/solid network so it really shouldn't. don't know if you or anyone can shed any light on that for me. bottomline is that my users want to be able to get to the reports on demand and I don't want them to have to wait for the navigation pages. ray Tag: sp_spaceused equivalent in CE?
  - 8
    - Determine if a column is indexed (and the index name) Brilliant. Thanks. Was not aware of sys.index_columns. Any cute tricks for the equivalent query on SS 2K Tag: sp_spaceused equivalent in CE?
  - 9
    - Personalize Reports for Each User Thanks for the reply!!! I am still not sure where to use this field. My question again is: When a user login to Reporting Services, he/she has to enter a domain UserName and domain Password. I want to know if it is possible to grab that userName and use it as a default value for my parameter. Thanks again, -Rohit Tag: sp_spaceused equivalent in CE?
  - 10
    - 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: sp_spaceused equivalent in CE?
  - 11
    - HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005 Unfortunately - it does not seem to control deletion of the backup files! It cleans out information from Datebase logs - but that is not really the problem. At least from what we see - it does not delte the older files. We have a cleanup running but older files do not go away. Bob Tag: sp_spaceused equivalent in CE?
  - 12
    - Embedded image does not appear Hello, What version of Reporting Services are you running Have you applied the latest service pack If you go to http://<server>/ReportServer and look in the bottom right you will see the version number. Also, are both images embedded Are they both the same image type (gif, jpg, etc.) Are either of them scaled Is the sizing option on both set the same Try building a new blank report and embedding both images using the wizard defaults. Does it work then Larry Tag: sp_spaceused equivalent in CE?
  - 13
    - can't (re)start SQLServerAgent after changing its logon credentials You can verify the permissions, windows group membership required, etc for the service accounts in the following books online topic: Setting Up Windows Service Accounts http://msdn2.microsoft.com/en-us/library/ms143504.aspx The NT Rights and Privleges section has the local windows group membership requirements - that one often gets overlooked for some reason. The help topic is pretty thorough and does a good job of covering the requirements. Also note that as the article states, using Network Service isn't recommended. A domain account can provide the same network access but in a more secure manner. Otherwise you open some holes - network service means you give permissions needed for the CDW to the machine account. And then other apps, services running under network service get the permissions as well as they would be operating under the machine account. -Sue Tag: sp_spaceused equivalent in CE?
  - 14
    - I have a VB script that works in WinXP sp1 but not in WinXp sp2 Hi admin, this post is not in a good forum so please delete it for me. thanks, mahsina Tag: sp_spaceused equivalent in CE?
  - 15
    - Correlated subquery in UPDATE - Where am I going wrong? Thanks Geert, I'll give that a try. Basically it's purpose is to fill in blanks on Table1 from info on Table2... Table1 is populated from a different source to Table2 and this query basically runs through and updates Table1. Actually, I'm not sure your suggestion will work - the select statement using the TOP 1 clause is not going to return the top row from a selection limited by the COL_C value of Table1. Am I making sense Tag: sp_spaceused equivalent in CE?
  - 16
    - Inconsistent OLE DB Failure when running SSIS packages Thanks for responding, I checked the patch level and we are up to date (2153) I will try inserting a diagnostic step to output the connection string. Re the method of accessing the source, the problem has been with the destination connections, would this still apply Tag: sp_spaceused equivalent in CE?

stu6008

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.

Top

Re: sp_spaceused equivalent in CE?

ErikEJ

sp_spaceused is not available in SQL Compact. You may find this useful: http://support.microsoft.com/kb/827968/en-us

Top

Re: sp_spaceused equivalent in CE?

stu6008

Thanks for the info. I am also considering using something like Sum(Len(MyNvarcharField)) to get a closer approximation of the variable length data (of which there are several). I don't really have a good percentage to estimate actual data vs. column max length. Expensive, but needs to run only a couple times a day to monitor size.

Top