Answer Questions

• gpai General database quesion

  guys i have a programming question i have table called prerequsites which is like this prerequisite component                       component a                                &nbs ...Show All

• Sowmithri Row numbers on export

  HI I have written a script to export data from customer table to another crm package, on the export they require the first column to be numbered 1 - .... say 1000 or how ever many rows there will be. Is it possible Thanks Rich is there not a function i could use in the statement , i am not going to use dts thanks Are you talking about a batch count Or does ev ...Show All

• moondaddy Graph(Chart) showing data

  Hello I am making the switch from using MSACCESS to do required reporting to using Reporting Services to accomplish the same tasks. A requirment I have is that whenever a graph (chart) is created, it contain the underlying data in a connected and aligned data table. MSACCESS allows this by selecting the chart options and then "show data table". Is this ability included in Reporting Services in MS Visual Studio 2003 .NET If s ...Show All

• Shuklin Problem with logging/System::ErrorDescription variable

  Hi, I've come up against a problem in my error handling. I have a package-level OnError handler which is a SQL Execute task. The SQL execute task constructs a SqlStatementSource expression to insert the error details into a table. This works fine and I've tested it by introducing various errors in the package. I have another SQL Execute task, which executes a SQL script from a file connection. This is a very long script (100s of lines) and works ...Show All

• Dean Hiller To change database engine

  I setup Visual Studio .Net 2005 and SQL Server 2005 express edition is installed with Visual Studio .NET 2005. Then I intalled SQL Server 2005 Standard Edition. When I looked at SQL SERVER Surface Area Configuration my database engine is shown as SQLEXPRESS. I want to use SQL SERVER 2005 standard edition and want to change my database engine to sql server standard edition. Can you help me I have the same p ...Show All

• Npotnis Cluster Node not running all databases

  Hi, We have had problems with a SQL server cluster. As a result of this we have been advised by our SAN hardware manufacturer to replace the Win 2003 servers with Windows 2000 servers. I have replaced one server, and it will successfully host all of the databases in the cluster except one. We see the following errors in the Application Event Log on the Windows 2000 server when we try to move this virtual server onto the Windows 2000 server: ...Show All

• Hyresse Backup & Restore encryption key

  Hello!   I started Configure Report Server (2005) and have executed backup of the encryption key. Problem occurred on restore of the encryption key as following error (I have provided correct backup snk):   ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.39'. The expec ...Show All

• SudeepNambiar Store the output of executesq

  hi I am trying to store the output of sp-executesql into a variable to implement it as a user defined function later The function is ALTER function [dbo] . [UnitsAvailable] ( @id int ) returns int as begin declare @sql nvarchar ( 100 ) declare @params nvarchar ( 500 ) declare @count nvarchar ( 10 ) set @sql = N 'Select count(*) from units where projectid=' + convert ( varchar , @id ) + ...Show All

• JPCat enabling/disabling query optimizer

  I would like to run some tests to measure the performance gain through the query optimizer. Is it possible to turn off the query optimizer Is there any command line switch or SQL operator for that   This is not possible. You can however write the SELECT statement or query with hints that force join orders or specific type of joins. See SELECT statement topic for more details. ...Show All

• Ian Sugar What are the performance characteristics of RDA?

  I have a server table containing a field of filenames and a field of type IMAGE containing large .tiff bitmaps, which I wish to pull via RDA down to my device connected by ActiveSync on it's cradle in a "refresh the device" scenario.  Is there anything anyone knows about the way in which RDA performs in this scenario about which I need to be concerned   Performance seems to drag to the extent that I'm reluctant to perform anymore ...Show All

• UNOTech about error

  My Reportingservice can be used no longer. when i open an existed project or new a project,Error is as follows:the application of This project's class(.rptproj) is not installed. How should i do when i run a project with not connectting to the internet,the error displays the first time.Then all time is the error. I am not sure what exactly happened. It could be some registry got corrupted. You can try to reinstall or repair "B ...Show All

• maklouf Help creating Embedded code Function

  How can I create a VB.NET function to run my query below that my SSRS report can run to retreive TotalPostingDays so I can show that in a textbox in my report   I need help creating the function in the Report properties of my SSRS report and not sure how to call this stored procedure to return TotalPostingDays.   I need to do this calculation by using a UDF, not stored procedure maybe.  The problem is, I do still need t ...Show All

• AlexZander This message could not be delivered because it is duplicate

      When I send message from Server1 to Server2,I found the error "This message could not be delivered because it is duplicate" in SQLProfiler on Target, why message can be duplicate who can help me     My environment is :     Instance1 on Server1,Instance2 and Instance3 on Server2,Instance1 and Instance2 is a sqlserver2005 cluster,message is sent from Instance1 to Instance3. That means ...Show All

• Chaxtor how do I determine how many columns there are in a file?

  Hi, I have a few different files in a directory. I want to take each file and determine which columns and data types it has. How can I know how many columns there are in a file Thank you. one way is to start a new project in vs as ssis right click over solution explorer->SSIS Packages and select import and export wizard select your flat file as source and destination as server, by ...Show All

• golfkeelo RMO On Sql Server 2000

  Hi. I'm using RMO to connect to a MSSQL 2000 Server to manage replication. I've successfully connected to the server, created the distributor, publication, articles and subscriber. However, when i try to manage the agents (ie. TransPublication. StartSnapshotGenerationAgentJob ) it says the method is only supported on MSSQL 2005. Is there any way I can control the agents from RMO on sqlserver 2000 Tore Birkeland ...Show All