Dean Jones (6/18/2009)

---

...

Sounds like a good idea, problem is that this means I will have to change 200 or so Procedures and I dont think this will get the seal...

that depends on your needs !

Do you need an aircraft or a T-bone steak ?

- I haven't seen a grant exec to a certificate. :unsure:

- if you drop a proc, all related grants also vanish !

What you might do is :

1) create a db...

We grant the exec to a db-role and add users in that db-role.

IMO you need to investigate why the proc needs to be re-created ?

If it already exists, just...

If the disk on which the data file resides is very busy, SQLserver may get a timeout on the extend operation.

It then raises this error.

In the background the OS is...

AFAIK All MC** stuff, you have to pass the required exams.

MVP is kind of an award MS grants you for a certain period and target area as a token of...

Is this proc created using a "execute as ..." clause ??

Indeed, in that case it is easy to lose track if you do it all by hand without a checklist.

Although we regularly reinstall our dba-systems-test server - and know the...

AShehzad (6/16/2009)

---

sorry that i paste here the error message of my modified trigger. Related error message for BOL trigger (that i mentioned in code) is

Msg 1084, Level 15, State...

AShehzad (6/16/2009)

---

While creating trigger for logon event according to BOL example as following

CREATE TRIGGER connection_limit_trigger

ON ALL SERVER WITH EXECUTE AS 'login_test'

FOR LOGON

AS

BEGIN

IF ORIGINAL_LOGIN()= 'login_test' AND

(SELECT COUNT(*)...

- Is the issue causing problems ? (What error do you get)

- Is the client configured exactly the same as the current production system ?

- did you capture and post...

Forget about AWE on 64-bit systems, 64-bit has enough direct accessable memory you don't need to extend it. IMO enabling it would only cause overhead because sqlserver will use the...

it depends...

From a dba perspective that migth be enough.

Did you also restore master and msdb ??

If not and your apps are using sql authentictation, they will not be able...

Also check the Books Online ref provided in the previous post !

e.g. shrinking a log may not occur when you expect it to, .... BOL explains why...

I always try to avoid linked servers !

With sql2008 SSMS you can connect to a server group and execute a centrain sql script at onece on the whole group !!...