Clarification on product specification

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - SP2 Upgrade Failure - 11032 - Unable to install Windows Installer MSP file SQL Server 2005 x64 Developer Edition Log output from the SP2 installation... ------------------------------------------------------------------------------------------------ Product : Database Services (MSSQLSERVER) Product Version (Previous): 2221 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 11032 Error Description : Unable to install Windows Installer MSP file ------------------------------------------------------------------------------------------------ The C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log file is a 5mb file that I can't make much sense out of...here are the first many lines of the file. I'll be glad to provide more information - just let me know what you need to know... Thanks, Dave === Verbose logging started: 8/15/2007 20:32:13 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: e:\47b31966cf7dcaa4e0fe0fa356ab34da\hotfix.exe === MSI (c) (D4:9C) [20:32:13:508]: Resetting cached policy values MSI (c) (D4:9C) [20:32:13:508]: Machine policy value 'Debug' is 0 MSI (c) (D4:9C) [20:32:13:508]: ******* RunEngine: ******* Product: {F14F2E25-99AF-42A9-977C-F6D0352DC59F} ******* Action: ******* CommandLine: ********** MSI (c) (D4:9C) [20:32:13:508]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (D4:9C) [20:32:13:508]: Grabbed execution mutex. MSI (c) (D4:9C) [20:32:13:508]: Cloaking enabled. MSI (c) (D4:9C) [20:32:13:508]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (D4:9C) [20:32:13:508]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (9C:BC) [20:32:13:539]: Grabbed execution mutex. MSI (s) (9C:FC) [20:32:13:539]: Resetting cached policy values MSI (s) (9C:FC) [20:32:13:539]: Machine policy value 'Debug' is 0 MSI (s) (9C:FC) [20:32:13:539]: ******* RunEngine: ******* Product: {F14F2E25-99AF-42A9-977C-F6D0352DC59F} ******* Action: ******* CommandLine: ********** MSI (s) (9C:FC) [20:32:13:539]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (9C:FC) [20:32:13:539]: Adding MSIINSTANCEGUID to command line. MSI (s) (9C:FC) [20:32:13:539]: End dialog not enabled MSI (s) (9C:FC) [20:32:13:539]: Original package ==> C:\WINDOWS\Installer\1f00a5.msi MSI (s) (9C:FC) [20:32:13:539]: Package we're running from ==> C:\WINDOWS\Installer\1f00a5.msi MSI (s) (9C:FC) [20:32:13:586]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F14F2E25-99AF-42A9-977C-F6D0352DC59F}'. MSI (s) (9C:FC) [20:32:13:586]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (9C:FC) [20:32:13:586]: Detected that this product uses a multiple instance transform. MSI (s) (9C:FC) [20:32:13:586]: MSCOREE not loaded loading copy from system32 MSI (s) (9C:FC) [20:32:13:586]: Applying multiple instance transform ' qlRun01.mst'... MSI (s) (9C:FC) [20:32:13:586]: Looking for storage transform: SqlRun01.mst MSI (s) (9C:FC) [20:32:13:586]: Validating transform 'SqlRun01.mst' with validation bits 0x809 MSI (s) (9C:FC) [20:32:13:586]: Transform 'SqlRun01.mst' is valid. MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2205 2: 3: Patch MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary. MSI (s) (9C:FC) [20:32:13:586]: TRANSFORM: Applying regular transform to database. MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Validation 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Signature 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: RegLocator 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: AppSearch 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: CompLocator 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: CustomAction 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Directory 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Registry 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: CreateFolder 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Icon 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 ... Tag: Clarification on product specification
  - 2
    - converting sql server 2005 data into xml format How to convert table in database, in microsoft sql server 2005 into xml format Tag: Clarification on product specification
  - 3
    - Problem with package.Execute passing variables I'm in the same position as Rafael here, but I do see that you can assign expressions to properties in the Bulk Insert Task... At least the GUI lets you use expressions for properties of the Bulk Insert task. Are you sure the variables are scoped correctly Have you captured the TableName variable in SSIS to ensure that you are getting the correct results I wouldn't think it would matter, but normally when I select a table from a drop down box, I get just the table name. When I selected a table in the Bulk Insert task, I got the fully qualified name for the table... Would that matter So, "database.dbo.table_name" is what showed up. Phil Tag: Clarification on product specification
  - 4
    - Conditional checks in SSIS. I think I might be getting what you guys are trying to convey. So here is what I did. I added a Sequence Container. 1. I added a Execute Sql Task to it which brings the GenderKey from Prod and puts it in a Variable using the following query .. SELECT [User::GenderKey_Prod] = ISNULL(MAX(GenderKey) ,0) FROM dbo.DIM_Gender 2. I added another Execute Sql Task which brings the GenderKey from Staging and puts it in another Variable using following query .. SELECT [User::GenderKey_Stg] = MIN(dg.GenderKey) FROM medical.Fact_Claim mfc INNER JOIN dbo.Dim_Patient dp ON dp.PatientKey = mfc.PatientKey INNER JOIN dbo.Dim_Gender dg ON dp.GenderKey = dg.GenderKey WHERE mfc.TaskID = I added the connector from Prod to Stg (1 -> 2). 3. Then added another data flow task (which will actually transfer the data). 4. And added a connector from STG to this data (2 -> 3) flow task and on this connector I defined the expression check @ [User::GenderKey_Prod] < @ [User::GenderKey_Stg] which if true, will execute the data flow task. All this makes sense, however, I am having troubles on step 2. Where condition task a parameter called TaskId, this parameter is a Package Level parameter I have added. I did the parameter mapping, but it keeps giving error on this step says 'Parameter Name is Unrecognized'. Can you see anything wrong that I have done in Step 2 while defining runtime parameters Tag: Clarification on product specification
  - 5
    - Checkboxes in Reporting Services? No problem, glad I could help. Jarret Tag: Clarification on product specification
  - 6
    - Navigation from the header Hello I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions Thanks Inder The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) Tag: Clarification on product specification
  - 7
    - Problems trying to insert data into the database using excel Hi all, I have encountered a problem. In the past i run a sql query to select all the data from the excel file and insert them into my SQL database. However recently i encountered an error when i run the query. Msg 7399, Level 16, State 1, Line 4 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 4 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls". How i solve this error. Any ideas Thanks Tag: Clarification on product specification
  - 8
    - tempdb Log file - stop/start SQL Server to reset tempdb??? The question was about the log size. Sorry I wasn't clear. I'm not sure why the tempdb needs a transaction log. Tag: Clarification on product specification
  - 9
    - Code to flatten a CellSet into a datatable Hi, Here's some code I've written which flattens a CellSet into a datatable. I looked for a long time to find similar code but could not find any. Can I please have some thoughts on optimisation/elegance etc... I'm a bit new to .NET so any advice would be great! Thanks. Code Snippet Public Function GetFlatData() As DataTable 'If (Me.Cells.Count = 1) Then ' Return New DataTable() 'End If Dim table As DataTable = New DataTable() Dim headers As ArrayList = New ArrayList() For a As Integer = 0 To (Me.Axes.Count - 1) For i As Integer = 0 To (Me.Axes(a).Set.Hierarchies.Count - 1) Dim h As Hierarchy = Me.Axes(a).Set.Hierarchies(i) If (Not h.Name.Contains("Measure")) Then table.Columns.Add(h.Name) End If Next i Next a Dim items As ArrayList = New ArrayList() For x As Int32 = 0 To (Me.Axes(0).Set.Tuples.Count - 1) Dim tx As Tuple = Me.Axes(0).Set.Tuples(x) Dim itemBase As CellItem = New CellItem() For Each mx As Member In tx.Members If (mx.LevelName.Contains("Measure")) Then If table.Columns.IndexOf(mx.Caption) = -1 Then table.Columns.Add(New DataColumn(mx.Caption, GetType(Double))) End If itemBase.AddMeasure(mx) Else itemBase.AddAttribute(mx) End If Next If (Me.Axes.Count > 1) Then For y As Int32 = 0 To (Me.Axes(1).Set.Tuples.Count - 1) Dim item As CellItem = itemBase.Clone(True) Dim ty As Tuple = Me.Axes(1).Set.Tuples(y) Dim memy As Member For Each memy In ty.Members If (memy.LevelName.Contains("Measure")) Then item.AddMeasure(memy) Else item.AddAttribute(memy) End If Next item.ValueCell = Me.Cells.Item((y * Me.Axes(0).Set.Tuples.Count) + x) 'item.ValueCell = Me.CellGrid(x, y) items.Add(item) Next Else ' for 1 axis cellsets itemBase.ValueCell = Me.Cells.Item(x) items.Add(itemBase) End If Next '' might have no measures need to cater For i As Integer = 0 To (items.Count - 1) Dim row As DataRow = table.NewRow() Dim attributes As ArrayList = (CType(items(i), CellItem)).Attributes For j As Integer = 0 To (attributes.Count - 1) Dim member As Member = CType(attributes(j), Member) row(j) = member.Caption Next Dim measures As ArrayList = (CType(items(i), CellItem)).Measures If Not measures Is Nothing Then ' each CellItem should only have one measure For j As Integer = 0 To (measures.Count - 1) Dim member As Member = CType(measures(j), Member) Dim value As Cell = (CType(items(i), CellItem)).ValueCell If Not (String.IsNullOrEmpty(value.Value)) Then 'need to set appropriate type accroding to cell 'table.Columns[member.Caption].DataType = value.CellProperties. row(member.Caption) = value.Value Else row(member.Caption) = DBNull.Value End If Next End If table.Rows.Add(row) Next Return table End Function #End Region #Region " Private Classes " Private Class CellItem Private _measures As ArrayList Private _attributes As ArrayList Private _valueCell As Cell Public Property Attributes() As ArrayList Get Return _attributes End Get Set(ByVal value As ArrayList) Me._attributes = value End Set End Property Public Property Measures() As ArrayList Get Return _measures End Get Set(ByVal value As ArrayList) Me._measures = value End Set End Property Public Property ValueCell() As Cell Get Return _valueCell End Get Set(ByVal Value As Cell) _valueCell = Value End Set End Property Public Sub New() _attributes = New ArrayList() _measures = New ArrayList() End Sub Public Sub New(ByVal attributes As ArrayList, ByVal measures As ArrayList, ByVal valueCell As Cell) Me.Attributes = attributes Me.Measures = measures Me.ValueCell = valueCell End Sub Public Sub AddAttribute(ByVal o As Object) _attributes.Add(o) End Sub Public Sub AddMeasure(ByVal o As Object) _measures.Add(o) End Sub Public Function Clone(ByVal isDeep As Boolean) As Object If (isDeep) Then Dim item As CellItem = New CellItem(Me.Attributes.Clone(), Me.Measures.Clone(), Me.ValueCell) Return item Else Return New CellItem(Me.Attributes, Me.Measures, Me.ValueCell) End If End Function Tag: Clarification on product specification
  - 10
    - LIKE HI,I want the synthaxe of a query with "LIKE" knowing that the fields must contain strings then a parametre then strings I tested with this synthaxe but it is not true: New_VilleExtensionBase.New_name LIKE ��%�� + @param1 + ��%�� How is that done Tag: Clarification on product specification
  - 11
    - How to specify the MSSQL.1 DATA folder in SQL Express? Thanks Andrea, I'll try to figure out how to do this during the install. Using SQLCMD.exe to execute the script where could I pick up the results Can I pipe it into a text file Tag: Clarification on product specification
  - 12
    - Is Full-Text Index really that much overhead? If you really NEED a full text index, then the way to go is probably SQL Server, instead of "inventing your own". You will never be able to match the speed of the full text index on SQL server, if the data you are indexing is on SQL server in the first place. How would you do it if not in SQL Server You would retrieve each field from SQL Server and search it on the web server. This is VERY process heavy. And I would assume you are doing it on your WEB/Cold Fusion server, which should not need as much processor, memory, etc as the SQL Server. With that said, the overhead is very high for a full text index. But if you need it, you will have overhead either way. Tag: Clarification on product specification
  - 13
    - Hourly Data Chris, What I currently have is: Cashier A: Hour :9 Total Transactions: 32 10 50 11 63 And so on. It would be nice if I could do this as follows: Day 1: Hour :9 Total Transactions: 32 10 50 11 63 Day 2: Hour :9 Total Transactions: 32 10 50 11 63 Only if it is possible. I am using this in a crystal report, so I can group inside the report, but don't know how to get the data over a longer period than 1 day. Thanks for the help Chris. Tag: Clarification on product specification
  - 14
    - What happens when the 4 GB database size limit is reached? hi, no, the database will stay available and not corrupted... you just will not be able to insert additional data... regards Tag: Clarification on product specification
  - 15
    - Can I debug a SQL 2005 stored procedure with the SA account I want to know if I can debug stored procedures remotely with the SA account. I can not have Active Directory in my system right now. Thanks Tag: Clarification on product specification
  - 16
    - What permission required to DROP TABLE ? Hi, I would execute the following query to allow a user to create table USE dbname GRANT CREATE TABLE TO username but it doesnt let me execute the following query GRANT DROP TABLE TO username I am wondering if there is a way to do this. I know db_ddladmin does that. But I dont want to assign the whole role or schema to do that. I want specific privilege According to SQL Server documentation, we need CONTROL permission to do this so I tried following query GRANT CONTROL TO username and GRANT CONTROL ON tablename TO username neither of them helped.. Please tell me what permission do I require to DROP a table. Thanks, Tag: Clarification on product specification
- Next
  - 1
    - SP to search on any number of characters I would like to know if someone would know how to write a Stored Procedure (using Select statement) to search on a partial word, for instance, like "micro", for Microsoft Office, Microsoft Communicator, etc. or an ordered number of characters, that are unique, like "obe", and will retrieve, ad"obe" or adobe. I'm using SQL 2005 and I'm running the search against a DB called platform_validation_tool and the table's name is dbo.software. The important column names that I want to retrieve this data on are Name(which would be the simple name like Microsoft Office Communicator) and software_package(which would be a Tivoli package name from the registry stored in this column with the name like "Microsoft_Office_Communicator_2005_XP2K_I8^1.0.0.0.5). I know you can use the clause WHERE NAME LIKE '%microsoft%' would retrieve all microsoft software packages. I'll assume you would have to setup parameters and concatenate them or something like that. Has or would anyone know how to accomplish this task Sincerely, Wallace Tag: Clarification on product specification
  - 2
    - Is there a way to parameterize lock type? Lois, Thanks for the recommendation. Unfortunately this is not what I am trying to achieve. I don't want to change isolation level - just to set a lock hint (see my other comment that describes why I want to do this). Tag: Clarification on product specification
  - 3
    - Conflicts in Merge Replication Hey, I don't think there is a way to specify the order under sql server 2005. Junhai Kan Tag: Clarification on product specification
  - 4
    - cluster install 2nd node unavailable Satya, I know the mentioned kb article. I'm not a newbe in installing sql server clusters, have done it a dozent times (x32) but never had troubles like this. At the beginning setupjob checks BOTH nodes for possible installation. All looks fine there! As mentioned already non of the logs (eventlog, clusterlog, sql inst. log) shows anything unusual or error (in my eyes). Prerequisits and pre installation steps are all done... The funny thing is installing a sql 2000 (x32) cluster would work (so there could nothing be wrong with the cluster inst.) Tag: Clarification on product specification
  - 5
    - Job interview question I have been asked by a person who is going to interview me to supply this informationl; ' Come prepared to be able to talk me through how to set up an SQL driven .NET website on a server. You are given a webroot folder containing root files such as the web.config and all the files for a .NET website and a data folder which contains an .mdf and .ldf files. Talk me through what each of these folders contain and what you would do with them in order to set up the website on a server such that you would be able to open a browser type the URL you have configured and visit that website.' I come from a Cisco background and no nothing about what she is asking. Is it unreasonable of me to expect to be able to gain this information in 2 days Can you tell me the best place to look for this knowledge Thanks for any help. Tag: Clarification on product specification
  - 6
    - Setting multi-value parameters using ReportExecutionService Does anyone know how to set multi-value parameters using ReportExecutionService in C# If I have rsExec = new ReportExecutionService2005. ReportExecutionService (); . . . ReportExecutionService2005. ParameterValue [] parameters = new ReportExecutionService2005. ParameterValue [2]; parameters[0] = new ReportExecutionService2005. ParameterValue (); parameters[0].Label = "Report_Begin_Date" ; parameters[0].Name = "Report_Begin_Date" ; parameters[0].Value = "4/15/2007" ; parameters[1] = new ReportExecutionService2005. ParameterValue (); parameters[1].Label = "SalesID" ; parameters[1].Name = "SalesID" ; parameters[1].Value = //Here, this parameter should accept multiple values like 200, 201, 202, etc. rsExec.SetExecutionParameters(parameters, "en-us" ); How would I set the SalesID to take multiple values Tag: Clarification on product specification
  - 7
    - Calculated Fields in the report Yes actually I got your point and now it works...Can you please see my previous post again I want to make sure I did the right thing.. Tag: Clarification on product specification
  - 8
    - Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000 hi Klaus, klaus_b wrote: Hi, in sql2005 express you can use the same connectionstrings like in all other sql2005 editions. The following i use in a webproject and it works very fine: <connectionStrings> <clear/> <add name= "Sup" connectionString= "Server=.\SQLEXPRESS;Database=Support;Trusted_Connection=True; Asynchronous Processing=True;MultipleActiveResultsets=True;" providerName="System.Data.SqlClient"/> ... </connectionStrings> AFAIK, "Asynchronous Processing" is not a valid nor recognized property, but "Async".. http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx The "Server=.\" means the local machine. Here you can say every name where you will connect to. The "SQLEXPRESS" is the instance of the sql Server installed on the machine. "Server=." means local machine, as "Server=(Local)" and the like... the slash is not included .. it's required when a named instance is involved, where the full name becames ComputerName\InstanceName (and/or all the variations of LocalComputer).. anyway all these properties, MARS included, do not provide actual speed benefit as "required" by Sasi.. sometimes MARS could be such a benefit but I usually doubt.. regards Tag: Clarification on product specification
  - 9
    - extract information from tables Hello Guys, my collegue left the job and I have been chosen to work on his assignments. He posted this question before and got the answer but I couldn't find a way to implement it in the program. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1726638&SiteID=1 I changed the database a bit as I couldn't understand his logic of putting both PayID and TransNo as this would be a linked table and should have many to many relationship Code Snippet TransactionID int Unchecked TransNo varchar(50) Checked RefNo nvarchar(50) Checked FundCodeID smallint Checked TransAmount decimal(18, 2) Checked Description varchar(100) Checked TransPayID (from TransPayLnk Table as foreign key) Tbl_TransPayLnk Code Snippet TransPayID int Unchecked TransNo varchar(50) Checked TransDate datetime Checked Operator char(5) Checked TerminalID tinyint Checked Flagged char(1) Unchecked Remarks text Checked RemarksDate datetime Checked TPayment decimal(18, 2) Checked Tbl_Payment Code Snippet PaymentID int Unchecked PayType varchar(50) Checked Amount decimal(18, 2) Checked TransPayID (Foreign Key from Tbl_TransPayLnk) My requirement would stay the same, I would need to put the data from these 3 tables into a single line without duplicating the records and I would need to display them in a DataGridView. P.S: Would it be possible to have Mixed when a TransPayID is matched in Tbl_payment with more then one record rather then brining cash and cheque. Thank you all for your help. Bye Gemma Tag: Clarification on product specification
  - 10
    - AWE working? Hi all, This is a question related to AWE settings. I am on windows 2003 ent version with SQL Server 2005 std version. I have configured SQL Server to use AWE and min memery as 22G and max as 26G (I have 32G in total as physical memory). I do see the message in log as "Windows Address ... Enabled", but when I am using performance monitor to view total memory in kb for SQL Server, it never starts at 22G (usually at 1G). And I doubt why The account I am running SQL Server is an admin account, so it can definitely locked down the pages in memory. Also, I do think AWE is working somehow, after several hours in running, the total memory will up to 8, 9 or 11G. So, apparently, it is over 2G per process limitation. I still want to know. 1. Is my AWE setting working 2. If not, how to fix that 3. How to confirm how many memory is actaully using by SQL Server Thanks, NIng Tag: Clarification on product specification
  - 11
    - Problem with ID 17981 Hello, I��m trying to do an update through a system but this message display a problem that I didn��t get to identify exactly the problem to looking for a solution. "Table error: Object ID 17981, index ID 1, page (0:871674153). Test (offset + len < PAGESIZE) failed. Slot 10, offset 0x1a8 is i Error while undoing logged operation in database " Could anyone help me please Thanks, Mauricio Tag: Clarification on product specification
  - 12
    - After restoring MASTER database, can't start SQLServer Service: Configuration block version 0 is not a valid version number Now, I checked and verified that my backup version of SQL Server is the same as the version installed on the computer I'm restoring too. I have SQL Server on a production machine that I backed up and want to test a full restore on a dev machine to make sure it will work when I need it to. Now that I've run the restore command on my tape backup and go to restart the SQL server service I receive: Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall. I'm afraid I don't understand why this is happening. If the builds are the same, then shouldn't restoring the MASTER database have worked normally and I'd be able to restart the service now Any thoughts or suggestions Tag: Clarification on product specification
  - 13
    - error: Could not find SP upd.sp_MSrepl_xxx_xxxxxx_1 it's most likely a bug then. You're going to have to call customer support and open a case on this one if you want to get this type of scenario to work. Tag: Clarification on product specification
  - 14
    - Plz do evaluate this SP SELECT dt.DynamicQuestionID, dt.QuestionOption, dt.UserID, qo.SortOrder, CASE WHEN qr.Response IS NULL THEN 'FALSE' ELSE 'TRUE' END AS Status FROM ( SELECT DISTINCT qr.DynamicQuestionID, qr.UserID, qo.QuestionOption FROM DynamicRegistration_QuestionResponse qr CROSS JOIN DynamicRegistration_QuestionOption qo ) AS dt INNER JOIN DynamicRegistration_QuestionOption qo ON qo.DynamicQuestionID = dt.DynamicQuestionID AND qo.QuestionOption = dt.QuestionOption LEFT OUTER JOIN DynamicRegistration_QuestionResponse qr ON dt.DynamicQuestionID = qr.DynamicQuestionID AND dt.QuestionOption = qr.Response AND dt.UserID = qr.UserID Tag: Clarification on product specification
  - 15
    - Hide parameter if other paramter is null What I have is a report using Reporting Services 2005 that will take in a parameter through the URL called RepID, so the parameter is hidden inside the report because it's passed through the URL. This will run the report for the specified Rep. However, I'd like to have another paramater (Or also using RepID) just as Admin which would be a boolean and when Admin='N', the RepID parameter should not be displayed on the screen and just be accepted through the URL paramater RepID. However if Admin='Y' is the URL paramater passed, I want the RepID parameter to be displayed in the report so that the Admin can enter whatever RepID they want to run the report. Is there anyway to do this without creating a separate Admin version of the report Tag: Clarification on product specification
  - 16
    - Stored procedure vs. query Arnie Rowland wrote: From a security perspective , I would never allow an application to directly access data tables. What security risk is involved with compiled code accessing the tables Arnie Rowland wrote: From my experience, all data access 'should' be done using Stored Procedures. The code base is centrally managed, and can easily be changed as system and business needs evolve. There is no way to determine which stored procedures are associated with the changed tables without either looking at the source code of the application or waiting for it to break. In my experience, it is more time consuming and frustrating to keep bouncing back and forth from source code and database only to find a stored procedure or view with 2-5 lines of code. Arnie Rowland wrote: For example, imagine the impact on the application if data tables have to be re-organized for storage or speed issues. With stored procedures, it is only necessary to change the procedure code so that the same resultset is produced -the application doesn't care where the data comes from as long as it gets what is needed. For storage or speed enhancement, when is a field name changed or removed outside of poor table design Why would the query need to change Arnie Rowland wrote: But when using inline queries, any changes to the data stores can cause catastrophic failure of the application until all queries are located and changed. (From experience, believe me, over the life span of a project, there will be businss needs to change where/how the data is stored .) If the extremeties that you're reaching for are actually put into play, the application itself will no longer work without dramatic changes to the stored procedures. Datatypes would need to change, parameters added to the ADO, and any change of reasonable magnitude would require extensive research even with good documentation. To reiterate my previous post, inline coding is th optimal choice for 2-5 line queries regardless of the action on the table. Arnie Rowland wrote: Also stored procedures can be easily changed to allow auditing. There are a lot of applications that are currently being re-written because of HIPPA and SarBox requirements. In addition to logging changes to data, HIPPA requires logging EVEN a data read operation that touches medical data. You can't do that with an inline query. Really I must be imagining application logs. (and legacy systems are often re-written to adapt to new found business needs. Auditing is no new obstacle.) Arnie Rowland wrote: And in a few occassions, after project roll-out, it was discovered that the application 'should have' done a better job of validating data before sending it to the data server. Was QA sleeping Arnie Rowland wrote: With a stored procedure, it was quick and easy to add validation code without having to trace out all locations in the application code where a query may have inserted data into a table. Validation is done on the form before the query is run. It's never done in the query itself. Arnie Rowland wrote: (Time from discovery, solution, testing, and 'fix': 45 minutes -no application re-deployement to 500+ desktops.) First, if your company has 500+ desktops and you don't have an application server to pull updates, it's time to get one. Secondly, a 45 minute fix is a lunch break, and lastly, as a developer for over a decade, I've never experienced major changes in either applications or databases that didn't require months of planning before any changes were made. Arnie Rowland wrote: But from a 'purely performance' perspective, with SQL 2005, there is little difference in most situations. (Though there 'can' be large differences in certain situations.) Very true. There is a definitive and defendable middle ground. Adamus Tag: Clarification on product specification

Gish

http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx

The above link says the pros and cons of two SQL Server 2005 editions.

Document says Compact Edition is not good for ��When you need a multi-user database server

��.

What is the meaning of multi-user database

Does this means the database strictly will not support two database connections at a time

-Thank you,

Gish

Top

Re: Clarification on product specification

ErikEJ

Multi-user means supporting several autonomous clients, like several web servers running against the same database, as SQL Compact is an in-process database engine, this will not work. Several connections are supported, but from the same application on the same machine.

Top