Answer Questions

• ETricotti How to use a Wildcard with the value for the parameter?

  I have a report that selects certain records based on what the user enters for the parameter but I'm trying to allow the user to enter a wildcard and show the relevant records. I used like and had the user add an * or even a % but it still returns nothing. Records are returned only when the user enters the full value with no wildcards. Help. SELECT DISTINCT PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID, PDFBM.REQUIRED_QTY, ICFPM.PART_DESC, ...Show All

• JBeem IP addresses: when SQL assigned multiple which does processing?

  SQL 2005, 2000 Server SP4, IIS 5, .Net Framework 2.0 My SQL Server lives in two networks separated by a Netscreen firewall. From there the Netscreen allows the Server to talk to a well-guarded Sybase that is on the other side of the firewall. So I can ping the Server at one address 'A'- but the Netscreen routes the traffic to the Server at the address the server knows itself as 'B'. The Server can't ping A (the address the outside ...Show All

• RyanBay Problem upgrading clustered node to SP1

  Hi We just upgraded a sql 2K Active\Active 2 node cluster to SQL2005. The upgrade seemed to go OK. We also managed to apply SP1 to Node 1 after an initial problem But now when applying SP1 to NODE 2 we are getting this error " A recently applied update, NULL, failed to install " We had the same problem on NODE 1. Turns out after installing client connection tools and management tools SP1 succeeded. But it does not se ...Show All

• Craig Z manually manipulate parameter info

  If i want to go directly against the ReportServer database to manipulate parameter info for a particular report definition, which table is that data stored in Probably not something you can do like that, you may need web service. The Catalog table contains information that may help you (text & binary blobs though) ...Show All

• Don Pellegrino sp_addrolemember inside a trigger

  I'm trying to handle some user management inside a trigger. When I call sp_addrolemember I get this error. sp_addrolemember cannot be used inside a user-defined transaction Is there any way to get around this error I need to assign a custom role based on a variable inside this trigger. Any help is appreciated. No. This is by design. Some system operations or DDLs cannot be executed under a us ...Show All

• DRLaff View with SELECT * doesn't pickup new columns in table

  Hi I have noticed that when adding a new column to a table that is used in a view with the following tsql: CREATE VIEW [dbo] . [vwPersons] AS SELECT tb1 .* FROM tb1 LEFT OUTER JOIN tb2 ON tb2 . PersonID = tb1 . PersonID the new column is not shown in the following tsql: SELECT * FROM vwPersons In addition to this, when modifying a view in Management Studio, all columns will be returned when the view is ope ...Show All

• skumary Best way to handle existing rows

  I need to create a fairly simple package that copies data from one database using a sql querie and inserts it into another. what's the best way to handle rows that already exist in the destination table The package needs to run once a day and ignore rows inserted from previous runs. You can pass the data through a lookup transform and compare them to the destination dataset. The rows that don't match will be marked as errors so click on t ...Show All

• Lay Lay Creating aomething similar like SCD wizard interface

  HI, I created a script component that is doing some transformations and it works very well. Now, I want to use the same script component on other dataflows in order to use it with other tables. Since my script component uses three outputs and some of my dimensions may have sometimes 50-60 columns, and the fact that I need to customize the column names used in my script, I would like to be able to have some kind of wizard like the SCD wizard to c ...Show All

• LoadStore Help! Transfer of database from SQL Express to SQL 2005 host environment

  Help! I have been testing my system on my development PC using SQL Express. Great! Now its all working and I have 4.5Mb of data, and about 50 tables plus queries. HOW DO I GET THIS TO MY NEWLY SETUP HOST ENVIRONMENT! Argh... There seems to be no way to export from SQL Express to SQL 2005. The host company cannot restore from backup (I think this is reasonable.) What was microsofts plan here What am I missing I have searched the net, and I have ...Show All

• micr0chip Error messages upsizing from MSAccess database to SQLServer

  I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages: Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQLServer Error: 17 [Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not e ...Show All

• pet9834792873928347 Updating database

  Can someone please tell me what I am missing... I am trying to update a record with information a user types into a textbox. I am not getting any errors even when in DEBUG mode. But yet the Data is not getting updated. Any Help would be very much appreciated. T CODE: Protected Sub bUpdateSlsNum_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles bUpdateSlsNum.Click Dim myCommand As SqlCommand ...Show All

• kingofnexus SSIS LOGGING

  Second time around w/this one. I'm running my sqlserveragent with a domain admin account and everything works well. I then switch to a domain user and the package fails. Windows app log contains ths Package "Package1" failed. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . So I go to the sql server agent jobs and select the job I'm trying to run. I then go to Job Step Properti ...Show All

• bezael Pivot Error

  Hi : I am getting the following error message when I am trying to do the Pivot operation. Msg 265, Level 16, State 1, Line 1 The column name "FirstName" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. Msg 265, Level 16, State 1, Line 1 The column name "LastName" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. Msg 81 ...Show All

• cliftonic Create schemas programatically.

  Hello, I need a column of type XML but I need to construct the XML at runt time in my asp.net application. I would like to create first an XML schema to be validated all the data that is going to be inserted in that column. Can u provide me  information in how to make this. Thanks. it need to be at runtime because of this. I am making a generic software product, lets say we have a table called person with some basic information, lik ...Show All

• senthilssk DataReader Source and Column Types

  Is there a way to control the types for output columns of a DataReader Source It appears that any System.String will always come out as DT_WSTR. As I have my own managed provider, and I know what went in, I can say that really it should be DT_STR. The GetSchemaTable call from my provider will always say System.String as it does not have much choice, but GetSchemaTable does contain a ProviderType which is different for my DT_STR vs DT_WSTR, or ra ...Show All