Answer Questions

• enric vives Deadlock problem? 3 way conditional split of data from one table to another never completes

  I have a source table which I'm splitting 3 ways based on a column value, but the target is the same OLE DB destination table. One conditional path is to a Multi-Cast two way split to same OLE DB gestination table. The default split is to a flat file for logging unknown record types. For a test I have data for only the 3 column values I want, but I'm having trouble with the process completing. If I pre-filter the data going into the source table by one or two values I can get the process to complete even if one split is to the multicast. If I include all three data types in the source table, I get different results depending on the order in which the conditions are specified - sometimes only two split paths are executed; other times all th ...Show All

• Will Merydith can't download ms sql 2005 free trail version

  hi was looking forward to downloading the 180 day trial version of ms sql server 2005. Signed up and everything. when it loaded the download page it only has the 2 help files listed. Has the free trial ended if i download the full express version does that have a free trial hi, to me all works as exptected... in the middle of the page you can find a section reporting: "Instructions Enterprise Evaluation Edition is available in two downloadable formats: an image file that you can use to burn your own DVD, and a self-extracting executable file that will allow you to download and install without a DVD burner" where you can download the ISO images or the direct self extracting execu ...Show All

• Biju S Melayil ReportServer - http://localhost/ReportServer - Error

  An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object. And my ReportServer log: <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product> <Locale>en-US</Locale> <TimeZone>Pacific Standard Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__03_24_2006_16_45_06.log</Path> <SystemName>USPROFILING</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVe ...Show All

• krick Issues with query modification and running a report that was imported into Visual Studio from Report Builder.

  I've noticed that after you import a report into Visual Studio the query for the dataset is in XML form that is based on the semantic modeling schema found at http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling . Is there a way to get that query broken down into sql so that it is easier to modify I'm also having a issue when I try and preview or run the report in Visual Studio. It appears that it is looking for some sort of connection to the model itself that is on the report server. "An error occured during local report processing. The item '/model folder on report server/model name' cannot be found." Is there a certain way that you have to set up your data source Do you need multiple data sources, etc... ...Show All

• EmmaColene getting primary key id on insert

  i have the following code in visual studio 2005 using VB it is running an insert query - this works fine but i want to know how can i get the primaty key value(which is auto generated) of the row that i just inserted... Dim conn As New SqlConnection( My .Settings.connStr) conn.Open() Dim sql As String = "INSERT INTO tblProspect (Prspct_FirstName, Prspct_LastName, Prspct_PropIDPrimary, Prspct_PropIDSecondary, Prspct_ApplicationStatus, Prspct_DateSubmittedOn, Prspct_PrimaryRent, Prspct_SecondaryRent, Prspct_MoveInDate) VALUES ('" & Me .txtFName.Text & "','" & Me .txtLName.Text & "','" & Me .cmbPrimary.SelectedValue & "','" & Me .cmbSecondary ...Show All

• Scott Boyd SOS_SCHEDULER_YIELD

  Can anyone shed any light on the wait type SOS_SCHEDULER_YIELD in SQL 2005 The following is the description from BOL... Occurs when a task voluntarily yields the scheduler for other tasks to execute. During this wait the task is waiting for its quantum to be renewed. Why would a task "voluntarily" yield the scheduler What type of tasks would do so If this is one of your higher wait types in terms of count and time, is that a pretty good sign that you need additional or faster CPUs Thanks! The SQL Database engine uses a non-preemptive scheduler internally to increase throuhput; Most threads are expected to yield often. Much more information on this topic can be found on http:// ...Show All

• battlex Multiple-step operation With Sql2005 And Ado

  Hi For the following query: Select Col_1 = '' Sql2000 returns an ado recordset with one field who's property Defined Size = 30. Doing the same with Sql2005 returns Defined Size = 1. When setting a value (Len > 1) to the field we get an error: "Multiple-step operation..." This error is not new to us, and we also know that we can solve it by changing the query as follow: Select Col_1 = Cast('' As NVarChar(100)) The question is, how can we control this new behavior Can we config SQL2005 to behave like SQL2000 Thanks, Nir. Have you tried setting the SQL2000 backcompat mode in SQL2005 The sql2005 behavior looks more appropriate to me, so most likely it is an intentional change. Column s ...Show All

• Manojit Paul Lookup Transformation has a strange behavior.. bug?

  Hi to all! i hope that You could help me, because i must build a release version of my SSIS package in 2 hours.. This is my big issue: i've a SQL Server 2005 (SP1 64bit version) and a remote SQL Server 2000 (SP4).. I've created a Data flow task that contains an OLEDB source (native client on SQL 2005 local server) and a Lookup Transformation that has to connect to remote SQL Server 2000 and returns me some columns.. I see all, tables, columns.. no problem at first sight.. I choose some columns to use in Lookup output and confirm.. When i re-open my lookup task, columns are not selected (checked).. obviously my oledb destination can't see that cols.. I choose, but my SSIS don't store any cols in output.. I've tried using error output, adva ...Show All

• Bastiaan Molsbeck Waiting For User Prompt when running Report Builder Reports

  I have created some reports using Report Builder however they autorun with default values when selected in report manager, cant think many people would want this to happen. Is there a way of getting rid of the default values in RB or preventing auto execute in RM Hi Phil You can remove the default values in RM by going to the said reports Properties tab then selecting the Parameters option on the left. Default values can be removed here. If all parameters are defaulted the report will auto run, if only some are default it will not. The only use I can see for this is when running subscriptions when there is cell specific security according to user. One would then simply default "select all& ...Show All

• jgz Nested Transaction Error

  When i try to run a stored procedure to update a value in an Oracle db i get the following error message: Unable to start a nested transaction for OLE DB provider 'MSDAORA'. A nested transaction was required because the XACT_ABORT option was set to OFF. I tried setting XACT_ABORT to on but now my update store procedure doesn't work either. Here is my update code: SET @cmd = ' UPDATE OPENQUERY ( ' +@Link + ', '' SELECT TARGET_VALUE FROM '+@Table+' WHERE TARGET_LEVEL1_VALUE = '''' '+@Prod+''''' AND PERIOD_VALUE = '+@WW+' AND TARGET_LEVEL_VALUE = '''''+@Factory+''''' AND TARGET_TYPE = '''''+@SchedType+''''' '' ) SET TARGET_VALUE = '+@NoProd+' ; ' EXEC (@cmd) ...Show All

• vasudupe 20,000 ft. directional question about technologies and capabilities

  Greetings, My desire is to have my primary db in FL and an online hot standby in both my MI and CA offices. The hardware is in place, as well as T1 size pipes. The solution I'm looking for would have all databases online in case of hardware / environmental failure although the application would only be pointing at the primary (or designated) database server. We have another 3rd party solution available, but I'd like to stay native SQL if possible. Is replication the way to go Does one-to-many work Can all the db's be online and available while replicating Can I catch up if switched to one of the other db's temporarily note:This is 100% SQL 2005. Thanks -- sorry for the newbie-flavor of the question, but I'm sure a ...Show All

• nitinmehta Service Listing Manager Question for Remus

  Hi Remus - Thank you for your Service Listing utility. I am very new to S.B. I had an intern working for us do some research work into S.B. and I gave him your utility to use for the work I gave him to do. Here is what I am trying to do. Very simply, I want to setup a remote (target) server that many other source (initiator) servers will send messages to via S.B. I had the intern learn how to have a single initiator server send messages to the remote server. He used your utility to create the SQL script that needs to be run on both servers to get things set up, and it works correctly. The script below is what your utility created to be run on the remote server. The reference to 'SDDev2' below is a reference to the initiator (source) ser ...Show All

• spinnaker15136 Creating full-text indexes on a table in a publication

  I have a table that is in a one way transactional publication. I need to create a full-text catalog on this table and have that catalog exist on the subscriber as well. I understand simply creating a FTC for an object in a publication will not cause that FTC to be replicated to the subscribers. I have scripted out the command and tried to use sp_addscriptexec to push it to the subscriber. When I do this, I get the following error: Last 183 characters in 'sqlcmd' output buffer: Changed database context to 'database'. Msg 574, Level 16, State 1, Server SQLSERVER, Line 2 CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction. Also, when this script is run directly from the subscriber, it works fine (but since the subscribe ...Show All

• Chirag Patel ADO Error codes...

  Hi, I have another question about ADO (using C++). I have searched the MSDN but I haven't found a answer to my question (maybe I'm just too stupid)... If I make a connection to my SQL Server there may occur some errors, but how to find out what went wrong In terms of code I have e.g. something like that: try { connection->Open(ConnectionString,Username,Password,ADODB::adConnectUnspecified); ... } catch (_com_error& e) { long numErrors = connection->Errors->Count; for (long i=0; i<numErrors; i++) { ADODB::ErrorPtr pErr = connection->Errors->GetItem(i); ..... } } Now I could get the error number by pErr->GetNumber(). But with which symbolic constant has this to be compared to find out which ...Show All

• HanSoloIsSoCute key columns

  I have noticed that Microsoft SQL Server 2005 Everywhere Edition OLE DB Provider doesn't support DBPROP_UNIQUEROWS property from DBPROPSET_ROWSET property set. Does it mean that I have to use the KEY_COLUMN_USAGE rowset to get list of key columns in table Yes, you should use DBSCHEMA_KEY_COLUMN_USAGE in this case. or you can get the same information with the following query: "select * from information_schema.key_column_usage;" ...Show All