Answer Questions

• gazwik Input column collection in script component?

  Does there exist an input column collection in script component What I mean is that if I have 10 input columns with names: a,b,c,d...i,j Then, within the script component, can I access any column collection such that column[0] has value for column named 'a', column[1] has value for column named 'b' and so on.. Using Row.a , Row.b, Row.c and so on does not give the flexibility to get/set values in a loop. thanks, Nitesh Is it possible to g ...Show All

• ahmed_black_horse SQL Express Manager: Error occurred during application start up sequence

  TITLE: SQL Express Manager ------------------------------ Error occurred during application start up sequence. Application will be shut down. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.ExpressManager.SRMainError&EvtID=ErrorDuringApplicationStartup&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: Method not found: 'Void System ...Show All

• jzhang2006 Step-thru Debugging of Script Transformation (June CTP)

  Has anyone successfully debugged a Script transformation in a Data Flow by setting breakpoints and stepping through the logic of the script I can't seem to get the breakpoints to stop execution. Any assistance would be appreciated. Here is the current BOL content on this subject, from the topic "Coding the Script Component:" Debugging the Script Component The Script component does not support the use of breakpoints. As a result, you can ...Show All

• Michael Cullina Snapshot replication - Primary key not transferred

  Hi There After using snapshot replication from Server 1 to Server 2 i found that the primary key contraint was not transferred to server 2. I used the option to truncate tables for snapshot. The indexes are there as nonclustered unique but the primary key constraint for the tables no longer exists at the subscribers. I ahve done this on 2 other servers and the primary key constraints were not lost on the subscribers. I am very confused, please h ...Show All

• lrryklly 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. It's sad, but I don't think SQLX comes with SQL 2005. Perhaps you can guide me in my mo ...Show All

• adolfo2005 ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC ...Show All

• alexbartell Generate Scripts option in SQL 2005 Management Studio

  Did anyone even bother to test the Generate Scripts option for a database I changed the following options from their default setting: "Include Descriptive Headers" = True "Include if NOT EXISTS" = True "Script for Server Version" = SQL Server 2000 "Script Indexes" = True and scripted all Stored Procedures, Tables, User-defined functions, and Views Problems: 1.  Generates IF NOT EXISTS (SELECT * FROM sys.objects ... should be ...S ...Show All

• Elliotte Unable to use SSMSE to connect to SQL Express server on secondary IP address

  I am having trouble to use SSMSE to remotely connect SQL Express server using IPs other than the base IP of the machine. Machine settings: (1) Has multiple IP configured. Those IP are accessible remotely (2) Firewall is not on. SQL Express server configuration: (1) TCP/IP and named pipe are on Browser service state: (1) running (2) listening at 0.0.0.0:1434 (UDP) SSMSE connection results: (1) with <ba ...Show All

• Bhargav Moving a SQL2K publisher to a SQL 2005 instance.

  Hi, I have to move a SQL2K instance (publisher) to a SQL 2005 instance and i prefer not to re-snapshot all the databases being replicated due to the large size of the databases. As i understand all i need to do is    1. Ensure all published databases are in readonly mode. 2. Stop the replication (by either dropping subscriptions, publication or stopping replication agents). 3. Move the databases to the SQL ...Show All

• Niran Errors in High-level Relational Engine and OLAP storage Engine

  Hi all,, Could someone help me out and explain to me why my two fact tables process successfully but the process still fails when i try to process the cube. This is the detailed error message. Ronald <Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Parallel> <Process xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLS ...Show All

• Zoctan baffled. How to purge old backups with maint plan

  I'm missing something basic... Trying to create a new job from sql server 2005 Management Studio. The nifty wizard under Management provides options to create backups, and clean history, but I cant seem to find out how to create a job to purge old backups. Looking at the commnand line Sql Server Agent Job shows: /SQL "\Maintenance Plans\Full Backups" /SERVER "JFSLIB-DEV" /MAXCONCURRENT " -1 " /CHECKPOINTING ...Show All

• Sachin chakote Linking Oracle Servers

  Has anyone successfully linked to a Linux Oracle server running 9i We are unable to get the link working.....have installed various drivers and still get connection refused. Any thoughts Try to use Oracle ODBC driver instead of Microsoft ODBC for oracle (His name should be Oracle in <oraclehome>) Try to install oracle client on your machine,and it should work Best Regards We have instal ...Show All

• Nathan Wynne recursive cte within a cte

  is there any way to define a recursive cte within another cte. I have defined a recursive cte which works great for finding the different versions of a given item. What I would like to do is to define a set of items for which I want to find the different versions. You can't create a CTE within another CTE, but you can reference a CTE in a second (or third, or fourth, or N) CTE:   ...Show All

• 　平 明? SQL CE Merge Replication

  Hello All,       I have a server with SQL Server 2000 installed on it. I have created a tool that runs on a Pocket PC with SQL CE backend. Multiple clients would be using the tool on diferent Pocket PCs. I would have to use Merge Replication for synchronization and since the Pocket PCs would not have internet / network access, I understand that I would need to use Merge Replication synchronization technique throu ...Show All

• N S S fn:contains() and full-text index

  I am glad to find out that full text index on xml column is actually xml aware - that I can use xquery to perform the search. However, when trying to find a word or phrase inside a node using contains(), it seems this function behaves differently in following situations: 1. contains(xmlCol, 'search text'), this works case-insensitive 2. contains('/root/someElement', 'search text'), this works case-sensitive In both cases, I have crea ...Show All