What service pack is your sqlinstance on ?

Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS

, Serverproperty( 'Edition' ) as Edition

, Serverproperty( 'InstanceName' ) as InstanceName

, Serverproperty(...

Did you change the SAC connection from localhost to the logical server name of your sqlserver instance ?

e.g. mysqlserver\myinstance you should connect to mysqlserver.

Why do you want the dependancy of both pk columns?

- an identity column auto increments its value by the increment value. If not tampered with that definition, it will generate...

did you try this in SSMS:

EXEC sp_configure 'remote admin connections', 1;

GO

RECONFIGURE;

GO

With clustering stuff, many thing must be managed using cluster administrator!

What are you looking for ? (With regards to instance management)

Whenever possible indeed !

OP stated

I...

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