It is not possible unless you take the drastic and unsupportedaction to modify some SQL Servers system stored procedures.

Logins are server-wide in scope and have passwords. The scope of a database user is to that one database. A Server login may have or be one or many database...

Let's add a touch of reality as well now. SQL2000 is extremely stable. SQL 2005 is somewhat stable, but extremely bug infested since it is another total rewrite of the...

Everyone probably uses the system SPs more than they realize. The SQL Server application software imakes use of a great many system stored procedures. Service Pack applications as well. Just...

This seems like a no brainer. If the tool meets business and functional needs one would be foolish to pay for a more expensive product. Sometimes the 'inexpensive option is...

EMC like many large organizations that sell products are just going through a process with you. Whether or not the individuals executing thast process are of 'stellar' quality is anothe...

Check out this posting ... it may hold the solution ...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=281275

SQL Server 101 - a SQL Server is a dedicated machine. Dedicated to SQL Server alone.

So I agree that TS has no place on the SQL Server. We have a...

Totally automation ... SQL Server MSX server, custom scripts, errorlog scanning, event log scanning, smtp email amd MOM to be brief. Basically the servers email/page me whenever there is an...

It's a great discussion but possibly in vain ... I just heard on the radio (yes 'old' fashioned news radio) that Bell South is asking for a retraction from USA...

We are in agreement Colin. Thanks for the clarification. As for my usage of this type of database storage construct, I leave all system objects on the 'primary' filegroup and give...

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

    DBCC DBREINDEX

   ...

Colin, I believe that you can have multiple 'filegroups' within a database. By default you get a PRIMARY filegroup only. Within a filegroup you can then have multiple files. When you...

I believe that the size of the database mentioned by Steve is off by at lease 2 orders of magnitude. Yes, two orders of magnitude. I know this from experience...

My SSC and DD were not in my inbox Monday morning either ... they arrived early in the afternoon ... I'm in the Midwest about 40 miles SE of Chicago....