Answer Questions

• Adam Cogan Is it possible to execute a container regardless of the checkpoint file?

  I have a situation where I need to make sure a task executes regardless of whether the package starts from a checkpoint or not. Is this possible Here's the scenario: I have a package with 3 tasks {TaskA, TaskB, TaskC} that execute serially using OnSuccess precedence constraints. The package is setup to use checkpoints so that if a task fails the package will restart from that failed task TaskA is insignificant here. TaskB fetch ...Show All

• salmanpirzada Visual Studio 2005 - "Generate Create Script" for SQL 2000 stored procedure

  Hello. I have noticed that "Generate Create Script" feature changed in VS 2005 (compared to 2003). In VS 2003 this feature was displaying dialog window where I could choose some options on what to include in script and where to place it. In VS 2005 this feature just creates SQL script in "Create Scripts" folder, without any intermediate dialog, and now it uses sp_executesql procedure in a script. Is there any way to change this ...Show All

• RichardCheshire Implementing message queue in SQL Server 2000

  I am implementing a message queue system in SQL Server 2000. My queue table looks something like this: [MessageId] [uniqueidentifier] NOT NULL, [MessageType] [uniqueidentifier] NOT NULL, [Status] [tinyint] NOT NULL, [SubmittedTime] [datetime] NOT NULL, [StartTime] [datetime] NOT NULL, [DispatchedTime] [datetime] NULL, [CompletedTime] [datetime] NULL, [MessageData] [image] NULL This is how I retrieve the next message for processing: SELE ...Show All

• SuryaGopi Streams in SqlFunction

  I am trying to use System.IO.Compression to compress/decompress the buffer. I have the data in byte format in sql server and I need to create an CLR user defined function. I have everything running except that for some of the files, the compressed size is larger than the actual file size. I tried to use both Deflate and GZip compression types. Did anyone face the similar situation. Thanks in advance for your help. ...Show All

• DaveSimmonds DB Owner & SqlDependency Problem

  I deleted the account owning Test Database after creating Test Database. Everythings work well except SqlDependency. SqlDependency OnChange Event is not working. I have tested SQL 2005 ent RTM & VS 2005 Pro RTM. I'm curious why it happened. Thank you. SqlDependency needs the EXECUTE AS infrastructure to do it's work. If the account that created the database was deleted, EXECUTE AS user ' ...Show All

• kyle_song sql server 2000

  This is my last attemp at trying to install sql server installed, which its been quite reluctant too, as I've spent the last 2 hours with no progress. I've downloaded MSDE2000A.exe from http://www.microsoft.com/downloads/details.aspx FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en Installed it in the default directory. "C:\MSDERelA" And ran setup which returned this error "A strong SA password is required for securit ...Show All

• J-Thread Successful Job that doesn't run? HELP

  Hello, I have a Job that runs a DTS package. This package in turns call several other packages. All individual packages run fines. When the main package is run manually it also runs fine. The jobs that calls the main package should be runnning for at least a couple of Hours maybe more and updtae several tables. It actually run nightly for only 20 minutes and doesn't update any tables. Yet it is in "successful" Any thougts ...Show All

• Cordell Lawrence When comes Sql26k?

  Dear fellows, I wonder how long for the upcoming Sql Server 2006 Thanks in advance Hi, katmai (this is the code name for the next release is targeted for 2007/2008). So this is yet a long way to go :-) Enjoy SQL2k5 meanwhile :-) HTH, Jens Suessmeyer. --- http:/www.sqlserver2005.de --- Thanks Yes, I do it. From 6.5 to 7.0 migration I don't remember so many fun in my career...And ...Show All

• Alexei Vladychevski Install Issue with September CTP

  Hi All, I am able to install completely without getting errors.  However, when I try to start the SQL Server Services, I am getting error - "Could not start the SQL Server Service on Local Computer".  I searched further and find it odd that there's no such folder name "MSSQL.1" under Program Files\Microsoft SQL Server\.  I believe sqlservr.exe runs under this directory, so could someone explain to me why would my install be c ...Show All

• Ayazhoda SSIS and SQL Agent is WORTHLESS

  I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start. To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package. The job will run under the "executing" status until I stop it manually. Does anyone have any idea why it might be doing this ...Show All

• Darkbob Backup of tables

  Hi Guys, I would like to take a backup of tables and further use them for manipulation purpose.   (e.g.)           Select * into arc_employee_ 07_07_2005 from employee   Where 07_07_2005 is formatted from getdate(). How can i achieve this formate. Thanks in advance. Hi JayaChandran i have just modified ur query to something like this. select * into Arc_Employee ...Show All

• Ralf P. SQL Server 2005/ ADO.NET 2.0 Begin Transaction Issue

  I have an application that was originally built in VS 2003 and was successfully running against SQL Server 2000 and SQL Server 2005 (June CTP).  Recently, we migrated to VS 2005 Beta 2 and are running on SQL Server 2005 (June CTP) exclusively.  Since the migration, we have some situations where we receive the following exception when attempting to begin a SQLTransaction: Exception Type: System.Data.SqlClient.SqlException Number: 3988 M ...Show All

• gabrielh How to suppress the subreport when there is no data in it?

  Since there is no way to pass value from subreport to the main report, how to suppress the subreport when it is blank Thanks. Can you explain your scenario in more detail please The closest you can get right now is to have the subreport queries in the main report and then determine the visibility of the table row in the main report based on the CountRows("DataSetName") aggregation result. ...Show All

• gwc Moving or rolling average, how to?

  Hi everyone, Just wondering how to do a 12 mth moving average in a matrix or graph (both would be great!). Does anyone have a custom function for this, or is there an easier way thanks, 99 Hi Joel, thanks for the reply :-) I am using a BI project with report project getting data straight from SQL server - no ETL or cubes. Can't seem to find any templates for the report projects. Any other ...Show All

• Stephen Joseph is this possible in SSIS?

  I got a OLE DB source pointing to 1 table and 1 flat file destination. currently this is how i export data from 1 table to 1 flat file. To make things easier, I was wondering whether i can have only 1 OLE DB source pointing to few tables pointing to few file destinations so I dun need to create 1 SIS project for each table data exporting. anyone can help me Brohans, In this scen ...Show All