SQL Server SP2 Command Line Upgrade Switch and Express Version Detection

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Query problems - Group By and Latest date Is the serial number of the part in the same table - if so presumably it is different for each time that part is replaced. You can use a nested query to get that - however it will run into a problem if there are multiple records with the same date. As it stands at the moment you could not distinuish between them. If you had records: SerialNumber Param1 TimeStamp Part_SN 0 Part1 15/03/07 1234 0 Part2 15/03/07 1235 0 Part2 16/03/07 1236 0 Part2 16/03/07 1237 0 Part3 15/03/03 1238 How would you know which of the two Part2 items fitted on 16 Mar to give the serial number of If there are additional fields to determine this then we need to use them If this does not arise then the query below should serve (substitute correct fieldname for Part_SN): SELECT B.[SerialNumber] ,B.Param1 ,B.[TimeStamp] ,B.Part_SN FROM ( SELECT [SerialNumber] ,Param1 ,MAX([TimeStamp]) AS TimeStamp FROM [Build Efficiency System].[dbo].[SSIS_SCANNERDATA_TBL] WHERE Test = 'T120' GROUP BY SerialNumber, Param1 ) A INNER JOIN [Build Efficiency System].[dbo].[SSIS_SCANNERDATA_TBL] B ON (A.[SerialNumber] = B.[SerialNumber]) AND (A.Param1 = B.Param1) AND (A.[TimeStamp] = B.[TimeStamp]) AND (B.Test = 'T120') ORDER BY B.[SerialNumber] If this is a problem then you will get multiple records in that case - one for each serial number. If the TimeStamp is a datetime which includes the time of the replacement then this will not be an issue (as long as the required serial number is the last record. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 2
    - Reporting Service Cache I enable cache for that rdl say 60 min means execution cache for that report i haven't enabled session cache coz i not displaying my rdl in browser i use Reporting Service webservice methods to accesses and render report code ------------------------------------------------ Private Sub RptRender2(ByVal paramName As String, ByVal paraVal As String) Dim rs As New ReportExecutionService() rs.Credentials = System.Net.CredentialCache.DefaultCredentials rs.Url = " http://localhost/reportserver/ReportExecution2005.asmx " ' Render arguments Dim result As Byte() = Nothing Dim reportPath As String = "/PanelPayments/EvalRpt2" Dim format As String = "EXCEL" Dim historyID As String = Nothing Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>" ' Prepare report parameter. Dim parameters(0) As WindowsApplication2.ReportExecution2005.ParameterValue Dim credentials As WindowsApplication2.ReportExecution2005.DataSourceCredentials() = Nothing Dim showHideToggle As String = Nothing Dim encoding As String = "" Dim mimeType As String = "" Dim warnings As WindowsApplication2.ReportExecution2005.Warning() = Nothing Dim reportHistoryParameters As WindowsApplication2.ReportExecution2005.ParameterValue() = Nothing Dim streamIDs As String() = Nothing Dim execInfo As New ExecutionInfo Dim execHeader As New ExecutionHeader() Dim SessionId As String Dim extension As String = "" Dim arrList As New ArrayList arrList.Add("1") arrList.Add("2") arrList.Add("3") arrList.Add("4") rs.ExecutionHeaderValue = execHeader execInfo = rs.LoadReport(reportPath, historyID) Dim i As Integer Try For i = 0 To arrList.Count - 1 'set parameter paraVal = arrList(i).ToString() parameters(0) = New WindowsApplication2.ReportExecution2005.ParameterValue() parameters(0).Name = paramName parameters(0).Value = paraVal rs.SetExecutionParameters(parameters, "en-us") 'get sessiion id SessionId = rs.ExecutionHeaderValue.ExecutionID Console.WriteLine("SessionID: {0}", rs.ExecutionHeaderValue.ExecutionID) 'render the result result = rs.Render(format, devInfo, extension, _ encoding, mimeType, warnings, streamIDs) execInfo = rs.GetExecutionInfo() Console.WriteLine("Execution date and time: {0}", execInfo.ExecutionDateTime) ' Write the contents of the report to an MHTML file. Try Dim sFilePath As String = "C:\Paypal\out\Summary" & paraVal & ".xls" Dim stream As FileStream = File.Create(sFilePath, result.Length) Console.WriteLine("File created.") stream.Write(result, 0, result.Length) Console.WriteLine("Result written to the file.") stream.Close() Catch e As Exception Console.WriteLine(e.Message) End Try Next Catch e As SoapException Console.WriteLine(e.Detail.OuterXml) End Try End Sub ---------------------------------------------------------------------------------------------- when verifed the report Execution log table it shows same parameter value except first 2 thanks Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 3
    - Newbie Parameter Problem cool ... all the best Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 4
    - Backup Database HI i have created job which executes following Store Procedure, my Qs is after 1-day has passed shldnt it overwrite , i mean i have 1-GB Database my job runs for 3-times a day so end of day i have 3-GB so wen time goes past 12.00 am shldnt it becomes 1-GB again Alter Procedure sp_DBBackup as BACKUP DATABASE [XYZ] TO DISK = N'D:\Office Purpose\Database\Backups\XYZ\Backup-Method (Append-Expiry)\XYZ_Complete_Append.Bak' WITH NOINIT , NOUNLOAD , RETAINDAYS = 1, NAME = N'XYZ backup', NOSKIP , STATS = 10, NOFORMAT Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 5
    - RESTORE DATABASE hunchback wrote: 1 - Try executing SSMS as the administrator account. You know, right click - Run as administrator, then try to do the restore from SSMS 2 - If point 1 did not work, then execute first: restore headeronly from disk = ... This will give you the list of backup sets in that device, the type, etc. Choose the backup set you are interested in (position), let us say 3, then execute: restore filelistonly from disk = ... with file = 3 to see the list (logical and physical) files in that backup set, then apply the "restore database" and use the logical names with the option "move" to move the physical file names to a specific folder. Let us know how it goes. AMB Thank you very much, I appreciate this. Running as Administrator (which curiously I've done before a number of times, although not with SSMS) resulted in this: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore failed for Server 'DDMNVT61'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Stoxx\intraDay.mdf'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ IN other words it is the same stuff. I want to make sure that I am not creating a wrong impression about Vista. In a week or so with it I simply fell in love with it and will never go back to XP. It is a wonderful OS in many respects. I was forced to installl it when I lost my Internet conn in XP and could not restore it in a week. I had all my dev work in there. Installation was a piece of cake. My network showed up in a blink as before with XP and 2K I had to spend hours troubleshooting it and frequently would just give up. But this security stuff is just too much. It is an overkill. They overdid it. I actually do have a workaround in mind. What I need is just my stored procedures. I have never done restore before and now I am beginning to realize that the SP's will not be resurrected. Right I am planning to go back to XP, copy all my SP's and reCREATE then in here (in Vista's SSMS). I actually can live without the data but cannot live without the tables since a number of my apps are trying to dump some records in them and the DB is not there. I get exceptions. My stored procedures automatically create the tables if they are not found and also create other stored procedures to insert and update records. It has been working for a long time. It is the least of my worries. What I really need now after I comprehended the threat: I need to understand how I can do RESTORE in case when I really need it. You guys should take care of it please. It is just scary. I will try the second method and will report back. Please, find out how those messages could be cancelled. It may be a bug. I do not know. It is not the first time I had to struggle with them. Somehow I could work around them when I copied my folders to Vista and could not attach DBs to SSMS for the same reason. It took two days to find out. Other people helped but this situation is different. Thanks. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 6
    - problem with recursive cte query I am running into 2 problems with this cte query. First off, it's not returning the results in the right order. What I mean is that, as you can see from the graph, the first row (tabid=4) should be followed by rows 3,4 and 5 but it's throwing in a row between. No matter how I try and order the results, it's not working as it should. The tabindex field is a user defined field as to what order the tabs should show up for the user so I have to order by that field at some point. ParentTabId TabId Title Link TabIndex 1 4 Personal Info /Employee/employeeAdmin.aspx 1 1 5 Employment Info /Employee/positionInfo.aspx 2 4 8 Dependents /Employee/dependents.aspx 3 4 169 Emergency Contacts /Employee/Contacts.aspx 2 4 170 Demographics /Employee/EmployeeAdmin.aspx 1 1 172 Employment Files /Employee/empFiles.aspx 3 172 210 New Hire Paperwork /Employee/empFiles.aspx 1 172 211 Form I-9 /Employee/I9.aspx 2 172 212 General /Employee/employment.aspx 3 172 213 Notes /Employee/notes.aspx 4 172 214 Pre-Employment /Employee/preemployment.aspx 5 172 217 Protected Health Information /Employee/protectedhealth.aspx 6 1 220 View All /Employee/viewAll.aspx 4 Problem 2 is that I need to format all of this as heirarchal xml but when I output it as xml in the query itself, every element is coming through as MainTabs (the cte name) instead of nesting rows 3,4 & 5 under tab id 4. So, how do I (if it's even possible) fix these two things If I can't do this in a query, how would you suggest getting an xml formatted result set from a table structure like this Structure meaning parenttabid = tabid of another row ordered by the tabid and then tabindex Thanks. with MainTabs(ParentTabId, TabId, Title, Link, tabindex) as ( select ParentTabId, TabId, Title, Link, tabindex from Tabs where parenttabid = 1 UNION ALL select t.ParentTabId, t.TabId, t.Title, t.Link, t.tabindex from Tabs t inner join MainTabs on MainTabs.TabId = t.ParentTabId ) select ParentTabId, TabId, Title, Link, tabindex from MainTabs order by tabid, tabindex Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 7
    - Request for feedback - Aliases have been deprecated for some time and will be removed soon Raul Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required. Thanks. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 8
    - Help with cupe partitioning/processing Hello guys I have an issue with one of our cubes which i hoped someone could help me with... The problem is a historical cube which is currently growing quite drastically, and includes daily history from 2004 until today. The cube is just processed full every single day, and this means processing 80+ million rows every day, when actually most of the data is not changed at all. I decided I want to split my cube in data for 2004, 2005, 2006, 2007 and then the current month. Once the current month is over then i would merge it with the year to date partition and create a new partition for the new month. My problem is how to implement the processing in a simple way Right now the processing is done in SSIS by just processing full the db, so I guessed i have to make 2 tasks, one to process full all the dimensions first , and one to process full the cubes afterwards in which i process for this specific cube only the latest partition. But this means at the end of the month I would have to change the package manually, since i need to merge some partitions and then process full only the newest partition again... Is there any simpler way of doing this Is my approach correct in the partitioning way and processing full of only the newest partition, except at the end of the month when i would need to merge and process the ytd partition Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 9
    - Problem running SSIS from C# Ted Lee - MSFT wrote: If you have other packages that work from your C# program, then it's possible something in that particular package is causing a problem (e.g. missing dependency for a task). I would try to narrow this down by reducing that package is something simpler that works (e.g. by disabling or removing tasks), then start adding back functionality until you get an error. Package runs from the C# on my desktop and runs from SQL Server from the server. It is just after moving the EXE to the server and running it on the server that the SSIS will come back as a "Failure" and bomb. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 10
    - MDX Sum distinct across specific dimensions Ah. I understand now. Let me give that I try when I get back to it in a few days and I'll respond. I already have that table set up in the data warehouse, but didn't think about trying a many-to-many relationship. Thanks again! Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 11
    - OleDB Source and Parameters Rafael Salas wrote: I agree, it is verry helpful. There are some request from the users to include and upfront visula indicator when a property is being affected by an expression. Right now, the only way know if there is an expression is digging into the expression property. That's one of the features soon to be included in BIDS Helper ( http://www.codeplex.com/bidshelper ). Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 12
    - searching similar records within a table Original Post: 4. If found return the details of the original record : Does that mean you want all the duplicates (not including the requested item) to be returned What if there is more than one Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 13
    - How to Create Assembly function using dll files in SQL Server 2005??? Hiiiiiii the exactly error message and syntax is like tht CREATE ASSEMBLY abc FROM 'C:\abc.dll' GO and the error message i m getting is: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'ASSEMBLY'. and i have also tried in sql server 2000 instance but as far as i know tht CLR Integration in SQL Server 2000 is not possible. plz plz give me solution, i need it urgently... Thnxxxxxxx Pratik Kansara Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 14
    - Database user and Corresponding login You may also want to have a look at these posts I recently wrote on this topic: http://blogs.msdn.com/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx http://blogs.msdn.com/lcris/archive/2007/09/12/basic-sql-server-security-concepts-permissions-and-special-principals-sa-dbo-guest.aspx To add to Gigi's message, dbo is not used only by sa, but by any sysadmin member as well. Thanks Laurentiu Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 15
    - Error while changing Custom Resolver between 2005 Publisher and 2000 Subscriber Hi all, here is the context of our problem: - Publisher : version SQL Server 2005 SP2 table in SQL Server 2000 (80) compatibility level publication in SQL Server 2000 compatibility level - Distributor : SQL Server 2005 SP2 - Subscriber : SQL Server 2000 SP4 + hotfixes (version 8.00.2187) There is only one article in our publication (a simple table with a GUID and a nvarchar(50) columns), and we have left the default resolver. 1 - The first synchronization of the subscription is successfully completed, and it is the same for the different updates/inserts/deletes or conflicts. 2 - Then we change the Resolver of our article by our own COM-Based Custom Resolver (developped in C# 2.0). This resolver only change the default behaviour: the subscriber always win (this is for a test, in the future we will have a complex business logic). All the synchronizations works fine and do what we want in the conflicts. 3 - We rollback the resolver to the default one... and here is the problem! The synchonizations stop to work correctly. For all of them we've got the same error: Code Snippet Replprov.dll , 2007/09/25 14:26:07.591, 4000, 16890, S1, ERROR: ErrNo = 0x80045017, ErrSrc = <null>, ErrType = 8, ErrStr = The schema script ' declare @cmd nvarchar(1000) set @cmd='exec sys.sp_MSchangearticleresolver @article_resolver=@ar, @resolver_clsid=@rc, @artid=@ai, @resolver_info=@ri' exec dbo.sp_executesql @cmd, N'@ar> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie..." mailto:N @ar">N'@armailto:N'@ar">N'@ar</A< A>> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie... It is no more possible to synchronize this subscription... Any remark will be helpfull cause we did not find anything on the net concerning this error. Thanks a lot! Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 16
    - Question on Row Count Transformation opss.... ya.... it's Row Number Transformation.. sorry for the mistake... thanks for the replies.... in this Row Number Transformation package, start number(seed) cannot be filled with expression... so can i say that this package can only be used to generate surrogate key if it's run only once thanks again... Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
- Next
  - 1
    - Datetime format for dimension Please help me Dear sir Thank you very mcuh ... for your help .. I got from your advice what I need thank u verymuch again Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 2
    - Accessing variables using file connection in Execute SQL Task Hi there, I need some help on how to access variables using a file connection... if that's not possible even direct input. I made a variable for the server name, and now I only need to know how to call the variable in the script. any help is appreciated. thanks Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 3
    - Custom Assembly Security I am still getting the following error Failed to load expression host assembly. Details: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I tried both the options below in my rssrv 1. <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="RSUtil.TranslationHelper" Description="Translation Helper Utility"> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001006369F01C85658052C70220BDCE29C0E49ACE83474C6AAE447B2C224CE2484B5FDE027D79CE0EE72A3B2222D4F170947247E46324A37EA70EE5280321AABCBED4A1D9A04E1E7158C8188944469D9372054B0A67ABCD953F369EC9A22B20B1307D3CC06215686DA65707C691C7CD3AFD2E1747C72BCFCA8F3A2D7BD8B2F73D29B3" /> </CodeGroup> 2. <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="RSUtil.TranslationHelper" Description="Translation Helper Utility"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\ReportServer\bin\AMOTest.dll" /> </CodeGroup> However both these settings didn't have any effect and the problem continued to occur. I also searched for a solution and found this article on the web by Bryant Likes http://blogs.sqlxml.org/bryantlikes/pages/824.aspx It takes about making certain assertions in the code for example.... [FileIOPermissionAttribute(SecurityAction.Assert, Read="c:\\temp\\hello.txt")] public static string HelloFromFile() However in my code I don't do any fileIO so I don't know on which file should I do the assertion. The code which I am calling contains AMO (Analysis Management Objects API) Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 4
    - inflation factor in Analysis Services 2005 Anybody knows how to apply an inflation factor depending on the date to a measure in Analysis Services 2005 The Inflation Factor is (Current Month Rate / X Month Rate) So lets say for current year the rates are Jan 121.64 Feb 121.98 March 122.244 April 122.171 For example If I want to calculate for March I would show a column for January February and March, the column for January would be multiplied by (122.244/121.64) the column for February would be multiplied by (122.244/121.98) and march by one (122.244/122.244) But in April the factors would be different I would have 4 columns, January February March and April, January amounts would be multiplied by (122.171/121.64) February by (122.171/121.98) March by (122.171/122.244) and April by one (122.171/122.171) Im using SSAS 2005 Thanks in advance Isaac Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 5
    - Error CUSTOM CODE: Function CheckSignificantDate(i as integer) as Integer Dim msg as String msg = "" If ( i = 15 ) Then msg=" Date Diff should be more than 15 Days" End If If msg <> "" Then MsgBox(msg, 16, "Report Validation") Err.Raise(6,Report) 'Raise an overflow End If End Function EXPRESSION: =CODE.CheckSignificantDate(DateDiff(DateInterval.Day,Parameters!ToDate.Value,Parameters!FromDate.Value,)) Here I am facing one more problem.In custom code if I take condition (i < 15), for each value script is raising.(i.e for every number.ex: 1,24,33,67..... ) Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 6
    - Advice on dimension-dependant KPI Goals We have KPI goals that vary based on the country or state. For instance for US Stores, the goal is 2, and for stores in NY the goal is 2.8 I can create an SQL table with KPI_Name, Country or State, and KPI_Goal. I can also generate a view that will provide the proper KPI goal for each store. What is the best practice to implement this kind of KPI I just don't know where to start. The examples I've seen are all hardcoded, like CASE when Store = XXX then 2.8 I'd rather avoid hardcoding KPI goals in the cube design as I'm expecting users to adjust goals regularily. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 7
    - Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out sp_MSmakegeneration will not return any information unless it errors out. If you want to see exactly what's going on, your best bet is to run profiler to trace it. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 8
    - Moving ReportServer Databases Sorry, but you're going to have to go back and set them up the way they were. Jarret Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 9
    - Table Join For 1 Dimension I have table join like this: Table A Table B _________ _________ | SVC_ID | ---------- | SVC_ID | |_________| |_POS | |_________| Table A is the primary table that contains every SVC_ID available. Table B will link to the SVC_ID in the Table A. Table B will not have duplicate SVC_ID's, and will not have every SVC_ID that is in the Table A. Now, my dimension is based off of Table A. I simply want to add the POS field as an attribute (showing up as Unknown/NULL when the SVC_ID doesn't exist.) The problem is that doing so limits the rows returned from Table A (only SVC_ID's that are in Table B). I tried reversing the relationship in the DSV, but AS will throw and error when trying to process. I also set the KeyNotFound setting to Ignore for the dimension. The only way I get this to work is to make a completely new dimension for Table B. Is that necessary Is there a way I can use the Table B POS field as attribute for Table A Thanks! Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 10
    - Hiding Non Empty Dimension members when using pivot tables I am working with a snowflake-type schema and I have a regular dimension that is joined to a fact table with a couple thousand unique members that represent financial instruments. I then have a reference dimension table with about 20 unique members that represent credit quality of these instruments. The typical presentation of this data is going to show the aggregated facts over this credit quality dimension but I would like to provide the ability to drill down into each credit quality sector to see the relevant instruments and their facts. When I nest the instrument dimension below credit quailty in a pivot table, it appears that I always get a full crossjoin (all of the two sets when I am really after something like a non empty crossjoin. Any suggestions would be appreciated. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 11
    - some questions about SMK The <Protect Sensitive Data Using Encryption in SQL Server 2005> said : If regenerate service master key with "FORCE" option, the keys protected by old service master key are lost forever along with the data encrypted by them. I create a master key in database and create a certificate protected by it.Then i use the certificate to encrypt some data. The master key also exists and the encrypted data can by decrypt after i regenertate the SMK with force option. So i'm puzzled,I want to know what are the keys which protected by SMK , are they database master key thanks Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 12
    - Automate backup for SQL 2005 Can you pls explain a bit more You can backup your db on this server ! have you appplied SP2 with critical update on that server in which you are unable yo view maintenance plans are you logged in with sysadmin id pls provide what is the version and edition of sql server you are using - Deepak Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 13
    - Cannot create a custom task I might get this wrong, as naming of assemblies and namespaces is not my strong suit. The type name is the namespace + the name of the public class you are referencing. So your namespace (and asembly) should be named SSISExcelExport, and your class should be named ExcelExport. I believe that it is case sensitive. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 14
    - multi-value parameter in Master report passing to single param sub-report in a list. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=164056&SiteID=1 Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 15
    - Shared datasource in different folder... Hi all, Ive tried searching but nothing came up specific to my problem. I currently have all the reports separated into separate folders, such as Finance, HR etc, and the datasources in a datasources folder at the root level. My problem is that when i upload reports into their appropriate folder, the shared datasource information gets deleted, and i need to re-map it everytime. Is there anyway to have the specific reports point to specific shared datasource folders on the report server when i upload them cheers Rob. Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
  - 16
    - SQL 2005 EXPRESS & ORACLE 10g Hi all, I am trying to link Oracle 10g (32bit) to SQL 2005 Express. My environment is: -SQL 2005 Express & Oracle 10g run to Windows 2000 - Oracle client is installed to the server I use either "New linked server" from Management studio or I run sp_addlinkedsever & sp_addlinkedsrvlogin to add the new oracle server. The server is succesfully created under "Linked servers" without any error. The point is I do not find the Oracle tables from within Management studio. Do I miss any step I tried both Microsoft & Oracle OLE DB, but i failed To the same server is also installed SQL 2000. From within Enterprise manager I linked Oracle 10g database without any error. Also I see the tables and run select statements. I used both Microsoft & Oracle OLE DB. Can anybody help Tag: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection

PismoPat

Our application installation setup needs to be able to detect:

Is SQL Server 2005 Express Installed

If false, run the SP2 Installation

Is SQL Server 2005 Express or SQL Express SP1 Installed

If false, run the SP2 Installation with Update Switch

Is SQL Server 2005 (not Express) Installed

If true, abort installation with a mesage.

Can you direct me to some documentation about testing for these environments or just if someone has some scripts that will run in InstallShield, that would be great.

ALSO, can you direct me to information about using the command line update switch for the Express SP2 Installer

Thanks.
Pat

Top

Re: SQL Server SP2 Command Line Upgrade Switch and Express Version Detection

Samuel Lester - MSFT

As for the exact Express command line installs for the first two cases, I'd suggest opening up template.ini from any SQL media and taking a look at their sample command line installs. There are quite a few, including Express installs, upgrades, etc. As for the wrapper, I'm not too familiar with InstallShield, so perhaps someone else can help out there.

Thanks,
Sam Lester (MSFT)

Top