Answer Questions

• Chris Lerew Update status from one DB to another with same table schemas

  I have 2 tables (master and masterbackup), trying to update and replace the status in one with the other based on master.number match UPDATE master m set m.status = (SELECT status from masterbackup where number = m.number ) FROM mastermasterbackup If you want to use the standard syntax because this needs to run on multiple platforms, you will have to make a few changes (untested, but this should be close): UPDATE master set master. ...Show All

• giantpanda77 SSIS Tutorial - Package configuration problem

  I've been working throught the SSIS tutorial but have a problem with the package configuration lesson.  After exporting the required object to the file the completion step shows: Name:  Configuration 1 Type:  Configuration File New configuration file will be created. File name:  C:\Documents and Settings\Andrew\My Documents\Visual Studio 2005\Projects\SSIS Tutorial\SSIS Tutorial\SSISTutorial.dtsConfig Properties:  &l ...Show All

• John Brownell Raw files - create once

  Hi, I try to add multiple files to a raw files. I use a loop for it and set the write option to "create once", so that the file should be created when the package is started and files are appended as they flow to the destination... However I always get an error when I try to add the second file that the raw file already exists... Well, I expect that it exists but I don't expect this error because that's not the intended behaviour! ...Show All

• DLSeth Time Dimension - Attribute Hierarchy

  I have a Time dimension built from Dim_Time Table.Dim_Time table structure as follows : TimeId int]  IDENTITY ( 1 , 1 ) Hour          tinyint Minute       tinyint Second      tinyint TimeId      Hour            Minute     &n ...Show All

• Martha Wieczorek Unable to use Books Online search function

  I am unable to use the search feature in Books Online.  Every time I click the "Search" button, I get this error message: Package "Visual Studio Common IDE Package" failed to load Anyone have any ideas on what might be causing this error I am having the same problem with RTM (Developer edition) code. I have tried    a) uninstalling the entire build of SQL Server 2005    b) yo ...Show All

• Samuel Chen SQL Server 2005 Express: Weird error message running SELECT COUNT query

  When running the following query on table RECORD using an existing SQL Server 2005 Express catalog: SELECT COUNT(*) FROM Record; I get the following error message right from the ODBC's executeSQLStatement(...) line: [Microsoft][ODBC SQL Server Driver][SQL Server]Der Operanddatentyp image ist fur den count-Operator ungultig. (english: The operand data type image is invalid for the count operator) Running the exact same query in ...Show All

• Andy Deng How to drop users programmatically through a sp

  Hi, I want to drop users programmatically, is this possible I tried create PROCEDURE [dbo].[sp_DelAllUnusedLogins] AS BEGIN SET NOCOUNT ON; DECLARE @UserName nvarchar(128) DECLARE user_cursor CURSOR FOR select name from sys.sysusers where status=12 and name not in ('NT AUTHORITY\SYSTEM','dbo') OPEN user_cursor FETCH NEXT FROM user_cursor INTO @UserName WHILE @@FETCH_STATUS = 0 BEGIN DROP USER @UserName FETCH NEXT FROM user_cur ...Show All

• Ibheri Moving from 2000 2005 SP with Cursor Errors

  I am in the process of moving some of my company's internal reporting from 2000 to 2005. Part of that includes moving some stored procedures and migrating DTS to SSIS. The problem I am having is with stored procedure - which I will refer to as SP1. SP1 calls second stored procedure (SP2) SP2 returns a cursor SP1 then opens a cursor and loops though the cursor returned by SP2. When I run SP1 I get the following error: Msg 169 ...Show All

• hypodyne TSQL UNION, but get the differance in dollar amount in the result

  GridView_1 Category Name SubCategory Name Amount Construction Construction 2,877.00 Design Design 0.00 Soft Cost Inspection 0.00 GridView_2 Category Name SubCategory Name Amount Construction Construction 2,800.00 Construction Contingency 300.00 Design Design 500.00 Soft Cost Inspection 980.00 Soft Cost Surve ...Show All

• jasontehpirate Programmability of parameter bar(layout/items)?

  Hi all, does anybody of you know how to code and customize the parameter bar of the SSRS reports I know about putting code behind expressions but how is it with parameters How is it possible to... 1. define the layout of the parameter bar and the positions of the parameter items 2. make the parameter items user-specific Is it possible to define a report with the report designer and hand over data (parameters) by code-behind or a referenced ass ...Show All

• Room222 CLR Performance

  We had a CLR function that was running in seconds under the April CTP - now it takes over a minute in the new Sep CTP.  We've determined that the bottleneck is in the following line: Dim SqlConn As SqlConnection = New SqlConnection( "context connection=true" ) Is there a new recommended way to open a connection I tested running your function 15,000 times on a post-CTP16 build and it executed qui ...Show All

• Closer SQL Job setup to run SSIS 2005 Package is Failing

  I keep getting a failure when trying to run my agent which is trunning an SSIS 2005 package.  I have checked the logins and appear to have given the right logins owner to the msdb database and my other databases but still getting this error: 03/09/2006 10:13:31,Run EBN Process,Error,0,BG-22SQL,Run EBN Process,(Job outcome),,The job failed.  The Job was invoked by User domain\myuserid.  The last step to run was step 1 (Run EBN SS ...Show All

• TimHa Failed SQL 2005 SP1 installations (Hotifx.exe crashes)

  I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files: Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL ...Show All

• MartinNorfolk Reporting Services Error

  I receive the following error, 'External component has thrown an exception. (rsRPCError)' , when I do http://servername/reports  or http://servername/reportsserver . Has anyone seen this type of error Thanks,  Edwina This issue has been resolved. I am pasting the error from the rporting services logfile. w3wp!library!1!8/31/2005-00:01:57:: e ERROR: Throwing Microsof ...Show All

• Darin Spence Execute SSIS Package in C# (ErrorMessage ??)

  Hi all I am executing a SSIS Package in C# (2005). Does anybody know how to find out, in case of an error, the error message I am doing the follwoing: Microsoft.SqlServer.Dts.Runtime. Package local_Package = new Microsoft.SqlServer.Dts.Runtime. Package (); Microsoft.SqlServer.Dts.Runtime. DTSExecResult local_DTSExecResult = new Microsoft.SqlServer.Dts.Runtime. DTSExecResult (); Microsoft.SqlServer.Dts.Runtime. Application local_Appl ...Show All