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

hmm ... what would firefighters do when they have a calm week ....

Training, reviewing, optimizing,

Training:

- persnol level knowladge and practise training

- refresh known stuff

- evaluate new techniques

- prepare...

mark (6/13/2009)

---

Good morning everyone.

I am attempting to complete some basic SQL training and I continue to receive the following error when attempting to create a procedure with a variable.

"Msg 207,...

Can you give come config info ?

(both servers/instances)

- OS ?

- sqlserver @@version

- linked server ddl statements/authentication settings

I guess you execute a sproc that has been created using "execute as login"

you may be able to actually perform stuff you normaly wouldn't be able to.

create proc usp_SSC_test

with execute...

We don't use any xprocs, so I didn't have to convert them.

We only used sp_oacreate with smtp mail. These have all been switched to dbmail in sql2005.

Maybe this link is...

did your sqlserver memory consumption grow contantly during this month ?

If yes, you may be suffering a leak and may need to plan reboots on a regular basis, unless you...