Another new feature of SQL Server 2008 is an extension to the CONVERT function whereby a binary value can be converted to a string representation.

e.g.

SELECT CONVERT(VARCHAR(MAX), 0x484920544845524521, 1)

...returns:

0x484920544845524521

This removes...

Nice idea.

An alternative is to use SSMS 2008's in-built data scripting functionality:

http://www.sqlskills.com/BLOGS/PAUL/post/Scripting-schema-AND-data-with-SSMS-in-SQL-2008.aspx

Chris

Hi Eros

Given the time taken so far to fix the issue, have you considered that it might be quicker to restore the database from the latest backup?

Chris

sp_MSForEachDB has been around since at least SQL Server 6.5, - it is UNDOCUMENTED and, therefore, should not be used in Production code.

Chris

The idea of the central reporting of database statistics is great, but surely using Excel to connect to each SQL Server instance and generate reports like this can't be considered...

I did once see an issue with SQL Server 2000 SP3a where a particular query returned different results (as in a different number of rows) depending on whether parallelism was...

I think that the question should have been re-phrased slightly, from :

"SQL Server 2008 has which new features/keys for database encryption"

...to:

"SQL Server 2008 introduces which new features/keys for database encryption"

Database...

If you despise the report designer as much as I do you could even take it a step further by returning the colour codes/names by the stored proc. This way...

Maybe I'm being pedantic, but I don't think that any of the answers provided are correct.

If you interpret a comma to be a column delimiter, the results should be either:

NULL,manoj

NULL,1

...or:

NULL,1

NULL,manoj

Note...

Hi, thanks for the info. I was just trying to...

I have found that the behaviour changes dependent on the running value of the 'allow updates' configuration option.

Run the following (on a test server):

USE [master]

GO

EXEC sp_configure 'allow updates', 1

GO

RECONFIGURE WITH...