How to rename a column or table on the desktop?

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails I'm looking at the call stack and don't see anything related to Integration Services. If this is general System.Data.SqlClient question, try appropriate forum as you may find better experts there. This forum is for SQL Integration Services. Links to .NET and SQL data access forums: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=45&SiteID=1 http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=87&SiteID=1 Tag: How to rename a column or table on the desktop?
  - 2
    - 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: How to rename a column or table on the desktop?
  - 3
    - 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: How to rename a column or table on the desktop?
  - 4
    - 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: How to rename a column or table on the desktop?
  - 5
    - 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: How to rename a column or table on the desktop?
  - 6
    - soap message exchange between .NET Webservice and stored procedure You call it like you would call it from a "normal" clr method (with one exception). 1. Create your web-service 2. Generate proxy-code against your web-service Code Snippet wsdl http://path_to_your_webservice.asmx 3. Include the proxy-code in your CLR proc project 4. Write your CLR proc(s) against the proxy code. 5. Compile your CLR proc assembly Here is now the difference/exception from if this had been "normal" CLR code. When executing against a web-service, the XmlSerializer will generate and load a dynamic assembly based on the proxy-code. Dynamic assembly loading is not allowed from inside SQLCLR. Therefore you have to pre-generate the assembly that would be dynamically created and loaded by using the sgen tool. 6. Run sgen against your compiled assembly from step 6 (assuming your proxy code is part of that assembly) with the /p switch. Code Snippet sgen your_assembly.dll /p 7. Now you can deploy the two assemblies (your SQLCLR assembly and the one generated from sgen) to the database. You have to depoy them with a PERMISSION_SET of EXTERNAL_ACCESS. 8. After having deployed the assemblies you can now create the usual T-SQL wrapper methods against your CLR code. 9. Execute!!!! Hope this helps! Niels Tag: How to rename a column or table on the desktop?
  - 7
    - Shared Connections and Stored Credentials for Subscriptions? In the properties properties for the RS project, there is a setting named OverwriteDataSources. Set this to False, and the data sources on the server won't be overwritten when you redeploy the reports. Tag: How to rename a column or table on the desktop?
  - 8
    - 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: How to rename a column or table on the desktop?
  - 9
    - Data Flow Task Stuck Corey M. wrote: When I try them sequentially, it works correctly every time. This is an acceptable workaround, but I am still curious to determine the reason for this strange behavio My guess is that it's an ODBC driver issue. Perhaps table locking or something like that. Who knows. You'll have to check for any known issues with the ODBC driver provider. Tag: How to rename a column or table on the desktop?
  - 10
    - 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: How to rename a column or table on the desktop?
  - 11
    - 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: How to rename a column or table on the desktop?
  - 12
    - 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: How to rename a column or table on the desktop?
  - 13
    - 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: How to rename a column or table on the desktop?
  - 14
    - 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: How to rename a column or table on the desktop?
  - 15
    - Wat's the effective way to improve performance in table using indexing? My approach would be to make transaction_date the clustered index and transaction_id a non clustered primary key. That should give the best performance for reading records by date as the data pages will be in the order you need them in. Depending on your queries using the Included Columns feature may give you want you want. You could create a non clustered index on the date and then include the amount in the index, this will put the amount into the index pages together with the date and remove the need to perform a second lookup from the non clustered index to the data pages to get the amount. So getting the totals by date will only need to read the index pages, which will be more compact (and so have a shallower tree) than the index pages as each row will only have the id, date and amount. If you have some natural partitions in the data, such as users then to query data within a year then it may be handy to use a horizontal partition. But I would look at tuning the indexes before partitioning. Make a copy of the table, change the indexes and run the same query against both tables with the "show actual execution plan" option turned on in SSMS. It will show what proportion of the total script's execution time each query takes. hope that helps, aaron Tag: How to rename a column or table on the desktop?
  - 16
    - 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: How to rename a column or table on the desktop?
- Next
  - 1
    - 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: How to rename a column or table on the desktop?
  - 2
    - Executing an SSIS package containing Analysis Services from ASP.NET blued555 wrote: Thanks for the reply. I have 2 machines, my web server and db server. After reading through the information in your link I think I need to clarify my security set up to check its definitely the 'double hop' problem. The identity that I'm impersonating is one created for this appication to use, not specific to the user. The identity has been created as a login on my db server and a user on the db I'm connecting to. This allows me to run an SSIS package containing stored procedures only. The AD user (identity) has been given access to the role required to run the Analysis Services Processing Task which is part of my SSIS package. Is this where the double hop is involved Passing the credentials from IIS to the Analysis Services Task Thanks for the clarification. Since you only have two machines involved, and the identity context is being created on the web server and not impersonated from the web user, I doubt that "double hopping" is your problem. The typical scenario for double hopping is when the web server impersonates the web user's identity and then tries to use that identity context to connect to a remote SQL Server (three machines, two hops). I suspect that either the impersonation is not working the way you expect or that the impersonated user does not have permission to do the SSAS processing. I recommend you test these scenarios by a) having your stored procedures log their user context to verify that impersonation is working, and b) log in to the SSIS machine with the user account in question and try to run the package directly to verify the user has permission. Tag: How to rename a column or table on the desktop?
  - 3
    - Upgrade SQL 2005 Standard to SQL 2005 Enterprise OK, I am little confused, I have two separate answers. One answer says I can just execute setup and select upgrade and the instance name, and yours says I need to run setup from the command prompt with the SKUUPGRADE flag. Which is the correct answer I have three named instances of SQL 2005 Standard I need to upgrade to SQL 2005 Enterprise. They are all currenlty at SP2 Tag: How to rename a column or table on the desktop?
  - 4
    - SQL Reporting Services performance on navigation pages. The SessionTimeOut parameter is definitely a remedy to the situation, but it doesn't really help in identifying why it would take so long even to load the first page of the Reports Manager. You asked if this was a report builder report, it is not, but even so, I don't have a problem recognizing that a given report might be slow depending on the database structure and volume of data. To the contrary, when I do actually run the report, it executes pretty fast. The link I referenced in my previous post points to an explanation linking the problem to the way that IIS starts it's process and it gives a possible solution to set up a call to the reportserver every few minutes, but that seems like a band-aid solution, albeit maybe the only real answer at this point. I have other applications using IIS and none of them has this issue. The pages load immediately, no matter how long it's been dormant. this leads me to believe that reporting Services has some background activity going on that requires more than meets the eye. I don't seem to be alone in this (other posts seem to have a similar issue) and maybe it's because there are 2 physical machines involved, maybe my setup has some flaw I'd be interested in hearing about users that don't experience this. thx, Ray Tag: How to rename a column or table on the desktop?
  - 5
    - 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: How to rename a column or table on the desktop?
  - 6
    - 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: How to rename a column or table on the desktop?
  - 7
    - 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: How to rename a column or table on the desktop?
  - 8
    - HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005 There's definately a bug in the Maintanance Plan Clean up task, it will not delete any files. Until they fix it we'll have to do it via a SQL command. Tag: How to rename a column or table on the desktop?
  - 9
    - Embedded image does not appear Hi Larry! Could you reproduce it Torsten Tag: How to rename a column or table on the desktop?
  - 10
    - 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: How to rename a column or table on the desktop?
  - 11
    - 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: How to rename a column or table on the desktop?
  - 12
    - Correlated subquery in UPDATE - Where am I going wrong? No, because the JOIN clause works the same as the WHERE clause so there is actually not much difference between them except for the time of filtering (JOIN occurs before the WHERE). But lets focus on the intention of the query because I think there need to be a better way. If I get it good, you want to set COL_A and COL_B to the values of table2 with the same value for COL_C and this only if COL_A is not filled in. What do you want if you have multiple values in table2 for one value in COL_C. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: How to rename a column or table on the desktop?
  - 13
    - Inconsistent OLE DB Failure when running SSIS packages Hi for other reasons I had to divide my packages up using seqence containers, since I did this there has been no recurrence of the problem. So the task which sets up my dynamic variables is in a seperate container from that which contains the tasks using the connections. Not 100% sure why this works but it seems to. Hope this helps Tag: How to rename a column or table on the desktop?
  - 14
    - Replicating Primary Key value onto the Foreign key value If you want to do it in a trigger, there is a different method to use. You would put the trigger on table1. Inside that insert trigger, you would use the virtual table named inserted which will contain a row for each row just inserted into table1, including the newly generated identity value for each row. If you post your table create staements, and a descripttion of what you want to do, we can likely help you in writing the trigger. Tag: How to rename a column or table on the desktop?
  - 15
    - 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: How to rename a column or table on the desktop?
  - 16
    - 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: How to rename a column or table on the desktop?

dreamfly

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

Top

Re: How to rename a column or table on the desktop?

ErikEJ

A 3rd party tool from this company may be able to help you, please contact the company (I am not affiliated): http://www.primeworks-mobile.com/

Top

Re: How to rename a column or table on the desktop?

Joao Paulo Figueira

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.

Top

Re: How to rename a column or table on the desktop?

dreamfly

Great tool! Instead of copying, MS should just buy your tool.

Top