System.Data.SqlServerCe

.NET Framework inside SQL Server

Index ‹ SQL Server

- Previous
  - 1
    - Calling Stored Procedure to get results into another stored procedure I have a complex stored procedure which in the end, has a select statement and returns a number of rows... such as: Select * from Temp_Table. I want to access these records in another stored procedure and do some maniulation on the rows, such as sum them or perform other calculations. How can I access these rows via a select statement or just insert them into a temp table in the 2nd stored procedure Thanks so much Tag: System.Data.SqlServerCe
  - 2
    - database change in batch update SQL script I used "OLE DB Command"(row by row) for update but because i found that very very slow i decided to try batch update. I check what is for insert and what is for update and those things that are for update i save to temp table. Then i run this: update [ODS].[dbo].[Adres] SET [MutatieDatumEinde] = stAdres.MutatieDatumEinde, [StraatNaam] = stAdres.StraatNaam, [HuisNummer] = stAdres.HuisNummer, [HuisNummerToevoeging] = stAdres.HuisNummerToevoeging, [Postkode] = stAdres.Postkode, [Plaats] = stAdres.Plaats, [Land] = stAdres.Land, [IndicatiePTTAdresStandaard] = stAdres.IndicatiePTTAdresStandaard, [KodeHerkomstAdres] = stAdres.KodeHerkomstAdres, [VervalDatum] = stAdres.VervalDatum, [BronODS] = stAdres.BronODS from [ODS].[dbo].[Adres] oAdres inner join [M2O_Stage].[dbo].[ODS_Adres] stAdres on oAdres.InstNr = stAdres.InstNr and oAdres.TypeAdres = stAdres.TypeAdres and oAdres.MutatieDatumAanvang = stAdres.MutatieDatumAanvang where stAdres.IsInsert = '0' I run this as an "execute sql task". Everything is running as it should and speed is incomparable, but.. i have problem to make this generic... what i mean is.. db names will change. How can i make db names dynamic here p.s. i just got idea .. i could probably make dynamic sql statement in script component and then run it there... but does anyone have a better idea Tag: System.Data.SqlServerCe
  - 3
    - Instead of insert trigger on table view with timestap column Do I have to use NULL for timestamp column in Instead of insert trigger on a table view. Here is what I am trying to do: --I have an employee table employee ( id int name varchar(30) Address varchar(30) timestamp (timestamp) ) --create view on employee table employeeview as select (id, name ,address, timestamp) from employee --I have to insert data in the basetable(employee) through the view --create instead of insert trigger on employeeView create trigger trig_insertView instead of insert as insert into employee select (id, name, address, null) from inserted Is it correct that I have to give value for timestamp column in the instead of insert trigger If no, then what do I have to do with timestamp column Thanks K Tag: System.Data.SqlServerCe
  - 4
    - Reusability & SSIS - issues they do not write in books about I have a simple requirement: Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID. Ok - I get that part about creating a custom task and so on for reusabilty. But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc. What is going to happen in that case Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version Tag: System.Data.SqlServerCe
  - 5
    - Black server reports after installing SP2 After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected. Has anyone else had this problem or suggest a solution Thanks in advance. Tag: System.Data.SqlServerCe
  - 6
    - The specified package could not be loaded from the SQL Server database Hi all, I have created a dts on my Sql server. which gets the data from my log file and insert into my sql 2005 table. In dts i am using 'Flat File Source' and 'SQL Server Destination'. When i execute this through 'SQL Server Business Intelligence Development Studio' it works good. But when i execute this through my c# code from my web server, it throws me an error 'The specified package could not be loaded from the SQL Server database.' This exception comes under app. LoadFromSqlServer. My C# Code : Application app = new Application (); Package package2 = app.LoadFromSqlServer( "\\Maintenance Plans\\FTPPackage" , "Server Name" , "UserName" , "Password" , null ); DTSExecResult result2 = package2.Execute(); string str = result2.ToString(); I hv tried package name like ' \\Maintenance Plans\\FTPPackage' and 'FTPPackage'. Plz help me to solve this... Thanks Harsh Tag: System.Data.SqlServerCe
  - 7
    - VS 2005 standard prevents using free SQL Express functionality? Hi, *relative newbie warning* I use Visual Studio Standard edition with the built-in version of SQL Server. Now I chose a new image catalogueing app, IDImager, that uses SQL Server Express to store photo info. The idea is that I can use the database also with my own code, or transfer the data to another app/database in the future if necessary. IDImager needs SQL Express with the 'connectivity components' installed using 'mixed mode'. This is their instruction page: http://www.idfoxx.com/support/idipro/install/ However, that option is not available in VS 2005 Standard and when I try to install these components with SQL Express I get the message that's not possible because VS 2005 restricts the install options. So far I gather that the free SQL Express gives one more options than my paid-for Visual Studio 2005 Standard edition, which seems a bit weird. Can anyone tell me how to work around this problem so I can install the IDImager app and use VS 2005 at the same time Thanks, Philip Tag: System.Data.SqlServerCe
  - 8
    - Joining mdx results All, I have two separate mdx queries I want to run. I need to be able to specify a date range for each using the range operator ":". The measures will be the same, just different date ranges specified. I want to take the results of each mdx query, and then join them together, so that I end up with a single result, but the measures from date range 1 in one column and the measures from date range 2 in another column. So I want the result to look something like the following: Measure Name Feb1-March1 June1-July31 Cost $55000 $65700 Quantity 7234 8245 Profit $25300 $31343 Let me know what you think the best way to implement this would be. I was thinking of using two separate mdx statements, and then joining them together in some way, but I haven't found a good way to do this. Please let me know if you have a good way to do this. Thanks. Tag: System.Data.SqlServerCe
  - 9
    - import data from excel data sheets Hello A problem with my replication system as occured. I have a working SQL server that can do replication trough internet, everyting works The problem is when I try to import large amount of data (10000 rows) to my database on the SQL server the subscriber on my client don't get the rows. That will say imported data is not being replicated. only rows that i have manually inserted will be replicated. I used the import wizard that came with SQL server. Is there a solution to this problem Tag: System.Data.SqlServerCe
  - 10
    - How to display column from Inserted table Hi all, I have created a trigger in SQLExpress which looking for any insertion to a specific table in a database: Create Trigger Tg_Insert on [tablename] FOR Insert AS Select * FROM Inserted --------------------------------------------------------- Assume there is nothing wrong with this trigger as I have already checked the output with Query tool. My question is how can I display the newly inserted data to the client In my case, Console application. I want to do something like Console.WriteLine("data from inserted table here"); How can I achieve this FYI, I'm using VS2005 with sqlexpress 2005. Thanks in advance. Regards, SHAH Tag: System.Data.SqlServerCe
  - 11
    - Last working day from last year! Dear Friends, How can I retrieve the last working day from the currentyear-1 Thanks Tag: System.Data.SqlServerCe
  - 12
    - Check data changes in table Hi all! I need to check data changes in some tables from specified date. Can it be done without triggers for each table SQL Server Management Studio always says "Data was changed" if another user updates data and you try to update old version. How it checks data modification date I found only this: USE [ScheduleDB] GO SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( '[dbo].[TTest]' ) AND type in ( 'U' ) but it can only show structure modification date. Tag: System.Data.SqlServerCe
  - 13
    - Get certain raw row from table Suppose I have a table with 100 records.. and I wantto get the 3rd record from that table. How can I do it Tag: System.Data.SqlServerCe
  - 14
    - SQL Server 2005 Service Pack 2 -- Now Available SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Tag: System.Data.SqlServerCe
  - 15
    - SQL task works running the package but not when called via C# This should be a very easy question. I'm trying to develop an SSIS package that will eventually do many things, but I can't get it to do very basic things. My current test package has 2 tasks in it: 1) File System Task ( FST ) 2) Execute SQL Task ( EST ) When running just the SSIS package via the VS2005 IDE ( as startup project ), everything works fine. The FST moves a file from DIR_A to DIR_B and the EST inserts a test record into the test table. If I set my C# app to the the startup project and execute the package from within the C#, it kinda works. The FST works fine, but the EST does not work and the package returns a "FAILURE" code to the C#. The EST is incredibly basic. This is the SQL text: insert into tmpssis ( tmpdata ) values ( 66 ); I'm using ADO.NET, Direct input, FALSE for IsQueryStoredProcedure, and it's using the only connection I've set up to the database. The FST block runs - the file gets moved, but then it fails on the SQL block for some reason. I'm open to any suggestions. Thanks, -BEP Tag: System.Data.SqlServerCe
  - 16
    - MDX throws error after server upgrade Hi all, I deployed the "Adventure Works DW Standard Edition" cubes on my machine and I wrote the following simple MDX : MDX 1 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany], [Product].[Category].&[1]) } on rows from [Adventure Works] The above MDX runs fine on my machine and gives me the output. The following version of SQL Server 2005 is installed on my machine : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition I tried running the same MDX on a server with the following configuration : Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Enterprise Edition . When I run this MDX I get the following error: "The Tuple function expects a tuple expression for the argument. A tuple set expression was used." I modified this MDX like this : MDX 2 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany] * [Product].[Category].&[1]) } on rows from [Adventure Works] The modified MDX runs fine on the server and gives the output. To summarize, MDX 1 and MDX 2 both run fine on my local machine and give me the same output whereas on the server with a higher build of SQL Server 2005, MDX 2 runs fine while MDX 1 fails with the error - "The Tuple function expects a tuple expression for the argument. A tuple set expression was used." I am unable to understand as to why this is happening Is this a compatibility issue which has been documented or is this a bug I request the community members to help me out. Thanks in advance, CodeKraker. Tag: System.Data.SqlServerCe
- Next
  - 1
    - Cant get Access Database Synchronizer set up on client machine I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation. His "Computer Name" as it's stated in his 'My Computer' properties is " PAVSGP024FE.NWFSC.NOAA.GOV " However his Access.MDW File is located in the directory "C:\Documents and Settings\ Joe Nobody \Application Data\Microsoft\Access\System.MDW". There is no directory called "C:\Documents and Settings\ PAVSGP024FE.NWFSC.NOAA.GOV \Application Data\Microsoft\Access\System.MDW". His current config.xml file looks like this. < xml version="1.0" encoding="UTF-8" > <SystemNode> <AccessDB>C:\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.mdb</AccessDB> <DeviceDB>\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.sdf</DeviceDB> <Login>Joe Nobody</Login> <URL>http://Joe Nobody:1024/</URL> <WinDir>C:\</WinDir> </SystemNode> He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http:// PAVSGP024FE.NWFSC.NOAA.GOV :1024/</URL> but this throws the error "The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]" I dont know what else to try! Anybody have any suggestions Tag: System.Data.SqlServerCe
  - 2
    - SQL Server slower after 2005 upgrade We have an extensive stress test for our OLTP application.that runs slower after upgrading to SQL Server 2005. We have done the following: - applied SP1 and SP2 - updated statistics (sp_updatestats) - recompiled all stored procedures Some behavior we notice in Perfmon over the course of the 1-hour test is: - Average CPU Utilization is up from 22% to 32% and we're trying to figure out why - Compilations per second are up from 200 to 250 - Recompilations per second are down from 5 to 1 (which is good). - Memory utilization is identical. - We see exagerated spikes in response times. The general performance seems pretty good - but there are periodic spikes that hurt our averages. - I examined perfmon for waits and nothing jumped out. - A small handful of application workflows are much slower, while most are roughly identical. I realize there could be a zillion different causes. But if anyone has experience upgrading a large OLTP solution which uses a mixture of dynamic SQL and stored procedures to SS2005 - and tuning the upgraded database - please offer any suggestions. Our current plan includes (a) running the Best Practices analyzer which already uncovered a trace flag we may want to use since we're running on an 8-way, (b) rebuilding indexes, and (c) examine a SQL Trace this time around too since it appears the slowness is isolated to certain application workflows. Please offer any suggestions that have worked for your team. Thanks so much! Mike PS I will post all the things we end up doing in the end once we get performance equal or better - hopefully the latter!!! Tag: System.Data.SqlServerCe
  - 3
    - Filtering on a part of a field - 3 Hello, new question about an old topic ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1232451&SiteID=1 ): I want to set a filter on a field, but the it must set a filter on a part of the field. I think it will be more clear with an example: I have a list with ItemNumbers and ItemDescriptions. ItemNo ItemDescription 1 Pineapple yellow 2 Cauliflower size 6 3 Orange sweet yellow etc. etc. Now I want that the user of this report can set a filter just by entering a part of the description. So, if he enters 'flower' he only see the cauliflower. If he enters 'yellow' he only see the pineapple and the orange, etc. etc. If a blank value is left, all the items must be shown. After this, Jarret, suggest to me to insert the next code into my query: where ItemDescription like '%' + @ItemDescParam + '%' This helped, but I want to have 2 options extra: 1) The part of the description which the user inserts must be independent of capitals 2) It also have to be possible that the user inserts more than one part. For example "pine" and "fellow" Can some one help me out Thx again Tag: System.Data.SqlServerCe
  - 4
    - Multi-user access through a data-access layer/remoting server Hi guys, I've been developing desktop client-server and web apps and have used Access and SQL Server Standard most of the time. I'm looking into using SQL CE, and had a few questions that I can't seem to get a clear picture on: - The documentation for CE says that it supports 256 simultaneous connections and offers the Isolation levels, Transactions, Locking, etc with a 4GB DB. But most people say that CE is strictly a single-user DB and should not be used as a DB Server. Could CE be extended for use as a multi-user DB Server by creating a custom server such as a .NET Remoting Server hosted through a Windows Service (or any other custom host) on a machine whereby the CE DB would run in-process with this server on the machine which would then be accessed by multiple users from multiple machines Clients PCs -> Server PC hosting Remoting Service -> ADO.NET -> SQL CE - and further more can we use Enterprise Services (Serviced Components) to connect to SQL CE and further extend this model to offer a pure high-quality DB Server Clients PCs -> Server PC hosting Remoting Service -> Enterprise Services -> ADO.NET -> SQL CE Seems quite doable to me, but I may be wrong..please let me know either ways Thanks, CP Tag: System.Data.SqlServerCe
  - 5
    - How To Connect From SQL Server Database To Another SQL Server Database I want to be able to access a table from another server for example using a stored procedure: I am in server A I want to do a select in a table (dbo.test) that is located on server b. so how can i connect to server b using windows authentication then access the table dbo.test thanks Tag: System.Data.SqlServerCe
  - 6
    - How to create Vertical Partioning Hi All, I setup a Transactional replication between SQL Server 2000 and SQL Server 2005 via wide area network . The intial snapshoot failed because run into problems on a table with column 379 columns. How do ceate Vertical Partioning a table on Publication Thank you. TJ_1 Tag: System.Data.SqlServerCe
  - 7
    - xp_smtp_sendmail My DTS program requires an email functionality. But I cant use xp_SendMail , its already configured to use for some other purposes. Then I came to knew about master.dbo.xp_smtp_sendmail, but my problem is its not executing (giving a procedure not found message). What may be the possible causes How can we able to rectify it Thanks in advance Tag: System.Data.SqlServerCe
  - 8
    - Error Message Text in Multi Languages Basically I am making ETL Project in which there is need to display Error Message in Multi Languages e.g.: US English, Japanese. User may have option to see Error Log Table in Japanese or US English, so I was working on it and found solution is below Sample Code, in which I’m checking same validation twice first for US English language and second for Japanese language. I feel it will take little bit extra time. Is there any better option to achieve this Please Help…….. SIMPLY COPY PASTE AND RUN SET NOCOUNT ON --> DECLARING @PhoneNumber TABLE VARIABLE HAVING PhoneNumber List DECLARE @PhoneNumber TABLE ( PhoneNumbebr NVARCHAR ( 7 )) --> INSERTING PhoneNumber List INTO it. --> Phone Number should be Integer Type. INSERT INTO @PhoneNumber VALUES ( '2766105' ) INSERT INTO @PhoneNumber VALUES ( '2766110' ) INSERT INTO @PhoneNumber VALUES ( '2766112' ) INSERT INTO @PhoneNumber VALUES ( '2710XYZ' ) --> Invalid Phone Number INSERT INTO @PhoneNumber VALUES ( '2766116' ) INSERT INTO @PhoneNumber VALUES ( 'ABC6105' ) --> Invalid Phone Number INSERT INTO @PhoneNumber VALUES ( '2766199' ) INSERT INTO @PhoneNumber VALUES ( '2766120' ) --> DECLARING @ErrorTable TABLE VARIABLE FOR STORING Error Messages in English and Japanese Lenguages. DECLARE @ErrorTable TABLE ( EnglishErrorText NVARCHAR ( 1000 ), JapaneseErrorText NVARCHAR ( 1000 )) --> DECLARING @DistinationTable TABLE VARIABLE WILL STORE VALIDATED Phone List. DECLARE @DistinationTable TABLE ( PhoneNumbebr INT ) --> DECLARING THE VARIABLES TO STORE THE VALUES RETURED BY FETCH DECLARE @PhoneNo NVARCHAR ( 50 ), @EnglishText NVARCHAR ( 1000 ), @JapaneseText NVARCHAR ( 1000 ) DECLARE MultiLanguageErrorCursor CURSOR FOR SELECT PhoneNumbebr FROM @PhoneNumber OPEN MultiLanguageErrorCursor /* PERFORM THE FIRST FETCH AND STORE THE VALUES IN VARIABLES. NOTE: THE VARIABLES ARE IN THE SAME ORDER AS THE COLUMNS IN THE SELECT STATEMENT. */ FETCH NEXT FROM MultiLanguageErrorCursor INTO @PhoneNo --> CHECK @@FETCH_STATUS TO SEE IF THERE ARE ANY MORE ROWS TO FETCH. WHILE @@FETCH_STATUS = 0 BEGIN --> INITILISATION OT VARIABLES SET @EnglishText = '' SET @JapaneseText = '' BEGIN TRY --> CHANGING LANGUAGE SETTING TO us_english SET LANGUAGE us_english INSERT INTO @DistinationTable SELECT CONVERT ( INT , @PhoneNo ) FETCH NEXT FROM MultiLanguageErrorCursor INTO @PhoneNo END TRY BEGIN CATCH SET @EnglishText = ERROR_MESSAGE () --> IT WILL RETURN English ERROR MESSAGE TEXT. --> CHANGING LANGUAGE SETTING TO Japanese TO GET ABOVE ERROR IN JAPANESE. SET LANGUAGE Japanese BEGIN TRY INSERT INTO @DistinationTable SELECT CONVERT ( INT , @PhoneNo ) END TRY BEGIN CATCH SET @JapaneseText = ERROR_MESSAGE () --> IT WILL RETURN Japanese ERROR MESSAGE TEXT. END CATCH /* RESETTING THE LANGUAGE TO us_english TO PREVENT FROM ERROR NO 16958: Could not complete cursor operation because the set options have changed since the cursor was declared. */ SET LANGUAGE us_english --> INSERTING ERROR MESSAGE TEXT INTO @ErrorTable TABLE VARIABLE. INSERT INTO @ErrorTable VALUES ( @EnglishText , @JapaneseText ) FETCH NEXT FROM MultiLanguageErrorCursor INTO @PhoneNo CONTINUE END CATCH ; END CLOSE MultiLanguageErrorCursor DEALLOCATE MultiLanguageErrorCursor SELECT * FROM @ErrorTable GO Tag: System.Data.SqlServerCe
  - 9
    - Copy Folders and Files to different location I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location. e.g., C:\MainFolder\Mar01 ==> Multiple files in Mar01 folder C:\MainFolder\Mar02 ==> Multiple files in Mar02 folder Does any one know the best way to do this in SSIS Thanks in advance. BC Tag: System.Data.SqlServerCe
  - 10
    - Permissions to view Stored Procedure Property My Production servers are SQL Server 2005 x64. I would like to allow my developers the ability to look at permissions on production stored procedures but not be able to change those permissions or alter the production code. What has to be set to allow this sort of security. Tag: System.Data.SqlServerCe
  - 11
    - data file blanks to nulls Hi, With DTS, the default behavior is to import blanks ("") in a data file as nulls in the table. However, in SSIS, the default behavior is to import blanks as blanks. I need to ensure that the packages I'm migrating import the data in the exact same way. I am wondering what is the easiest way to convert blanks to nulls Right now I'm using a script to convert the blanks to nulls before they are written to the table, but just wondering if there's an easier way. Thanks Tag: System.Data.SqlServerCe
  - 12
    - Send an email on non-fatal errors from Data Flow Ok, I'm incredibly new to all of this so please bear with me. I took the Integration Services tutorial, and that's pretty much all that I have done. I'm creating my first package and I want to be able to email myself when certain non-fatal conditions occur. I still want the entire row to flow into my table. My understanding is that this type of checking should be done in the "Data Flow" tab not the "Control Flow" tab. However, I can't see a toolbox item in "Data Flow" to create a SQL script like this. I can see that the "Lookup" toolbox item will allow me to write a SQL script but how do I get it to send out the email Or should I really be doing this type of checking in "Control Flow" where there is an "Send email task" item Any help is greatly appreciated! Thanks! Tag: System.Data.SqlServerCe
  - 13
    - Service Broker "TO service could not be found" Message origin: "Transport" I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin: "Transport". This is my activated stored procedure that is sending the message to the target service. I am using certificate security. Any help appreciated.... CREATE PROCEDURE [usp_ProcessMessage] AS BEGIN SET NOCOUNT ON ; DECLARE @conversation_handle uniqueidentifier DECLARE @message_body AS VARBINARY ( MAX ) WHILE ( 1 = 1 ) BEGIN BEGIN TRANSACTION ; WAITFOR ( RECEIVE TOP ( 1 ) @conversation_handle = conversation_handle , @message_body = message_body FROM [tcp://mydomain.com/INITIATE/MyQueue] ), TIMEOUT 1000 ; IF ( @@ROWCOUNT = 0 ) BEGIN COMMIT ; BREAK ; END END CONVERSATION @conversation_handle IF @message_body IS NOT NULL BEGIN BEGIN DIALOG CONVERSATION @conversation_handle FROM SERVICE [tcp://mydomain.com/INITIATE/MyService] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' ON CONTRACT [tcp://mydomain.com/INITIATE/MyMessage/v1.0] WITH ENCRYPTION = ON , LIFETIME = 600 ; SEND ON CONVERSATION @conversation_handle MESSAGE TYPE [tcp://mydomain.com/TARGET/VisitMessage] ( @message_body ); END COMMIT ; END END GO My endpoints are created like so: CREATE ENDPOINT MyEndpoint STATE = STARTED AS TCP ( LISTENER_PORT = 4022 ) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE MasterCertificate ) GO GRANT CONNECT TO CertOwner GRANT CONNECT ON ENDPOINT :: MyEndpoint TO CertOwner GO And my routes like so: GRANT SEND ON SERVICE :: [tcp://mydomain.com/INITIATE/MyService] TO CertOwner GO CREATE REMOTE SERVICE BINDING [MyCertificateBinding] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' WITH USER = CertOwner , ANONYMOUS = OFF CREATE ROUTE [tcp://mydomain.com/INITIATE/MyRoute] WITH SERVICE_NAME = '[tcp://mydomain.com/TARGET/MyService]' , BROKER_INSTANCE = N 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' , ADDRESS = N 'TCP://xxx.xx.xx.xx:4022' GO Tag: System.Data.SqlServerCe
  - 14
    - Distinct Count with Junk Dimension Attribute Hi, Suppose I have following Model Dimension which is formed based on Junk Dimension definition. JunkID ModelID ModelCode ModelTypeID ModelTypeCode ModelSpecificationID ModelSpecificationCode 50 50 BAO 2 FFCVT 2 F1C1 53 53 BGO 1 FFAT 1 FW4A4 55 55 NBO 3 FRAT 9 V4A5 60 60 NCO 3 FRAT 9 V5A5 97 55 NBO 3 FRAT 11 V4A5 99 53 BGO 1 FFAT 13 F4A4 And In Fact Table Suppose there is data as below... JunkID Amount 50 5210983 53 9576 55 7994 60 7872 97 4306 99 6519 Now my requirement is to make Distinct Count on ModelID. If I makes Distinct Count on DimModel.ModelID then it gives me 5 on every combination in Cube. If I make Distinct Count on FactTable.JunkID then it gives me 6 in places of 5 as above seen data. Please help, how can I make Distinct Count on ModelID in this situation Thanks in Advance Bhudev Tag: System.Data.SqlServerCe
  - 15
    - Trying to set output variable to row count result of SQL Execute Task I am building this as an expression, but it is not working. I am trying to return the row count into a variable to use later in an update statement. What am I doing wrong I am using a single row result set. I have one variable defined in my result set. I am receiving an error stating: Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow". Any help is appreciated! SELECT count(*) FROM hsi.itemdata a JOIN hsi.keyitem105 b on a.itemnum = b.itemnum JOIN hsi.keyitem106 c on a.itemnum = c.itemnum JOIN hsi.keyitem108 d on a.itemnum = d.itemnum WHERE a.itemtypegroupnum = 102 AND a.itemtypenum = 108 AND b.keyvaluechar = " + (DT_WSTR,2)@[User::Branch] + " AND c.keyvaluechar = " + (DT_WSTR,2)@[User: epartment] + " AND d.keyvaluesmall = " + (DT_WSTR,7)@[User::InvoiceNumber] + ") Tag: System.Data.SqlServerCe
  - 16
    - How can I set SO_TIMEOUT on the sockets used by the JDBC 2005 driver? Hello, One of our customers is experiencing a problem that makes me think there is a network problem, because we make a request and never return from the driver, but the transaction is still open on the server awaiting the next command (and holding locks blocking other processes). I see a number of other driver writers have described similar problems, and their "workaround" is to set SO_TIMEOUT on the sockets (setSoTimeout) they create which is a last defense so that the transaction won't block forever. I do not see this in the API documentation- how can I set this Many other drivers use a connection string parameter, do you offer the same Is there any logging I can enable that can show me for sure that the driver is waiting indefinately on socket.read (thats not terribly expensive) Thanks, Steve Tag: System.Data.SqlServerCe

ANGanley MCSD

Sorry being a little vague but if you can point me in the right direction.

I have just created a new VB – Windows Mobile 5.0 pocket PC – Device Application. (which will be connected to a PDA)

Do i have to use System.Data.SqlServerCe or System.Data.SqlClient to connect to my db.

Top

Re: System.Data.SqlServerCe

Jens K. Suessmeyer

That depends if you want to connect to a SQL Server mobile / Compact Database (then you will need the SQLServerCe namespace) or to a *big* SQL Server (then you will need the SqlClient namespace)

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---

Top