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.

"Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation...

Yu will need to register the SQL server under the SQL Server Group. Its local profile based so if you have never used Enterprise Manager on the server before...

Perry Whittle (7/2/2012)

No, it won't, as the remaining files in...