We use integrated security on all the servers (mixed mode) and I'm a SysAdmin on the servers in question.
The thing I'm struggling to understand is the fact that the...

Not as yet.

I've uninstalled the APEX software and everything seems to be back to normal.

I'm now investigating other auto-complete/formatting tools (just the freebies for now).

I've never noticed any issues using mis-matched ssms and SQL versions.
I just find I needed to remember that certain commands don't exist in previous versions (like CAST(XXX as DATE)...

I've just had it freeze again, and managed to run the sp_who2 command using sqlcmd.

Looking at the output file, I can't see anything in the BlkBy column.

Thanks all

Haven't had a chance to contact APEX as yet, but I'll do that this week (not entirely sure when).
I'll also check out the SP_WHO2 (I can...

The laptop is restarted every night (I set off a restart as I'm leaving so it's clean for when I get in the following morning).
When I've checked Task Manager,...

There are a good couple of hundred tables, views, etc.

I'll contact Apex and see what they say.

I've just done a repair install of SSMS and it's...

Luis - the server is hardly used at the moment (it will get a bit more usage when various things go live).

Grant - It's around the 60GB mark...

Hi Thom

They do against all the servers.
Looks like I'll have to go through all of the logins and sort them out.

Hi John

All the servers are set up to set British English (looking in Server Properties/Advanced/Default/Language).

That's why we can't understand why the DATEFIRST property is difference or...

Sorry Gail, missed your reply.:blush:

I'll speak to our server team to see if they can alter the settings.

We've got quite a bit of CPU idle at the moment as the server isn't in full use as yet.
We're expecting CPU usage to increase as more stuff is...

Hi Gail

Thanks for that.

Does that mean we have (potentially) 12 cores sitting idle?

One of the SQL instances showing that error is :-
Microsoft SQL...

Hi Erin

I've just come across this article and it looks almost perfect for what I need to start capturing.
The only other thing I want to capture is...

I've just tried the following (with outputs):-
xp_cmdshell 'reg query HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names'
xp_cmdshell is not recognised as an internal or external command, operable program or batch file