Well one thing you should watch out for is the use of the truncate command, as this will break your backup chain.

There is really no penalty for shrinking the log...

Since you need the totals from each of the five tables, you have to join the tables and group by id.

I would use something like:

UPDATE TABLENAME

SET COLUMN = REPLACE(COLUMN,'Brodmann-10','Brodmann-1910')

WHERE COLUMN LIKE '%Brodmann-10%'

It is tough to troubleshoot when you do not know the current output and the expected output.

I don't really have much to provide. The issue that I am facing is...

Your case statement is fine.

Is it possible for you to provide some sample data, so I can validate ithe query.

Two things come to mind, one you should not be using left joins unless you have too. Two one of your joins has a one-to-many relationship.

You want to use least privilege and combining roles and explicit permission can quickly become convoluted. Just use something as simple as this

USE [DB]

GO

GRANT SELECT ON [dbo]. TO

GO

USE...

I am doing the transaction log for every 20mts. The first log is bigger than the full backup as I Quoted in my last post, after that all the trn...

To create a schema go to start --> programs --> microsoft.net framework sdk v2.0 --> sdk command prompt and type

xsd c:\myfile.xml /outputdir:c:

This will automatically create an XSD file.

more info:

http://msdn2.microsoft.com/en-us/library/x6c1kb0s(vs.71).aspx

No, unfortuntely there is nothing to tick. Express edtion is a stripped down version of SQL Server 2005 with limited functionality.

here is a link with features that are available

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

As...

A full backup does not truncate your transaction log. You must back up your transaction log to truncate it.

This is a quote from BOL

Note Sometimes a transaction log...

FYI detach/attach is usually much faster than backup/restore.

The easiest way is to detach/reattach the database. You can do this via SSMS and then have SSMS generate the script. You will have to generate 2 scripts...

This formatter is good and FREE :D. You can choose the online or desktop version. You can always use the online version, but I believe the desktop version expires...

Note the above is only needed if you want to truncate the log and reclaim space. If not use

DBCC SHRINKFILE (N'LogFileLogicalName', 0) instead, to just shrink the log file.