Answer Questions

• ploxis SQL 2000 Publisher and SQL 2005 Suscriber

  Where can I found information on how its works and how to do it I tried to do it but I always received an error message Greg, Thanks again for your help. I did as you said. While I can try to start the replication by script, I was wondering if there was a way to start it via the SQL Mgmt. Studio Express Please let me know. Thanks, Rupak Ganguly Check out the following topic in SQL 2 ...Show All

• Vijay Kumar Error: Cannot fetch the rowset from OLE DB provider "SQLNCLI" for linked server "MOTHER\DATABASE"

  Hi, I’m trying to make several distributed queries to a linked server, and for some of them I get this error message. I can’t find anytihing about it anywhere. Can anyone tell me what could be the reason of this error The way I'm executing the query in my stored procedure is: exec sp_executesql @sqlinsert @sqlinsert being a nvarchar sentence that contains the distibuted query. Thank you! Mehdi ...Show All

• jch_00 Database Mirroring: Cannot set the Mirror Server instance as the partner on Principle server

  Hi,   I’m trying to get database mirroring working but having problem when principal and mirror are not on the Domain. (I got it working once if both principle and mirror servers are on the domain.) Both servers have fully qualified domain names. Both have Windows server 2003 SP1 and SQL Server 2005 June CTP.   I used Local System Acct/Mixed mode and follow the Setting up Database Mirroring using Certificates article i ...Show All

• Gustavo Frederico Error registering a Third Party assembly

  Help. When I try to CREATE/Register a third party assembly (dtsearchNetApi2) within SQL server I am getting an error (see below). I have the source code for dtsearchNetApi2 but it is in C++ and I would like to avoid having to extend/modify it if that is avoidable. I have written a 'wrapper' class in C# but sine it references dtsearchNetApi2.dll I can't register that dll either. CREATE ASSEMBLY DBSEARCHNETAPI FROM 'C:\Temp ...Show All

• adtyerheryh query timeout expired

  Using VB, I am running a bulk insert query from csv file into a newly created table. It works fine on small test files; but when I try it on the production data, I get a "query timeout expired" message and processing ends. The text files contain several hundred thousand lines. How can I resolve this problem. I have several hundred of these csv files and more coming. Here's the code: Dim sSQL As String sSQL = "BULK INSERT ...Show All

• Jupp Varibale manipulation and expressions

  Hi There I realise this is a braod question, perhaps some could just direct me to a good link or try help. In my package a have a result set variable, i use an execute sql task to load this result set variable with a list of tables. I then start a foreach loop mapping each table name in the result set to a @TableName variable for each loop. I then perform an execute sql task , in the execute sql task i use an expresion for the actual sqlStatemen ...Show All

• jeremiah3000 Dynamic SQL Server Destination???

  Hi, Is there anyway to dynamically change the Sql Server Destination Let's imagine i want the data to go to a table based on a specific parameter like year for example... Imagine tables like table1_2005, table1_2006 and i want to dinamically change the SQL Server Destination so it would insert 2005 or 2006 and so on.... I can't seem to find that option... It was really a good idea for microsoft to implement Expressions in such component ...Show All

• houtexwebdev Sum from two tables.

  Hi, I'm new with this SQL and I have one question where I need help. I have 2 tables (Table1) and (Table2). Both tables have columns (ItemNum) and (Pcs). Table1 is for items which we have. Table 2 is for items which we have delivered. I need to calculate the sum of how much we have Items. So the query should show ItemNum and how many pcs we have. Example: Table 1 Id ItemNum Pcs 1 1 10 ...Show All

• Prakashnet Show Message if dataset is Empty

  Hi ! Is it possible to not display a report when the dataset is empty and in this case show a message to tell that there is no data to display Thanks ! Data regions (matrix, table, list, chart) and subreports have a so-called NoRows property. If set, this is the message to display in a textbox (which replaces the data region when no rows of data are available). Note: the NoRows property is available in t ...Show All

• Anders Bratland Reporting Services (newbie)

  Dear all, When I choose 'Reporting Services' as Server Type from Connection Manager there is nothing in the textbox. Why My crystal ball is currently unavailable, so please give some more information what you are doing! Maybe you are talking about MS SQL Server Management Studio and that the dropdown "servername" gehts empty when you change servertype to "reporting services" I ...Show All

• chaboy Configure SQL Express to utilize Windows clustering

  We are planning to setup SQL Express on a windows os clustered environment and trying to shoot for a active-passive configuration. We know that SQL server 2005 has this ability and will be leveraging that for mission critial production applications, however there are several other apps that we intend to use internally and would like to leverage windows clustering. Has anyone done this - Should we share the INSTALLSQLDATADIR If yes, then how ...Show All

• pdx_benjamin SSIS EVent driven query

  Hi, We have 8 SSIS jobs which need to be made dependent on the arrival of a single file. All the flows need to be triggered based on the presence of a file Whats the way to do this Thanks Manish You couldI would use the FileWatcher Task to watch for the file. When it arrives, use Execute Package Task to fire off your 8 packages. To be honest, it depends on you. Do you want SSIS to ...Show All

• mk8086 Cannot connect to SQL2005

  Hi, This is the error I am getting - HELP A connection was successfully established with the server, but an error occured during the login process(provider: TCP Provider - error 0 an existing connection was forcibily closed by the remote host. (Microsoft SQL server error: 10054). I have checked the error code 10054 - at this link http://support.microsoft.com/default.aspx scid=kb;en-us;Q303120 it says it applies to SQL2000 Regards Sahil & ...Show All

• Coding_Freak Reporting Server 2000 Authentication Issue

  Hi, I have installed the eval version of Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report. Is there any way to disable this windows authentication dialouge box Regards, PS: in the viewer i gave the path of the report as http://localhost/Rerport/ABC.rdl I also tried with the ...Show All

• VistaYou A/Synchronous execution of SSIS ETL packages

  Hi I'd like to know if there's a way to control the execution of ETL packages, such that: Different packages, or at least packages that don't access the same table or database run asynchronously with respect to each other; e.g., two different packages run at the same time and If a package is called for execution more than once by different requests, force them to run synchronously, or one after the other. If this is possible, what resources w ...Show All