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
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.
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
In EM, the left pane shows servers, etc. What is the meaning of the red
squiggly line which can apprear on the server icon?
Thanks.
My co-worker, no idiot, says that the tooltip in the system tray forthe SS2000 icon usually shows the computer and server, but once in awhile shows the password (two slashes and the password).Is this a known bug of some sort? It really shouldn't be showing hispassword. It's likely the developer edition, but still, that isn'tgood.
View 2 Replies View RelatedI am getting a general protection fault when pressing the print icon in Reporting Services website.
Hi I found this article:
http://database.ittoolbox.com/groups/technical-functional/sql-server-l/reporting-services-2005-print-icon-causes-machine-to-reboot-1592477
but I can't figure ou how to "remove" the RSClientPrint Class add-on in IE 6.
P.S.
Why does something as simple as printing need to be an ActiveX control? There are all kinds of issues revolving around pushing this out using SMS for users without local admin permission.
So i finally figured out how to create custom transform and add an icon to it. However - when i added the component to toolbox it appears as a file icon (when i didnt have icon it appeared as a blue box) - in the data flow designer it appears as the correct image.
From BOL wrote:"The Data Flow toolbox uses the 16x16, 16-color image type, while
the design surface of the data flow tab uses the 32x32, 16-color image
type. Both are default image types for icons created using Microsoft
Visual Studio 2005."
I assume this has something to do with it - my ico is default 32x32 - however, what would be the way to fix it?
I am adding some KPI-style graphics to a report (BIDS 2005) and for consistency I would like to use the same icons that are available in the Excel 2007 icon sets that are used for conditional formatting in spreadsheets - there's no point in having users learn another set of icons. Are these graphics available anywhere so they can be added as embedded images in a report? Am I missing some other way to do this?
Thanks,
John W.
Hi,
Have two servers, one production server and one backup server. Both are Windows 2003 Server having SQL Server 2000 installed.
I have created replication on these servers using a wizard. I then generated SQL scripts to delete and create the replication. These scripts work well, but to test to remove the replication on both servers I used sp_removedbreplication 'DBNAME' on both servers. Not all were removed and on Replication Monitor and sub items plus Log Reader Agent there were added an icon, a red 'X' as in error. The replication seems to work.
Does anyone have any idea on why this happened and what I can do about it. It is not very nice to have errors in replication on a customers servers.
Grateful for answers
Best,
/M
Hi All
I installed the following in order:
1. .NET Framework Version 1.1 Redistributable
2. .NET Framework Version 1.1 Software Development Kit (SDK)
3. MSDE 2000 Rel A
In the command window I changed to the directory where MSDE 2000 Rel A was installed and typed in this:
setup.exe INSTANCENAME=MyDb DISABLENETWORKPROTOCOLS=1 SAPWD=<My SA PASSWORD>
MSDE installed successfully and the little icon appeared in the system tray, next to the clock. However, there was no little green arrow/triangle showing on the icon to show connection status as Connected.
4. ASP.NET Commerce Starter Kit
During the Starter Kit install a Connect to Database window opened - Connect to SQL or MSDE.
In the 'Server' field the following was automatically displayed:
STEVE-HOME/MyDb
Where STEVE-HOME is the name of my computer (changed from 'localhost') and MyDb is the instance name.
Thw 'Windows Authentication' radio button was selected by default. I left this unchanged, then clicked OK.
A window opened asking to test the connection. I clicked OK and the connection was successful.
(I didn't select the SQL Server authentication or enter a username, password or select a Database.)
The Starter Kit installed successfully and works fine. However, the SQL Server Service Manager icon states it is not connected when I mouse over it.
I opened the SQL Server Service Manager window and the Server and Services fields are blank.
Surely the Starter Kit wouldn't work if MSDE wasn't connected.
Can anyone advise on how to get the icon to show it is connected
Your help would be greatly appreciated.
I tried to open mdf file without any success. Then, all database files icon were changed or grayed out. How can i repair or replace the file to it's original file? ex... the file named "event.mdf" has now a wrong icon not a database icon like before.
View 11 Replies View RelatedHI, there,
I added a new windows user "ReportUser" which is a local user (not in administrator group). When I connect to the report manage's web page, I use reportuser to log in (when the anonymous access is disabled it will ask a log in). Report builder icon is not showing up on the report manager home page.
If I log in as a user in administrator group, the reportr builder icon shows up so I can download it and build report.
I have assigned reportuser "Content manager" and "repoter builder" access to the home folder. Is there anything else I have to do to make the report build icon show up on the home page?
Thanks
Jack
Morning all!
My SQL server email job notifications have stopped working, but mails sent through the xp_sendmail command still work.
The only thing that has changed recently is the SQL server agent account passwords have been changed, these accounts are normal win2000 domain accounts.
Any ideas cos I am fully stumped?
Is it possible to set up a Job to send a notification , if a process is blocked for more than a minute on SQL Server 2000.
Thanks for any help on this
I wish to know if there is anyway to find out if a perticular job on SQL Agent was executed or not. I am not looking for Log History of the job, but, something like a trigger that will fire an email to notify that a perticular job that was scheduled to run at a certain time did not run.
To explain in detail, I have a job that is scheduled to run every 15 min. This job is crutial and I wish to be notified if the job was not run for some reason or other. I already have a program that delivers me the history log of the job each day, but, checking history to see if the job ran or not every 15 min is not possible. Again, I am not talking about the job success or failure, but the fact that the job has run or not - thats it !
If you are suggesting a SMO object, I will appriciate if you provide me with the code or alternatively a source to refer.
Thank you.
hi all i have found for function as function: SubscriptionEnumeration in API of notification service, i want display myAlert(notifications) in(for example: one day).the Function SubscriptionEnumeration display Subscription of (subscriberId,subscriptionType,nsApplication) it can be made this ?thanksHungN
View 1 Replies View RelatedHi,
I want to build sql notification service in my web application and i not know how to build it. Please help me how it possible and any sample code then pls send me else give me link of website. Its very urgent for me, now i am using timer for checking for updation in database and i want to notification service for that because its take many time and timer fire every time even database change or not.
Jaydev Jangid
hi,
An application, every one hour it connects to sqlserver and uploads data from MSAccess database.i should get the notification weather that application is connected to the server or not.because this application gets currepts very often.
any help is appreciated.
thanks
preethi
Does anyone know how I can receive some type of notification (an alert) that fires when a new database is created (or an old one deleted) on a server?
Thanks.
I have set up SQL Mail on a SQL 7.0 box and I can successfully schedule tasks and receive e-mails from them. However, when I try to get mail notification from a scheduled DTS package I run into problems and no mail is sent. Under Profile Name the only item selectable is Microsoft Outlook. I've tried selecting this as well as leaving the profile blank and nothing seems to work. We use POP3 server and Microsoft Messaging. Our corporate e-mail system is Notes so we forward mail through the POP3 server via Internet mail to our Lotus Notes system.
Any suggestions so that we could get our DTS mail notification working? Anything I could try that I haven't?
Thanks!
Does anyone know if there is any software available that notifies specified people when an error above a certian level occurs. Im thinking along the lines of email and text message.
Im running sql server 2k at sp3a level, and the software will have to be compatible with it so as to get the event notification to pass the information on.
If there isn't any software, would anyone know of any scripts that will do this?
MSDE 2000? Thanks.
View 2 Replies View RelatedCan you send these to a group of DBA's
View 1 Replies View RelatedHow can I set up the notification email when one of your jobs got failed using Database mail..
I've already set up the database mail ... but I am not quite sure how to use the database mail to send a notification when a job failed...
Dear all,
I would like to know, is there any method that the notification can be send more than one person? (SQL server agent--> Job Properties--> Notification--> email)
The dropdownbox list allow one email only, can I add more people on the email list, or insert more email address in the same operator?
Thanks to all
johnson Mok
Hi,
Can anyone tell me abt SQL Notification Service ???
Is that SQL Programming application or can be implemented with other Dot Net Languagues ???
Need to know further that this services are implemented only by the Database Engineers or integrated with the Application development using .Net Language like C# etc ????
I m n urgent need for this problem
Thanks in advance
Regards
Aravind