Question about Microsoft SQL Server 2005 Enterprise Edition for PC

2 Answers

Sql procedure i want to know about sql procedure in sql server

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Microsoft Expert
  • 43 Answers

Take a look at this link, it will give you an overview of stored procedure in sql server:
Benefits of Using Stored Procedures In SQL Server

Posted on Jul 04, 2016

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 392 Answers

Dear friend you can get all your answers about stored procedure in sql server through this link:
http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx

good luck

Posted on Feb 25, 2009

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

Reset sql sa password directly and efficiently


A few days ago, I had a painful experience that I lost SA password on my MS SQL Server database, and I almost took the whole weekend to look for an efficient way to reset SA password. I asked friends, searched on Internet and even bought some book.... Fortunately, I finally got a SQL server password recovery software and it instantly reset SA password without data loss. And I also got a couple of good solutions for sql sa password reset to save your weekend in case you have lost or forgot MS SQL Server passwords (SA password!).



Option 1 : Use MS SQL Server Password Unlocker to Recover/Reset SA Password

The most direct, efficient way to reset SA password is to take use of the third part utility - SQL server password recovery software. Just two steps:

Step 1: Access to master.mdf file, which is default at C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf

Step 2: Select SA password and reset SA password
So, Reset SA password successfully!



Option 2 : Recover or Reset SA Password with Other SQL Server Login
If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that account and reset SA password of SQL Server. Reset sql sa password as described here :

SQL SERVER - Reset Password of SA Login Using Management Studio.

Login into SQL Server using Windows Authentication.

In Object Explorer, open Security folder, open Logins folder. Right Click on
SA account and go to Properties.

Reset SA password, and confirm it. Click OK.

Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.



Option 3 : Recover or Reset SA Password with Windows Login that is a member of Windows Admin Group

If there is any other Windows Login that is a member of Windows Admin Group, log in using that account. Start SQL Server in Single User Mode as described followings :

SQL SERVER - Start SQL Server Instance in Single User Mode.

There are certain situation when user wants to start SQL Server Engine in "single user" mode from the start up.

To start SQL Server in single user mode is very simple procedure as displayed below.

Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on desired SQL Server instance and right click go to properties. On the Advance table enter param '-m;' before existing params in Startup Parameters box.

Make sure that you entered semi-comma after -m. Once that is completed, restart SQL Server services to take this in effect. Once this is done, now you will be only able to connect SQL Server using sqlcmd.

on Oct 05, 2010 | Computers & Internet

5 Answers

Some requirement for SQL server repair


Read this blog at the following link: http://recoverymaster.livejournal.com and know helpful details about MS SQL server database recovery wizard. You can download this software: http://www.sqlrecovery.org

Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...

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

Better and safe way to repair and recover MDF files


To choose a reliable and 100% safe and secure, a SQL server database recovery utility guarantee the zero loss of quality. You can refer to this page: http://www.sqlrecovery.org and also read this post http://recoverymaster.livejournal.com/519.html

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

14 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

1 Answer

SQL Server 2000 SP3 - Installation Path


The only way to change it. Is to reinstall the SQL Server, and be guided accordingly once you meet the setup option you need to change the folder destination where you can setup the sql.

Hoping this will be the solution you are looking for.


Best Regards,


Philip

Oct 26, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft SQL Server 2005 Enterprise Edition for PC Logo

Related Topics:

154 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18377 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...