This is from SQL SErver 2005 BOL article installed from the CD:

Using a Dedicated Administrator Connection

"To conserve resources, the DAC connection is not available in SQL Server 2005...

HI,

I don't know your requirements for the database, but I would not create databases with several filegroups on C: I would not put any databases on the system drive assumning...

I use Structured Storage File type when saving the package. Then you can copy the file and open it from another computer. You will have to correct package content to...

Ram,

see if this article from Database Journal will help you. It contains a VB script that adds values to the registry for SQL Server 7, you can adjust script lines...

John,

SQL Server Reporting Services are a very good tool and come mostly free with SQL Server (see licensing for details when it is free and when it is not)

If...

Terry,

You should not be logging as SA

He is an admin but generic per se

SOx auditors will not be happy with that,

Get yourself new credentials instead!

I would use Source Code Control tools like Visual Source Safe, Teams Foundation Server or Subversion (Subversion is free)

Martin,

this command not only may change the collation, but it will totally rebuild Master database including login information. I would specify the collations for individual databases.

Ram,

I did not mean he-he at you, it was just funny joke about the space. I do understand we should not install stuff on the production servers.

Have nice weekend!

He-He!

This is so cool!

Why would you want to do that? It does not take a lot of space and if people need to look up something, they can easily access the copy online...

I use DB ID. For some reason i did not have luck even filtering on Database Name

The questions should be:

How do you manage so much data? How often do you suppose you will revisit any give file? How do you back up your data and to...

getdate() returns current date and time like the clock.