Answer Questions

• ahmedilyas 'dbo' problem

  We've one windows user account, which is directly associated with 'dbo' user. What I mean by the above is: When you look at the logins you would see this user as 'Domain\siva' when you look for this user in the database user list, you won't find this windows account there. When you double click 'dbo' from the user list, you would see it's associated with the 'Domain\siva' login. When you go to login properties for this account and grant access to that particular database (under User Mapping), ther 'user' column shows 'dbo' rather than 'Domain\siva'. Even if you type 'Domain\siva' in the 'user' column, it gives an error saying, "Rename failed for user 'dbo'................. Cannot alter the user 'dbo' (error 15150) I want t ...Show All

• VDBA RESTRICT FILTERS BASED ON USER LOGIN

  I am using a SSAS cube as my data source for my reports. I have set up the roles on the cube and that works fine. However, in my reports I want to be able to restrict the report filters based on the user that logs in. E.G. we have a list of users from different countries. if a user from the US logs in then the country filter should have only USA in it. If a Japan user logs in then the country list should have only Japan. Currently, the country filter still has all the countries but the logged in user can only get data for his country. I want that list to only be populated with user country only. I think it has something to do with the dataset that is populating the country list but I have no idea as to how to fix it. Any help will be appr ...Show All

• clint 2 Calculate Quarter

  Hi, I need to retrieve both Mont and Quarter from an MS SQL server field containing a date as ''01/01/2007 12:10:00'. Retrieving the Month is working properly, but getting some sql error with the Quarter function. I will appreciate if someone can indicate me how should I do in order to retrieve the Quarter from a date. To retrieve the month, I am using: & "MONTH(STOCK.VALUEDATE) AS 'Month'" To retrieve the Quarter, I am trying (but getting error): & "QUARTER(STOCK.VALUEDATE) AS Quarter" Thanks, Aldo. I already got the answer... & "STOCK.VALUEDATE AS 'Original Date', " _ & "DATEPART(month, STOCK.VALUEDATE) AS 'Month', " _ & "DATEPART(qua ...Show All

• Andrew Beery SQL error in MS Access and need helps

  Posted: Fri Dec 15, 2006 9:51 am Post subject: SQL error and need helps Your error would appear to indicate you are connecting to an Oracle database. This is a Microsoft SQL Server forum. There are some tricks in Oracle to defining and converting datetime fields, all of which I have forgotten - however, I bet someone on an Oracle forum could help you, if no one else responds. ...Show All

• Yulia Issue with checkpoints and Event handlers

  Hi, We are currently facing an issue in ensuring restartability of an SSIS package. The scenario is explained below. Context: The SSIS Package has two Data Flow tasks. The Data Flow task named DFT1 is the predecessor for DFT2 and chained with OnSuccess precedence constraint. OnPreExecute and OnPostExecute event handlers have been implemented for DFT1. Each task in both event handlers as well as DFT1 and DFT2 have FailPackageOnFailure set to True. Scenario1: Task in OnPreExecute of DFT1 fails. DFT1 is attempted and succeeded. OnPostExecute of DFT1 was not attempted. DFT2 was not attempted. Checkpoint file was created; however, no entries were made. When restarted, execution star ...Show All

• daff2 How to know if user have access to a specified DB

  Hi ! I'm searching a way to know if a specified user have access to a specified database. For sure I may look with Enterprise Manager, but I'm searching a way by looking in System Table, or using StoreProc Where the Info about user and is Database access are store Any idea I'm using MSDE Zak Then you should be good. Good luck, Zakary! select [name] from sysusers where [name]='userName' Oh ! Sorry you are right !!! Thanks for the info !! That tell me that the user exist on SQL but not if the user have access to a specified Database ... Thanks body! I don't use Alias in my project only SQL Account Actually, when I w ...Show All

• chrisryp print / export SSRS report from t-sql

  Greetings, I have a report that I would like to execute (export to PDF) from t-sql. I can view it interactively from the SSRS website; I can view it from my asp.net application; I can also create the PDF programmatically from the asp.net front-end, but I need to run a batch type query from a stored proc with a report(PDF) as the output... For example, I want to create and send out a PDF based on a trigger.... How do I do this from t-sql Any ideas Thanks. Dan Web Service calls are only hard to implement in TSQL, close to say that this is not possible. Would could be done is to write an application and execute this application on a trigger base with passing the needed parameters to i ...Show All

• Stampede2 OLAP - EXCEL problem - urgent

  Hello, I have a dimension hierarchy with 2 levels, like this: A - X - Y - Z B - U - V - T And I have a cube with the dimension above and one measure (sum). The fact table of this cube has 2 columns (level2,sumvalue) and i have the values: Level2 SumValue X 1 Y 2 T 6 When I access this cube from Excel and use multiple selection weird stuff happends. So, I create a Pivot table, in which i select only X,Y,U: Level1 Level2 Total A X 1 Y 2 A Total 3 Grand Total ...Show All

• Yang Hsien Min How to deal with User!UserID in Data-Driven Subscriptions

  First a bit of background. We use the Windows-logon to authenticate en identify the user. With this logon we check within most of our reports what a user is allowed to see. Depending his level or geographical location he is allowed to run reports on one to all sites. He can selects the sites from a Multiple Select box. This works fine. Now, we want to use data-driven subscriptions, I understand why we can't use this parameter, but how do you people deal with this kind of configurations. I would prefer not to 'double' the reports in a normal and a subsciption version ..... Meanwhile i've been playing to write a custom assembly, hoping to get the Username placed so that i could mislead SSRS, bu ...Show All

• Jamie Thomson Convert columnar data into rows

  I have a table of data that needs to be converted to rows but with a way to identify for each row the column the row value came from. Here's an example table: Employee FED MEDI SOCSEC 123 $100 $25 $70 234 $242 $54 $90 345 $75 $10 $55 Here's the format the data needs to be in after it's converted. Employee CodeType Code Amount 123 T FED $ 100 123 T MEDI $ 25 123 T SOCSEC $ 70 234 T FED $ 242 234 T MEDI $ 54 234 T SOCSEC $ 90 3 ...Show All

• mmmmBeeeer How can we check the language by which functions, stored-procedures, and triggers are written in SQL Server 2005?

  Hi, all here, Could please any experts here give me any guidance in what way can we check in what language (T-SQL or CLR language ) the user defined database engine objects :functions, stored-procedures and triggers are written Thanks a lot in advance for any guidance and advices for that. With best regards, Yours sincerely, Hi, Simon, Thanks a lot. With best regards, Yours sincerely Sys.objects provides that information Have a look at this page in BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f8d6163a-2474-410c-a794-997639f31b3b.htm ...Show All

• Irfon Subhan Results & Messages Window

  SQL Server Management Studio I have dual monitors and I would like to move the results and messages window to my secondary monitor. I can't seem to figure our how to unconnect it though. I have been able to move the object explorer. Thanks, Mike That isn't possible in the current version. The results and messages panes are actually part of the editor window, and editors windows are constrained to be within the parent frame. "Tool windows" like Object Explorer aren't subject to this constraint. If this feature would is important to you, please file a suggestion on http://connect.microsoft.com/SQLServer . We use customer suggestions to help guide feature selection in future ver ...Show All

• SouLDragooN log reader generates error log file and mdmp file every minute

  Hi, anybody can help with these we want to know if something we did make this happen or because this is just an error in SQL 2005 RTM version thanks ------------------------------------------------------------------------------------- 2007-01-31 22:33:50.045 Microsoft SQL Server Log Reader Agent 9.00.1399.06 2007-01-31 22:33:50.045 Copyright (c) 2000 Microsoft Corporation 2007-01-31 22:33:50.045 Microsoft SQL Server Replication Agent: logread 2007-01-31 22:33:50.045 2007-01-31 22:33:50.045 The timestamps prepended to the output lines are expressed in terms of UTC time. 2007-01-31 22:33:50.045 User-specified agent parameter values: -Publisher QATESTI\SQL2005 -PublisherDB qatesti_sql2005_db -Distributor QATESTI\SQL2005 ...Show All

• Scionwest Corruption of backup file on remote server

  Dear all, What I want to do is to backup my database through the SQL script, when the backup is successful, the .bak file is saved in my local harddisk. After that, I used the XYRunProc to execute a "copy" command to copy the .bak file to a remote server. However, when I want to restore the database using the .bak on the remote server, I found that the .bak is corrupted. This problem does not exist if the file is copied to the remote server manually (click copy on local server and click paste on remote server). Do anyone know what's the problem of this This really made me very frustrated. Hope someone can help me, thank you very much! Regards, Strike Hi Strike, XYRunProc is an ex ...Show All

• Liloch Expression from within sproc?

  If I'm inside a stored procedure called by an MDX query, the following would query the cube and figure out the sales for the current tuple: new Expression("[Measures].[Internet Sales Amount]").Calculate(null).ToDouble() So I was expecting to be able to do that from within a stored proc called from a DMX predict query. I was hoping that I could evaluate the $Cluster expression from within a sproc and figure out what cluster the current row in the DMX query belongs to. Basically, I'm trying to make my sproc function signature more elegant so I don't have to pass in the NodeId like: select $Cluster , MyAssembly.MySproc( PredictNodeId ( Cluster ())) as CoolData from [Customer Clusters] NATURAL PREDICTION JOIN ( select * f ...Show All