"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...

Select top 1

3 as LuckyExerciseNumber

, isnull([Title],'') + [LastName]

FROM [AdventureWorks].[Person].[Contact]

ORDER BY SUBSTRING(CONVERT(VARCHAR(40), NEWID()), 1, 8)

😀

Are you referring to exercise 3 of Ms Brawn course ? :hehe:

Keep in mind this reg key only influences if SQLServer will write a notification in its ERRORLOG file.

If you want an actual recording, regardless of this reg key setting, you...

You've had some hints above,.

Now, if this were on a RAID volume, this really shouldn't have been an error as long as the physical drives are still available to support...

As you have noticed, Jack used

The O and O2 are called...

1) compare the execution plans ! (and statistics)

2) is the hardware configration the same ?

( cpu , ram, disk , io chanels,..)

3) are these both dedicated sqlserver servers ?

4) other...