You have to restart the SQL Server Service for lock pages in memory to be enabled.

Here is a small set of data ... honestly, I'm still not entirely sure I understand the full relation yet. This is a 3rd party vendor's application database and something...

Ok, I thought I was going crazy ... I thought that is what the QotD said when I answered it as well ... thanks...

Not entirely true. Trace flag...

Right, which is why I knew I couldn't group ... but in essence, that is what I'm looking for ...

So for example ... this is currently what I'm displaying:

IsParentParentWorkOrderNo

10

10

10

10

10

0146385

0146385

0182639

0182639

0182639

0182639

0182639

Basically if...

Joshua Perry (3/21/2008)

---

That has nothing to do with what appears to be a new question:

[font="Courier New"]If you are moving system databases (master, msdb, model, tempdb), you would change the location...

Joshua Perry (3/21/2008)

---

Still wrong. That's the procedure for moving between servers. This is the procedure for moving the location:

http://technet.microsoft.com/en-us/library/ms345408.aspx

Also, setting trace flag 3608 at startup and running in...

SQL can track successful and unsuccessful logins by default ... you have to enable the option, which requires a SQL restart:

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 3

GO

This can be...

I've used several, but definitely prefer RedGate's SQL Compare. They have a free 14 day evaluation version. If you end up buying it (which you should), ask for Carl from...

Yep, nothing has been published yet ... we have so much stuff to do ... so we're doing everything locally for now until we're ready to open up. Pretty excited...

Yes ... if you're excluding hardware, that means we're talking about the operating system and SQL Server. There are quite a many reasons to as why SQL could go down.

Again,...

Also, is it truly best to separate your non-clustered indexes onto a separate file group, on a different drive?

Minus tracing, I don't believe there is anyway to accomplish this.

Sounds like management studio simply got hung ...

Did it only happen once? If so, I wouldn't worry ...

Really? Do you a link for this?...