Add in the COUNT clause in the select which references say the ID column in the orders table

Select distinct u.FirstName + ' ' + u.Surname as Verifier, COUNT(co.ID) AS NumberVerified

From...

If I understand right, you want to move all users databases from Server1 to Server2?

There are a number of methods to do the task

Backup & Restore

Attach & Detach

Copy Database Wizard

Also...

AD Groups is by far the most simplist way to configure security in SSRS, it is up to you if you want to go down this route or not, I...

Is it just the server or are the users and servers changing domain?

If its just the server, ensure that there is a trust between the two domains so that authentication...

sp_configure will only change the default language for new logins created not at the server level.

http://coolkidsdoit.wordpress.com/2009/01/28/changing-the-default-languagelocale-sql-2005/

Relates to 2005 but just substitute \90\ with \100

Disclaimer - not tried, nor do I...

whats the language of the login set to?

Change the logins default language to British, or change the properties of the server to British (right click server --> properties --> advanced), on both be sure that this doesnt...

Would be interested to know where you read that a truncate would break it as its not logged in the transactions log.

Truncate is a minimally logged operation, it is logged...

Looks like a dateformat issue, maybe on one server your login is set to English (MDY) format and on the other British English (DMY) format.

So on the MDY server, your...

If you already have a MCTS then you need to take exams 457 and 458 to get the MCSA, from there you take 464 and 465 to get MCSE. ...

Could also go for this

=FORMAT(Parameter!......................., "MMMM, yyyy")

Can try experimenting with the formatting, one thing to note capital M is month lower m is minutes

Rebuilding indexes requires space, so if there is no space in the DB then it will add the space to the file to rebuild successfully which is probably why you...

http://technet.microsoft.com/en-us/library/ms186385

Need to ensure you have DBMail setup, and a trigger or something to fire the email to your once it triggers the Agent Alert.

Ah equal proportional fill wasnt the best term to use, my mistake on that.

Yes I would in the first instance add more space, but as the OP wanted other alternatives...

Query sys.sql_modules and msdb.dbo.sysjobsteps these will contain the definition of any proc trigger etc and any commands within job steps.