Answer Questions

• jpgetty2win Displaying selected rows from a Fact table

  I have a fact table which stores data ( customer name, document type, editing start time, editing end time, editor, revision id etc) for each revision of a document. While displaying data however i need to take into account only the last revision of each document. What is the best way of doing this Do I need to create a separate dimension table with the document id and max revision id as fields or is there a better way of doing it You don't need to change anything about your revision dimension. I imagine, that it has key attribute having values of 1,2,3,... up to whatever largest revision you think you will have in few years. I don't see the reason to include document id into this dimension - different documents can have ...Show All

• weirdbeardmt xp_delete_file

  I created a maintenance plan to remove files older than 2 weeks. The plan executes successfully, but does not work. I notice in the log that the single quotes are doubled. I ran one command which worked, but others did not. Is there a problem with the command Here is a copy of the log: Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1399 Report was generated on "SQL". Maintenance Plan: Clean Up Backup Files Duration: 00:00:12 Status: Succeeded. Details: Cleanup Master (SQL) Maintenance Cleanup on Local server connection Cleanup Database Backup files Age: Older than 2 Weeks Task start: 9/12/2006 7:34 AM. Task end: 9/12/2006 7:34 AM. Success Command:EXECUTE master.dbo.xp_delete_file 0,N''F:\SQLBackup\master'',N''ba ...Show All

• Yassi Problem Launching Report Builder

  Hi, I am having a problem launching Report Builder on one of my users pcs. When he clicks on the icon the following error message appears: dfsv.exe has encountered a problem and needs to close When I log in as myself to his PC Report Builder launches with no problems. Any advice Cheers Hi, Re-creating the user's profile worked in this case, Thx ...Show All

• Gunstar_00 Maxis 3G Connection

  I cannot connect to SQL Server 2000(Remote Server) through Maxis 3G connection. The remote server does not has firewall. I'm using Windows Application to connect to SQL Server 2000. dim strsqlcon as string = "Server=000.000.000.000;databse=dbname;usr=sa;pws=1234" dim sqlcon as sqlconnection = new sqlconnection(strsqlcon) sqlcon.open() "It's Error : Sql not exist or access denied." But I can connect to SQL Server 2000(Remote Server) through Local Area Connection. Have any solution Thank you. I enabled telnet service in Services Tool. In cmd, i type "telnet xxx.xxx.xxx.xxx:1433" Error " Connecting To xxx.xxx.xxx.xxx:1433...Could not o ...Show All

• Vitalijus ADP connection to SQL

  I would like any advice on connecting an Access Project to SQL Server 2000. Authentication is in mixed mode and user enter a name and password. When he click cancel twice, it will appear error - he enter without check a name and password. How I can prevent that Any chance of changing the authentication to Windows only I don't understand what is happening in your scenario - can you explain with more details how you set up your project to connect to SQL Server Thanks Laurentiu ...Show All

• fcatacutan uninstall SQL server 2005

  Hello after uninstall SQL server 2005 by tools (vs_uninst_betas) still exist in program menu. How can uninstall definetly. Thanks you. See this post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=554589&SiteID=1 What entries still appear in Add/Remove Programs Are there still Microsoft SQL Server entries, VS entries, or both Thanks, Sam Lester (MSFT) ...Show All

• David Brenchley Avoiding clear text passwords and editing of packages

  Hi! I have an SQL Server where only a group of sysadmins have access to install DTSX packages. Those DTSX packages are developed by another team that does not have access to the production SQL Server. They use their own SQL Server. In order to make it as simple as possible to install these packages by the sysadmins, I suggested the use of configuration files. The files are associated with the job that executes the package and all that has to be done to install the package is copy it to the file system or import it into the SQL Server. Developers use their configuration file, sysadmins user theirs. Nothing new here. The problem is that some of the packages have to access some old systems and we cannot use integrated authentication. We have ...Show All

• P R W Parameter isn't refreshing

  Hi. I have a datasource that depend on parameter A. Parameter A get his values from query and have a defualt value. Parameter B get his default value from query that depend on parameter A. Now, whan I run the report, parameter A get a value and then parameter B get his value and the datasource run OK. But the problem is that when I'm changing the A value (from the value list) - The datasource run fine but Parameter B stay with the old value with out any change. Does any one know how to solve it. I'll be happy to give more explanation if it isn't clear enough. Thanks. I stand corrected. Thanks Ham. Hi, thanks for your reply. I found a sulotion in another forum. I just needed to set the parameter as ...Show All

• Joel Triemstra Import from Data from Microsoft Access

  In SQL Server 2005, Im trying to append data to tables which already exist. Im importing the data through the import wizard. The source from is Microsoft Access with no username and password. The source to is SQL Server 2005 using OLE DB Provider SQL Server with the login information of the schema I wish to use. I click through and the tables appear in the source. When I select all, they appear in the destination but they appear with the dbo. prefix which would regard them as new tables since the tables dont exist under that schema. I can click on the first destination table drop down text box and see all the tables under the schema there suppose to be under but its not the default. There are a lot of tables and I don't feel lik ...Show All

• FoxyNet Remote connecton

  I made a 1 form app(to learn with) in VB Express. I published it, installed it on my pc and everything is fine(I used a db from my main app I'm building which was made in VBE(but I didnt install the db in my project, I only connected to it) anyhow With my 1 form application, I can add,edit the records in the db, no problem there but when I took it to another pc and installed it, it installed fine, but when you launch the app I got an exception stating That it cannot find a SQL connection etc... I do have remote connections checked in SQL. Is there something that you have to do to a remote pc to make it visible We have a simple peer to peer network. I have an existing app(Access) that I use mapped drives to share ...Show All

• Melvin McClurkin READ_COMMITTED_SNAPSHOT

  ALTER DATABASE TestDb SET READ_COMMITTED_SNAPSHOT ON; The above statement work fine in SQL Server 2005. But my problem is that I have some old databases still using Sql Server 2000. I know the above statement is only valid in 2005. Is there any workaround in Sql Server 2000 to do the same thing Thanks. You can use READ_COMMITTEE isolation in SQL 2000 and this READ_COMMITTED_SNAPSHOT is introducted in SQL 2005. http://www.informit.com/articles/article.asp p=27020 http://www.informit.com/articles/article.asp p=327394&seqNum=2&rl=1 http://www.microsoft.com/technet/prodtechnol/sql/2005/cncrrncy.mspx What you want is non-blocking read-committed isolation level in SQL200 ...Show All

• NateRickard "distinct" in select query

  when i use select : select flattened (select productid, $support from [model name].[table] )...... i have result with many record same. so i write : select flattened (select distinct productid, $support from [model name].[table] )...... but when i run, it's error. ( don't know what error). how can i do to get table record with not same record (loop) note : it write in DTS and i use sql 2000 i can't use query like you show. i want you "distinct " in DTS syntax like that: select flattened (select productid, productname, categoryid ,[$probability] from predict([model name].[table name], incluse_statistics) where productid > 1000) from [model name] predi ...Show All

• nobodyman sql express installation error

  Hi, I have tried to install sql express several times and each time it fails to start the sql service during the install process. I am copying part of the three log files below. File Name :C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_REHMANK-PC_Core.log Running: ActivateLoggingAction at: 2006/11/11 13:33:57 Complete: ActivateLoggingAction at: 2006/11/11 13:33:57, returned true Running: DetectPatchedBootstrapAction at: 2006/11/11 13:33:57 Complete: DetectPatchedBootstrapAction at: 2006/11/11 13:33:57, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2836" returned false. Running: Per ...Show All

• WolfgangB permissions granted to an application intead of a user

  I have an application that talks to an access db located on a 2000 server. I would like grant permissions to the application instead of a specific user. Any help would be great... Answer is the same - Windows security works by assigning permissions to users - permissions cannot be assigned to applications. You should read the post that Raul pointed out. You can attempt to use application roles or have the application connect with specific credentials to the database, but a smart user can reverse-engineer the application and figure out how to connect directly to the database, hence there is no security guarantee of the type you seek. Thanks Laurentiu let me restate: the db is on a mapp ...Show All

• OOT_In_Atlanta Looping through source connections

  I am trying to build a package that loops through different SQL Server connections and puts the result set in a single SQL Server connection. I have looked at the Flat File example but this does not help. How do I loop through a list of SQL Servers (can be in a table, or file) make the connection to that SQL Server, run a script against Master to gather DB names (have this part) and write it to a reporting server (have this part). I have tried the For Loop and For Each Loop, but can't get either to work with SQL connections. I have seen this question a lot, with no real answers. (Everyone who answers just points back to the Flat File example) Thanks, Pete Yes you understand it right. The idea yo ...Show All