Try a DAC (dedicated administrative connection) !

That should always allow a single sysadmins connection to perform some very basic stuff.

Keep in mind remote DAC is off by default, so you...

Where are the days, when removing builtin\administrators was enough to be considered "secure". :w00t::hehe:

dos prompt help for shutdown shows this:

X:\>shutdown /?

Usage: shutdown [-i | -l | -s | -r | -a] [-f] [-m \\computername] [-t xx] [-c "comment"] [-d up:xx:yy]

...

- What version of sql2005 is this ? (+ sp + cu please)

- has the package been modified lately ?

- did you try sp_revoke_login_from_proxy and grant it again ?

Good input Bob.

We to often forget this new feature of sp2.

:blink: :blink: Where's my donckey 😀

I've been reading a bit on the cloud topic ..... already forgot the obvious :blush:

At my plant, we only have CI databases.

I have...

:blink: :blink: Where's my donckey 😀

I've been reading a bit on the cloud topic ..... already forgot the obvious :blush:

At my plant, we only have CI databases.

I have...

FWIW: concering the "dangers" of CLR modules ....

- http://www.sqlservercentral.com/Forums/FindPost457289.aspx

- http://www.sqlservercentral.com/Forums/Topic483423-386-1.aspx

Are you refering to SQL in the Cloud ?

I don't know :unsure:

We're not into cloud surfing .... at least not yet 😀

Hopping in way to late for this thread, but as I was confronted with application roles nolonger working in SQL2005 for a restored SQL2000 database....

BOL states:

The encrypt option is not...

I think you should alter one db to primary

Check "Pausing and Resuming Database Mirroring " in BOL !

Check "Database Mirroring How-to Topics " in BOL !

from BOL topic "How to:...

As Gail stated, CLR is not a replacement for TSQL procedures, it is just an addition to help where TSQL isn't performing well or just cannot do it.

Regarding content visibility:

-...

just to add a little bit :

- Keep in mind Connection pooling also keeps connections open ! By default it will retain at least one distinct connection for 60 seconds...

Ron (8/31/2009)

---

ALZDBA (8/31/2009)

---

That's because you have the condition on the SAP_Cust in the where clause, so are excluding NULLs (which are the non matching)

Alter your where clause to

WHERE dbo_SAP_CUST.KUNNR <...

Never use 'sa' !

Consider it only to be in SQLServer to get started and to perform some very basic SQLServer service tasks !

Create your own set of accounts.

Prefer windows...