Answer Questions

• Robert Polding SQL 2005 express permissions

  Can I use (an) active directory group(s) to allow clients to connect to a server running sql server with windows authenticion   Is there an article that explains how to do something like this that someone can point me two Thanks One more, How can I set up and SQL login to work. I set up the login the same way, and I thought I set up the permissions, but in my C# code all I get exceptions that say the connection doesn't have permissions to insert, delete, etc. The only permission my login has is to select. Is there a step by step procedure to setting up a login in SQL express 2005 Thanks. Depending on the user you stated in your connection string, you w ...Show All

• ZDB Please help with Locking Design.

  Hello, I have the following Awards Table: Amount   MaximumAllowed   NumUsed 25.00      20                             1 50.00      10                              3 Basically, I need to randomly select awards from this table and I need to keep track of how many have been distributed and not go over the maximum allowed. So it seems like when I go to retrieve an award, I nee ...Show All

• aybe SSIS bulk insert task

  i need to do a bulk insert for every csv file from a particular folder & i wish to do this programatically. i hav tried a "foreach" loop & using variables for the filenames but it doesnot seem to be working & i just cant figure out why !! Are you receiving an error when trying Foreach If you provide more details people in this forum would be more likely to help you Thanks Rafael Salas Here are some links that should help, whilst not the Bulk Insert Task, the concepts are the same- Looping over files with the Foreach Loop ( http://www.sqlis.com/default.aspx 55 ) SSIS Junkie : SSIS: Enumerating files in a Foreach loop ( http://blogs.conchango.com/jamiethomso ...Show All

• Tracy Woo MSDE (SQL Server does not exist or access denied.)

  Hi all, I'm getting this error message when I try to connect my MSDE database from other machine using enterprise manager application. Both of the machines are WinXP SP2. I found some solution such as using 'SQLServer Network Utility' but didn't work out for me. I even can not connect my database on my computer using TCP/IP. When I connect with name, it worked fine. I already enable both TCP/IP and Named pipe protocol on the MSDE machine. If someone has solution on that please let me know. Thanks, Myo Did you open the ports on the computers HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I have exactly the same issue. I have installed MSDE2000 on a PC with Windows XP Professio ...Show All

• Craig M Jackson How to work out the difference of two numbers in SQL table.

  Hi I have 2 columns the first column is a counter thats always counting up like a meter, the second column is a formula that calculate the difference between the counter(column one). like Counter Difference 1 1 3 2 6 3 9 3 11 2 13 2 17 4 25 8 The first row is taken as it is, but the second row will be difference = 3-1 the third one will be 3-6 and so on. How can I do this in a SQL table or any other away Your help will be highly appreciated. So what are you trying to do, inserting the values or just querying them What should be done in a SQL table, a kind of automatism HTH, Jens Suess ...Show All

• Beast Forever recursive query

  Hi guys, this is a weird query i need to build, or it can be an stored.proc, whatever's easier I have a table Item_ID Item_PARENT_ID --> references "Item_ID" Item_LEVEL --> 0 = top, else 1, 2, 3, 4 Item_NAME Item_START_DATE Item_END_DATE I would like to populate a gantt like chart, I have this table and need to generate an output ORDERED BY DATE BUT "PER LEVEL" how should it look like ID | NAME | PARENT ID |LEVEL|START DATE 1 topitem 1 - 0 01/01/01 9 subitem 1-1 1 1 09/01/01 3 subitem 1-2 1 1 15/01/01 2 subsubitem 1-2-1 3 2 01/01/00 7 topitem 2 -- 0 02/01/01 and so on. So this is a tree structure, ordered a. By top's date b. by sub date c. by sub ...Show All

• Michell Cronberg MDX - Remove a certain member from the total

  Hello everyone - I have a State dimension, the ALL level is called Total. On each report I show the total for all Members for each measure. I now have a request to remove certain states from the TOTALS. Any ideas Thanks for your time. with member [MEASURES].[Loan Count] AS '[MEASURES].[LN CNT]' member [MEASURES].[UPB] AS '[MEASURES].[CURRBAL]',format='#,###0' select non empty { [MEASURES].[Loan Count], [MEASURES].[UPB] } on columns, non empty { [STATE].total } on rows from XXXX where ([MONTHS].[TOTAL].[81]) Take a look at the VisualTotals function. I found a answer: let me know if you know of an easier way. Thanks! with member [STATE].[EXCEPT] AS 'aggregate(EXCEPT({[ ...Show All

• Cale Hoopes question on package configuration

  Hi, Programmatically, how will i be able to know if a package is using package configurations Thanks. Michael Entin - MSFT wrote: The task does not need to know about configurations, you should be getting the connection string from connection object in any case. If the configurations are used and connection string is present in one of the configuration, the configured value will be applied to the connection object when the package is loaded. So if you read the value from the connection object, you will get the configured value. does this still apply even if the script task is placed on pre-validate or pre-execute event handlers thank you very much for t ...Show All

• JohnnyR Unable to Setup on Windows Vista

  Hello, I cannot install SQL Server 2005 Express Edition on Windows Vista (Build 6000). I am logged on as the administrator. I tried to setup SP1 version, but it didn't work. Neither did after applying SP2 version. What can be the reason On the Problem Reports and Solutions panel it tells me to update to SP2. But it doesnt work. Can you confirm then that with the currently released version of vista, and the currently available SQL express (sp1) that there are known issues. I have installed SQL management studio express and it opens, but when I try to create a new database, it fails stating that permission was denied in database 'master' (microsoft sql server, error: 262). This might be similar ...Show All

• HairyDan rsAccessDeniedToSecureData

  I've installed a fresh load of SQL Server 2005 onto a Windows 2000 server, including all the trimmings with SS2005. Reporting Services 2005 is the main thing I want to initially check out, but I can't get it to work. In the 'Reporting Services Configuration' it shows the 'Web Service Identity' as a blank grey box which can not be edited. I can't help but think this might be where the issue is. I looked at this thread, as it describes the exact same problem, but the solution did not work for me. The RS service will start up, but then when I navigate to http://localhost/reportserver or http://localhost/reports it gives me the following error: Reporting Services Error Thanks for your reply again. 1. There was no problem accessing machine ...Show All

• sweet_salt SQL 2005 Express, Studio Management Tool

  I have just downloaded VB Express, that comes with SQL Express In order to manage and use SQL databases it seems I have to use SQL Studio Mgt Tool. But, where is it I can only see Configuration Tools, but not any Mgt tool or DB Engine...... Maybe my installation is incomplete thanks Done. Thanks! SQL Management Studio is an additional tool that must be downloaded and installed separatly. You can download it from here: http://www.microsoft.com/downloads/details.aspx familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en ...Show All

• dmadrian get rid of an anonymous subscription

  Hi all I've got the following situation: setup up an merge publication (distributor and publisher at the same server) setup an anonymous subscription deleted the subscription In the replication monitor, I still see the deleted subscription. Why And how do I get rid of it Thanks a lot for any informations and greetz Aline 1. try to delete the subscription on the publisher side using sp_dropmergesubscription, (see http://msdn2.microsoft.com/en-us/library/ms176045.aspx ) and 2. try to delete the subscription on the subscriber side using sp_dropmergepullsubscription, (see http://msdn2.microsoft.com/en-us/library/ms187336.aspx ) if hte subscription is a Pull Subscription. ...Show All

• hye_heena SSIS process error "Too many buffers are locked"

  Anyone seen this SSIS error when importing data I have a 64bit quad processor with 8gb and am importing from Oracle 9 using 32bit DTExec.exe from the command line. OnInformation,Myserver,MyDomain\SQLAdmin,J001OracleDimExtract,{CEB7F874-7488-4DB2-87B9-28FC26E1EF9F},{1221B6EB-D90A-466E-9444-BA05DBC6AFD8},6/29/2006 10:58:08 AM,6/29/2006 10:58:08 AM,1074036748,0x,The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 2 buffers were considered and 2 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked. Thanks I was running two SQL ta ...Show All

• ChrisErven Do you use the Reporting Services configuration files and if so, how?

  Wondering if I could get some feedback from 'you All' on how you use the Reporting Services configuration files. Specifically, I'm interested in - 1) Have you ever made changes to the configuration files (Yes/No; if Yes - how often ) 2) What if any operations you commonly do in the files (list) 3) Do you script or otherwise have automated solutions for updating these files (Yes/No; if Yes - in what scenarios; if No - did you try to ) Any other feedback about the configuration files is also welcome. Thanks, -Lukasz 1) Yes. Depending on the requirements. 2) - Changing web.config to use Forms Authentication - adding encryption keys to share session cookies with other ASP.NET sites - adding policies for using ...Show All

• JRQ Displaying images from SSAS data source

  I'm trying to display the images from the Adventure Works SSAS database in a SSRS report. I've added an image object to the table, set MIME to image/jpeg (as it is set in the value fiel of the attribute in AW SSAS database) but I'm getting just a 'x' instead of the image and following output: Preview complete -- 0 errors, 1 warnings [rsInvalidExpressionDataType] The Value expression used in textbox ‘LargePhoto’ returned a data type that is not valid. Preview complete -- 0 errors, 1 warnings [rsInvalidExpressionDataType] The Value expression used in textbox ‘LargePhoto’ returned a data type that is not valid. Preview complete -- 0 errors, 1 warnings [rsInvalidExpressionDataType] The Value expression used in image ‘image ...Show All