Answer Questions

• ImagineNation Anonymous Access from Pivot Table to OLAP 2005

  My asp-net web application connect to Analysis Services 2005 through Pivot Table client. To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous". Which property give me the same thing with AS2005 Thanks! Thanks, it's working. But, if i set "Impersonation Level" property to Anonymous Is this the same of SSPI=anonymous Hi, The SSPI connection property is still there, so it should work the same. Are you getting an error David Botzenhart Hey David - good to hear from you ! Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standar ...Show All

• MLyons10 joiing two unrelated tables?

  Hi, I have two tbls (trade & retail) - at the minute I have a query (in just one tbl) which looks like this SELECT SUM(Total) AS WeekRetailTotal, COUNT(*) AS MonthRetailOrderNo, DATEPART(wk, OrderDate) AS SalesWeek, YEAR(OrderDate) AS SalesYear FROM dbo.Orders_Retail WHERE (account = @Account) AND (OrderStatus <> 'Deleted') AND (PayStatus <> 'Pending') AND (OrderStatus <> 'Refunded') AND (DATEDIFF(d, OrderDate, @StartDate) <= 0) AND (DATEDIFF(d, OrderDate, @EndDate) >= 0) GROUP BY YEAR(OrderDate), DATEPART(wk, OrderDate) ORDER BY YEAR(OrderDate), DATEPART(wk, OrderDate) I then have the same query (bar a couple of differences) for the trade tbl which looks like this: SELECT SU ...Show All

• SabAlo SQL Server 2000 installation problems on Windows 2003 Ent x64 cluster

  I have a Windows 2003 Enterprise x64 edition cluster setup and functioning normally. Now, I am trying to get SQL Server 2000 installed as a failover cluster but am having some difficulty. When installing, I get the message '[sqsrvres] ODBC sqldriverconnect failed' in the event log. The message happens when the installer is trying to bring the SQL Server Service resource online. I am able to ping the name of the instance successfully. I am able to manually start the 'MSSQL$InstanceName' service. I have turned off the firewall on both machines, but this did not help. I have the DTC Service setup as a resource in the same cluster group. I also read http://support.microsoft.com/default.aspx scid=kb;en-us;815431 which seemed promising, b ...Show All

• Justin Patterson User access right

  Is there any way I can enable a user to run a stored procedure but nothing else in SQL2000, not event select/insert/update/delete on any table. yes, it is possible..create a new user ,dont give ur user any rights apart from grant execute on dbo . myproc to myuser Jim: In addition to what Nitin says you might consider creating a ROLE with a name something like 'table_deny'.  Then modify that role so that (1) select, (2) insert, (3) update, (4) delete and (5) DRI are denied to this role for all tables.  Then add your user to this role.  Then if at a later time the PUBLIC role is granted rights to one of these tables your user will still have rights to that particular table denied. Da ...Show All

• AvalonNewbie deriving a new column from another derived column

  In a Derived Column data flow transformation, why can't I refer to a derived column (added in that same transformation) in the expression for another derived column It seems I am forced to chain 2 DC data flows, just to do something as conceptually simple as: a = x + y; b = a 2 On a related note: Can I define a variable that is scoped to each row Can I bind a variable in an expression to avoid creating a new row, e.g. let a = x + y; a 2 as the expression for new row b It's a good idea Jamie. Do keep in mind that it adds another layer of complexity. Along with some other difficulties, the user would have to specify an order of execution for the expressions, and the UI would need a way too enable and maintain that. Ch ...Show All

• rock.aut data reader source in data flow problem

  hi all, i have a package in ssis that needs to deliver data from outside servers with odbc connection. i have desined the package with dataflow object that includes inside a datareader source. the data reader source connect via ado.net odbc connection to the ouside servers and makes a query like: select * from x where y= and then i pass the data to my sql server. my question is like the following: how do i config the datasource reader or the dataflow so it will recognize an input value to my above query i.e for example: select * from x where y=5 (5 is a global variable that i have inside the package). i did not see anywhere where can i do it. please help, tomer hi jamie, thank you for y ...Show All

• remedios_ SSIS Newbie - ETL question....

  I am tasked with loading the data from one SQL Server 2005 database into another of the same type and schema on the same server. I'd like to use this task to get my feet wet in terms of using SSIS. Can someone suggest a way of doing this Thanks in advance Yes, you are correct. I am interested in the data. I will check out the link you sent. Thanks Rafael Salas wrote: That's why I suggested not to use Identity columns in the target tables; so they are not autogenerated in the destination; then just map the source columns to the destination ones. Exacftly. Identity columns are the devil's work OK, I might be exaggerating a bit. But I always steer wel ...Show All

• oren Conversion Issues - SS2000 to SS2005 - using Object Method

  I am converting   databases from Windows 2000 and from SQL Server 2000  to a totally new 4 processor Server 2003 with SQL SErver 2005.  I used the Database Copy Wizard in SS2005 to do the transfer.  I used the Object Method.  After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the databases copied from SQL Server 2000 to SQL Server 2005.  What did I do wrong   And how do i fix it.  Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files.  I had to do each one manually. ...Show All

• cbpd86 Equivalent of Crystal Reports "Specified Group"

  I was just wondering if you could create in SSRS the equivalent of a Crystal "Specified Grouping" i.e. Let's say I have a Loan Risk Grade Field, and the values may be 1 to 99 If I wanted to group not by individual Risk Grade but say a grade banding how would I go about it In Crystal you would be able to create a specified grouping,let's say Group A = Risk grade 1-10 Group B = Risk Grades 11-20 Group C = Risk Grades 21 - 99 In SSRS, would I have to put this in the SQL (i.e. create a "grade banding" field output) or is there a way via the "Edit Group" or some other interface to specify this Cheers for the suggestion....but my question was specifically aimed at the creation of custo ...Show All

• ddlam How do I move my database?

  I am using VWD 2005 Express, with SQL 2005 Express. My web hosting company supports ASP 2.0 and SQL Server 2005, but have put SQL on a database server, which is separate from the application server. I successfully published a "Hello world" test application, but my database application failed after displaying the logon page, presumably when it first tried to connect to the database. VWD has created my database within the application folder ( app \App_Data\ASPNETDB.MDF) and created the configuration string in web.config: - < add name = " ConnectionString " connectionString = " Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True " pr ...Show All

• MDesigner The PIVOT SQL construct or statement is not supported.

  I am trying to use a Pivot T-SQL statement in the Table Adapter Configuration Wizard in Visual Studio 2005. I get the error message "The Pivot SQL construct or statement is not supported". Then it executes the SQL statement as if there were no error. Unfortunately, it will not create the table adapter because of the error. Below is the T-SQL statement I am using. SELECT OrderNumber, OrderDate, custlastname, [1001] AS Dept01, [1002] AS Dept02, [1003] AS Dept03, [1004] AS Dept04, [1005] AS Dept05, [1006] AS Dept06, [1007] AS Dept07, [1008] AS Dept08, [1009] AS Dept09, [1010] AS Dept10, [1011] AS Dept11, [1012] AS Dept12 FROM (SELECT Orders.Ordernumber, Orders.OrderDate, Customer.custlastname, DeptID, OrderDetai ...Show All

• Alinushka Email subscription Issue

  We have deployed SSRS 2005 on internet using Forms authentication. every thing works just fine except the email subscription; when a user who is part of browser role (manage individual subscription) clicks on new subscription his To field is grayed out (unable to modify) and account showing in it is the service account we use to run reporting service. we need to give users permission to specity To, CC, BCC fields without letting them see other subscriptions. can you help us configuring this Hi Aneel- You need to go into the rsreportserver.config file located in the ReportServer folder and look for the "<SendEmailToUserAlias>" node. If it is "False", change it to "True" and you'll be abl ...Show All

• Chedid Haddad SQL Statement

  Hello All, I imported a excel file from SSIS and created a table called Lockbox. To avoid the user from having to change the excel file -it is being imported as is. I only need 4 fields: [Contract ID] , [Check Number], [Owner ID], [Site ID] The table I need to import to Transaction has Diffrent Column Names -ex-CustomerID, ResortID. The columns are in diffrent order. And I need to add more information into them like UserID = 'Hwells', Trantype = 'MF' and convert to a diffrent data type [Site ID] to text. Is their a sql statment that can do this SQL2005 Thanks for your time I'm trying to work out what you mean here... Following your imports, you have tables dbo.[Lockbox] and dbo.[Transaction], and now you want to add extra colu ...Show All

• Davids Learning Exporting Database using Microsoft OLE DB Prvider

  Hello, I'm trying to export a database using the 'DTS Import/Export Wizard', I need to use the 'Microsoft OLE DB Provider for SQL Server', but it does not appear on the 'Data source' Drop-Down list of that Wizard. What can I do to get that OLE DB Provider installed I'm running SQL Server 2000 Personal on a Windows XP Media Center PC and I have MSDAC 2.8 SP1 installed. I also checked that I have the file sqloledb.dll on the 'C:\Program Files\Common Files\System\Ole db' directory. I'll appreciate any help. Thanks. Anybody I'm having the exact same problem. how do you "re-install" and register the standard data source items like " Microsoft OLE DB Provider for SQL Server &qu ...Show All

• DrFlick setup for school projects

  How do I install / setup SQL server 2005 so that I can use it for my school projects. I am learning C# and web service programming that supports connections to an SQL database. I need to be able to use it as a "local host" that can connect to Visual Studio 2005. Thanks Sam, That helped and I am able to connect also to the TOM database now. Excellent! I already have a copy of the SQL 2005 developer edition. I guesss I am wondering how I install and setup that version Thank you, TG_KG My suggestion would be to try the free eval version of SQL Server 2005. It is good for 180 days and can help you play around ...Show All