Within the same major version of sqlserver a restore should never be an issue for user databases.

I'm glad it got sorted out, even with the misterious "for internal use" 😉

For best it should at least be added as a sidenote to the online rebuild in BOL.

Thanks...

I'll put in a virtual pint :w00t:

Let's hope for the code mismatch, even if in both sql2005 as wel as 2008.

I'll vote on Connect !

Problem is, we cannot trace/dump the...

You should compare the execution plans for the troublesome queries.

(you can save them and post them is this forum thread if you want to)

Your issue must have something to do...

Breathe 😀

Out with the bad air ... In with the good ....

go

I would guess it has something to do with the basic difference of an online rebuild compared to an offline rebuild: keeping it up to date with ongoing operations.

So it...

- Is your sql instance using Mixed authentication ?

- did you check for the password with your peers ?

- I would try a remote desktop connection, making sure you get...

- on the other hand, if the trigger fails, the whole transaction fails, so the insert will be undone !

- double check that the triggers are enabled !

SELECT OBJECT_NAME(parent_obj)...

start sqlprofiler and ask your .net dev to perform his (her) inserts.

Check the statements your profiler shows and you'll have your diagnose.

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