?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - about update sureshv wrote: when transfering data from text file to sql server using dataflow how can i update a record if it exists.Is it not possible to use or call stored procedure in the dataflow. please let me know Explained here: Checking if a row exists and if it does, has it changed ( http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx ) -Jamie Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 2
    - printing error Can you login as an admin and print a report I believe that the first time you try to print any report, it installs the print controls. Then you can log off and let the user back in. This way, the print controls would be installed for the user the next time they need to print. Hope this helps. Jarret Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 3
    - ODBC Connection Fails from cluster node What's your connection string The server name must have been changed (from the machine name to cluster network name resource name). Have you changed it in your conn string Is it a default instance and named instance Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 4
    - SQL Server 2005 - Building a development Server For this purpose, I suggest something similar to a 2.0 or higher dual core CPU, 1 GB memory (2 GB would be better), 80GB or larger SATA 7200 rpm disk. Somethink like a Dell 520 desktop would work just fine. You won't need a monitor/keyboard/mouse -you will be using a KVM (get a four port KVM to allow for future additions). For your purposes, RAID seems overkill. If the data is critical (unlikely in a DEV environment), you could get a second drive and use the OS mirroring capability. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 5
    - Silent install using VBScript If you need to collect information about the install, you will need to do it before launching the command line install and then build the command line string yourself. If you know your configuration, you can make the standard setup.exe <parameter list> call from your VBScript. Thanks, Sam Lester (MSFT) Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 6
    - Sql Server Reporting Services 2005 returns 404 not found Rob, Do you have SQL Installed as the default instance or a named instance Also, is anything logged in RS or Event Viewer that may lead to the problem -Bret Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 7
    - exception handling - best practices It is a delimma. Constraint failures cause block failure and unfortunately, cannot be handled by TRY...CATCH. On the other hand, IF EXISTS causes two database hits (twice the network traffic) for every insert action. And it doesn't completely protect against the possibility that a conflicting row is not created by another user between the check and the insert. I often see that the most used option is to allow the application to handle the constraint error -it is passed back to the connection object. When it is a situation of inserting a new row or updating an existing row, I have often issued the UPDATE command, then check the @@ROWCOUNT and if it is zero, then do the insert. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 8
    - Scheduling an automatic backup You need to explore how to use the Windows Scheduler service. (And that is beyond the scope of this forum.) OR, You may wish to explore this option: http://www.codeproject.com/vb/net/SQLAgent.asp Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 9
    - Using Integrated Security from .Net Web to access SQL Server 2005 Well, that depends. Using SQL Server 2005 and Windows Server on different boxes, you will have to setup delegation and a server principal name within your AD. having them on the same box and in additin if the above option applies, you will have to set the web.config security part < identity impersonate="true" /> Remember that this only works if you set the virtual directory for Windows Authentication. using Anonymous access will use the specified account to logon againstg SQL Server. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 10
    - Accessing the underlying sql query from the rdl file After attempting to autogenerate serialization classes on the SemanticQuery xml with Xsd and XsdObjectGen, I ended up hand coding some classes that handled recursion. From there, I was able to regenerate the sql query by walking through the filter and grouping sections. While this isn't a generic solution, it works well for my needs because the model I need this for is a single datasource derived from a view. As a feature request, it sure would be nice to be able get the query string from the reporting engine directly. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 11
    - IBM DB2 as Data Source You want an OLE DB provider for DB2, available from both MS or IBM. The Microsoft OLE DB Provider for DB2 is available with SQL 2005, but is a separate download. Feature Pack for Microsoft SQL Server 2005 - February 2007 - Includes Microsoft OLE DB Provider for DB2 http://www.microsoft.com/downloads/details.aspx FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en You may want to review this KB if things are a bit slow - http://support.microsoft.com/kb/918362 Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 12
    - Reporting Services 2005 Subreport issue... No, you're not the only one who needs this functionality. I have a report with 11 single cell subreports with which I would like to do some pretty basic arithmetic, however, there seems to be no way to reference the values of subreport output in Reporting Services. Why is it any more difficult to reference a subreport value than a textbox value, considering that you can embed a subreport in place of a textbox ! This really is disappointing as it's a pretty basic requirement, sort it out Microsoft! It's about time you listen to what your customers want from a product rather than dictating to them what they can have. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 13
    - SSIS Data Conversion: Convert a String (like yyyymmdd) into Datatype dt_DBDATE or dt_DBDATE Please search this forum... Plenty of examples dealing with this exact topic. You'll need to use a derived column and substrings on your date field to build it so that it looks like this: mm/dd/yyyy Then around all of the substrings you can perform your cast. (DT_DBDATE)(substring............) Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 14
    - SQL Compilation and execution plan Please look at this MSDN article in order to find out more about what's causing your recompiles: http://support.microsoft.com/kb/308737 If you're still facing problems it would really help to give us a simple script that illustrates your problem (table schema & exact queries). Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 15
    - SQL Reporting Services - Page X of XX counts in header Would using the number of detail items for that invoice give you that answer IOW, figure out how many are going to fit on a page Or does the row height expand differently for each invoice line (because of a long description or whatever) If the rowheight does not expand, then I'm thinking you can use CountRows() with the scope argument limited to your invoice. What do you think >L< Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 16
    - Export to Excel Hello Mahima, You need to make sure that everything in your report lines up, this includes objects in your report header and footer. When objects do not line up, it creates a column so that the excel export looks like the actual report (or as close as it can). Hope this helps. Jarret Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
- Next
  - 1
    - Layout question An inclusion to this question: we see that a tables Location property's value cannot come from an expression because this is exactly what we want to do; however we can pad a table using an expression. We need to locate the Credits table based on the number of rows from the Charges table. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 2
    - Flat File Data Source with variable number of delimited columns No. The only thing you can do is read in each line as one big record and then maybe use substrings or something to pick apart the files. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 3
    - Stuck on a Inner Query here it is.. Modified.. SET DATEFORMAT DMY Create Table #person ( [PeopleId] int , [DOB] datetime ); Insert Into #person Values ( '100' , '23/2/1990' ); Insert Into #person Values ( '101' , '12/12/1968' ); Insert Into #person Values ( '102' , '1/1/2000' ); Insert Into #person Values ( '103' , '12/12/2003' ); Create Table #episode ( [Episode] int , [People] int , [Start_Date] datetime ); Insert Into #episode Values ( '45' , '100' , '30/01/2003' ); Insert Into #episode Values ( '46' , '100' , '12/01/2007' ); Insert Into #episode Values ( '47' , '101' , '01/01/2002' ); Insert Into #episode Values ( '48' , '103' , '19/2/2007' ); Select * from #Person Where DateAdd ( YY , 18 , Dob ) > getdate () And Exists ( Select 1 from #episode Where DateAdd ( MM , 12 , Start_Date ) > Getdate () And [PeopleId] = People ) Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 4
    - help with WHERE clause Try the code below. Chris Code Block SELECT * FROM Users WHERE (( @Username IS NULL) OR (( Username = @Username ) OR ( Username LIKE N'%' + @Username + N'%' AND NOT EXISTS ( SELECT 1 FROM Users u2 WHERE u2.Username = @Username )))) Code Block --Example with results DECLARE @Users TABLE ( ID INT IDENTITY ( 1 , 1 ), Username VARCHAR ( 20 )) INSERT INTO @Users SELECT 'Admin' UNION ALL SELECT 'Administrator' UNION ALL SELECT NULL DECLARE @Username VARCHAR ( 20 ) SET @Username = NULL SELECT * FROM @Users WHERE (( @Username IS NULL) OR (( Username = @Username ) OR ( Username LIKE N'%' + @Username + N'%' AND NOT EXISTS ( SELECT 1 FROM @Users u2 WHERE u2.Username = @Username )))) /* ID Username 1 Admin 2 Administrator 3 NULL */ SET @Username = 'Adm' SELECT * FROM @Users WHERE (( @Username IS NULL) OR (( Username = @Username ) OR ( Username LIKE N'%' + @Username + N'%' AND NOT EXISTS ( SELECT 1 FROM @Users u2 WHERE u2.Username = @Username )))) /* ID Username 1 Admin 2 Administrator */ SET @Username = 'Admin' SELECT * FROM @Users WHERE (( @Username IS NULL) OR (( Username = @Username ) OR ( Username LIKE N'%' + @Username + N'%' AND NOT EXISTS ( SELECT 1 FROM @Users u2 WHERE u2.Username = @Username )))) /* ID Username 1 Admin */ Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 5
    - SQL in OLE DB Use the Lookup Transformation. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 6
    - Unused Connection Managers A work around could be to use SQL Server based package configuration; you will have an entry on the config table for each configuration. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 7
    - Please help me SSIS... As you've probbaly seen already, the toolset in SSIS is much larger and much different than is DTS, but once you get your hands dirty, you'll probably never want to go back. With that said, can you please share a little more data about the "transforming these data from these tables" from your post Depending on the details of what you need to do, different solutions may be feasible. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 8
    - How to debug database engine stored procedures on SQL Server 2005? No Query Analyzer anymore. The debug functionality has 'moved' into Visual Studio. 1. Try this resource: http://msdn2.microsoft.com/en-us/library/ms165034(VS.80).aspx 2. Print statements show in the 'Messages' pane. 3. Yes, cursors still function the same. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 9
    - using uniqueidentifier datatype Here the sample, Code Snippet create table mytable ( id uniqueidentifier default newid () primary key nonclustered , name varchar ( 100 ) ) Go Insert into mytable ( name ) values ( 'Mani' ) Go 20 --remove the number 20 after go, if you execute it on SQL Server 2000 Go select * from mytable Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 10
    - Error 18210 Backup up SQL Server 2005 Database to network drive Well, backing up to networks drives is not officially *supported*, thats why the browser only display the local drives. The reason for that and the logical explanation why you shouldn��t do that is, because the network is less reliable than local drives. If you want to make sure the database is backuped to network, you will have to either make sure the windows where the backups are streamed to the network don��t interfer with each other or you use a local backup to a drive and copy the files later over. Thats the most reliable option beside using a NAS / SAN. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 11
    - Adding records I think you will have to rewrite your code to use a SqlCeResultSet instead of a ADODB.RecordSet if you want to use funtionality similar to .AddNew. For a example using using SqlCeResultSet.CreateRecord and using the SqlCeUpdateableRecord, see http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlceresultset.createrecord.aspx Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 12
    - Value of next record You can do this way because a dataset field is nothing but an array of values: Fields!YourField.Value(RowNumber( "DataSet1" )+1) but make sure you check for the last record as it will give error when it reaches last record. Shyam Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 13
    - Date filter in MDX Filter is not really an efficient way to do this, if possible I usually try to populate drop down lists of members in reports, but sometimes this is not always practical. Have you tried converting your comparison values to dates as well FILTER([Reservation Search Log].[Reservation Search Log].ALLMEMBERS, CDate([Reservation Search Log].[Reservation Search Log].Properties( "Simple Insert Date" ))>= CDate("2/6/2007") --'2/6/2007' AND CDate([Reservation Search Log].[Reservation Search Log].Properties( "Simple Insert Date" )) <= CDate("2/7/2007") --'2/7/2007' Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 14
    - ADO:Dispaly Limited Records It sounds like you want to further refine the results of the qrymillcgetbytype query...In this case, I wouldn't expect appending an additional where clause to the query name to be parsed correctly. One suggestion that might work is to use something like: SELECT * FROM qrymillcgetbytype_app WHERE <your where clause here> Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 15
    - Property DefaultSchema is not available for Database [DatabaseName] this is by design. Group cannot have a default schema, since no principal can have group as its primary id (as opposite to group id). Consider following: windows user1 is added to windows group1 and group2. If both of them are allowed to have default schema what default schema user1 has then Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
  - 16
    - Performance In Simple Scenarios Synchronous audit has to do one database write (one insert). Asynchronous audit has to do at least an insert and an update (the SEND) plus a delete (the RECEIVE) and an insert (the audit itself), so that is 4 database writes. If the destination audit service is remote, then the sys.transmission_queue operations have to be added (one insert and one delete). So clearly there is no way asynchronous audit can be on pair with synchronous audit, there are at least 3 more writes to complete. And that is neglecting all the reads (like looking up the conversation handle etc) and all the marshaling/unmarshaling of the message (usually some fairly expensive XML processing). Within one database the asynchronous pattern is apealing when the trigger processing is expensive (so that the extra cost of going async is negligible) and reducing the original call response time is important. It could also help if the audit operations create high contention and defering the audit reduces this. Some more esoteric reasons is when asynchronous processing is desired for architecture reasons, like the posibility to add a workflow triggered by the original operation and desire to change this workflow on-the-fly without impact/down time (eg. more consumers of the async message are added, the message is schreded/dispatched to more processing apps and triggers more messages downstream etc etc). If the audit is between different databases even within same instance then the problem of availabilty arrises (audit table/database may be down for intervals, blocking the orginal operations/application). If the audit is remote (different SQL Server isntances) then using Service Broker solves the most difficult problem (communication) in addition to asynchronicity and availability, in that case the the synchrnous pattern (e.g. using a linked server) is really a bad choice. Tag: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

Bob Hodgman

I've read about this hotfix at http://www.kbalertz.com/Feedback_933097.aspx but I can't find anything on microsoft.com about it. It sounds like a worthwhile hotfix, but I'm wondering about the absence of an announcement on microsoft.com.

Anyone else know about this hotfix

Thanks!

Top

Re: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

Peter Saddow MSFT

The knowledge based article is at http://support.microsoft.com/kb/933097, Cumulative hotfix rollups aren't generally announced as much as other release since they are really only needed by customer experiencing problems that the hotfix addresses.

Thanks,

Peter Saddow

Top

Re: ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

ts11

How can I obtain the hotfix without cost All support options for obtaining indicate I will be charged.

Thanks in advance.

Top