My co-worker, no idiot, says that the tooltip in the system tray for
the SS2000 icon usually shows the computer and server, but once in a
while shows the password (two slashes and the password).
Is this a known bug of some sort? It really shouldn't be showing his
password. It's likely the developer edition, but still, that isn't
good.
I have a SQL Agent job that runs at 4:15 in the morning. The job has 5 steps, each step only runs if the preceding step succeeds. The second step, which calls an SSIS package that does the main processing, appears to finish as it goes on to the next step; however, when looking in 'View History' there are 2 entries for this step - the first one shows it as still running (Circled Green Arrow) but with a start and end time. The second entry says the job succeeded.
I have been seeing conflicts, such as deadlocks, with later jobs. I suspect this job is causing the conflicts - maybe the package is still running in the background instead of having actually completed?
what conditions a job step my be showing in the job history as both running AND completed successfully?
I have the following two expressions in side-by-side fields in a report. They compute the percentage of unit sales and retail sales that a particular row accounts for. ("SalesData" is a DataSet.)
=FORMATPERCENT(SUM(Fields!Units.Value)/SUM(Fields!Units.Value, "SalesData"), 2, -2, -2, -2)
=FORMATPERCENT(SUM(Fields!Retail.Value)/SUM(Fields!Retail.Value, "SalesData"), 2, -2, -2, -2)
What I need to do is provide a SUM of the top five percentages and display it as a tooltip for the respective column headings. So, basically, what percentage of the overall retail/unit sales was contributed by the top five? The table usually displays approximately 40 rows.
Thanks in advance for any help.
Jamie
What am I missing on the tooltip. I have entered a very simple if statement based on a parameter. Why will it not display with I run the report?
I have entered the simple formula in the tooltip under the fields textbox propeties. What am I missing.
=iif(Parameters!ExcelExport.Value = False, "No", "Yes")
Is there a way to increase the Toop Tip Length? Currently, it is limiting to 512 (approx) Characters. I need to show more number of characters for certain items.
If its not possible, is there an alternative of showing a window on mouse hover and show the data just like a tool tip.
Thanks,
Sampath.
Is it possilbe to have the tooltip (mouse-over text) display longer? Seems like it currently displays for only 5 seconds.
View 3 Replies View RelatedHi
On a report I'm making for CRM Dynamics I have a filter that's a String and that the user types what ever he wants to filter on. It filters for example on "Bikes:" and the user can use even the %, for example "Mount%" to get only Mountains Bikes. As I have made a parameter for this and so on, I can€™t find anywhere where I can set up a Tooltip for it, so the user have some examples on how to use this particular filter. So, how/can I make this Tooltip?
Kind Regards
Hello,
I am displaying a complex formula in a column header tool tip. The formula is generated in a stored procedure. (I do not enter the tool tip text directly in the column header expression.)
Within the stored procedure, how do I generate a string that contains a carriage return/line feed?
Thanks,
BCB
Hi,
I need to set up tooltip for some images in a reporting service
2005 report. I add some text in image's tooltip property.
However when I move the mouse over the image in the report preview,
it does not show any tooltip. What am I doing wrong?
There is also another property called tooltiplocid.
What is that? when and how should we use it?
Thanks in advance.
Hi all,
I have a simple query which returns all the names of products attached to a particular order.
select a.orderid, b.product_name
from orders a, order_items b
where a.orderid = b.orderidSay it returns this data: (sorry about the formatting!)
orderid product_name
===== =========
001234 Sweater (Black)
001234 Trousers (Large)
001234 T-Shirt (Pink)
What I want to do is, instead of getting 3 rows back, I want to roll up all matching values (of product_name) from the order_items table into a simple string seperated by a comma. So, for the data above I would get a single row with the orderid and a string containing something like this: "Sweater (Black), Trousers (Large), T-Shirt (pink)".
I'm sure there's an easy way to do this in SQL Server 2000 but I've not been able to work out how to do this and I couldn't see anytihng in SQL Books Online..
TIA for any help...
Mike
Is there any way in which i can carry or retain the tooltip value which is shown on my report into Excel sheet ....
i mean when i export the report into Excel sheet, tooltip value is gone?? how can i retain the tooltip value when i export into excel ??
is it possible if so ...any hints??? thanks a lot in advance
Today an instance periodically becomes unable to accept connections. The service will respond to a service-shutdown and when restarted will accept connections for a minute or two but then refuses to accept connections or service active connections. We have gone through several cycles of this.
The log contains rows of :
2007-12-03 13:16:33.46 spid2 Process ID 55:0 owns resources that are blocking processes on Scheduler 7.
2007-12-03 13:16:38.47 spid2 Process ID 55:0 owns resources that are blocking processes on Scheduler 7.
2007-12-03 13:16:43.49 spid2 Process ID 55:0 owns resources that are blocking processes on Scheduler 7.
Any comments??
Michael (the perplexed)
I have MS SQL Server 2005 Developer Ed. and try to make a database diagram of remote MS SQL Server2000 database in MS SQL Server Management Studio.
I receive an error "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
Dear Listers,
Has anyone experienced performance degradation after converting / uprading from SS7 -> SS2000 ? .... wrt executing a reporting stored proc. that creates dynamic sql and makes extensive use of temporary tables.
If so, what measures were taken to progress towards a final resolution ?
Our scenario:
SS7 code was executed in isolation. ie. it was the only instance running on the box. When the SS7 job had completed, the SS7 instance was shutdown and the SS2000 instance was started .... then the SS2000 code was executed
- Identical h/ware (The SS7 and SS2000 were installed on the same box)
- Identical schema, indexes, triggers, views
- db files on identical RAID5 array
- Stats updated
- Tables reindexed
- data & procedure caches purged
Note that the temporary table(s) were NOT indexed.
TIA
John
We have several servers, each with many jobs. Some jobs run as Owner "SA", and some jobs running as various domain admin accounts. We have been told to modify all jobs to run with Owner "SA". Now, some of the jobs read or write flat files and I am a little concerned about this. Does the domain account which starts the SS2000 services determine the rights to read and write files? If so, I guess changing all jobs owners to "SA" has no real risk?
Thanks!
Michael
Requirement: Some data (basically a SELECT) FROM SQLServer(2K) toOracle/Lnux on a CONTINUAL basis.Does NOT need to be Real-Time...can be like (Oracle's) Materialized View,i.e. automagically refreshable.What are my options in impleneting this process ?thanks--10gR2/Linux
View 1 Replies View Related
Hello,
Is it possbile to migrate SS2000 DTS packages to SS2005 SSIS involving databases with compatibility mode set to 80. If yes, what are the potential issues, which may occur?
Sajish
we have a 2000 db that we'd like processed by RS2005. We dont want to convert the db to 2005. Is this possible?
View 1 Replies View RelatedI have to force a space allocation to a DB file in order to stop a Diagnostic Manager alert which states that the database is over 80% full. Now, I don't think this alert is rational, nor do I think it is useful in any way but that's the way it goes. My only option is to allocate more space to the DB so that the space used will fall below 80% so the alert will stop being issued.
So, can you tell me how to force a space allocation on an existing db file?
Thanks,
Michael
Hi,
We are implementing push transaction replication from Production SQL Server 2000 database to SQL Server 2005 reporting server and SQL Server 2000 Test server.
SQL Server 2000 PROD to 2000 Test is simple but from SS2000 to SS2005 I have following questions:
Is it feasible to create push subscription from SQL Server 2000 to SQL Server 2005 database?
When I am trying to setup publisher/subscription properties, It only give me options to pick SQL Server 7.0 or 2000 or heterogeneous databases.
When I am trying to register SQL Server 2005 database in EM of SS2000 it don't allow me to add it and through exception that I need to use Management studio, Is there any alternate way to register?
Thanks
--rubs
In SS 2000 I want to create a sproc that returns the correct address block for a contact. I want to concatenate AddressLine1 and AddressLine2 if AddressLine2 has a value. When I run the following query I get an error (below):
SELECT vwICPContacts.PersonID, vwPersons.PreferredAddress, vwPersons.Email1,vwPersons.email2, vwPersons.email3,
CASE
WHEN vwPersons.preferredAddress='Home Address' then
case
when (isnull([vwpersons].[HomeAddressLine2],'') = '') then [vwPersons].[HomeAddressLine1]
when (isnull([vwpersons].[HomeAddressLine2],'') <> '') then [vwPersons].[HomeAddressLine1] + Char(13) & Char(10) & [vwPersons].[HomeAddressLine2]
END
ELSE
case
when (isnull([vwpersons].[AddressLine2],'') = '') then [vwPersons].[AddressLine1]
when (isnull([vwpersons].[AddressLine2],'') <> '') then [vwPersons].[AddressLine1] + Char(13) & Char(10) & [vwPersons].[AddressLine2]
END
END
AS MailingAddress
FROM (vwPersons INNER JOIN vwICPContacts ON vwPersons.ID = vwICPContacts.PersonID) LEFT JOIN vwCompanies ON vwPersons.CompanyID = vwCompanies.ID
Error Message:
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals boolean AND, type equals nvarchar.
I've done this before but am completely stumped. Any ideas?
Jane
Is there any way to configure a notification icon in the start tray in Express 2005 (like we had in SQL Server 2000) with a little green (or red) arrow (or dot) to indicate whether the server's up (or down)?
View 3 Replies View Related
Earlier versions of SQL had an icon in the system tray - which was very useful. I cannot seem to find how you activate this in 2005.
Also you could schedule a job MSDE 2000 to, say, backup a database. I can't find how you do this in SQL Express.
Hello all;
I am trying to form a replication system but at the very beginning i couldn't pass an obstacle.
While trying to create the Replication it says i have to change the user which starts the SQL Agent because the current starter user account is a system account and this will make the replication between servers fail.
"SQL Server Agent on OZN currently uses the system account, which causes the replication between the servers fail. In the following dialog box, specify another account for the service startup account."
I change it in the properties dialog box of the SQL Server Agent. The new account is the one I formed and granted accordingly. But it gives the following error when I try to apply the changes.
" Error 22042: xp_SetSQLSecurity() returned error -2147023564, 'No mapping between account names and security IDs was done' "
I tried many things, searched in the net, changed the owner of the database, applied new accounts, many grants, applied service pack 4, etc...
If anyone helps it will be very much appreciated. Thanks in advance...
I have no idea where to post this kind of question, so here it is!
I have a requirement to retrieve oracle 10 data into SS2000 in as near real-time as possible (stupid users!) and join with resident SS data for on-demand reporting. (We use SS replication to populate some reporting tables from other SS2000 instances and this has spoiled the users as well as the developers! )
I would like to know if there are any clever ways of doing this, or if a plain-old DTS package running in some kind of loop is the practical answer. 1 minute delay is probably too long . . . I don't know if data can be pushed from the oracle side. Or if we need to write a Service and use it to suck and push.
Any suggestions?
thanks!
Why would some of my servers that I have registered not show a green arrow (or any connection status for that matter). It's just a blank white circle. Is there some sort of connection error happening between me and the server?
It's sort of annoying to click on these servers and have the error "SQL Server xxxx is not known to be running. Are you sure you wish to connect?" Any way to get around that?
Thanks..
Can anybody tell me what the following icon means against the SQL Server Agent in EM. I'll describe as best as I can:
Its the usual pc tower picture, but instead of the usual green arrow or red square at the bottom, I'm getting what looks like a window (its very small, I can't tell exactly).
When I see this icon, I can't see or change the Service Startup Account under properties and EM doesn't seem to know if the service is stopped or started (I get the option to do either - although both fail if I try them)
Any help would be appreciated
Regards
Andy
Is there any way to change the interactive sorting icon or even adjust it? When I add the functionality to a column, it skews the column heading to make room for it. This means that reports that previously displayed properly no longer look correct. If I adjust the width of the report to allow room for the icon, then the report overflows its boundary in terms of printing.
Also, the icon does not display evenly all the time. Sometimes, it displays directly next to the text and sometimes it is off to the right more.
I have seen the red down arrow for disabled, but I don't know what this means?
(I can't post an image is there a way to upload an image?)
It appears to be a little red tornado or down pin?
Hi everyone,
This is a beginner's question: I know that in order to run a package i need to press ctrl_f5 but i also know that there should be an icon (dimmed green arrow) to do that but i cant find it on the toolbar! I only see the "debug" green arrow. Can anyone help me find the lost "play" (or "run") green arrow ? on which toolbar is it situated ?
Thanks
In SQL 2005 when a database is in suspect mode there is no obvious way to tell (via SSMS). In SQL 2000 the word "suspect" was displayed (via Enterprise Manager) next to the database, and the respective database icon was grayed out. Why was this behavior changed for SQL 2005? From a disaster recovery standpoint, it is very important to see immediately if a database is in suspect mode.
View 9 Replies View Related In my installation of RS 2005 when I click the Refresh Icon on a report the report doesnt update. But when I click the "View Report" button it does.
For example, if I change the parameters on the report and click the refresh icon the report seems to flicker as if it was rfreshing but the report data remains the same, even the paramaters in the report remain the same (I have the parameters that are selected in the report header)
Anyone have the same problem or know the solution?
Hi all,
I apologize if this question has already been asked a dozen times, I ran a search and came up with nothing, soooo...
I installed SQL Server 2005 Express Edition SP1 + SQL Management Studio Express.
I attached all my old databases, and setup named pips, tcp/ip, etc, but for some reason, I don't see a SQL 2005 Express Icon in the system tray to indicate to me if the Server is running or not.
now I undestand Express doesn't come with Agent tools, but where on earth is my tray icon? Do I need to download the 'advanced reporting tools' version instead? (about 200mb+)
TIA,
Ray Bolander
Triac Engineering Ltd