Answer Questions

• Brent Cray How to open sdf file(2.0) with sql server 2005 standard edition?

  I have an embedded pc which runs windows ce 4.2. I have created an amplication which use sdf file 2.0 version. So i want to copy this database into Desktop PC and open it with Sql Server 2005. Should i upgrade this database Will i have problems after upgrade Look here for information: http://msdn2.microsoft.com/en-us/library/ms173006.aspx Alternatively, you can open .sdf file in VS 2005 by selecting Fil ...Show All

• Ashoka Grouping in List Control

  Hi, I am new with RS2000. I am working on a Reporting application. I have some Application names on X-axis of a bar chart say they are 90 in number. I want to group this chart in a list control in such a way that in each portion the chart must contain 15 application names if suppose there are 90 application names. Add a (detail) group to the list with the following grouping expression: =Int((RowNumber(Nothing)-1)/15) This shou ...Show All

• Stephen XYZ Table load

  After working on this with no luck for a couple of days I am sick of pounding my head against a wall! I need help!! I am trying to load 3 flat files into one table and I am not sure how to do it using SSIS. I just need some guidence as to where to go. I can load 1 flat file into the table but 3 is the issue and combining the data so it is loaded in sequential rows. I have had it load, but it has been in three pieces one after the other. I am jus ...Show All

• Ken.Saraf divide by zero exception

  How I can rectify divide by zero exception in stored procedure i know it, but actually I want that display 0 or my error message instead of server error message. when i write Query like select 4/0 then it display error msg - 8134 but i don't wan't to display it, i want it as 0. i have too much table like apr0405i, aprs0506i similary as years wise table. So i create sp and passing '0405' value of parameter of sp which select ...Show All

• ammd cannot create database error in sql express 2005

  hi.. i have a pc that is on a domain with domain user rights and i installed a sql server express 2005.. when trying to create a new database am encountering an error: create database permission denied in database 'master' (microsoft sql server error:262) could anyone help how to go about this..am new to sql express. thanks what am trying to achieve here is that.. clients pc can use sql ...Show All

• santech79 DMX Query

  Hi, I am having a DMX Query as follows. SELECT [Englishproductname],( SELECT $TIME, [Profit], PredictVariance([Profit]) FROM PredictTimeSeries([Profit],5)) FROM [ProductSales_Forecast] It displays as English productname and the Expression as columns. The expression consists of time, profit as nested one. I need to have no nested queries. I want englishproductname to repeat for all the columns inside the expressions. I don't want to ...Show All

• Ekart Laszlo SQLNCLI.DLL can't find MSVCR80.dll at runtime

  I have written a C++ DLL that links against the SQLNCLI.LIB, which uses the SQLNCLI.DLL. When the runtime DLL loader attempts to find MSVCR80.DLL which SQLNCLI.DLL depends on it cannot find it unless it is in your system path somewhere. I thought this behavior was depricated with the release of VS 2005 and the C Runtime 8.0 Isn't this supposed to be loaded via a manifest file from within SQLNCLI.DLL If not is the proper solution to copy MSVCR80. ...Show All

• BryanCTG sql 2000 scripts

  How can i set something up so that a new sql script is generated on a regular basis for the tables, stored procedures This is because the tables, stored procedures change once a day. So that we can just run the generated scripts on the required sql servers. Thanks Red-Gate also offer a product called SQL Compare which will do all this for you: http://www.red-gate.com/index.htm Several of the companies I ...Show All

• myeager Stored Procedure runs but no records inserted

  I have just installed a fresh copy of SQL Server 2005 on a new server.  I transferred over one of my stored procs which has been working beautifully on another SQL Server 2005 server. This time though when it's run, It runs but doesn't insert anything into the destination table.  I recreated the tables that were on another server on this server by using the SQL query that you produce when  you do a Right-click | Script Table As ...Show All

• Raju_Sreenivasan Doesn't like a particular namespace

  Hi, Can someone try and replicate an error for me. Follow these steps: 1) Create a new package 2) Place a Sequence container in it 3) Create a variable called User::ContainerStartTime scoped to the package 4) Create a variable called User::ContainerStartTime scoped to the sequence container 5) Change the namespaces of the 2 variables from "User" to "Metadata" You get an error on step 5 saying another object in the collection already has that nam ...Show All

• Menko Downloads from the SSIS team

  Hi, Just a quick note for all that the SSIS team has started to post fresh content for download. We will be adding some links to various pages so you can easily see things when looking at the the SSIS portal on MSDN  http://msdn.microsoft.com/SQL/bi/integration/default.aspx For now if you search for "ssis" on the microsoft downloads site you will find the current content.  Sample Logging reports, jump start training, Meta Data in ...Show All

• Winnie123 How to FAIL package intentionally?

  I need to fail the package intentionally if Send EMail task executes. How can I do that I know there is a property FailPackageOnfailure, that fails the package on task's failure, but how can I fail the package on task's successful execution Thanks in advance How about setting an expression on ForceExecutionResult Setting 1 is failure. This works for me on tasks, success vs failure constraints are followed, ...Show All

• Tibor den Ouden BCP using SMO

   We have a SQLServer 2000 stored procedure, which imports data from files using SQL-DMO BulkCopy object(sp_OACreate is used to create the objects). We also use Format files to aide the import. Now, we are planning to convert this stored procedure to .NET application using Visual Studio 2005. Books Online says I have to use SMO Transfer object. But I could not find any information how to BulkCopy using this object. Any guidance in this ...Show All

• Triumph69 SQL Server Express default username and password

  Hi all, Can someone help me pls What is the default username and password for SQL Server 2005 Express I'm not able to login. I've tried username: sa, root password: <nothing>, <sa>, <root> all to no avail... Pls helppppp... Thanks. Also, by default the login server instance for SQL Server Express (if you didn't change it in the install) is <servername>\SQLEXPRESS or .\SQLEXPRESS.  This is a common confusion. ...Show All

• Arild Belsvik Using variables of Connection Manager, Connectionstring

  Hello, I'll spare everyone my diatribe about MS and Booksonline... I considered myself pretty good at Server 2000 DTS. It certainly has it's shortcomings, but there are a couple books on the market that helped a lot. I'm now trying to learn Integration Services, and not getting very far. There are two books out so far. one is poor, the other worthless. What I want to do seems very simple. That is to loop through a series of .txt file ...Show All