Answer Questions

• Tamim Sadikali Incorrect Scripts using database generate scripts wizard

  I am getting incorrect scripts, not an error, on the indexes when I use the database ‘generate scripts’ wizard. This only happens when I have 8 or more tables and on indexes with include columns. It’s getting the index columns mix up the include columns. Here are the scripts I got: -- From database ‘generate scripts’ wizard with 8 or more tables (Incorrect) -- CREATE UNIQUE NONCLUSTERED INDEX [IX_DimArmType_Lookup] ON [dbo] . [DimArmType] ( [EW_Arm_Type_Skey] ASC , [Arm_Type_ID] ASC ) INCLUDE ( [Arm_Type_LD] , [EW_Source_DB_ID] ) WITH ( PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [PRIMARY] The ‘script index as’ wizard seem to work fine. -- From ‘script index as’ wi ...Show All

• LeeroyB Want to log CLR exceptions in SQL table

  So I have some SQLCLR stored procedures, that use some .NET classes. I have a table in the database for exceptions, and I want to log all exceptions (except SqlExceptions of course) to that table. I have the following example: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server. SqlFunction (FillRowMethodName = "FillRow2" , DataAccess = DataAccessKind .None, SystemDataAccess = SystemDataAccessKind .Read, TableDefinition = "fld_colname NVARCHAR(4000)" )] public static IEnumerable ExceptionTest() { // Some example from a website List < string > names = new List < string >(); using ( SqlConnection connection = new SqlConne ...Show All

• Lakshmi N SSIS Deployment and Removal issues

  I created a setup package and installed it on my SQL2005 server. I cant seem to find anywhere on the server where they are installed, but I can access them from the Job schedule tool, which work for me. However, now I have to upgrade the deployed SSIS and I cant seem to install on top of an existing one (gave me no errors but after testing it i realized it is still running the old version.) My questions are: 1) How can I find and delete these SSIS packages from the server 2) How can I just upgrade for a new version of a SSIS package I need to be able to do both things as at some point I may want to just remove some packages. I Installed to the SQL server. I conneted to the SSIS service with Managem ...Show All

• Chakkaradeep Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All

• rtb33 Problem setting Package Variables in SSIS Package

  Hi, I am making use of the DtUtil tool to deploy my package to SQL Server. Following is my configuration: 32-bit machine and 32-bit named instance of Yukon. I have some package variables which need to be set in the code. Previously I did it as follows: Set the package variables in the code. For example: pkgFile.Variables["User::DestinationServerName"].Value = <myvalue> Deploy the package as follows: applnObj.SaveToSqlServer(pkgFile, null, destinationServer, null, null); Here the package was successfully deployed and when i open those packages using BIDS, I am able to see that the variables are set to the values as doen in teh code. Because of oen problem I am not using SaveToSQLServer method. So ...Show All

• Scott Chang Reporting Services Monthly Subscription

  Hello, I'm scheduling monthly subscriptions in reporting services. I would like to receive subscriptions every 2nd Monday of the month. For instance, if the 1st is a Friday, then report should be delivered Monday, the 11th. So my question is: in reporting services: if I set the subscription for Monday - 2nd week, and the first day of the month is a Friday - does it consider the week from 4 -> 10 as the second week (because month began the week before) - or as the first week (because it takes into account only full weeks) Thanks a lot for any help! Best regards, Tiago Excellent, thanks a lot Jarret! Hello Tiago, I just ran a test to check th ...Show All

• kennm Same DB, Different Performance on Different Servers

  Hi, We are doing response time testing on our application with SQL Server 2000 SP4. But it is found that a query have different performance on the same DB (restore from the same backup) in different servers. The execution plans are different on the 2 servers. Server A: the execution plan use parallelism with varying response time (from 3 sec to 64 sec). Server B: it is a single thread execution plan with faster response time (about 1 sec). Here is the server configuration: Server A Dell 750, you can access Dell homepage for more detail. CPU – P4 2.8 GHz CPU Memory – 2G Disk – RAID 1 SCSI OS – Windows 2003 Enterprise Edition SP1 Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18: ...Show All

• Wayne Sepega Get number of business days between dates

  Hi. Is there a way to get the number of business days or hours between two dates Also, is there a way to have it ignore weekends and U.S. holidays Thank you. Thank you, Tom and Mugambo. Your suggestions worked. i am using this script to get amount of business days Code Snippet set datefirst 1 declare @sdate datetime declare @edate datetime select @sdate = '20070516' --for example, start date May, 16th select @edate='20070531' --end date May, 31st select datediff(day, @sdate, @edate)+1-( select (case datepart(dw, @sdate) when 7 then (datepart(ww, @edate)-datepart(ww, @sdate))*2-1 else (datepart(ww, @edate)-datepart(ww, @sdate))*2 end)+ (case datepart( ...Show All

• Will Merydith If Statement (EASY)

  I'm trying to group ages in one report, and Case numbers in another. Both are in string datatype, and require more then 3 choices. Im not keen on coding, so i was wondering, how do you make an IFF statement with more then 3 choices, i need about 7, maybe even a little more. *this is for a column grouping in a matrix. Here's what i have right now...It works..but i need to add more years. =iif(left(Fields!ICNNo.Value, 1) = "4" , "2004" , iif(left(Fields!ICNNo.Value, 1) = "5" , "2005" , iif(left(Fields!ICNNo.Value, 1) = "6" , "2006" , "Unknown" ))) Please help! thanks! I would suggest going to a 2 character ...Show All

• Mortsdeh Updating report templates without losing subscriptions

  Hello, We are using Reporting services 2005 and have been for some time. Recently we have started using the subscriptions as well. However we have come across a problem with this. Currently we are updating our report templates by removing them and then creating them again. This worked fine until we started using subscriptions. Now, when the reports are removed, the subscriptions that are associated with the reports are also removed. Is there a way to update a report template, without having to remove the report first And can this be done programmatically The code is currently publishing the reports by calling ReportingService2005. CreateReport( name, "/" + reportFolder, false , template, null ); Thanks, Denise. ...Show All

• ivanw Multi-Valued parameter output

  I am trying to work on this project where I have to select multiple values from the parameter and after selecting them I have to output results for each value from the parameter on a different page. The output format is standard for all but the values are going to be different. I am able to output results for one parameter value on one page, and I also tried to change the parameter to multi-valued but it didn't work. please help... Thanks, -Rohit Mhmm, I thought I got you. Can you send over the RDL File to have an look on your code HTH; jens SUessmeyer. --- http://www.sqlserver2005.de --- Place your data in a table, group the values by the parameter values and ...Show All

• Aleniko29139 SSEM - How do you connect to an MDF file?

  I have SQL Server Express 2005 (April CTP) along with SQL Server 2005 Express Manager (SSEM).  I am trying to create an ASP.NET web site using VS 2005 and in the process I want to create and use a smallish SSE database using an MDF file.  I thought I could connect to the MDF with SSEM to populate the DB with some data but I can't figure out how to connect.  Does SSEM support this   Is there a better way to do this - perhaps from within VS 2005 Done.  Thanks again. Can we directly connect to the MDF file of the SQL server, in our program, as we do for Access Thanks Hi Keith I think you may use the sp_attach_db  to do that This ...Show All

• DSBNET how to get the real boundary of "time" dimension of a subcube dynamically?

  how to get the real boundary of "time" dimension of a subcube dynamically e.g. CREATE SUBCUBE [SMS2005] AS ( SELECT ( [time].[date].[date].&[2007-01-01T00:00:00] : [time].[date].[date].&[2007-01-10T00:00:00] ) ON COLUMNS FROM [SMS2005] ) go I want to create a global measure that show the stocks on the boundaries of the subcube'range (in this case , they are 2007-1-1 and 2007-1-10). Whenever a different new subcube (focused on time dimension) is built, this measure can behave differently based on the subcube. To this problem , I think the key is that how to get the real boundary of "time" dimension of the subcube dynamically in the definition of the globally wanted measure. Does anyone ha ...Show All

• Grant_csi HTTPS access to SQL 2005 cubes

  Hi , I have configured Http Access with following instruction www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx my machine is win2k3 sp1 and same machine i installed msas 2005 and iis (both are running same machine) when connect to my url : http://localhost/olap/msmdpump.dll it will showing following error:   < soap:Envelope xmlns:soap ="http://schemas.xmlsoap.org/soap/envelope/">                              < soap:Body > < soap:Fault xmlns ="http://schemas.xmlsoap.org/soap/envelope/">  < faultcode >XMLAnalysisError.0xc10e0002</ faultcode > < faultstring >Parser: The syn ...Show All

• ddee Wrong version returned

  When I execute the query "Select @@VERSION as 'SQL Server Version'" from SQL Server Management Studio Express, I get '2005 - 9.00......." returned as the version. When I execute the same query from a VB 6 program, I get "Microsoft SQL Server 2000 - 8.00.760 (Intel X86)" returned. What is odd is the VB 6 program had been returning '2005' within the last two weeks. I have not uninstalled or re-installed 2005 in my environment. I also executed the following at the command prompt and recieved SQL 2000: "C:\Documents and Settings\Administrator>sqlcmd -S MARKB-LTXP -U SA -P medw.1 -q "select @@version" -------------------------------------------------------------------------------- -------------------- ...Show All