That is strange indeed.

Double check if you are trying to move the correct db-files. (they can have any name with no "link" to the db itself)

Check if there are still...

I'm totally with Lynn here :w00t:

One other thought of the day:

Whay are you defining the clustering index on a 3-column ix ?

- Are those columns always used (all 3...

I'm with PaulB's suggestion !

Keep prod and dev data on separate instances !

it may need some time to actually take it offline.

It will no longer accept new connections/commands for that db.

But it may need to complete the offload, taking some time.

Maybe just create a view (on the remote server) and query that.

Test it and see what the effects are.

Marcus Wilkinson (6/30/2009)

---

Thanks ALZDBA.

All my jobs todate have been owned by the same service account that has local admin rights.

Ok, to comfirm, now I'm using a proxy and a different...

hi_abhay78 (6/30/2009)

---

Its good to try this option .Once you are the Admin on the server , you can do anything ..But you messed big time my friend 🙂 ...this is...

get rid of the linked server !

Why: query stability !

Keep in mind if sqlserver cannot find a "by default" good plan, it may pull over all data of the...

This is actually thé weak spot of SQLAgent. :crying:

What I do is create a SQL user account, make that account jobowner of the jobs non-sysadmins are wanting to manage.

Also add...

For the moment, add the service account you are using to the windows local administrators group of your server.

Maybe best to stop / start your sqlinstance.

Then you should be able...

Chris,

I just hope people don't get scared to start small, if you hit them with "armagedon" :hehe:

Don't present a dam breakage scenario for those that need to seal up a...

check you sqlserver instance ERRORLOG file to see if the startup is OK.

You may also want to try to add your windows account to the local server group called

computername\SQLServer2005MSSQLUser$computername$instance

In my...

Oh indeed....

One of our devs was astonished his server didn't work after a 380V overload (it should be 220V and due to an electrical mishap the cerquit got an overload...

You only know what your insurence pollicy is worth, the first time you need to call for its couverage !

In case of sqlserver, you can challange your DRP before you...

this is on sql2005, right ?

Check the OVER clause in BOL. It may provide you a nice solution for your problem.

from BOL:

The following example shows using the OVER clause with...