You can get the database files from the sysfiles "select * from sys.sysfiles" view.

Or are you interested in filegroups?

Regards,

Andras

Was this your homework? If so, you are likely wasting your money.

without error handling:

CREATE PROC conv

@fromCurrency CHAR(3)

, @amount MONEY

, @toCurrency CHAR(3)

...

Concerning licensing, from the SQL Servfer licensing FAQ http://www.microsoft.com/sql/howtobuy/faq.mspx:

You can run multiple instances of SQL Server 2005 on a single computer. Multiple instances are used by organizations that have several...

The approach Management Studio is using is simply checking the name of the database like

db.name in ('master','model','msdb','tempdb')

Regards,

Andras

If you can separate the databases into different instances, you can have an instance for Dublin, one for London.

Management Studio allows organizing servers into groups, You need to register your...

Unfortunately Management Studio does not support organizing databases in the Object Explorer.

Regards,

Andras

I'm afraid you will need to create the condition expression using OR and list all the relevant columns. On the other hand you do not need to write this condition...

Please note that the transaction log is not an audit log. This means that the user who dropped the table may not be recorded in the transaction log (this is...

Do you need the results of Statement 2 for statement 3? If it is not important that statement 2 executes successfully (since you want it to be outside the transaction)...

If your concern is the wasted space that is common when you change or drop a fixed length column, then this is is a problem when you move from varchar...

Similarly to changing filegroups you cannot repartition existing tables with a single statement....

Hi Lester,

SQL Server 7 does support all three replication types (snapshot,

transactional and merge). More specific information concerning replication on SQL Server 7 you can find on http://msdn2.microsoft.com/en-us/library/aa226168(SQL.70).aspx

Regards,

Andras

Books online describes this better than I...

You can embed the above into a stored procedure and set that it executes in the context of dbo.

e.g.:

create proc a with execute as 'dbo' as begin

select ...

end

Regards,

...

SQL Server 2005 SP2 has introduced logon triggers http://msdn2.microsoft.com/en-us/library/bb326598.aspx. Alternatively, if you do not have SP2 you can use the service broker to implement these like on http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/

Regards,

...