Answer Questions

• dr Davide Bombarda creating tables

  I am trying to go through an arraylist and create some database tables for each entry in the array. what I have is Dim ques As String For Each ques In questions query = "create Table " + ques + " (plantid nvarchar(100), Answer nvarchar(100))" cmd = New SqlCeCommand(query, con) cmd.ExecuteNonQuery() Next I am wanting to use the item in the arraylist as the name of the db. I am getting an error saying ...Show All

• TiredDBA questions from newbie

  just finished installing SQL Express, and now, dont know what to do next :) - I have installed FULL. Does it have any GUI tool for me to create a database - how can I login into system - how can I restore a backup file I have a backup file from SQL 2005 standard - how can I create backup for databases thanks Hi Glenn, thanks for your help. However, after doing your steps, the error message appears "User, gr ...Show All

• detrius67 Drill Through bringing back too many results

  I have created a Matrix Report through the Report Builder and specified a filter on a Date field so it only shows the current months work.  This works for the initial Totals within the Matrix but when you click on the Totals to show the Drill Down it will show all the results regardless of the Parameter. How do I make the results in the Drill Through look at the Parameter I am passing to the Report Many Thanks ...Show All

• DenversAllenB HTMl not refreshed after deleting group from table

  After I designed a simple table with a few fields (student Name, test score) and then I added a 'school name' group as a grouping level. The table displayed fine. However, I then deleted the 'school name' group from the table but it continued to impact the data display (no data shows, just the heirarchy restructuring). I have gone through all cells, rows, etc to ensure there is no remaining reference to the 'school name' group. When I looked at ...Show All

• Denis Brasfield cannot install integration services

  Hi! During the installation of integration services (SQL 05 Developer RTM) I get the following error: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Failed to install and configure assemblies C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: Failed to generate type library 'C:\Programme\Microsof ...Show All

• RWeeden "certificate not found" for second receiver

  I am trying to test load balancing between multiple broker service instances. I have set up one sender and two receivers. When I tried sending a lot of messages from the sender, I noticed that all messages were being received by receiver 1 alone. While I am able to communicate between sender and receiver 1, I am not able to send message to the second receiver (I stopped the first receiver instance to find this out). I receive the "certifica ...Show All

• Asmodai to get the latest price value

  hello all.. having been search around for days but no clue.. Hope some MVP can help.. typically from transaction, there are TIME dimension, PRODUCT dimension, and there is PRICE value measure.  normally, OLAP returns is the sum aggregation of the PRICE value when cross joining the TIME and PRODUCT.  However, I would like to retreive only the LATEST PRICE of a product.. return result should be:     & ...Show All

• ken handzik [PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

  Hi, I have two problems with Toggle Items when I render my Reports using the RS Web Service. First, the URL when I click on the + / - image will redirect me to the Report Server URL ex : The page that display the report is at : http://localhost/report/default.aspx If i click on one of the +/- image, it will redirect to something like this : http://localhost/ ReportServer /myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0 ...Show All

• VarShant Remote Connection problem on MS SQL 2000

  Hello, First, I want to say I read all threads similar this thread and I couldn't solve problem. My firewall is always off when I tried to connect remotly to SQL Server. I opened 1433 port from my router's configuration page and forwarded it to 10.0.0.4:1433. When I started SQL Server service and checking "netstat" with "-na" paramters. It shows only one row as "TCP - 0.0.0.0:1433 to 0.0.0.0:0". What "0.0.0.0" means and why foreign ad ...Show All

• Kodo Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Here is the draft of a revised BOL topic, copied into plain text because the HTML can't be copied neatly. How to: Loop through Excel Files and Tables Introduction The procedures in t ...Show All

• Tanna Using Row Count

  Pardon my ignorance, but does someone have a step by step guid to include row count transformation in a package. What I want to do is to count the number of rows extracted from the source and the number of source inserted to the target. I have tried to include a row count transformation with a variable defined. But the variable keeps showing 0 after each run The issue you may be encountering is when did ...Show All

• ruvyzzang How to use sp_addlogin

  Hi all, I want to add a windows user login which looks like: MachineName\UserName, however back slash "\" is not allowed in ap_addlogin. With UserName only, the privileges are not granted correctly as far as I tested. How can I walk around Any ideas I use SQL express. Br, XZ     I don't know what documentation comes with SQL Express, but if it is that limited to not cove ...Show All

• SalamELIAS URGENT:spsbackup.exe gives logon errors

  I am trying to Sharepoint Portal server with sql2005 on the normal everyday transactions everything works fine. However when we try to run SPS restore cannot we keep getting this error. This is  VERY URGENT  as we are trying to deploy a new site but cannot until issue is resolved. 'TWIG\Administrator' has already been given dbowner rights to all databases and can run backup but not restore. Error Message: Login failed for user 'T ...Show All

• HugoBeach can't connect to SQLEXPRESS locally

  I have SQLEXPRESS installed on a Windows 2003 Server. The SQL Tools show that TCP and Named Pipes are Enabled. I can't connect using either the command line or the Mgmt Studio with either of these protocols. Following is excerpt from program I'm trying to install: 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 setting ...Show All

• Zubair Database Diagrams

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ BUTTONS: OK ----------- ...Show All