Answer Questions

• jods Users Folders

  Hi, I am wanting to manage my users folders. Now, I can see them, but I cannot see their "My Reports" folders. Also, if I publish a report to their "user" folder, they cannot see it. What am I missing with permissions Thanks! Users folders is part of the my reports feature: /Users Folders/<user name>/My reports put content in the user's my reports folder and they should be able to see the content. Users do not have access to their folder /Users Folders/<user name> by default. If you login as a local administrator on the reports server computer you can set the permissions. You can grant any of the existing roles or define your own. To navigate to the &l ...Show All

• Vampire7639 SQL Server 2005 Std Ed SP2. - Lock Pages In Memory

  How do I determine if Lock Pages In Memory is applied I have the Policy to the Service Account. Thanks - Covi forgot to add sp_configure 'awe enabled' Thank You for replying, I have Locked Pages In Memory set on to the Service Account. How can I confirm other than looking at the setting that it is truley being applied to SQL Server 2005 Std. Ed. Is there a counter or something that confirmes the setting is being applied by SQL Server. not that I know of USE: DBCC MEMORYSTATUS From: http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx “When you enable Lock Pages In memory, DBCC MEMORYSTATUS’s output will show that AWE mechanism is in use” ...Show All

• janetfan95758 SQL Table valued function as Partition Data source. How?

  Hi, How can I use table valued function as data source for a partition Is it possible Thanks a lot Deepak! Your answer was on time. Here's an Adventure Works example from Erik Veerman's blog - is this the approach that you were looking for http://solidqualitylearning.com/blogs/erik/archive/2005/12/16/1503.aspx >> Managing Analysis Services Partitions with Table-Valued Functions (table UDFs) I've been spending much of my time recently working with Analysis Services 2005 (SSAS).   You'll see a few blogs in the near future with some practical learnings/ideas on SSAS in tandem with my SSIS blogging.   Here's one of them. ...Show All

• JavaBoy Cannot connect to AS2005 remotely using SSMS or BIDS

  I really need help to understand why I can't connect to SSAS from a remote machine running SSMS or BIDS. Following is my setup: SQLServer 2005 on a development server Server Name: SQLWIN-1 Named Instance: SQLWIN1 If I am running management studio locally from the server machine I can connect to SSAS fine. However, when running from a remote machine the connection fails with the following errors: TITLE: Connect to Server ------------------------------ Cannot connect to SQLWIN-1\SQLWIN1. ------------------------------ ADDITIONAL INFORMATION: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient) ------------------------------ No connection could be made becaus ...Show All

• estrela666 Error on a view

  I am getting an error when I open a view err is: Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (260) was exceeded. How do I work aorund this issue On the assumption that you are using SQL Server 2000, there are a couple of KB articles on this: http://support.microsoft.com/kb/818406 http://support.microsoft.com/kb/828269 Either way, it seems that the solution is to upgrade to SQL Server 2000 SP4. Chris Well, according to the second link I posted: "If you still receive the "Msg 4414" error message, you may have to break up the query so that a lower number of tables or views are referenced in the ...Show All

• Subby Dev SQL2005 Management Studio malfunction altering user after (SQL2000) db attachment

  I have encountered a frustrating problem [bug ] in MS SQL Server 2005 Management Studio -. Attach a SQL 2000 database -. A user exists which I need to associate with a login. -. I create the login (same name as user) -. I edit user properties, but the Login field is disabled (along with all Username selections). -. I try deleting the user, cannot because user owns some db schema element (nothing appears under "Owned Schemas") -. I try changing the db_owner flag on the user, but when I click OK I receive the error: Login name must be specified. (SqlMangerUI) -. I checked the database properties->security, removed the user (it disappeared), hit okay, tried previous steps again without success. What to do for now Creating a diff ...Show All

• Niehls Events keep bubbling up, even with Propagate=False

  I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in the middle of the night, probably due to some maintenance going on. I have created an event handler to log the error, sleep a couple of minutes and set Propagate=False. This works great. When the connection is down, the error is logged, once the connection comes back, the package just keeps going. I also have an FTP component that receives a file a ...Show All

• Bill Martin Help in Installation

  Anyone tell me which edition i use SQL server for winxp as server.can anyone send me that file. You can install all editions except Enterprise on XP SP2. These would include SQL Server Express, Express Advanced, Standard, Workgroup, & Developer. Thanks, Sam Lester (MSFT) ...Show All

• Duncan Woods Multi value in Report Parameter using MSVS Report Designer.

  Hi All, I have a question, How to user the Multi value in Visual Studio Report Designer. My dataset contains the following Select empno,empname,basicpay,deptcd from employee where deptcd in (substring(@gdept,1,4)) Here variable gdept is the report parameter. I am passing the value. it works fine with single value. ( the source of gdept is a another dataset to list the deparment code+name, Example DEP1 - COMPUTER DEP2 - ADMIN DEP3 - FINANCE ) when I preview, i have a combo box to select the department. If I choose one deparment, it works fine. If I choose more than one department or select all I have error message "substring function requires 3 aruguments." what is wrong is the query Plea ...Show All

• GetCode Records not updating in Script Component

  I am seeing a strange behavior in a script component that I can't figure out. Basically, there is a field in my script that checks to see if a string field is length of 1. If it is, it updates the field with some value. The strange behavior is that it picks up some of the rows but not others. If Row.FieldValue.Length = 1 Then Row.FieldValue= "Some Value" End If I've tried variations such as: If left(Row.FieldValue.,1) = "-" Then Row.FieldValue= "Some Value" End If But I get the same results. Any Ideas Does [Field] need to be trimmed Might some data contain trailing white spaces Thanks, that did it. I am ...Show All

• ccal Visual Studio 2005 The remote connection to the device has been lost. Please verify the device connection and restart debugg

  Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get The remote connection to the device has been lost. Please verify the device conection and restart debugging. I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back! My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've re ...Show All

• programmer01 Data retrieval is much slower in RS than in management studio

  A call to a stored procedure completes in 13 seconds when ran from within SQL Server Management Studio. A report whose data source uses the same stored procedure can take as long as 10 minutes to run. The same parameter values are used in both the direct call and the report. The execution log says almost all of that time is spent on data retrieval. How could that be What might be the cause WITH RECOMPILE Another one of our developers found a forum where someone had posted the same issue. Their suggestion was to add WITH RECOMPILE to our stored proc. After doing this we have experienced dramatic increases in performance with no unexplained slow periods. Also, before we added WITH RECOMPILE, the ...Show All

• Brian_W display TODAY's records...

  I am saving files in SQL Server 2005 with a datetime field called news_date_time and I want to display all today's records regardless of the record time. I tried this code but didn't work.. [code] SqlCommand sql_command = new SqlCommand("SELECT * FROM files_news WHERE news_date_time = TODAY ORDER BY news_date_time DESC", sql_connection); [/code] There's a performance issue converting a date into a string and then comparing a string Can this performance difference even be measured Adamus The only problem with that method is that it's quite bad for performance.  An index on "orderdate" will not be usable by the query engine to help satisfy the query.   - ...Show All

• black dove RS 2005 Prompting for Credentials

  For the life of me, I can not get integrated windows authentication to work with an installation of Reporting Services 2005. I get prompted when connecting to the /Reports IIS virtual directory when not on the IIS machine. If I'm logged onto the machine I don't get prompted. Or if i use the IIS servers IP address in the URL I don't get prompted. The only way I can avoid windows prompting (when not logged onto the IIS machine) is to set the /Reports virtual directroy to "Enable Anonymous Access" I know Windows Integrated authentication works because we have other web applications where Anonymous access is turned off, and everything works as expected. Meaning going to another server for database access thos ...Show All

• Sniper167 managing SQL server 2000 servers with 2K5 management studio

  For some reason when I try to use sql 2005 management studio to manage a sql server 2000 server and attempt to use activity monitor to view processes I get an error (see below) (BTW I love being able to copy the message text). I can perform this operation from enterprise manager without issue. Is this a problem with management studio TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Unable to execute requested command. ------------------------------ Unable to launch Activity Monitor. You may not have sufficient permissions. (ActivityMonitor) ------------------------------ Timeout expired. The timeout p ...Show All