Answer Questions

• fatquack TableAdapter and variable

  Hello, I want to do something like this in a TableAdapter's SQL Statement: SELECT Type.* FROM Controllers INNER JOIN @Type AS Type ON Type.ConfigurationId = Controllers.ActiveConfig INNER JOIN Tank ON Controllers.ControllerId = Tank.ControllerId WHERE (Tank.TankId = @TankId) But I get an error because of the @Type variable. Is there any other way to choose a table in a TableAdapter with variables Thanks for your help! Additional information: @Type is a Function that returns a table... but that might not be the problem. skuehner wrote: Additional information: @Type is a Function that returns a table... but th ...Show All

• dsl_beginner sql datatypes

  i hope this is the right board for this. i want to have a table for members of a club/society and i wnt to be able to maintain the structure of their member id numbers, eg com212 for a committee member, or mem019 for ordinary members. is there a way to automate this using some sort of auto-incriment function and use this as the primary key for the table thanks in advance, mark This is an alternative way to achieve the same goal just put IDENTITY(1,1) before PRIMARY KEY when you create the table. This identity will start from 1 and increase the ID by 1 CREATE TABLE XXXX_Info ( ID int IDENTITY(1,1) PRIMARY KEY, X varchar(50), Y datetime, Z varchar(50), ) Hi Mark, Please s ...Show All

• kopo from OLTP, DW, SSAS, to Report

    Transaction db (such as AdentureWorks) changes all the time. If I'd like to see Report updated every day, DW and SSAS should be updated every night. Is there any sample (DTS) or ducoment for this issue Thanks! -Z I'd suggest you take a look at The Microsoft Datawarehouse Toolkit written by Joy Mundy and Warren Thornthwaite from the Kimball Group. It walks through all of the layers of a BI solution using Microsoft technology (from ETL to DW to SSAS to reporting) and discusses issues such as data latency, ETL schedules, near real-time updates, etc. HTH, Dave Fackler Thanks, Dave! It helps a lot! -Z ...Show All

• Davids Learning HOW TO USE SSIS (DTS) IN SQL EXPRESS

  I ’m trying to use ssis in Sql Express in order to replace my old DTS that I used in MSDE but I found that SSIS doesn’t work in Express, question is How could I use new DTS technology in Express Thanks in advance. The SQL Server 2005 Backwards Compatability Components include the DTS2000 Runtime that will allow you to use your old 2000 DTS packages in SQL Express. You can download it from the SQL Server 2005 Feature Pack page. Regards, Mike Wachal SSIS does not come with Express or Workgroup editions of SQL Server 2005. See Integration Services with Basic Transforms here http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Derek ...Show All

• AlGee Accessing an SSRS report from the web, being prompted for Guest signon screen

   I have a sql server 2005 application that uses asp and some canned reports that I built using SSRS.    All reports run from the server but not when to try accessing from another computer on the network.  I get a prompt from windows that requests me to enter a password for the Gurest account.  The Guest account is not selectable.  Does anyone know how to supress the signon page   I am using sql 2005 workgroup edition.   I would like the users to go directly to the ssrs report without any logon screen. Thanks  Rich  Jens, What explorer are you talk about   Could you be more specific.   Been looking all over for that option on my server mach ...Show All

• carlo74 Remove old SQL 2005 Backup files

  I am trying to configure a maintenance plan in SQL 2005 to do a full backup every day and to do log file backups every hour. What I want to do is to keep 3 days worth of full backups and 24 hours of log backups and remove all the backups older that this from the server so that I do not use all of my disk space. I will then backup these files to tape so that I have a good backup history. In SQL 2000 there was a simple option to remove backup files older than a given time frame. Is there an option to do this in 2005 If not can you suggest a way that I can do this. Hey Thanks Andy, But i never seen check box for include sub level folder in maintanance plan clean up task. can you tell me wher ...Show All

• vbmon SSIS Checkpoints

  I have a package that uses ssis checkpoints. It works well. However, when I try to setup transactions for some task, the chekpoints aren't used. I read BOL and It states: "If a package is configured to use checkpoints, Integration Services captures the restart point in the checkpoint file. The type of container that fails and the implementation of features such as transactions affect the restart point that is recorded in the checkpoint file ." But, how checkpoints are affected by transactions what relation exists between this two components Hello Jamie, those links are very interesting, but neither of them solve the relationship between transactions and checkpoints. In fact, if you instal ...Show All

• Ratheesh*MCP* Calculating the average over time

  Hi all, As a follow up for my previous post about calculating the number of active subscriptions at any given moment ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1147061&SiteID=1 ) an other 'newby question'. With the measures from my previous post I managed to make two calculated members: [ Active subscriptions SoP] and [Active subscription EoP] (SoP = Start of Period; EoP = End of Period). What I would like to create is an other member which calculates the average number of active subscriptions for a given period, so I can create an pivot like the one below. At the question marks ofcourse should be the average for the entire week. This however is not equal to (10843 + 10866) / 2 = 10854.5 but equals (10854 + 108 ...Show All

• Andrea Giovannini Deployment issues

  Hi All, I am running SQL RS 2005 on Windows Server 2003 My client is XP sp2 with .NET 2005 Team When I try to deploy a RS report to my web server I get an error; Error 4 The permissions granted to user 'MyDomain\MyUser' are insufficient for performing this operation. What folders/user/permissions need to be opened on the server so that I can deploy reports from my client machine regards, Bill Can no one tell me what permissions I need to deploy reports to the server, or is this really a rare issue Did you install SP1 for windows 2003 server I did. SP1 for SQL Server as well. Thing is, I had everything working fine a week ago. We had to ...Show All

• prk Install path SQL Enterprise Manager

  Hi, We want to install SQL Enterprise Manager on a seperate server. Our provider for this server requires us to install SQL EM on a non-default drive/path, d:\programs. How can I achieve this TIA, Wim Run the setup.bat file from the SQL Server installation CD, and select Install Client components, and you can specify where you want the programs installed. Looks like this works for 2005. However we want to use 2000. My mistake, should have mentioned this. We already looked quite extensively on the CD but could not find any clues for resolving this. Does anyone have an idea It could be that Enterprise Manager 2000 is not meant to be installed seperately from SQL Server 2000. Can anyon ...Show All

• Santosh Kalkeri FormatNumber >> Excel export?

  Hi all I want my measures to be exported(Excel) as numbers instead of text. When i simply use them as is it does this correct but as soon as I as the following number formating it no longer exports correctley. =FormatNumber(Fields!Example.Value,2,True,True,True) The same apllies to whe  I set the formatting in the text box properties to N Can some please tell me how I can acheive this result when exporting Thanks in advance G Thanks Adam I came accros the same thing today when i was casting the values returned from custom code. I just hope the same principal will aplly to currency. In my case I had to figure to use N0 as format type to get 1,345,456 When using the cdbl() to do this you cant use Forma ...Show All

• Ehab Fadl Many different tables sharing a unique ID

  Beginner's question: I have many unrelated tables, each with a unique "ID" column, but each ID must be unique in all tables. What's the best way to achieve this Thank you. GUID In Books on line see topics: Using uniqueidentifier Data Send Feedback newid CREATE TABLE MyUniqueTable (UniqueColumn UNIQUEIDENTIFIER DEFAULT NEWID(), Characters VARCHAR(10) ) GO INSERT INTO MyUniqueTable(Characters) VALUES ('abc') or INSERT INTO MyUniqueTable VALUES (NEWID(), 'def') GO int If you need to use an int you can have a table with one column and one row that holds an int that you get and increment for each insert in each table ...Show All

• kadabba Table Header

  Is there a way to angle column headers in reporting services. The WritingMode property is not sufficient for what i need. i need the text to go from bottom to top but ata 45 degee angle. Thanks rduclos This is not supported. One very involved workaround could be to write a custom report item that does this. ...Show All

• DiscoverIT NoLock vs ReadPast

  I have been experiencing deadlock errors with two stored procs that I am using. SP1 is a read query that gets all unprocessed orders (status = 0) SP2 is an insert query that inserts new orders (Status = 0) uses a transaction. I have a multithreaded application and once in a while the read query (SP1) will try to read a new row that has just been inserted but not committed yet hence the deadlock arises. If i use a hint "With(NoLocks)" this will be a dirty read and still read the uncommitted insert from SP2 - is this correct Where as if I use hint "With(ReadPast)" this will now only read committed rows and hence the deadlock should not arise - it will not read any uncommitted rows - Correct So I think th ...Show All

• TheGreenGenie Data Source View of Mining Structure cant be edited?

  Hi, all here, Thank you very much for your kind attention. I got a quite a strange problem with Mining structure for OLAP data source though. The problem is: I am not able to edit the mining structure in the mining structure editor. The whole data source view within the mining structure editor is greyed. Could please anyone here give me any advices for that Thank you very much in advance for any help for that. With best regards, Yours sincerely,   You can't edit the data source view in the data mniing designer. The DM designer has a "read-only" view of the DSV. You need to switch to the DSV designer to make edits. Hi, Jamie, thank you very much. Regards, Hi, Jamie, thank you very ...Show All