Answer Questions

• Ofer Gal Connectioni leak with MDAC 2.82

  Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousends). It is using the SQL ADO provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790). Is there a knwon bug like this Is there a way to trace the ADO provider Is Cancel method same as Close for the ADO Connect ...Show All

• Sridhar Paladugu DB Restoration Problem

  I am working on a site redesign which attaches to an MS SQL backend. The hosting company sent me a backup copy of the DB. I am trying to restore the db into my SQL Server but keep getting an error. I created an empty DB and then backed up that DB. I then replaced the .bak from my db with the .bak file he sent to me in a zip document. I then tried to do a DB restore through enterprise manager and recieved this error: Device activation error. T ...Show All

• gthkane SQL express ?

  I've been trying to figure out how to Auto Number my database entries in SQL Express and Automate certain parts of data entry for form entries in Visual Web Developer's SQL Express 2005 edition.  Could someone clue me in   Thanks in advance. DJ  I'm assuming, like me, you are coming from an MS Access world. I'm also assuming that you have set up a column to use for the identity field ...Show All

• Brenton House (MDX) EXISTING operator - inconsistent behaviour when using subcubes?

  I am getting what I think is inconsistent behaviour when using the EXISTING operator to obtain a set defined by the current query context... See the two queries below (explanation follows). WITH MEMBER [Measures].[MyDate] AS Tail ( EXISTING [Date].[Calendar].[Date], 1). item (0). membervalue SELECT {[Measures].[MyDate]} ON 0 FROM [Adventure Works] WHERE [Date].[Date].[October 26, 2002] ... returns [26-10-2002] ...Show All

• Thiago Silva Is it possiable to store password encrypted to an external config file?

  I got a problem when developing SSIS packages. For security reason, the sensitive information must be encrypted, and they should be configurable dynamically (by an ASP.NET application). so I tried several ways to achieve this, 1. use SSIS Package Configurations to generate an XML config file It's a convenient way to generate config file. but the passwords are not encrypted (or I don't know how). 2. use Variables and Property Expressions I ca ...Show All

• starnamer Cannot open a connection with SQL Server 2005 Developer Edition.

  I have installed on one computer Sql Server 2005 Developer Edition (CTP Version) together with a Visual Studio 2005 Beta Edition (July Version) and after configuration some properties by example the Network access, I had a lot of errors from the SQL Server Management Studio received(The most of them are a Connection timeout error but others errors too). In the same time I have made a test program to test the new SQL Server 2005 using DB Li ...Show All

• christiansoldier Report Builder - A filter is required

  Using Report Builder, I am querying a table that has: 85,000 rows 5 columns The report will run with only 4 of the columns, but when I add the 5th (data type is nvarchar(1024)), I get an error message that says: Cannot run this report. A filter must be specified. When I add a filter on that 5th column, it will run. Does anyone know if there is a record limit in Report Builder Is there some sort of governor that I can modify Thanks in ad ...Show All

• Ultrawhack System Configuration Checker

  My install of SQL keeps failing at the System Configuration Check stage, I currently have XP Home Edition installed on my PC, do I need to have XP Professional installed instead due to the fact that IIS can only be installed with XP Pro Hi David, There are a number of checks in SCC, not al of them mean you can install. Which one is failing SQL Express does run on Windows XP Home SP2, as long as you're a ...Show All

• hasmukhkp Import flat file automatically?

  Hi, I'm going to be getting several flat files that need to be imported into one of two tables. Although the text files will have different file names, they will have either "Header" or "Detail" in the file name, so I can tell which table they need to be imported into. The problem is I don't know enough about SQL Server 2005 to set up an automated import of these files into the database. Does anyone have any suggestions ...Show All

• Marts Joins with XQuery

  Hello, I have a very simple data table: CREATE TABLE [ALMPayloads]([ID] [int] NOT NULL,[OutputPayload] [xml] NOT NULL) with the following content: ID = 1 OutputPayload: <ReportDocument>   <ALMSimulationResult>     <selectedModelAssets>       <modelAsset ID="8bc798ae-cc15-4807-8805-61ecfc8f3c01" description="Global Bond" internationalCode="     &nbs ...Show All

• Matthew Hunter Reporting Servers - Export to Multiple tabs in Excel

  I need to create a Reporting Services report that contains multiple result sets.  I want each result set to export to a different tab in Excel.  I want to be able to name the tab.  I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet.  Is there a way to accomplish this task. Unfortunately no, you cannot control the sheet naming. ...Show All

• dklayman VB.net 2005 and SQL

  Hello, I'm relitively new to the VS.net 2005 platform and need to create an SQL database for my current project to work properly, but I keep being told that I can't access the SQL Server 2005 Express to create an database. Has anyone else had this problem, and how can I get around this Thanks N. Rawe No, this hasen't worked and it is the same error i am experiancing with MySQL as an alternative. For now i shall just use access to ...Show All

• Sommarafton Lookup Transform error when linking using a DT_R8

  I'm trying to lookup a value in another table linking on a column of datatype DT_R8.  The lookup transform is complaining that I can't link on that datatype.  However, the documentation says that it should work.  I'm using the April CTP.  Is this fixed in a later version   Any suggestions DT_R8 is not allowed as a join column. So are DT_R4 and BLOBs (DT_TEXT, DT_NTEXT, DT_IMAGE). ...Show All

• timg_msft Maintenance plan job unable to send Mail Alert

  Our configuration : SQL Server 2005 June CTP Enterprise Edition version : 9.00.1187.07 OS : Windows 2003   The Problem: After configuring Database Mail account and profile, maintenance plan or job generated with the maintenance plan Wizard is unable to send mail.   The SQL Agent error log contains those messages pointing on a bad profile name.   Error Messages [264] An attempt was made to send an email when no email session has be ...Show All

• Wentzel Cannot connect to Database in Server Management Studio

  I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below.  I am about to pull my hair out.  Everything was working fine for around 4 days and now everything just blows up.  I've tried using both sql authentification and also windows: Errors I'm getting (print screens): http: / / www. photopizzaz. biz/ junk/ sqlserver_ 2005_ errors_ ...Show All