Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - New to SSRS - Pass query paramater at runtime Hi all, Im new to SSRS, basically I have created and deployed a report to my reporting server. Now I have a query parameter on my report. From my application, I can access the report manager, and here it asks me for my variable. I'm not sure if my question is a vb.net one, but I was wondering if anyone knew how I could pass my query paramater to SSRS at runtime. Basically it would be easier for my users if they could just see the report they are interested in, rather than having to type the variable in to be able to see the report. Thanks for your time. Barry Andrew Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 2
    - User Defined Function Help Needed so . . what is the problem then Are you getting any error message Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 3
    - Locking table select 1 from dbo.Department with(TABLOCKX HOLDLOCK) Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 4
    - Managing SQL 2000 databases on Vista... You can use the bcp utility: http://msdn2.microsoft.com/en-us/library/ms162802.aspx Additional, you can download the eval version of the full SQL Server product. Thanks, Peter Saddow Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 5
    - i got an err msg ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. ------------------------------- so what i should do to mach for a biginer, where is this file thanks Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 6
    - Third Party .NET Charting packages Can SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from. R Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 7
    - Sql Server Express - Shared Hosting - Connection String - What do you guys do? Hey, I have a asp.net 2.0 app that has a sql server express backend. I have been scratching my head for weeks trying to find a good wasy to encrypt my connection string. I store the string in web.config (which in itself is in theory "safe" because it's not servable) and I have scoured the web to try to find a simple way to encrypt the connection string. Even using user store would require running aspreg_iis.exe on the host with a command prompt (which clearly I cannot do). It seems that everyone's solution requires running a command prompt executable on the server. So I am left to wonder what everyone else does. I am not comfortable using just the web.config because a determined hacker could get to that info. Then again, a determined hacker could get into any system , I guess. There are no credit card #'s stored in this app, but in theory there must be a way. I run all access to the db through stored procedures with permissions, for whatever it's worth. Thanks in advance! David Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 8
    - Stored Proc. With Multiple Database Reads I am trying to write stored procedures that deny table-level read/write to the sproc_user login. Here is what I want to do: Make a sproc_user login and allow public access to a database called KM. Within KM database, write stored procedures that query and update tables that may exist on either of three databases: KM, QM, or REP. However, I can get the stored procedure to read/write to tables on KM database, where sproc exists, as long as I grant execute rights to the login. However, how do I allow my stored procedures to SELECT, INSERT, and UPDATE to tables within QM and REP Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 9
    - Display Analysis Services Server-Based Formatting in RS 2005 Report Thanks Teo, Actually I'm still having problems with displaying color. Here are some more details of the issues...thanks in advance for any help you can provide: I am trying to display a grid with dimensions on both the rows and columns and server-defined formatting on the cells within. In AS 2005, you are not allowed to have a dimension on the columns if you use the "Microsoft SQL Server Analysis Services" data extension, and if you use the OLE DB connection, then you are allowed to have a dimension on the columns, but the cell properties (FORE_COLOR and BACK_COLOR) do not get translated to AS attributes. One work-around is to translate the column dimension members onto measures, and then display those measures in the grid...however, in my specific implementation, that causes the report to run really really slowly (minutes) and is just not a feasible solution. Basically, I need a data extension that allows a dimension on the columns AND translates the AS properties to RS attributes...does one exist (either through MS or a third party) I need to dynamically generate an MDX query based on user input. For instance, if the user inputs "United States" (via an RS report parameter...I like this feature a lot by the way), then I want to query my relational SQL database and find a list of comparison countries (comps) and then generate an MDX query which will show me a grid of AS-based data for each comp. I have not come up with a way to do this at all. In another reporting platform we demo'ed, they provided a programatic hook for developers to manipulate the XML report definition before it was sent to the rendering engine and at that point you could insert a custom MDX query based on the user input, but I have not found any way to manipulate the dataset queries in RS. The MDX query parameter implementation does not seem helpful in this case. I have heard of something called "query expressions" which sounds promissing, but I can't actually find any examples of this or even a basic explaination of how to use this feature (if it exists). Thanks! Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 10
    - Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe. Not sure if you have resolved this or not. I had the same error trying to connect to a new SQL Server 2005 installation with the management studio from a remote machine and discovered that the named pipes protocol was diasabled in the SQL Server network configuration protocols. I enabled it and restarted SQL Server and the problem was resolved. Good Luck Lane Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 11
    - Security required to run deployment utility Thanks Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 12
    - sql query Very close Alejandro, However the OP wanted a format of 'hh:mm AP'. (Notice the space between the minutes and AP indicator.) This alteration will produce exactly what the OP requested. select stuff( right( convert( varchar(25), getdate(), 0 ), 7 ), 6, 0, ' ' ) -------- 12:23 PM Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 13
    - Debug tsql I am talking about query analyzer (SQL 2000) Here I took a screen shot of it http://tinypic.com/view/ pic=44hvq7a Right click on the procedure and the last thing in the menu should be debug Denis the SQL Menace http://sqlservercode.blogspot.com/ Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 14
    - Calling a package at Runtime I am working on a package that will sense a text file in a folder. From this text file I will be extracting the file name which will tell me what task I need to run. How can I create a package that, depending upon what the file name is, call a specific package. To be more clear, I will have 3 different flat files that is each in a standard form. Their names will be unique. To transform their data will require different ETL logic. I will be using a loop to constantly check to see if a file has been put into the directory. I just need to know how I can direct the input file to the proper ETL task. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 15
    - define a default value ?? thanks Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 16
    - Irritating issue in Reporting Services 2005 SP2. Nope Any reply MSFTs Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
- Next
  - 1
    - Way to find registered classes/functions for the Assemblies added in Analysis Service. Hi, Is there some way through which we can find the classes and function registered with Analysis Services, when we add Assembly code for Stored procedures Thanks, Santosh. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 2
    - Problem with AuthenticationExtension Hi, there's in fact no big difference with the extensions you're using with SQL2000. The security extensions should be there when you installed SQL2005. I know that a couple of extra methods came with the Security extension 2005, that you have to override in your own code, but you'll notice soon enough. What error message do you get Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 3
    - Help with finding last record! try this: -- sample table / data create table t1 ( [code] nvarchar ( 10 ), [date] datetime ); insert into t1 VALUES ( 'AB' , '2004-10-05' ); insert into t1 VALUES ( 'AB' , '2005-10-05' ); insert into t1 VALUES ( 'CD' , '2005-10-05' ); insert into t1 VALUES ( 'CD' , '2006-10-05' ); -- return the code and date of doubles, -- when the newer date is at least 180 days before today select b . code , b . date from t1 as a join t1 as b on a . code = b . code WHERE a . date < b . date AND b . date < ( getdate () - 180 ); Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 4
    - SAC Command Line utility doesn't start SQLBrowser Service I've exported surface area configuration settings from a server and tried importing them onto another server. The remote connection settings are imported but the SQLBrowser service remains Disabled. Am I doing something wrong The command line command I ran (in the C:\Program Files\Microsoft SQL Server\90\Shared directory) is "sac.exe in sacconfig.xml". The following is my config file: < xml version="1.0" encoding="utf-8" > <CommandArguments xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema "> <Components> <anyType xsi:type="Component"> <Type>SqlServer</Type> <InternalType>DatabaseEngine</InternalType> <Instances> <anyType xsi:type="Instance"> <Name>SQLEXPRESS</Name> <Service> <Name>MSSQL$SQLEXPRESS</Name> <StartMode>Auto</StartMode> <ServiceState>Running</ServiceState> </Service> <Features> <anyType xsi:type="Pair"> <Key>AdhocRemoteQueries</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>CLRIntegration</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>DedicatedAdministrator</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>DatabaseMail</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>HTTPAccess</Key> <Value xsi:type="ArrayOfAnyType" /> </anyType> <anyType xsi:type="Pair"> <Key>OLEAutomation</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>ServiceBroker</Key> <Value xsi:type="ArrayOfAnyType" /> </anyType> <anyType xsi:type="Pair"> <Key>SQLMail</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>WebAssistant</Key> <Value xsi:type="xsd:int">0</Value> </anyType> <anyType xsi:type="Pair"> <Key>XP_cmdshell</Key> <Value xsi:type="xsd:int">0</Value> </anyType> </Features> <Protocol> <anyType xsi:type="Pair"> <Key>NamedPipes</Key> <Value xsi:type="xsd:boolean">true</Value> </anyType> <anyType xsi:type="Pair"> <Key>TCPIP</Key> <Value xsi:type="xsd:boolean">true</Value> </anyType> </Protocol> </anyType> </Instances> </anyType> <anyType xsi:type="Component"> <Type>SqlBrowser</Type> <InternalType>SqlBrowserService</InternalType> <Service> <Name>SQLBrowser</Name> <StartMode>Auto</StartMode> <ServiceState>Running</ServiceState> </Service> </anyType> </Components> <Version>9.0.242.0</Version> </CommandArguments> Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 5
    - Which Data Flow task to use? jrp210 wrote: I would need to pivot the data in this case though. Its normalized now with mulitple rows of companies having different company ids. Then there's always the pivot transformation. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 6
    - Reporting Services 2000 Installation Problems. Hello every1. I have been trying to install Reporting Services 2000 on a Windows Server 2003 machine with SQL Server 2000 and Framework 2.x for a couple of days now. When i run Reporting Services setup it tells me that Asp.Net is not installed or is not running, i know this could be caused becouse i have Asp.Net 2.x running instead of 1.x, but what ever i do, changing all IIS settings and website settings so the server uses Asp.Net 1.x the problem still exists, is there any solution besides a reinstallition and installing RS2000 be4 the Framework 2.0 Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 7
    - 64-bit Separate Install?? Thanks for the clarification. Now I have another question from your response, I am guessing my IIS is 64bit because when I installed IIS, I had to point to AMD64 folder in the source CD. How do I confirm this Thanks in advance. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 8
    - Is there 1 default instance per OS Server or per SQL Server? On a Server 2k3 x64, I've installed SQL Server 2000 x32 SP4 and SQL Server 2005 x64. When installing both SQL Server 2000 and 2005 on the same server, does each SQL Server have it's own "default instance" or there can only be one "default instance" per server TIA, Gary. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 9
    - SSMS Help Hi, I'm not sure this is the right discussion room that I'm looking for my problem. In fact, the problem is very simple though I don't know how to deal with it. I accidentatly clicked some buttons on my SSMS IDE. And, my IDE seems bad. I uncheck 'Dockable' click box of SSMS's Object Explorer. And, is there anybody who know how to put that back to the original format Thanks. Myo Zaw Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 10
    - Creating an Windows Rdl on the fly using .net programming Hi, Thank you very much for the link. I will just go through the link and will check it out whether this sorts my purpose. Sorry for the inconvenience and thank you very much for the helping hand Kind regards Pratik Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 11
    - Datamigration to MS CRM Dear Smilebey, Send me the CREATE Table statment of your tables in source and destination to pedro.perfeito@cgd.pt . I will try to help you, and give you the better option to resolve it! Thanks! Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 12
    - SQL server replication connection problem Hi I have a problem when trying to setup replication between two SQL servers on different networks. My publication server is SQL Server 2005 Standard Edition. My subscription server is SQL server 2005 Express Edition I have setup the publication no problem but am now trying to create my subscriber. However, when trying to connect to the server, I receive the following error: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'W2M-RDC-01'. (Microsoft.SqlServer. However, because the servers are not on the same network, I cannot use the server name. Why does it not allow you to connect to an IP Is there a way to create an alias I have read that you can but am unsure how to do this. Do I need to change the hosts file If so, where can I find this and what exactly do I need to change Kind Regards Dan Rostron Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 13
    - Aggregation Types Can anyone briefly describe all aggregation types available in SQL Server Analysis Services Thanks, Shyam Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 14
    - the procedure 'sp_addrolemember' cannot be executed within a transaction I use sp_addrolemember inside a DML trigger and every thing goes well in my computer; I can insert or update into my table and sp_addrolemember is executed successfully, but my customer get this error every time he tries to insert or update into the table. "the procedure 'sp_addrolemember' cannot be executed within a transaction" Can anybody help me solve this funny error. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 15
    - Get Culture for Multilanguage in Reporting Service Well that sounds all too familiar, ��#error��, this is often caused by insufficient access to the assembly��s resources or inaccurate data sent to the localization service (an empty string). In the web application that we are currently developing we created our own reporting service that calls the SRS server and sends all the parameters and attributes to the server as serialized data. Process allows us to gather our application A��s parameters and send it to the SRS server who then calls Application B. Application B finds the requested resource and returns it. You could look into taking a similar approach by adding a parameter from you application A��s currentUI Thread and might achieve the same results. From the code you posted I can only notice one possible flaw; This code is called from the report server who does not have direct access to application A. remember your calling the report server and not this function, hence the security overrides required to make the service calls work. LocalizedString( string stringIdentifier, string language) If you enter the parameter manually, then it can call the service, however in this case I could see it being null, because it��s a three way call and your attempting to remove the middle man. You request the report from A, the SRS processes your request and then calls the assembly B. Right now it would appear that there is no communication at all between your server/report and your applications. Without fully understanding the exact code of your application I can only assume it might be due to one of those issues. I suggest trying the parameter expression method I stated the last post. Below are some of the links I found useful during my research for this task: http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx http://msdn2.microsoft.com/en-us/library/aa287725(VS.71).aspx http://www.codeproject.com/sqlrs/CustomAssemblies.asp http://blogs.msdn.com/bimusings/archive/2005/06/16/429795.aspx Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen
  - 16
    - using case statement to determine Order by field and direction (asc or desc) when using Row_number Good point, Mani. Tag: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

ngarris

Yesterday and today, the Process Info screen in Enterprise Manager indicates that the "Host", a single workstation on our network, is generating around 50 connections to the database. This particular application is well-behaved and typically generates only 2 to 5 connections per instance. Furthermore, we cannot find this particular workstation/host on our network because we retired it off the network some time ago.

Anyone know of the accuracy of the Hosts column on this Enterprise Manager screen We're suspecting that the network address column is correct but the Hosts column is incorrect. There are about 10 different network addresses pertaining to this particular Host (1-5 connections per network address).

Re: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

Satya SKJ

Can you check the mAC Address for that host and find on the network

Re: Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

mebrian

I have also been having that problem. I was able to use the MAC address to track down the PC when I first saw the problem, but found that the computer name was not what was displayed in SQL EM. Additionally, I am continuing to have the same problem but have found that different MAC addresses are being listed all with the same Host name. Should you find more information regarding this issue please post your results here.