Question about Microsoft SQL Server 2000 Standard Edition for PC

1 Answer

TRIGGER IN SQL

WHAT IS TRIGGER IN SQL. WHAT IS THE USE OF TRIGGER

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 8,596 Answers

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. A trigger is really an event handler. SQL Server allows users to create triggers (event handlers) for 3 types of events:

  • DML Event - Occurs when a DML (Data Manipulation Language) statement: INSERT, UPDATE or DELETE, is executed.
  • DDL Event - Occurs when a DDL (Data Definition Language) statement: CREATE, ALTER, or DROP, is executed.
  • Logon Event - Occurs when a user logins to the Server.
There are 3 different types of triggers (event handlers) based on the types of events they are triggered by:
  • DML Trigger - Executes in response to a DML event.
  • DDL Trigger - Executes in response to a DDL event.
  • Logon Trigger - Executes in response to a logon event.

Posted on Jul 03, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

Tip

SQL 2008 SA Password Reset


How to reset sa password in SQL Server 2008 when forgot the sa password?

Many time, This problem comes, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login sa password by which they can connect to server. In SQL Server 2005, SQL used to fixed group sysadmin with the server role BUILTINAdministrators, that is to say, all local NT administrator automatically add a SQL Server system administrator. But since 2008 Windows BUILTINAdministrators group is not included by default in the sysadmin server role in SQL Server.

So, follow the steps mentioned to reset SQL 2008 password for SA account if no BUILTINAdministrators.

Step 1. Download and install MS SQL Server Password Unlocker.

Step 2. Run MS SQL Server Password Unlocker, click Open, import the master.mdf file. All the user names of your SQL Server will be displayed.

Step 3. Select an SQL account, such as 'SA', click Change Password button.

Step 4. Type a new password, and then click OK.

The new password has been set for your SA account, now you can login
SQL Server with the new password.

Currently SQL Server 2008 still supports two types validation and authentication for access link to resources database, Windows authentication mode and SQL Server and Windows authentication mode which also known as mixed mode. Both of these authentication methods provide access to SQL Server 2008 and its resources.

The Mixed Mode - SQL Server and Windows Authentication Mode

SQL Server and Windows Authentication Mode uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server. SQL Server 2005 introduces a new way, the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. SQL Server 2008 also to do so. The policy of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode.

on Oct 26, 2010 | Computers & Internet

Tip

How to Create and Remove SQL Server Password


SQL Server is a Microsoft product used to manage and storeinformation. It uses tables to contain large sets of records for thedatabase. Do you have a SQL server and have you ever used SQL server?Do you know how to create a SQL Server passwordto protect your data stored on SQL server? What to do if you forgetyour SQL password? Following it will introduce you how to create a SQLpassword. And it also tells you how to remove SQL Server password ifyou forget as password can be easily lost.

How to create a SQL Server password?

As we know, it is an important security measure to set a passwordfor user accounts and in particular the SA account. And it is very easyfor you to create a SQL Server password. Just follow the simpleinstructions.

1. Open the Microsoft SQL Server Management Studio program from the Start menu bar in Windows.
2. Click on the SQL Server instance on which the new user will be created.
3. Right-click the Security folder, point to New, and then click Login.
4. On the General page, enter a name for the new login in the Login name box.
5. Select SQL Server Authentication and enter a password for the login.
6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
7. Click the OK to complete the creation of the new user.

Sometimes it happens that you ignore or forget the systemadministrator password. What will you do if you forget SQL password andcannot access to SQL database? The effective way I know is to remove SQL Server passwordwith the help of SQL Server password remover software. MS SQL ServerPassword Unlocker is one of the good MS SQL password remover toolswhich can help you remove SQL password in a few seconds.

How to remove SQL password with Windows Password Unlocker?

MS SQL Server Password Unlocker is handy SQL Server password remover software for you to reset SQLpassword including reset SA password and other user passwords. It caneasily remove SQL Server password for Microsoft SQL Server2000/2005/2008 in a minute. You don’t need to install MS SQL Server onyour PC, and the file in master.mdf format is enough for you to removeSQL Server password and set a new one for it.
Step 1. Download and install MS SQL Server Password Unlocker, and run the application.
Step 2. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.

This SQL account password has been reset. You can login with the newly set SQL password. Although it is easy for you to remove SQL Server passwordwith SQL password remover, it is better to keep your SQL password inheart. Or you can also write it down on a paper and keep in a safeplace.

on Sep 07, 2010 | Computers & Internet

3 Answers

Forgot SQL Server SA password. How to reset user password to login SQL Server?


When SA password for SQL Server logon forgot, please take SQL Password Genius to install it on computer.

Step 1: Run SQL Password Genius full version and browse Master.mdf file to import into it.

Step 2: Select SA user and click "Reset" button.
After master database file imported into SQL Password Genius, you would see all user in list. SA password is unknown. Select SA account and click "Reset" button.

A new window would pop up, type new password for SA account in it. And click "OK". Instantly, SA password is changed successfully. SA password lists in software screen.

Step 3: Close SQL Password Genius and restart SQL Server Services.

SQL Server services influence SQL password reset on computer. So we stop it before using SQL Password Genius. Now, when you finish SQL SA password reset, restart SQL Server Services to run SQL Server with SA account.

How to Reset SA and Other User Passwords for SQL Server

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

Tip

4 Methods to Change MS SQL Server Password


Have you ever forgot or lost your MS SQL Server password? Did you reinstall MS SQL Server or change SQL Server Password by some ways at that time? I once forgot my MS SQL Server password and I reinstalled My MS SQL at last as I failed to find some good methods to solve the problem. What annoying and terrible experience it is! In order to avoid reinstalling SQL Server for a second time due to the same reason, so I collect some methods to change SQL Server password for sa account.

Method 1: Use Command Prompt to Change SQL Server Password


Step 1. Open a command prompt (Start -> Run -> cmd)
Step 2. Type the follow commands, and press Enter after each line:
Osql –S yourservername –E
1> EXEC sp_password NULL, ’yourpassword’, ’sa’
2> GO
The yourservername is the name of your server, yourpassword is the new sql sa password.
The command line 1> also can be changed to other command, the model is EXEC sp_password ‘oldpassword’, ‘newpassword’, ‘sqlaccount’.


Method 2: Use the Query Windows in Management Studio to Change MS SQL Server Password

Step 1. Open SQL Server Management Studio
Step 2. Open a new query
Step 3. Type the follow commands and excute:
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO
The NewPassword is set for your SQL Server sa account.


Method 3: Change SQLServer Password by Windows Authentication

If Builtin/Administrator is present in SQL Server, you can login with an ID which is member of Administrators group and change sa password in SQL Server. Just do as follows:
1. Login into SQL server using Windows Authentication.
2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
3. Type a new SQL sa password, and confirm it. Click OK to finish.
After restarting SQL Server and all its servers, you can log into SQL Server by sa login with new SQL sa password.


Method 4: Change MS SQL Server Password with Third Party Software

In addition to the methods above, you can aslo choose some SQL Server password recovery tool to change SQL Server password. MS SQL Server Password Unlocker is one of the good MS SQL passwrod reset tools which can help you change SQL Server password in a few seconds. It allows you to chage MS SQL password on SQL Server and Express 2000/2005/2008.

Following is a guide for you to change MS SQL password with MS SQL Server Password Unlocker.
Step 1.Download and install MS SQL Server Password Unlocker.
Step 2. Run MS SQL Server Password Unlocker, click Open, import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.
This SQL account password has been reset. You can login with it.

Well, the four solutions are the easy-to-use MS SQL Server Password Reset ways.

on Aug 10, 2010 | Computers & Internet

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | Computers & Internet

1 Answer

Time based triggers or procedures


Syntax to create Triggers in SQL are :

Create Trigger trigger_name // "trigger_name" : Give name to the trigger
on
table_name // "table_name" : name of the table on which trigger has to created
for Update
as

Begin

// Here Query has to be written here

End


Dec 18, 2008 | Microsoft Computers & Internet

5 Answers

SQL 401: cannot open database


SQL database Recovery Software remove errors from SQL server database and allow recover your all database of SQL Server 2012 or below versions. The software support with all over version of SQL server. Try at here:-
SQL Database Recovery

Jun 06, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft SQL Server 2000 Standard Edition for PC Logo

190 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18331 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...