Answer Questions

• amit.la A question on Conversation timer persistence

  I'd like to add code to a trigger to calculate the time to fire a message into a queue based on a field changing, and conversation timers seem like the way to go. My first question refers to this line from the BOL: "Calling BEGIN CONVERSATION TIMER on a conversation before the timer has expired sets the timeout to the new value." I think that in this trigger, I can simply begin a new conversation if the given field has changed t ...Show All

• Jax Developer SSIS and COM

  Dear all, Does anyone know if exists any COM wrapper provider for SSIS TIA enric12879 wrote: Yes, I've been thinking over the possibility to call SSIS packages from Visual Basic 6.0. But I haven't found relevant information about that. this might be a dumb question, but why don't you use vb.net or vb 2005 You can elect to only install the SSIS component(s) of the SQL Server product. It is the same media and ins ...Show All

• Bo Jangeborg SQL Server Management Studio Express CTP doesnt launch

  after i installed SQLExpress and SQL Server Management Studio Express CTP (ssmsee), ssmsee worked, i registered few SQL servers in ssmsee and it was OK. but after the system reboot, everytime I double-click ssmsee shortcut, nothing shows up. i wonder how can i trace the error or reset the settings. I have tried repair, uninstall+install but doesnt help. Please advise. Thanks. yes, I have installed full books o ...Show All

• casimir Common Task succeeds but reports failure

  I've made a medium size SSIS package that copies a dozen or so table.  Each table is copied inside of a sequence.  Each sequence holds a DELETE SQL command, and a data flow.  Each data flow has a MS-Acces source, a unicode to ASCII data conversion and a SQL server destination. Sometimes a sequence will run and all the data flow steps report success, but the sequence box reports failure.  (The tables copied just fine) Someti ...Show All

• Sadagopan Rajaram - MSFT DTC error with concurrent data flows

  I have a package that has several data flows that run concurrently after some initial tasks and an initial data flow. I want transactions on each of the data flows and have set the transaction option to Required on the data flows (not on the package itself). I am also using checkpoint restart on the package. A couple things are happening. 1) the first data flow is successful and that releases the several that are waiting. Some of these compl ...Show All

• GReg Bonebrake Passing Command line arguments from Visual Studio

  Hi all, Is it possible to pass command line arguments to a package when running it from within VS I want to set the value of a variable via the commandline, and found that you can to this in DtExec with the "/set \Package.Variables[...].Value;..." syntax. According to the docs, you should be able to pass the same argument via the 'CmdLineArguments' property in the 'Properties' dialog of an SSIS project in VS ( CmdLineArguments . Run t ...Show All

• Algorith Drag & Drop Multiple Query Files Into Management Studio

  In SQL Server 2000, you could have a Query Analyzer (QA) query window open to a particular database, and drag and drop a group of query files from Windows Explorer on it. QA would then open a query window for each of the files, and automatically default it to that database. I am trying to get the same functionality in SQL Server 2005 Management Studio, but it nags me with the "Connect to Database Engine" dialog box for every file. W ...Show All

• abhishekK error 18452, Login failed for user Reason: Not associated with a trusted SQL Server connection.

  Hi all, I have two servers running windows 2003 and both having sql server 2000. I want to establish a linked server between all of them. i created them . but now when accessing the data from those server the following error is being displayed Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user 'manoj'. Reason: Not associated with a trusted SQL Server connection. i have enabled mixed mode authentication.even then its not display ...Show All

• KJV Converting an Access database

  Converting an Access database I uninstalled sqlserver2005 express and reinstalled sqlserver2005 ctp.  Now, everything is in order. I've just searched books online for convert(conversion) and import(imports, importing). I see no instructions on how to convert my access 2003 database into an sqlserver database. It was easy enough in sqlserver 2000.  However, I've uninstalled that.  Is there a way of coverting in sqlserver 2005 &n ...Show All

• Michael_B Problems Using Temporary Tables

  I am declaring a temp table in control flow via Execute SQL task. I then want to use that table as a source in a data task, keep it alive going back to control flow and use it as a destination in another data task following. I am having trouble just getting the first data flow to access that temp table. In my Execute SQL task, I'm creating a simple temp table. After executing that task, I can head to the data task and change my OLE DB Source to ...Show All

• Dale Harris please look at my problem..

  I don't know what to call this but here is my problem: I need to create a report: sample table (grouping by name) name:   kris                                                                          ...Show All

• Ruske Guide to Setting Up the Different Data Mining Operations

  Unfortuately, the documentation doesn't seem to really provide the process to setting up the various mining operations (clusters, trees, etc.). So I am sitting there, trying to figure out what it is asking for when I try to set up a K-means cluster. Is there a better guide available There's a beta 2 tutorial available at www.sqlserverdatamining.com that should be in the documentation as well. I'm not sure what ...Show All

• Anil Gakhare The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait

  Every time I get this error, at different points of testing inserts and deletions on my table: The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Why do I keep getting this All I'm doing is deleting several hundred thousand records and inserting them into a couple of tables. i shouldn't have to truncate my log every time or my application ...Show All

• MackJerry cannot install integration services

  Hi! During the installation of integration services (SQL 05 Developer RTM) I get the following error: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Failed to install and configure assemblies C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: Failed to generate type library 'C:\Programme\Microsof ...Show All

• Baris Guner SSAS Relational Table Design

  The scenario: We have multiple machines that acquire data based on time as product moves through them. We know when a product enters the machine and when it leaves the machine. During the time it is in the machine we can have 100 data points acquired every 30 seconds with 30 products in the machine. If a product remain in the machine for 30 minutes, that means that product will have 60 * 100 = 6000 data points associated with it. If we were ...Show All