Answer Questions

• ercilia hirata Strange behavior from SQL Server 2005

  Hi all, This is really a strange problem: I have one computer in my network where sql server is installed. Via another computers in the network i get the data from the sql database. Now i created a large query but executes fast, it has multiple left joins in it but if i execute this query in sql server i get an execution time which is 0.20/0.40 sec. if i execute the same query through a php script the execution time is 2.4/2.6 we dont ...Show All

• Anil_J Sql Server 2005 not starting

  Hi,       I have my web application with backend  as Sql Server 2005 CTP(Yukon). Initially It works well. I updated some security settings to the OS Windows Server 2003 and restarted the machine. Now the Sql Server is not starting.When I manually started  It logs error as follows. 2005-10-13 03:39:57.85 Server      UpdateUptimeRegKey: Operating system error 5(Access is de ...Show All

• Cyber22 Execute package on a for each loop container

  Hi. I am running a package using 'execute package' inside a for each loop file iteration. I have to iterate through some 10,000s of files to ETL source data, a resonably complex package. I want to set going and get some sleep but every 200 files or so I get a memory exhausted error and the task fails. Is there a short easy fix to refresh memory each iteration. If so please let me know. Just ignoring the failure at task level won't refresh the me ...Show All

• Software Design Engineer Could not find stored procedure 'master..xp_jdbc_open'

  Hi All, I am using WebSphere 5.1 and try to setup Datasoruce connection in WebSphere I have selected "Microsoft JDBC driver for MSSQLServer 2000" from the picklist in WebSphere Admin Console. The 3 jar files below are referenced correctly as well: ${MSSQLSERVER_JDBC_DRIVER_PATH}/msbase.jar ${MSSQLSERVER_JDBC_DRIVER_PATH}/mssqlserver.jar ${MSSQLSERVER_JDBC_DRIVER_PATH}/msutil.jar However when I run a testconnection, it fa ...Show All

• Amernath Transactional Replicating hanging SQL Server 2005

  Hi, It appears that every 5 or so days, my transactional replication is hanging.  I see that I have a couple thousand undistributed commands and this number keeps growing.  It forces me to generate a snapshot in order to sync up.  When generating the snapshot, I will get frequent messages like "waiting for a response from server...".  So I will keep stopping and starting syncronization.  Eventually the snapshot will g ...Show All

• fwyattblake How to use the new TSQL PIVOT operator with reporting services?

  Hi, I am still tryng to find a solution to this problem. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=125123&SiteID=1 Assuming that Matrix will not work for me, I thought that may be there would be a solution by using a standard report of some kind and the new PIVOT operator. I do not know in advance the number of rows and columns and I do want the report formatted as a flat file. Any idea Thanks Philippe ...Show All

• Paul Stubbs - MSFT Solve order

  Hi !! I'm migrating my AS2000 to AS2005 but I have a problem. In my AS2000 I have a lot of calculated members and some MDX queries that use those member. The problem is: In AS2005 the order of calculations changed. Now the calculations are done before the aggregations in the MDX querie. But I have more than 300 calculated members and change one by one seems to be very hard. How can I change my MDX querie to do the aggregation before the ca ...Show All

• Sean2408 Schedule the integration packages from the web application

  Hi all, I have developed some SSIS packages and scheduling them by using the SQL Server Agent. But now I want to change all the scheduling from my web application. is there anyone could help me this Do you mean that you want to alter the schedule If so, this is not an appropriate question for the SSIS forum. The schedule is defined in SQL Server Agent, NOT SSIS. I do not know if there is an API available for Agent. Try the SM ...Show All

• sahil_m join table udf question

  select a.*, b.* from table1 a join dbo.myTableReturningUdf(a.Col1, a.Col2) b on a.Col1=b.Col1 I am getting this error: Line 3: Incorrect syntax near '.'. It doesn't seem to enjoy the period separating the table alias from column name (a.Col1). Am I not permitted to send to the udf, parms that come from table1 What I am trying to do is match each row in table 1 with mult rows that are returned by myTableReturningUdf - hence the joi ...Show All

• Vallari Kamble - MSFT Could not establish trust relationship for the SSL/TLS secure channel

    Hi, I am working on sql server reporting services 2005 , i got this error while deploying a report Error 1 The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. C:\Temp\NotificationReport\db.rds 0 0  NB: i checked IIS no ssl required on all sites. Any Help Thanks Tarek Ghazali SQL Server MVP ...Show All

• Avocado How to skip snapshot in Transaction Replication (from SQL Server 2005 to 2000)

  We have two SQL Server 2005 production DB at remote sites. Due to network bandwidth issue, we need to replicate these DBs (publishers and distributers) to central corporate SQL 2000 DB (subscriber for backup and possible reporting (and in rare case as a failover server). We would start out with backup from SQL 2000 db restored on remote SQL 2005 DBs. When we have DB issue on remote 2005 DB, we want to restore it from central corp. 2000 DB bac ...Show All

• jef.ptc Connections to SQL Server Files (*.mdf) require SQL Server Express 2005

  When ever I click on an MDF file in VS2005 I get the following message. Required Components Missing. Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly.  Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/ linkID=49251. I think this may have been due to the install order and options I selected. 1. VS2005 Pro, without SQL Server Express 2005 as I wa ...Show All

• Dhatri Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• Sudeep Ghosh Can the OWC 11 "Pivot Table Field List" display AS 2005 Hierarchies and attribute correctly?

  We have an application in production that uses OWC to provide access to cubes in AS 2000. I've converted all the cubes to AS 2005, and they work great with the Excel Cube Analysis Add-in, but we are having challenges with OWC. The problem with OWC is that the pop-up selector "Pivot Table Field List" displays all objects the same way. All the Dimension, Hierarchies and Attribute objects all show up in the field list, which makes the ...Show All

• JP Gonzalez VSS Service and SQL 2000

  Didn't know where else to ask this question, so here goes: "MicrosoftR SQL Server 2005 provides support for creating snapshots from SQL Server data using Volume Shadow Copy Service (VSS)." Is the same true for sql 2000 or don't VSS and sql 2000 work well together. TIA, Barkingdog sql2000 does interoperate with VSS. It is handed natively by the VSS service. New in sql ...Show All