I hope I understood you right, but I think this code should work.

But be ware that in you sample data there are 3 paces between the monetary values and the...

Jan,

two possible reasons spring to my mind.

First of all it is possible that the backup...

Here's the link for 2005 which clearly says that the data must be aggregated by SUM.

http://msdn2.microsoft.com/en-us/library/ms145568.aspx

Markus

When running an Optimization Job or basically DBCC REINDEX it's always possible that a user process blocks the job. If a clustered index is being rebuilt, an exclusive table lock...

In SQL 2005 you can define DDL_Triggers and Event_notifications to catch these type of actions. See BOL for details.

But even if you haven't defined any of those the default...

Don't forget the "copy database" option.

Markus

Thanks Hans,

that's exactly what I was looking for.

Markus

Andras,

thanks for the response, but this function returns all the numbers from the string. Also it goes through the string one character at the time and I was hoping for...

As the others already said, the answer is wrong.

Or should I say BOL is not always reliable?

Have a look at http://www.sqlis.com

The error says

"There is already an object named 'MANAGER' in the database."

So the object doesn't have to be a table. I suggest look in sys.objects

for any objects with...

Add an expression to the row like this:

=IIf((RowNumber("table1") Mod 2), "lightblue", "blue")

Just replace the colours with thise you want.

Markus

Your code lis fine, but it seems like you mdf file is corrupted.

Do you have any backup of the database? If yes try to restore it and run DBCC CHECKDB...

Actually the "Lock pages in memory" option only works with SQL 2005 Enterprise edition. See also this article http://support.microsoft.com/kb/918483

The standard edition simply ignores the setting.

You should also read this: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/05/03/using-64-bit-sql-server-2005-lock-pages-in-memory.aspx

Markus

I can assure you they do. SP2 made some changes to the scripting options and also to SSMS (Customr reports, Object Explorer...