Answer Questions

• ARASKAS Using UniqueIdentifier as Primary key

  Hello, is it a good idea to set an UniqueIdentifier field as primary key why i can't set an indentity specification How can i do Thanks a lot Boyd, I appreciate that it is open for debate, but can you give me an executive summary to the two sides or point me to where I can read the debate to make my own decision You say "... but you definately can do it." but that kinda implies to me that you think it may not be ...Show All

• fan2005 Possible to make "Detail View" default in Report Mgr?

  Is there a config file where this can be modified such that the views in http://SomeWebServer/Reports will be Details view by default Still wondering about this. I reviewed the CSS one day for the site, but didn't see this in there. ...Show All

• Tony Robyn Cannot attached Personal.mdf

  SQL 2005 CTP does not like the personal.mdf from the Starter kit.  I cannot attach the file at all.  Can someone send me the scripts for database build   Thanks. Hi. If you're still having a problem with this, please ask again and be sure to post the command you're executing. Thanks! Did you try the June CTP This came out after this post and has numerous fixes. Let us know if you still nee ...Show All

• Cosmo69 SQLServerAgent not starting

  Hi all, I have a maintenance plan on SQL2000, that is backing up the database. It is under Management/SQL Server Agent. When I try to start the job, I got an error, saying: Error 22022 SQLServerAgent is not currently running so it cannot be notified of this action. But, when I try to start the SQL Server Agent (in Services), it stops directly with the following information ...Show All

• norwegian db design question

  This problem comes up over and over in my designs. It must be the way I think. Here is an example: Table proposals is the depository of all data. The other table is only to enforce the constraint. An author can make many proposals with the same topic, language and category. When done, she flags just one within this group of rows as FinalizedProposal. I am keeping the data of the ‘drafts’. They are all proposal rows but just one is labeled fi ...Show All

• Mohan Gupta Dimension Processing Error

  I am using following configuration Server:-SQL Server 2000 Database :-Oracle MSOLAP :-Cubes But while processing dimension We are getting follwing error Analysis Server Error: Processing error [Attempt to delete member that is in use] '27-08-2005' ; Time:3/17/2006 1:04:01 PM The mentioned date is already there in database ,Pl let me know what causing this error Thx and regards Pankaj ...Show All

• DiesIrae How do you sort large files

  I had no luck sorting large files with Sort transformation. 1 or 2 GB are still so-so, but 3 - 5 GB seem to hang up and not finish.. Anyone else encounter this What would you recommend as workaround (maybe some other program)... Thanks. The reason I asked is I also had been working on a scalable sort and am curious what folks are using so far. I just finished. My sort is 100% plug and play compatible wit ...Show All

• sm1908 Business Intelligence in SQL Express?

  Hello, I have spent about half an hour looking for an answer to this, so apologies if I have missed it. Can you get Business Intelligence Development Studio together with SQL Server 2005 both in Express editions There was mention of an Express toolkit which includes BIDS but it seemed to imply you couldn't combine it with SQL Server Express. If not, what is the cheapest way for an individual to get Business Intelligence Development St ...Show All

• yayah_1 How to Reuse functions in script tasks ?

  Hello I have some common functions that i use in several script tasks. How du i store a function globaly so that i can use it from different projects and still only have to edit it one place Correct. I am not able to think of any other way to do the same. Because each script task is different Identity(different project), if you create a function into one ...the other script task will not be aware of ...Show All

• pratty Error: An error occurred due to no connection

  This error is for Nov RTM running under "NETWORK SERVICE" account. I created a data source "MyDataSource". It looks like: <DataSource xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:dwd=" http://schemas.microsoft.com/DataWarehouse/Designer/1.0 " xsi:type="RelationalDataSource" dwd:design-time-name="2d2b4fc8-af5c-4314-9155-384afd11fb70" xmlns=" http://schemas.microsoft.com/analysisse ...Show All

• W.Randy Windows Mobile 5 connecting to SQL Server 2005

  Can't get winmobile 5 to connect to my sql server 2005 (using vs2005). Here's the connect string: "Data Source=tcp:XXXXXX\default,1433;Database=YYYYYY;" _ & "Integrated Security=SSPI;" This very same string, and variations of it, work in a vs2005 winforms app, but not a windows mobile 5. I'm (obviously) using system.data.sqlclient. MS documentation says it's supported on both platforms with no syntax changes. ...Show All

• Omer van Kloeten XMLBulkLoad

  Hi,     I have been working on SQL Server 2005 nearly for an year now. In Beta2, there is class XMLBulkLoad which can be used to bulk copy data from an XML file into SQL Server using a mapping schema. Now I have installed the Yukon April CTP and OMG the XMLBulkLoad class is missing. Does anybody have any idea whether it has been removed or changed to something else It was earlier "unofficially" in the " System.Data.SqlXm ...Show All

• XLNT Can not start Report Builder!

  I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default. When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or n ...Show All

• Waldsee grouping by months

  Hello everyone starting from this example table: code    qnt        date aaa          1        21/01/2006 abc          2        24/01/2006 aaa          3        27/01/2006 asd          1        11/03/2006 wde    ...Show All

• Cypris How to change the value of a variable within data flow

  Hi, I would like to know is there any way we can assign/change the value of variable within data flow without using script component Thx. Row Count does that - but you are probably not looking for that specific case. Beside the script component you can only do it if you develop a sample data flow component. Why do you think the Script component is not a good option for you Why do you think script component is slower Have ...Show All