What Windows version and edition are you on ?

(x86 / x64 / ia64)

repent_kog_is_near (10/27/2009)

---

just want to make sure I got it:

so if I reset the errorlog, then I should be able to see the setting/option for LPIM in the erorrlog right after...

I know it is on x64, I haven't enabled it on 32bit.

This info is written at sqlserver startup time.

To prevent ending up with xMB of errorlog file size, many choose to recycle the errorlog file using the commands I posted.

If the...

http://technet.microsoft.com/en-us/library/ms190730%28SQL.90%29.aspx

states:

The Windows policy Lock Pages in Memory option is disabled by default. This privilege must be enabled to configure Address Windowing Extensions (AWE). This policy determines which accounts can use...

You will not find this info is the errorlog has been rolled over.

e.g. using "EXEC sp_cycle_errorlog" or "DBCC errorlog"

You should find it after a fresh start of the sqlserver instance.

Else...

"Introduction

As a part of ensuring that they've created a secure environment Windows administrators often need to know what kind of accesses specific users or groups have to resources including files,...

Indianrock (10/26/2009)

---

SOLVED ! thanks for your input Gail, we will have to consider smaller inserts. I looked in our Spotlight tool and noticed the spid of the...

Aaarchh ......

Indeed, I copy/pasted the wrong example code out of one of my test...

It is not perferable !

Using EM it does take care of all needed authorization.

So .... EM is the easy way.

check SSC for a split (table valued) function .

e.g.

/*

* Split a delimited string using a table valued function with XML

*/

-- table-valued function

CREATE ...

keep in mind it is best to change the service account using Enterprise manager. (it also takes care of the needed authorization for the new service account)

I think you even have 60 days to switch to another server with the same license.

e.g. hardware switch or DRP

The primary question was "... will the system block if I drop the synonym and recreate it to point to the new object with ongoing operations ..."

And off course the...