[Pat Phelan]

The current version of Microsoft SQL is SQL 2008.

If you are running a different version of Microsoft SQL, it is your responsibility to state what version you are using (for example, SQL 2000, service pack 2). If you don't include information about what version of Microsoft SQL you are using, we'll assume that you are running SQL 2005 and the answer that we give you may or may not work with the version of Microsoft SQL that you are using.

Kudos to r937 for reminding me to include this version information in our FAQ

General Topics

What is a FAQ?
How to ask a question to get quick and correct answers?
How do I "join the community"?
What does Microsoft have to say about group participation?

Homework

How NOT to ask for help!

SQL Server Topics

How do I get DDL for my tables?
SQL Server Security (logins and users)

[Pat Phelan]

An FAQ is a list of Frequently Asked Questions in a forum, newsgroup, or other (presumably online) place. These are questions that regularly appear because pretty much everybody asks them at one time or another. This is a really good place to look for a general "look and feel" for both the forum itself, the people who post there, and the topic in general.

FAQ Index

[Pat Phelan]

Originally posted by Brett Kaiser, updated by Pat Phelan

Please state your problem in the context of a business requirement. Please do not force a narrowly focused technical solution, which may or may not be of any value.

It may also be a distraction to what the actual solution would be. To aid in the solution please do the following if possible

1. State the question

"How do I find the earliest row entered"

2. Please post the DDL of your tables (Including Indexes, and constraints)

Like

CREATE TABLE myTable99(Col1 int IDENTITY(1,1), Col2 char(1), Col3 datetime, PRIMARY KEY (Col1))

3. Post some sample data in the form of DML

Like

INSERT INTO myTable99(Col2, Col3)
SELECT 'a', '01/01/2005' UNION ALL
SELECT 'b', '02/01/2005' UNION ALL
SELECT 'c', '03/01/2005'

4. Post whatever DML that you have attempted already...

SELECT * FROM myTable99 a CROSS JOIN myTable99 b

5. Post the expected results

Col1        Col2 Col3                                                   
----------- ---- ------------------------------------------------------ 
1           a    2005-01-01 00:00:00.000

Good Luck. If these instruction are followed, you will most likely get an answer in minutes.

And don't forget to use [ code] [ /code] tags when posting code, just eliminate the spaces I have used here.

FAQ Index

[Pat Phelan]

Originally posted by Brett Kaiser, updated by Pat Phelan

First and foremost, just join in! Ask or answer a question, add a comment to an existing message thread, or stop by the Yak Corral which can be found in the Chit Chat section.

You can also add yourself here:

http://www.frappr.com/dbforums

FAQ Index

[Pat Phelan]

Originally posted by Brett Kaiser, updated by Pat Phelan with further updates by gvee


Using Enterprise Manager:

1. Open the database folder to display all of the tables.
2. Right Click on the table(s) you want.
3. Choose Menu options All Tasks>Generate SQL Scripts
4. Look at the dialog, there are three tabs. Make sure you pick all the correct options (indexes, keys, ect)
5. Click Preview.
6. Copy and paste the code.

Using Management Studio:

1. Open the database folder to display all of the tables.
2. Right click the table you want.
3. Chose the "Script Table as" option
4. Chose "CREATE To"
5. Chose one of the remaining options

FAQ Index

[Pat Phelan]

See their Knowledgebase article 555375.

FAQ Index

[Pat Phelan]

In discussion of poor practices in another forum, we unearthed some old threads here that demonstrate the wrong way to ask for help. If you want examples of how NOT to ask for help, these are some good examples!

With thanks to Blindman for bringing these posts back to public view, and to R937 for suggesting that they be imortalized!

The Introduction

It gets better!

Taking this process a few steps further:

1) If you are asking questions for a course, please say so up front. We need to take a different approach when helping you with homework than we do with folks that simply need an answer to a "real world" problem.

2) It helps us a great deal if you can post a link to the assignment, or if you can scan the assignment and post it with your questions. That way we know exactly what the assignment requires, and we can infer a lot about what they're trying to get you to learn in the assignment.

3) Don't expect us to just do your homework for you. Life isn't like that, and you'll cheat yourself more than you can cheat the school/teacher if all you do is copy what someone else has done for you. We'll be glad to help, but you really don't want to turn us loose on your homework assignment... We can be evil!

4) If you have a partial solution worked out, or have at least tried something, post that too. If we can see what you've tried, we can probably help you a lot more than if we "start cold" because we can then see more of how you're thinking and where we can help.

FAQ Index

[Pat Phelan]

There are two parts to SQL Server security, and both parts are required... They work together to determine security, and neither is useful without the other.

The database server has logins. Logins establish identity and grant access to the server. Logins come in two general flavors, Windows Authenticated and SQL Authenticated.

Windows Authenticated logins use trusted connections to convey information about the Windows Login that is making the connection. The user doesn't need to enter any information like username or password because these were entered and confirmed when the user signed on to Windows. Windows Authentication is normally only used in an Active Directory environment, although it is possible to use the Windows logins provided by the local machine too. Windows Authentication is more secure at the communication level (between the client and the server), and can be more secure end-to-end if it is used properly, but applications that use only Windows Authentication are vulnerable to "drive by users" if a machine is left unsecured.

SQL Authenticated logins require passing the user name and password to SQL Server. The SQL engine then confirms the user exists and that the password is correct for the specified user. SQL Authenticated logins are especially good for use with very old applications and also for non-windows applications.

Once the user has logged in, their identity is established for SQL Server. Some logins have server administrative permissions, such as the sa login or the sysadmin role which can grant them access to everything on the server. Each login is logically mapped to at most one user in each database. If no user is mapped to a login, then that login has no access to that database.

Within their database, a user is granted permissions. Some permissions are database-wide, such as db_owner or db_datareader. Other permissions are specific to a given object such as a view, table, or stored procedure. Permissions control what actions a given user can perform. If permission is not granted (directly or indirectly), a user can do nothing within the database.

FAQ Index