Answer Questions

• allison_h Tracking table changes on SQL server ce without using RDA?

  Hi, Can anybody let me know if there are ways to programatically track changes made to a SQL SERVER CE table I am writing a db monitoring tool on SQL server CE which should track any changes made to the table.(Insert update and delete) We could have done this using triggers on Sql Server 2005. Since triggers are not supported on SQL Server CE, are there any alternate ways to achieve this functionality Regards, Ananth Have you considered merge replication, which does exactly that for you. If that is not an option, then you would have to implement this manually through your Data Access Layer code, as there are no other ways to do this (other than merge replication/rda) ...Show All

• ethos71 "Error converting data type nvarchar to real" using LIKE operator on CHAR column

  View1 has a CHAR column of CharCol1. While using LIKE operator on this column, I receive below error. Select * from View1 Where CharCol1 Like '%77%' Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to real. But all of below syntax works: Select * from View1 Where CharCol1 like N '%77%' Select * from View1 Where CharCol1 Like '77' Select * from View1 Where CharCol1 = '77' Why does SQL 2005 treat '%77%' as real This used to be working in SQL 2000.     It works for me in SQL 2005. Are you sure your view's CharCol1 is really a character column, and hasn't been casted as real Actually the view was being used in SQL 2000 ...Show All

• ckob database owner is needed

  hi, on 1 of my servers (actually, the dev. server I have setup up here at home), I must included the database owner everytime I select something or make a db call. for example select T.foo from K inner join T on T.id = K.id must actualy be written like: select dbo.T.foo from dbo.K inner join dbo.T on dbo.T.id = dbo.K.id or else it wont work what did I do wrong for this database owner thing to be a "must" when writing queries on this server. spec: sql 2000 sp4 > What do you get on the server that requires dbo. when you execute: >select suser_sname(), user_name() | ______________|__________ | foouser | foouser >select * >from sysobjects >where name = '<name>' ...Show All

• Residual Logic Games Installing Developer Edition Management Studio

  I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas Hello Joe, Could you please let us know what error you are getting while installing Dev edition This will help in narrowing down the cause so that we can resolve it quickly. Regards, Rajesh Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine. Thanks anyhow. ...Show All

• donkaiser NoLock vs ReadPast

  I have been experiencing deadlock errors with two stored procs that I am using. SP1 is a read query that gets all unprocessed orders (status = 0) SP2 is an insert query that inserts new orders (Status = 0) uses a transaction. I have a multithreaded application and once in a while the read query (SP1) will try to read a new row that has just been inserted but not committed yet hence the deadlock arises. If i use a hint "With(NoLocks)" this will be a dirty read and still read the uncommitted insert from SP2 - is this correct Where as if I use hint "With(ReadPast)" this will now only read committed rows and hence the deadlock should not arise - it will not read any uncommitted rows - Correct So I think th ...Show All

• Cammyr The fastest way to stop SQL Server 2000 without admin permissions... (Bug)

    Do You want to stop the SQL Server service without admin permissions Use this Code : CREATE TABLE [dbo].[stop_service] (  [NUMBER] [int] NULL , ) ON [PRIMARY] GO INSERT [dbo].[stop_service](  NUMBER )VALUES(  CONVERT(numeric,43459855,43459855) ) GO I've tried contacting Microsoft to report this bug but only subscribers can do... Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file... Does anybody know how to submit this error Btw, for now the workaround is to use the correct syntax / parameters for CONVERT function like: INSERT [dbo].[stop_service]( [NUMBER] )VALUES( CONVERT(numeric,43459855) ) A ...Show All

• Nadav Popplewell permissions issue with http driven report in web iframe

  Hi there, I need to understand why I am getting the following error when I run my deployed (remote) report embedded in an iframe within a page of my web application. error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'cnMOOR'. (rsErrorExecutingCommand)For more information about this error navigate to the report server on the local server machine, or enable remote error This happens when I fire the following code from a commandbutton: AppSettingsReader cfgApp = new AppSettingsReader(); string prefix = Convert.ToString(cfgApp.GetValue("reporturlprefix", typeof(System.String))); string reporturl = prefix + "Client&rs:Command=Render&rs:Format=HTML4. ...Show All

• Deeps_123 BUILTIN\Administrators vs System Administrator

  Hello all, does someone know where to find information regarding what is accesible to a BUILTIN\Administrator which is not accesible to a System Administrator Somewhere I have read that a System Administrator can not see the "All users' folders (i.e. the collection of "My folder"s for all users of the Report Server) but I have also experienced a behaviour which has surprised me: as a System Administrator with all permissions I cann't even see folders that a BUILTIN\Administrator can. Does it mean that a System Administrator can not really manage all the resources of a Report Server Any ideas will be welcomed. Many thanks. Firstly I would like to ask from where you have ...Show All

• DuncanP Loading XML Data into Relational Tables from XML Datatype column

  This may seem like a redundant exercise, but in SSIS I am loading a single table with XML files into an XML Datatype column.  I have already successfully loaded the file directly into relational tables using the XML Source and SQL Server destination.  But during the transformations, we clean the data and if there are research questions, we have to go back to the original XML data file and search on it.  I want to store this file in the database as well to facilitate easier searching. With this approach I'm hoping to accomplish a few goals: 1) Reduce the size of storage, assuming the SQL Datatype column will compress the data making it smaller than the original file.  Then I can take the original file and store it ...Show All

• captainsina table name too long via ODBC

  Hi, I am traing to execute this select SELECT count(*) CM_CERT_VARIANCE_DET_APINV_RELATE using SQL SERVER ODBC, however, I received this message: "Identifer too long" Is there any table length name limitation I think, there is, because works well on SQL environment. I mean, should this table have less then 18 characters Can I work around this limitation cheers, Alessandro hello alex, if you are using sql server 2005 you may use synonyms for more information please consult BOL or see my blogs reagrds, joey Hi Rob, Doesn't work SELECT COUNT(*) FROM [CM_CERT_VARIANCE_DET_APINV_RELATE] OR SELECT COUNT(*) FROM CM_CERT_VARIANCE_DET_APINV_RELA ...Show All

• Daemoniorum configure Defaultmaxbuffersize and DefaultmaxbufferRows

  i want to improve the performance of my ssis...im left with last 3 bottleneks...3 huge tables ...here are the details : table 1 :rows : 40 million + size of each row..1 -2 KB i had set the default max buffer to the max..100 MB and default max buffer rows to 100,000 ... considering that average row size is 1 kb. table 2: rows :17 million row size : 280 bytes again i have set the max buffer to 100 MB and default max buffer row to 300,000 .applyin the same logic.. table 3 rows: 59 million size per row : 85 bytes.. as the row size was small...i made default max buffer row to 1000000 that'll still be less than 100 mb..which i had set as default max buffer size.... the first 2 have given a considerable sp ...Show All

• _Michael_ Newbie Trying to connect to Adventure Works db on local desktop

  All, I'm running Windows Xp Pro With SQL 2005 Dev edition with Adventure Works sample db installed. I am the local administrator on my desktop, the services are up and running and I specified local connections only since this is the DEV edition of SQL05. When I try either one of these connection strings: Data source=(SQLDEV05); initial catalog=AdventureWorks or Data source=(local); initial catalog=AdventureWorks. I receive this error message: TITLE: Microsoft Report Designer ----------------------------- A connection cannot be made to the database. Set and test the connection string. ---------------------------- ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When conn ...Show All

• JDAnthony Foreach endless loop

  I'm having a problem where I'm using a Execute SQL Task to retrieve a dataset and storing that in an object variable. Then on success of that execute sql task I use a foreach loop task to go through the dataset and do 2 tasks inside the foreach loop. When I execute this package I have ~12 records in the dataset however when I get to the foreach loop in the 2nd iteration it keeps repeating it. It acts like it is stuck on the second record (tuple) and never goes on. I'm using an ForEach ADO Enumerator in the foreach. I've even set a breakpoint on each iteration and no task fails in side the foreach loop. I'm completely perplexed why it will iterate to the 2nd record but get stuck there in an endless loop. I've tried this on 2 different compu ...Show All

• The_Nod Time dimension

  Dear All, I have created a Time Dimension using the Date Wizard in Analysis Services (in ROLAP storage mode). Now I would like to "export" it into SQL Server 2005 database relational tables and manipulate the relational tables such as generate a surrogate key etc. How do I do this TIA, John The Schema Generation Wizard (launched from the Database->Generate relational Schema... menu) will generate tables in the DSV and in the relational data source so there should be no need for a seperate "export/transfer". If you follow the steps I outlined, I believe you'll get what you're looking for. For more information look in SQL Server 2005 Books OnLine under SQL Server Analysis Services (SSA ...Show All

• Joel McCormick prblem with turkish I in SQL Query

  Dear all, i am using SQL server for turkish language and i have a problem with turkish character "i". Whenever "i" comes in any word of query it gives wrong result. It also not able to recognize the small and capital "i" of turkish. can anybody help me in this regard Double: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=801811&SiteID=1 ...Show All