Answer Questions

• mAh3u Newbie trying to get specific data from an SSE Database

  It was suggested to me to try and post this here in the sql express forum. I am trying to query a specific field from my sse database based on two different variables. And use this information to fill a textbox with an integer. The first variable is a combobox that is filled with data in one of the other tables in the sse database. This table has a PKcolumn that is an integer and the identity of the column. The only other column is a n ...Show All

• Laxmikant D. Passing parameter to a dts

  I don't understand how to pass a parameter to a dts package from another. In SQL 2000 you can map a variable with a variable of the package you will call. How can I do this For example in the current package execution (package1) I have a variable1 = 5 and when some step complete I call package2 with the value of variable1 in variable2 of package2. I need help with this. Thanks in advance.   KirkHa ...Show All

• Fady El-Rukby Web App Failover problem

  Hi, I have successfully set-up a DB mirroring. When the pricipal goes down, the mirror picksup and the other way around too. So the mirroring part is working great. However, when I use my web applicaiton (dot net 2.0), it is not able to connect to Mirror server . I get the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that und ...Show All

• jcwc888 SQL Sever 2005 only has client side?

  Why I couldn't find any datebase engine setup SQL Server 2005 Developer Windows xp It shows succeeded but the thing is when I try SQL Server Configuration Manager---->SQL Server 2005 Services-->Nothing showed up No single items there. I have 15 G free space on that partition... I installed SQL server 2005 Developer E ...Show All

• Edcase_70 Sequencial Desgin Limitation on DataFlow Task?

  Sequencial Desgin Limitation on DataFlow Task Inside dataflow task, is seems like it is sequencial only, there is no constraint definable there, only data view definition allowed on the path. which means I cannot achieve this: One file source, if one data field is in value-a, I want to dump it to Table-A, if the data field is in value-b, I want to dump it to table-B by using two SQL server destination. Is my understanding correct The only way ...Show All

• bt7403 Will ROW_NUMBER ( ) keep the provided order of records if the OVER clause orders on the same value?

  In the code example below, I am trying to store the user-provided sort order for a set of record ID's passed to me by the application.  Since I am Ordering by the ResultSetID, which is always 42 in this example, is it guarenteed that the passed in order of ListingID's will be maintained by the ROW_NUMBER() function --Code Starts Here Declare @ResultSetID int , @ListingIDsXml XML Set @ResultSetID = 42 Set @ListingID ...Show All

• Grant Carthew sql server express loses ability to write to database

  After a period of use (typically 1-2 hours), an application using SQL Server Express stops writing to the database, whilst still continuing to read from it. As far as I can tell, no error message is generated by any operation. The application is written in VB Express and is executed on several machines, with SQL Server Express on a central machine. Re-starting the application on the affected machine restores normal operation. The problem ...Show All

• TMX How to allow remote connections to SQL Server 2005 Express database

  I've developed an asp.net 2.0 web app with vs 2005 and am using a SQL Server 2005 Express database. The app works fine locally, but after uploading to the remote web server the following error occures: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network ...Show All

• Morkz NullProcessing and Reference Dimensions

  Have a Measure group in a fact table. This fact table links to the project dimension and the time dimension. In the project dimension there are some additional dates like ProjectStartDate and ProjectDueDate. So I create a new time dimension for these dates. So for the Measure Group / Time (ProjectStartDate) combination, I define the dimension usage as a reference to the project dimension. But when I process I get som errors on ProjectStart ...Show All

• Ian M Please Help!!!

  I'm running Visual Studio 2005 (VB) with SQL 2005 installed. I tried to add a SQL database and it says SQL express is not installed. And here I was thinking that SQLexpress was only for VS express. I do not want to use that old crippled handicap SQL express database... how do I use the regular SQL database Thanks. Drae, if you are at all concerned about reaching the limits placed SQL Express, then yo ...Show All

• Vasil B VS.NET 2005 and CLR stored procedure permission sets.

  VS.NET 2005 automatically deploys a CLR stored procedure when you start a project with debugging. However, if the CLR stored procedure attempts to access external resources you will get a message stating: System . Security . SecurityException : Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed . I've isolated this to ...Show All

• worb How can i secure my MDF file?

  If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF How can i secure the .MDF so that no one can gain access to it hi, you can distribute the backup file(Password protected) of that database, and then restore using query. you can programticaly restore the database using OSQL EXE available in tools folder of microsoft sql server ...Show All

• Bob Rivers Drillthrough Functionality via Excel Add-in

  Hi, I'm using the Analysis Services Excel Add-In to query a Cube built with partitions. When using the drilldown functionality for my current\default partition the function seems to work fine. However, when I try to drilldown on data in the other partitions, the following error message appears: "Unable to Drillthrough on this Cell" Would someone please be able to shed some light on this Many Thanks Jonathan Derbyshire     ...Show All

• Ted Glaza SQLCMD "-r" option

  OK, so I'm playing with SQLCMD and trying to get the "-r" option to work. According to BOL it's supposed to redirect error messages of severity level 17 or higher to the screen (stderr). Presumably this would be useful in situations where you're running a script with the "-o" option, so that output would be sent to a file and error messages would be sent to the screen and not included in the output file. When I run it in the ...Show All

• hitesh T-Sql Preformance

  I have a Stored Procedure that I need to make run more efficiently. I am calling the SP from a page that displays the data as a report. I have tried to change the SQL to several queries into temp tables and selecting the data from the temp tables, but the page does not display any data. I then put all the queries together and the page works if it doesn't timeout. I realize the query below is not efficient but I am uncertain how to speed it up fu ...Show All