Answer Questions

• semilogic Xpath/Xquery SQL question

  Hi all, Sorry to dump my problem, but I'm a bit stuck for ideas. I've searched BOL and MSDN but can't seem to find anything that does what I want, and I'm no Xpath/Xquery expert. I'm running SQL 2005, and have a typed XML column with the following data in it: < PPP_PCB xmlns = " urn:hl7-org:v2xml " xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance " xsi:schemaLocation = " urn:hl7-org:v2xml PPP_PCB.xsd " > < MSH & ...Show All

• mrbelk navigation on subtotal

  I have a matrix and a subtotal footer summing up a group of numbers. Each row has a primary key. I use the primary key to drill-through another report through "Navigation". Unfortunately, the generated subtotal column also have a link but it has a primary key of whatever the first row is, which shouldn't have a primary key. So I can drill-through the subtotal but it returns the wrong result. I have not been able to override the subtota ...Show All

• Andy Green How can I find out whether SSIS is installed in the server?

  Thanks a lot. Thanks. I checked SQL Server Integration Services. It is disabled. I just started. Thanks. What exactly do you mean By script/scheduling or simply looking for file system for any DLL or whatever Have a look at the service SQL Server Integration Services, if it is present you have SSIS installed. YOu can check that by open the SCM or type in the "net start" on the commandline on the server. HTH, Jens ...Show All

• dakotahnorth Connection Manager in SSIS packages

  I am trying to run a package outside of the Business Intelligence development Studio.  It continuously fails and tell me that my username cannot logon due to a password failure.  When I check my connections the password never shows in the connection string and remains blank in the connection properties although I have checked Save Password in the connection properties.  Does anyone know how I can save the passw ...Show All

• Sam13 Parse SQL Statements

  Hi. Does anyone come across this error message whenever u try to parse ANY SQL statements in Management Studio 2005 (even parsing SELECT GETDATE() fails)... >>> .Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. >>> Thks! See this KB article Yogi, I'm assuming it's the problem ...Show All

• Robert Wakeland Management Studio and Enterprise Manager on Same Machine?

  Greetings! Do any of you know whether or not it's possible to install Enterprise Manager onto a box with SQL Server 2005 installed I've come across a couple of problems when trying to admin some SQL 2000 servers, so I need EM somewhere. Also, it's incompatable with SQL Server 7.0, of course, and I've got two of them to admin as well. Thanks! I am running into the same problem, and have try downloading an ...Show All

• FinnurJ support asian character and connect limit

  Do MS SQL Express support Asian character set If I want to input Traditional Chinese character, what collation I should use Is there any limitation on the no of connect to MS SQL Express 1. Yes, MS SQL Express supports Asian character sets. Japanese, Chinese Traditional, Chinese Simplified, and Korean . 2. A SQL collation is selected by default for English-language locales. The default collatio ...Show All

• Giri T Script component and variable!!

  Hi All, I have developed a simple package utilizing script component and variable. What I am trying to do is declare a variable in the parent package that can be change at run time to either 1 or 0. If 1 I want the package to succeed and branch off to run some child packages and if 0, then branch the other way and run another child package. In ether way, I want to be able to load one of the two child packages and not both. I I declare a va ...Show All

• Ben0s Removing duplicates

  Hi all,       I have a table like        UserNo        UserName          1               Ajit          2              & ...Show All

• Philippe Jan How to Pass parameters in SSIS dataflow

  I am using a parameterized select query as displayed below to fetch values from source. SELECT A.Account_GUID, M.Merchant_GUID, H.Household_GUID, B.BankAU_GUID, SR.SalesRep_GUID, E.Entitlement_GUID, I.Income_GUID, Exp.Expense_GUID, SP.Sales_Product_GUID, P.Product_cd, SUM(S.Sales) AS Monthly_gross_MC_VI_amt, SUM(S.Sales) - SUM(S.[Returns]) AS Monthly_net_MC_VI_amt, SUM(S.SaleTxns) AS Monthly_gross_MC_VI_tran_cnt, ...Show All

• johoja Joining two fields to single field

  If I have a database table with the following columns: ID Other_ID Description And I want to join the two ID fields to one field in another table that contains the following fields: ID Name How would i do that Here is some sample data and what I would like returned TABLE1 ID Other_ID Description row 1 1 2 Number1 row 2 3 1 Number2 TA ...Show All

• Ross Smith SQL Server 2005 Remote Connection Problem... Big Time.

  Hi, I installed SQL server 2005 express edition on my windows server and I had no problem with connecting it remotely through Management Studio, then I removed it and installed a full edition SQL server 2005. That's when it's gone all wrong. Now I can't remotely connect the server through Management Studio. The error I get is the same as some of the people in this forum has which is: "An error has occurred while establishing a conn ...Show All

• Streetkeeper Trans Replication Works Under certain conditions.

  I have 2 SQL 2000 servers (both have SP4) and are running on Win2003 SP1. We will call them SQL1 and SQL2. SQL1 is the publisher and distributor for trans replication, SQL2 is the subscriber with immediate updating, and queued updating as failover. I configured the publisher and subscriber. The snapshot replicates fine to the subscriber and all the agents are working fine. There is only 1 table article configured for replication. Let's ...Show All

• browerjs Problems Installing SQL Server when CTP was previously installed

  If you are having problems installing SQL Server, including Express Edition, and you previously installed one of the Community Technology Preview (CTP) releases, then read on... Please provide feedback if any of these steps are confusing. -------------------------------- Note that if the user already has .NET Framework on their machine, they're going to have to go back to an earlier version, do the SQL Uninstall, then go forward to ...Show All

• MrNoBody Variables in the four naming conventions

  Hi I am running SQL Server 2000 and have two different databases with different names on two different machines. The servers (machines) are linked and I want to use a single set of stored procedures on both databases. I want to know if and how I can use variables in the four naming conventions in a stored procedure. This way I do not have to write an if statement and rewrite the code for each database. Example: Select * from SE ...Show All