Not the best example, but

CREATE DATABASE TEST_ME

GO

USE TEST_ME

GO

CREATE PROCEDURE Test_P

AS

EXEC SP_TABLES

GO

EXEC Test_P

should return 21 rows, that is 19 system table entries and two views. That is the default for...

Not sure if this will help

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

Well, there is an undocumented s_proc sp_MSforeachdb in master, which accepts a command and executes this in every db on the server.

As I don't use it, I can't remember...

So, now is more time.

Why do you expect system procedures to be in a new db?

Oh sh*t, never type while being unconcentrated.

There are no s_Procs in a model db anyway. What a bad post I made!

Apologize for irritating you!

I think when you create a new DB, SQL Server makes a copy of your model DB. Everything ok with that DB?

CREATE TABLE Double_T

(

col1 INT PRIMARY KEY

)

GO

CREATE INDEX sI ON Double_T(col1)

will run fine. It is allowed but makes no sense.

You should provide more information as for DDL, DML, sample data or any advise will be a shot in the dark.

1) You can only have one PrimaryKey on a table.

2) A PrimaryKey implies uniqueness.

3) Indexes have to be maintained, thus, the more you have, the longer it takes.

4) It makes...

I understand what you are saying about SQL Server not moving a page to maintain the sorting of the clustered index, but I still think there are time when SQL...

EM is at best an administration tool, nothing to retrieve information on your data. You should tell your user to use QA, or some other front-end.

To answer your question, AFAIK...

Okay, that's a very valid reason

AFAIK, not quite right!

You store with only two decimal places, but you calculate with at least 5 or 6.

Looking at the emoticon I'm glad not to sit next to you

Absolutely right, everything has its pros and cons. Personally I'm used...

Hey Dave,

what's wrong with you? ASKING a question, instead of answering?

This might also be a rather religious question, but I like DEFAULTS and use...