Answer Questions

• Karl Costenbader 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

• Eva Pierce Monsen Set c# parameter properties

  Hi all, Is it possible when creating a stored procedure through visual studio using a sql server 2005 project, to set the sizes of the parameters that are specified. For example: public partial class test { [Microsoft.SqlServer.Server .SqlProcedure ] public static void addRecord( string name, string details) { ................. some code ................. } } Would it be possible to set the size of the parameter 'details' to nvarchar(max) and 'name' to nvarchar(50) or something along those lines. The problem at the moment is that when this project is deployed both of the parameters are set to 4000 characters and sometimes the details parameter are greater than 4000 characters and it is being trun ...Show All

• Stelresort Is there a way to alphabetically select rows from table?

  I have SQL mobile database. Due to the size and speed, I would like to select only rows that start with a certain set of alphabets. Is there a way to do this I just don't want to query everything and use only a small number of rows since the recources on the device is limited. Thanks. See LIKE operator help in Books Online for more details on the syntax and examples. http://msdn2.microsoft.com/en-us/library/ms174473.aspx Like '[A-F]'   More on LIKE - http://msdn2.microsoft.com/en-us/library/ms179859.aspx Thanks for you help. How about selecting from "A-F." It would have to be a column in a row that starts with certain le ...Show All

• 2326ac SQLServer 2005 Problem

  Hi! I want learn about ADO.NET, I'm trying to start a SQLServer 2005 Express with a example database for practicle with it, but i can't connect to configure the db. I'm tried dowloading a set of examples from Microsoft.com, but whe i execute some example aganist the db always get the same error: C:\DB\>sqlcmd -E -i OrderingServiceScript s\SetupOrderingServiceProgram.sql HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow re ...Show All

• NeederOfVBHelp Copy tables on remote servers

  Hi all, I'm trying to create a script / stored proc that copies one table from a remote server to another table on a different remote server. The approach I wanted to take was... create a stored proc that can be called remotely the stored proc tests to see if the table exists, if it does it is dropped, if not it is created new table structure and data copied from remote server A to remote server B ...I feel that this should be quite easy, but I must admit I'm struggling. Any help would be really appreciated. Cheers, Jon Thanks for your reply William. I have tried SELECT INTO... select * into remoteServer .intranetcms.dbo.woodford_bridge from localServer .intranetcms.dbo.woodfor ...Show All

• TechNoFear Missing SQL perfmon counters

  SQL perfmon counters are missing. Running SQL 2005 Workgroup (which is a 32 bit app) on a 64 bit OS. Could the counters be missing because of running a 32 bit app on a 64 bit OS Anyone know Thanks. Thanks! This worked. try running x86 perfmon (i.e. %windir%\SysWOW64\perfmon.exe). ...Show All

• Salman Maredia BIDS - Error on design surface of Calculation tab in Cube

  Has anyone seen this Within 'Business Intelligence Development Studio' (BIDS) with a cube opened and the calculations tab selected, the design surface displays a message that reads: Unexpected error occurred: 'Error in the application.' This occurs in any project I open and it still occurs when I restart BIDS or the computer itself. Any ideas Can anyone suggest a remedy Seems like it because it worked perfectly fine before I refreshed it with Office 2007 TR, that must have upgraded the dll's on the oledb folder to the 3009 release making it out of sync with the dll's on the tools / SQL Server. Yes, my system too has has Office 2007 Beta 2 TR i ...Show All

• JamesCox1968 Newbie Question

  Hi Guys, I am new to this Reporting Service world. May be its very simple question. I have create a report in SQL Server 2005 reporting services and want to link this report with aspx page. How I do this. Just want to link report with default.aspx page so when this page open report also open automatically. Please let me guide how could I do this. Regards I would recommend using the ASP.net ReportViewer control. It will make the web app appear much more polished than just linking to the reportmanager. ReportViewer1.LocalReport.SetParameters( ); Juran Hi Guys, Please ignore my previous email. I have fixed the above issue. Now I don't know ...Show All

• tchen777 Reporting Services

  Dear All, Developed a report using Reporting services (2005)integrating Chart FX .The report is built successfully but raises an error on deployment. Error: Could not connect to the report server. To resolve the error in the properties of the project i had given the target server url= Http://localhost/webfoldername (installed webservices on the local server) but still i am getting the same error. How to resolve the error. Regards Mohd Sufian Thats probably like the error message is telling you. YOu have to either restore the symetric key which is used to encrypt and decrypt the report definition in the Report Server Database or if you don’t have a backup copy, delete all encrypted content in the database. ...Show All

• Adrian Heath DB Access to Add Tables to a DSV

  Wondering if anyone can tell me what level of access a cube developer needs in the DB source (SQL Server 2005) in order to add tables to a DSV. For some reason, we can not even get a list of tables to add to the DSV with db_reader access. However, when we grant db_writer access all is good. Either I am missing something here or there seems to be a discrepancy. I thought that one of the advantages of the DSV is that you do not need that level of access in the DB as you can create quieries and calcs right in SSAS. Thank you in advance for the help. ...Show All

• cwlaualex Schedule table

  Where can I find an english translation of the values in fields ReccurrenceType , State , Daysofweek , and Type in the Schedule table of the ReportServer database Example what does it mean when RecurrenceType is equal to 2, or equal to 4 Thanks I agree with serginio17. Several of our scheduled reports have a stored procedure as their data source. These procedures sometimes update data before selecting it for the report to use, which means we can't schedule several reports to run at the same time if they each update the same table. Thus, we are looking for a way to show what subscriptions are active and when they are scheduled for. Viewing all schedules one by one using the web interface is not practical for the nu ...Show All

• MarioBR How to use information from a dimension in a calculated member

  It would be really useful to be able to extract information from an Analysis Services 2005 dimension such as:- "The number of seconds in the current time dimension member". This will enable calculated members such as the following to compute a process percent operation time. Member = [Measures].[Sum of seconds the process was operating] / "No of seconds in the current time dimension member" (eg.Day, Week, Month etc.) How can I get this information from the dimension for use in a calculated member Many thanks Thanks for the suggestions Deepak however what I am trying to do does not directly involve the time dimension. I have another dimension called Shift which co ...Show All

• elhussein RowCount

  Hi, want to get the number of rows i'm retrieving from a source. This count should be written as " No: of roes retrieved" + varname I have used OleDbSource, RowCount,Script [ To write in a file ]. Rows is the package level variable name used in rowcount. when i do this way it always writes as 0 in the file. [code in Script] Dim sw As New StreamWriter( "D:\Vijay1.txt" ) s = Variables. Rows sw.WriteLine(s.ToString) sw.close [/Code] Can anyone help on this Can you try as follows: Dim sw As New StreamWriter( "D:\Vijay1.txt" ) sw.WriteLine(Dts.Variables( "Rows" ).Value.ToString()) sw.close()   Thanks, Loonysan ...Show All

• ccote Re-Post when using drilling down into parent-child data

  I have a problem with a report that seems to re-fetch its datasets on the initial click of a toggle button, but not for any additional clicks..  The report displays two tables, one is the 'results' and the other is the 'rules' for the user to understand why his results may be what they are.  The 'Rules' table is the one giving me trouble. The 'Rules' dataset has a unique id and a parentid which is NULL or points to another row in the same dataset (representing parent/child relationship).  There is only 1 details row in the rable, and the details grouping for that row groups on the dataset.id.  The parent group is set to the dataset.parentid.  The initial visibility is set to the textbox in the first colu ...Show All

• wessen Union All

  Hi, In my data flow taks, The Source data is coming from AS400 has 4 columns, I need to achieve the followings and require your help. 1. Generate a new column which will be combination of concating these 4 columns. 2. Need to add an extra row for Header & Footer. Please Help. Concatenation is achieved using the Derived Column component. Adding your own header and footer rows is a bit more difficult because they need to have the same metadata as the data row. For this reason, concatenate all columns together so as to make a single, very wide, column. You can then use the UNION ALL component to put your header, data and footer together. The header and footer will probably be created using a source script compone ...Show All