Hey there,

Is the user sUser a SQL account or AD account and if so is it a member of any groups which could be registered with SQL and conflicting?

Regrading your...

Can anyone help with this? PLEASE 🙂

Huh? :unsure:

Do you mean, difference between online and offline? Cant do much with and offline DB... Cause its offline...

Is this out of interest or do you have a real-life problem with an environment? If so have you considered mirroring?

Replication is generally problematic to set up and get...

Check to see that the user has 'connect' rights to the server and at least 'public' on the database in question.

Ed,

Our WIntel team have looked at this and confirmed that we have access to the registry. This has been confirmed by creating, modifying nad deleteing a key.

Is there anything else...

Ed,

I have checked and can connect to the cluster and its 2 nodes with regedit.

In all 3 i nstances i see 'HKEY_LOCAL_MACHINE' and 'HKEY_USERS', however this is less then i...

Thanks Ed.

WIll speak to Winel team and let you guys know how it goes.

Hi there,

I am now having a similar issue with ssms 2008. Installed it yesterday and when it imported by server registrations, i get the server state on all but one....

neerav.saini (6/24/2009)

---

hi all,

In my database i want to create new *.mdf file and i want to transfer selected tables frmo old mdf to new one.Is this possible?

If yes how to...

Hey all,

Have been reading all the posts and thought i'd chime in a point that i think has been overlooked.

We have an a/p 64-bit with 64gb ram and it runs...

Mani Singh (6/10/2009)

---

I hope this should work: Restore the database and under security check each user and their corresponfing Roles, should e highlighted. infact they might be orphaned but the...

I dont run witness servers as theres things that can trigger a fail over that you dont really want.

But I've put below what i think is happening.

Errors in error...

Hey Lowell,

Cool avatar btw. I have already tried DENY DELETE TO {user} and it doesnt work (my guess is that for some reason the DBCREATOR server role overwrites it}. Any...

Thanks for your reply.

Can you explain what you mean?