How do I configure the database so that it will send an alert to all users who are logged in and using SQL*Server, when I need them all to get out of the database ??? Or, what do I need to look up in the documentation ??? I have looked under SQL*Mail, but that doesn't look like it will work for what I am trying to do.
Any help you can give me will be greatly appreciated.
Thanks,
Nancy
I am using sql server 2000 with service pack 3a
I have install same copy for database server at two windows 2000 server box with SP4.
I have been connected both server on LAN and replicate our required data from one to another. It's working fine.
In actual implementation both server would be connected via ISDN Dialup
Total distance between two server is maximum 40 KM.
I apply same method like lan on ISDN Dial up.
1. Given all permission equvallent to administrator to new user
2. Login by new user
3. Install database server at both end.
4. Dial by one place to another.
5. Ping each other by ip address.
6. By dialup place , I can ping new static IP address given by dial.
7. Dial in place I can ping both IP address newok card as well as new dialip IP
8. Search IP address (RAS Base)., Ping also to remote IP.
I didn’t ping physical network IP address. I can’t brows simply, I can’t ping domain name but I am able to ping remote IP.
I got error at the time of registration - 'Specify Sql server not found, Connection Open Connected()'
10. I try to user client network utility again get error as under-
Add 2nd server by client network utility at the another
Try to connect at got error-
Unable to connect to server test
Server msg 17 level 16 srare 1
ODBC Sql server driver [TCP/IP Socket] sql server doesn't exit
I didn't understand why I getting error in registraion of one server to another, while both can be registered to each other in LAN environment.
Let me help , I am trying to that for last 4day and night but not yet got any conclussion
Thank in advance for all of you
R.Mall
I Create an availibility Group with a primary and a secondary. (For test)
Then run Planed Failover.
Switched to secondary. That's ok.
After that I update some tables on secondary (That now is primary)
I Run Again Planed Failover on server 2.
Switched. OK
But primary database Get (Not synchronizing) Status.
And in primary I don't have that updates.
How to sync these databases and exit from Not synchronizing.
We have 2 switch between primary and secondary this morning.
after that one database in secondary went to "initializing / recovery pending".
How can i exit from this situation ?
Can you use the below query to get CPU high utilisation alert purposes for both named and default instance? or, do I need to make any changes here (@wmi_namespace=N'.ROOTCIMV2' ) ?
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'CPU_WM_Utilization_Check',
@message_id=0,
@severity=0,
[code]....
Hi folks! I have an alert that fires on error 208(Invalid object name '%.*ls'.)
Can i customize it to get some thing like in the Net-Send command:
(invalid object name '%.*ls'. executed by %user from %computername)
What my concern here is to customize the messages. The description option in the alert allows only static info to be added.
Howdy!
Hello Everyone,
Please help Newbie !!
I have a server where I have been getting
"SQL Alert Sev 24 : Fatal Error : Hardware Failure" for
the past week.
Occurence : We disconnected the workstation (which we are
using as SQL Server) from one floor and connected it to
another floor. No Configurations changed. No hardware
failures reported so far on the win 2000 box.
We are very well able to do the SQL development on that
box. Everything seems normal except I get this error sent
atleast once a day in the morning.
Regards,
Kurt
Follow are the Erros/Warnings in the Event log.
1)
The SNMP service is ignoring extension agent key
SOFTWAREMicrosoftDHCPMibAgentCurrentVersion
SOFTWAREMicrosoftWINSMibAgentCurrentVersion
SOFTWAREMicrosoftIASAgentCurrentVersion
SOFTWAREMicrosoftACSAgentCurrentVersion
because it is missing or misconfigured.
2)
Application popup. Service Control Manager : At least one
service or driver failed during
system startup. Use event viewer to examine the event log
for details.
3)
The site server ILS service service dependsd on the IIS
Admin Service which failed to start becasue of the
following error: The service cannot be started either
because it is disable or because it has no enabled devices
associated with it.
4)
The remote access connection manager service depends ont
eh Telephone service which failed to start because of the
following error: The service cannot be started, either
because it is disabled or because it has no enabled
devices associated with it.
5) Network Problem. The time service has not been able to synchronize with domain controller for a long time.
..
We are trying to create some alerts in our SQL Server 2014 BI edition.Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box.SQL Server event alerts are working. Issue is only with "SQL Server performance condition alert".
View 3 Replies View RelatedWe recently had a problem with DB Mail. SQL jobs that sends an email succeeded but the email in the job fail to sent. There was a problem with the email server. The error is included. We fixed the problem with the email server. How can I get an alert when a DB Mail email fails send?
Date4/23/2015 10:01:06 AM
LogDatabase Mail (Database Mail Log)
Log ID5907
Process ID13204
Mail Item ID5702
Last Modified4/23/2015 10:01:06 AM
Last Modified Bysa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-04-23T10:01:06). Exception Message: Cannot send mails to mail server. (Insufficient system storage. The server response was: 4.3.1 Unable to accept message because the server is out of disk space.).
)
It seems that in order to get an email alert from SQL Server 2000 I need Microsoft Outlook orMicrosoft Exchange client installed. Is there any other way to get an email alert (not net send) when a back up is finished? for example using a @hotmail.com account?
thanks
I'm pretty new to MSSQL. We have SQL 2K and I was wondering if anyone has seen this issue before.
When I create/modify an Alert there is no option for "SQL Server Performance Condition Alert" in the Type under General tab.
Has anyone seen this before? What can I do to get this type of Alerts?
Just a note -- on my other SQL servers they have the options.
thanks in advance !
I have a SQL 2000 sp3 installation on a Active - Active
cluster. I wanted to create a performance alert, but when
I tried, the Sql Server Performance Condition Alert choice
is missing from the drop down menu on the new alert setup screen. Does anyone know why? Any help will be greatly
appreciated.:confused:
Hi
I am trying to setup alert msg. on my mobile phone when sql task fails
Has any body done this before????? Any sugessitions????
Thanks
Vijay
I am trying to create an alert when there are more than 2500 connections to our ailing SQL Server.However, for now, I need to restart the SQL server service because users begin complaining they can't connect.
1) I created an operator - me.
2) I created a job which runs a query.
INSERT INTO Sessions_alert
SELECT host_name, program_name, login_name, count(c.session_id ) num_sessions, getdate()
FROM sys.dm_exec_connections c JOIN sys.dm_exec_sessions s on c.session_id = s.session_id
GROUP BY host_name,program_name,login_name ORDER BY 4 DESC
3) I created an alert - included the job from above. Type performance condition alert. Object - SQL Server General Statistics. Counter - User connections.Alert if counter rises above 50. Just testing. I really want to know when it gets past 2500.
4) I've set the alert to email and delay is between responses 2 minutes.
It history tables says number of occurences is 18964. However, I don't receive an email.
Shouldn't the alert send an email? Do I need to include email code in the job?
I have a simple SSIS package that imports an Excel Spreadsheet into a table. The column heading got changed, so the package failed, as expected, but I would like an alert or some way to make the scheduled job show "failed". I tried putting an event handler on the :Data Flow" step to send an email, but it didn't work.
I would like to figure out the event handler problem, but more important to have the job show as failed.
For some reason the Scheduled job shows "success" even though the SSIS package failed. A better solution is to make the scheduled job itself fail, based on the package failing.
I've noticed that the 14150 event is no longer showing up in the Application Log. The 14151 event does. We tried modifying the alert:
sp_altermessage 14150, 'WITH_LOG', 'true';
But this of course doesn't work on messages under 50000. We utilized this alert in SQL 2000 to send emails upon the success of a merge replication. Any idea how to get this to work? Is there a workaround or did MS drop the ball on this event? If they dropped it - sure wish they would let us know and also remove the ability to setup the alert for it...
Thanks in advance!
-Dave
Same SQL Server DB engine (2012), connected with two different clients (2008 and 2012). When I check objects for performance condition alert, 2008 client shows the objects name with leading "SQL Server".But 2012 client displays just the object name and NOT prefixed with "SQL Server".we have automated alerts creation, so it fails depends on the client version.
View 0 Replies View Relatedi was trying to install sql server 2000 enterprise edition on win 2003 with SP1. i got stuck with this error sayinbg;"the driver software you are installing has not been properly signed with Autheticode(TM) technology. therefore windows cannot tell if the software has been modified since it was published. the publisher's identity cannot be verified because of a problem,
The installed INF file does not contain digital signature infromation"
Do you still want to install this driver software?
No matter what i click, either yes or no, it takes me nowhere. i googled it everywhere still could not find a solution. please let me know if you guys got any idea.
I have a Table "Customer" which contain a Field "CreditLimit",
Now I want a Mail alert on change of this filed with both value old credit limit value and New credit limit value.
Is its possible without trigger??
hi all,
any keyword for exit SP? like the exit sub.. which stop the Sp from next statement if one condition occured?
like :
if NOT exists (select blabla)
exit SP execution
else
(blablaba)
~~~Focus on problem, not solution~~~
SQL Server 2014 BI edition.
select * from sys.dm_os_performance_counters returns the object names prefixed with "SQLServer:" (e.g. SQLServer:Databases)
It was expected as in other editions also. Issue is that when we try to crate "SQLServer Performance Condition alert", object names in "Object" list comes without the prefix "SQLServer:" (e.g. Databases). Please see the attached snapshots.
We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.
I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.
Is there any additional step I should/could take to get this active?
I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!
View 6 Replies View RelatedIs there a way to exit an executed DTS package using Microsoft TSQL without causing an error or does this need to be in VB?
View 4 Replies View Related
I need to exit from an entire package if a data pump task fails in a sequence container.
I thought I'd use a script task to do this but I'd be glad to learn of any way to do this.
Thanks!
Enantiodrom
Hi,
I have a package that goes out and picks up a file off of a ftp server using the ftp task. How do I force the package to stop running if the file is not there?
I am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.
View 2 Replies View RelatedHello I have three stored procedures Sp1 calls Sp2 and Sp2 calls Sp3 as follows:
Exec Sp1
Inserts, updates
Exec Sp2
Inserts, upadtes
Exec Sp3
If error Exit Exec Sp1
Can I end Sp1 if I catch an error in Sp3
Has anyone seen this?
When I exit out of Query Analyzer - it hangs and gives the following error message in Event logger
Hanging application isqlw.exe, version 2000.80.760.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.
i have data like...
userid startdate in_out
1 2011-11-20 9.30 1
1 2011-11-20 10.30 0
1 2011-11-20 12.30 0
1 2011-11-20 12.45 1
1 2011-11-20 6.30 0
See 1-Entry 0-exit for 2011-11-20 12.30 is exit but entry time of that exit is missing....
Can i insert same exit value for entry?
Hi experts,
I have a job that has several steps.
One of the steps is of type T-SQL. I have an IF...ELSE block in it. If the if statement is true...perform an action.
Else exit from the job reporting failure.
I would like to know what sql stmts should i use to exit from the job (in the ELSE block)
I tried to use EXIT in the else stmt but it is not exiting from the job step.
Thanks in advance
Hello I have three stored procedures Sp1 calls Sp2 and Sp2 calls Sp3 as follows:
Exec Sp1
Inserts, updates
Exec Sp2
Inserts, upadtes
Exec Sp3
If error Exit Exec Sp1
Can I end Sp1 if I catch an error in Sp3
As part of our application deployment we have wrapped and automated the SQL Server Express install by launching the setup.exe with our parameters and waiting around for the process to exit.
I had been checking for a Exit Code != 0 to detect errors returned by setup.exe but this does not appear to be foolproof. Several customers' deployments have returned non-zero exit codes, but SQL Express seems to be successfully installed.
I have not found a reference of possible codes returned and their meaning that I could use to fine tune our checking. Does one exist? Or am I going about this the wrong way and should just check for the existence of our instance after setup is complete?
thank you for any input.