Answer Questions

• learnerplates SQL Server Compact Edition RC1 Released

  Dear Community, The SQL Server Compact Edition RC1 has been released and is now available at download center http://www.microsoft.com/downloads/details.aspx FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn’t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en We have blogged about it at http://blogs.msdn.com/sqlservereverywhere/ . Please check out the RC1 bits. Thanks Sachin, Program Manager, SQL Se ...Show All

• portect Simultaneous DB access

  I have C# Express and the SQL Express Management Studio CTP installed. So far, I've been forced to disconnect from the server in one app to connect to it in the other. I understand there is something around a 4 connection limit in SQLServer Express, so I don't see the problem. During one of these episodes, SQL Mgmt Studio hung while opening DB properties, then the SQLServer service couldn't be stopped. Now the DB can't be opened even after a reboot. Help Thanks. That answered my question. I am new at this and want to play by the rules. I was able to mark your response as 'helpful' but I didn't see where I could mark it as an 'answer'. Is 'helpful' the same as 'answer' If not, how do I mark your respons ...Show All

• geertdeprez Problem with creating new SQL server database in VWDExpress using SQL Server 2005 Express

  I have two problems on creating new SQL server database in Visual Web Developer 2005 Express using SQL server 2005 Express. The 1st problem: (It is resolved) After installed SQL Server 2005 express and Visual Web Developer 2005 Express. When I tried to create a SQL server database in VWD the following error occurred: "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/ linkId=49251" I was stuck with this problem for few days. I did several times of install/reinstall of VWPExpress and SQL server Express, made very sure following proper de-installation sequence as specified in t ...Show All

• LouisVanAlphen bulk load change in 2005?

  I have a dts package that does some bulk load operations without a problem in 2000. When trying to convert them to SISS or trying to run the same dts package against the a copy of the database (in 2000 mode) running on a 2005 server I get Bulk load data conversion errors (truncation) for row xxxx.... Has the bulk load process changed in 2005 My Sproc is using a bulk insert command with a fmt file.. CSS stands for Customer Service and Support. It used to be called PSS. Is there any way to relax those checks I was under the assumption that running a database in 2000 mode would allow backward compatibility. I am under a huge time crunch now, and at this point my only contingency plan i ...Show All

• BinFolder Is it safe to use volume mount points with SQL 2005?

  Hello, To implement the new SQL 2005, I plan to make the environment easy to manage. The environment should be simple to document and be automated via scripts. Therefore I plan to use mount points as described below. On a typical SQL server with multiple drives like C, D, E, F, G, H. Where each drive will have various folders to hold SQL code, data files, transaction log files, tempdb files, snapshot files, and other types of files. This typical environment is not pretty and is hard to write scripts for. So I plan to standardize on one standard directory structure via volume mount point. On all new SQL 2005 servers, we should see drive E as the one and only SQL Server directory. Other drives will be mounted to drive E as shown. ...Show All

• mhubel Accesing package Variable in Conditional Component

  Hello Experts, I am trying to load data to a sql table from flat file..I have a script component which will validate the data. I am also firing the errros when data validation fails. Once I encounter an error I want the whole package to be aborted. What I have done is declared a variable called errorcount (Scope :Package) and I am incrmenting this variable everytime an error is raised and next I have a Conditional Split which will check if this variable count is greater than 0 if yes I will not update the table.This is the only way I think this will work. error I am getting is :The collection of variables locked for read and write access is not available outside of PostExecute. I understand they r in the same data flow thats the r ...Show All

• maryz cannot create jobs on x64

  Hi all, Just installed sql 2005 x64 (DB Server + Client Tools incl. management tools) and encountered the following problems: 1) Could not create jobs Getting Error: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent. JobObjectKey '. (Microsoft.SqlServer.Smo) Tried several different job types always same result Installing SP1 does not help Any help is highly appreciated TIA Dan Check whether your MS Distributed Transaction Coordinator service is running or not. If not start the service. Please post this to the " SQL Server Tools General " forum. Thanks, Peter Saddow I get th ...Show All

• TrD bulk insert from text file

  I import a group of sentences INSERT from a text file .... test Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') Insert Into XXXXX Values('UUUUUU','3') The file contains 1000 insert (Aprox); I read lines for lines the file I make the insert In VS.NET 2003 it works correctly and the process consumes little memory but In VS.NET 2005 the pocket is without space. How I can specify the factor of growth of the database SQL Mobile How another thing can be happening I sorry for my inlges ... i speak spanish Thanks. ...Show All

• Sina Hakami HOW TO: Print a report directly to a printer

  The code below is a class file done in vb.net. The original idea came from reading this forum and some blogs. To use the code below, you can create a windows application or service. then create a class file and drop this code in it. Remeber to reference the 2005 report execution service and also in the program settings include the path to your server. IE: ReportExecutionService = http://localhost/ReportServer/ReportExecution2005.asmx or whatever your server URL is at. Setup the public properties for printername (sharenames work fine), Number of copies and Report name. That is all there is to it. This code is REALLY expandable to add more options. Please remember to let me kow if you like this. Imports System ...Show All

• George2 UPDATE Method

  I have a column of values in one table that needs to be updated based on an adjustment factor in another table. The table which contains the adjustment factors is built with the following column names. RangeBeg RangeEnd Factor The factor is determined depending on where the value falls in the range. I have been trying to do an sql script with no luck. Any Help would be appreciated. Thanks Hi, this could be something like (just guessing because we really need the DDL and some sample data to see how your actual design is working): UPDATE SomeTable SET SomeValue = ( SELECT SomeUpdateValue FROM AnotherTable AT WHERE ST.SomeRangeValue BETWEEN AT.RangeStarting AND AR.RangeEnding ) ...Show All

• Polarbear541 Database Mirroring - 'NT AUTHORITY\ANONYMOUS LOGON.' failed

  Hello, I have set up 3 servers - Primary, Mirror and Witness. When I run the database mirroring wizard all my endpoints are configured, but when i start the mirroring service i get a 1418 error - in the logs in says - Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 10.20.1.5] I have looked through the BOL and can't find anything helpful. - I'm pretty new to SQL server, so any help is very much appreciated! Thanks Kerpoise This is not a SQL problem but an authentication issue. The right approach is to follow the guidance ...Show All

• BalexH Running code in report (nationalizing reports)

  Is there a way for me to include code in a report that run independently of any control expression I want to nationalize the text in various text boxes: First Name: John Doe or Fornamn: John Doe Currently, my client are using CR, and name the text boxes in a special way so when the report "starts", they iterate over the controls on the form and call a DLL file to set the Value of the control based on language of the user (a parameter to the report). I understand that I can have expressions for each of these controls that calls embedded code or a custom assembly, but I have to write that expression *for each control*. I'd rather iterate over all controls and set the value centrally. Another options would be to dr ...Show All

• Supermatthew Problem appending to a raw file

  I have subscription records for five different magazine titles that i process by looping each one though a dataflow using a for-each loop. I am using the following instructions to append to the raw file: http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx This works fine when I pass four different magazine titles. when i try to run all of the titles(five), i get the following errors: [Raw File Destination [131195]] Warning: The parameter is incorrect. [DTS.Pipeline] Error: component "Raw File Destination" (131195) failed the pre-execute phase and returned error code 0x80070057. Any ideas Thanks. Frank I'm also left wondering what parameter the warning is talk ...Show All

• CBuilder Report Model Template

  HI, When I create a new Business Intelligence Projects, I can not find the "Report Model Project" template. I am not sure If I failed to install a few components ( client components). If this is the problem, how can I add these templates Thanks, RR I'm having the same problem. I've chosen to install all components and yet no Report Model Project Template. Is there somewhere we could download this template. I don't know if this makes a difference, but I have a licensed copy of Visual Studio 2005 on my computer. Thanks in advance for your advice. Ok. I've figured out what was wrong here. The Report Model template appears to be related to integration services and is not incl ...Show All

• ThunderRock Import Flat Files

  hi all i using SSIS to import flat files and i need support how can i import flat file from folder inculed many files and when finish start to next and next ..... if can i select from flat files to add condition like Select * from.....where ...... thanks Hosam Abd EL-Wahab wrote: hi all i using SSIS to import flat files and i need support how can i import flat file from folder inculed many files and when finish start to next and next ..... if can i select from flat files to add condition like Select * from.....where ...... thanks You can run a foreach loop in your control flow to loop over every file... No, you can't do a select * from flatfile where.... Howev ...Show All