Ok, I hear what you're saying about not appending the t-logs. However with any backup strategy, there's only one question that will drive the entire process. Its driven...

Here's another thought.

There's no way you can keep logins from accessing MASTER. If the logins are not SYSADMIN role, they won't be able to create any objects in MASTER....

Wait, I forgot to even ask.  Are all these databases on the same server?  If so you may be right to go with the trigger option.  However if this is...

Ok, nobody bit on this one, so I guess I will.

Why wouldn't you try to use replication?  You could replicate the data to a table in the student portal database.

I...

I'm assuming you don't have auto create / update turned on.  None of the documentation I've seen seems to indicate that updating of stats occurrs during a DBCC DBREINDEX operation. ...

Awesome.  Just bumping this since it seems to come up as a forum topic.

Mark is correct.  As with any tool that deals with a critical process such as production code promotion, you have to evaluate and allow for a transition period.

With that being...

Dbdebunk is a great site for stuff like this. Also, required reading for any SQL Server DBA should be "Database Design for Mere Mortals" by Michael J. Hernandez.

http://www.amazon.com/exec/obidos/ASIN/0201752840/qid=1112986851/sr=2-1/ref=pd_bbs_b_2_1/102-2297557-3402530

/edit -...

Frank.  You dog just called.  He wants to spend more time with you.  He says you are spending too much time with us DBA geeks. He said that he was going...

Oh and one more thing.  Relational theory is a SCIENCE not an ART.

You can't make up things like set theory.  It is imperitive that any DBA understand these basic SCIENTIFIC...

I just said that I find naming conventions to be rather silly.  I never said you shouldn't have one.  Neither did I say that I did not use one myself...

Ah yes, the obligatory "flame war" of database design naming conventions.

I tend to use the KISS approach when naming database objects (Keep It Simple Stupid).

1.  Table names...

DTSRun from a command line is extremely limited.  If you have many variables to pass in to a DTS package, you have to use a script / program.

I wrote an...

Its actually more like...

$Connection->{ConnectionProperties}->{"File Type"} = 1;

$Connection->{ConnectionProperties}->{"Skip Rows"} = 0;

$Connection->{ConnectionProperties}->{"Text Qualifier"} = """";

But yeah, you get the general idea...

Just got a good question in an EMail about ActivePerl licensing.  ActivePerl is a free download from ActiveState and is provided for both commercial and non-commercial use. 

See http://aspn.activestate.com/ASPN/docs/ActivePerl/EULA-Community_License.txt for...