I disagree with the answer given, since a NEW COLUMN is handled differently to a new default on an existing column.

Quote BOL

"When a DEFAULT definition is added to an...

I too am confused by the 'correct answer for the points'.

The IN / OUT / FORMAT parameter is not optional and therefore an error occurs when the command is run...

but then they'd have to deduct points from those that answered RIGHT but in fact were WRONG

I also think the answer quoted is incorrect :-

BOL quotes

"

I too would like to see my account credited for my correct answer.

On my system xp_logevent posts messages into the Windows Application Event Log

When you actually READ and then RE-READ the question . Then select the correct answer. You get it WRONG.

Sounds just like Program Development.

The signed spec says one thing ,...

From various articles I've come across, the consensus seems to recommend putting backups onto a separate drive.

However, I believe it comes down to risk of failure. If the backup and...

We're doing all of these.

The GRANT EXEC in the stored procedure script and then using VSS is the only way we have found of ensuring that the permissions are retained...

We're using TCP/IP since a number of 3rd party applications that need to access a named SQL instance can only do so via the port number

We are currently having a debate with or .NET developers. They NEED full access to all data and proc's at all times in all environments . I believe however that...

I've reviewed these and do not think they apply in this case.

The server is currently only running SQL and no other application. I have looked at the sql error logs...

We have our ERP systems running on AS400's and are running .NET applications from SQL. We have created DTS packages which extract data out of the AS400 through an ODBC...

The port number has been specified in Network Utility.

SQL seems to have changed to a different port after the failover

Thanks - that's achieved the perfect result

Excellent - that seems to work fine.

I've also had an alternative approach :-

exec sp_addlinkedserver @server='DEV', @srvproduct='', @provider='SQLOLEDB', @datasrc='REALSERVERNAME'

This works too - modifying the server name in the Linked Server.