take a look http://www.sqlservercentral.com/Forums/Topic457751-291-1.aspx#bm457829

A good question.

What is the difference between 8 and 9?

8 Password mismatch

9 ...

Check today's post: Why Object Qualification is important. A good one.

http://www.sqlservercentral.com/articles/T-SQL/62061/

Agree with this suggestion: "- specify the owner when you create the table".

Simply qualifying the object name with an owner name (DBO), for example, create table DBO.tablename.

Refer to...

Good to know this counter. Just found an earlier post from Steve mentioned about it.

Performance Monitoring - Basic Counters

http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

I agree with both of you. Great points. Just like database backups, over 99% database backups will not be used, but we still keep backing up for <...

"User Access? I need to sit down with a pencil, paper and SQL book to work on this part."

--> Need business owner/system analyst to define the user...

"I change owner name to dbo instead of mine?" -- A good decision.

My 2 cents:

Is your database normalized? Is OLTP?

Create database diagram; data type/length should be consistent cross all the related tables;

Indexes, do not forget cluster index;

User access at different...

If a person's DOB = '1988-02-24 15:00:00.000', the age should be 20 already as of today (March 5th, 2008).

But the 3rd query returns 19.

select DATEDIFF(yy, '1988-02-24 15:00:00.000', GETDATE()) - CASE...

Take a look books online: System Views (Transact-SQL) > Catalog Views (Transact-SQL).

These 2 may help: sys.database_files and sys.master_files

May have a copy of the database to figure out why instead of...

Sounds like you are a developer. Are you supposed to create the table using Create Table DBO.tablename? Simply qualifying the object name with an owner name (DBO) is...

"Any database you create on a smaller edition will run on a larger edition. You can backup the database from the smaller edition and then restore it on the larger...

How about script the change out and run from Query instead of SSMS?

Alter database [dbname] ... /* one change only each time */

You may need to ask the vendor why and how to. They may set it this way for a reason.