I managed to get this working..

ran the following commands

1. dbcc opentran('db') - which shows me that the old LSN was slightly out of date

2. sp_replrestart - reset the transactional replication

3....

thanks for the replies guys.

Lucky enough the db that is corrupt is still in prod/test stage, so it's not a prod database yet.. But it's seems like a good...

Hi there,

I have 2 groups of developers

Dev1Team

Dev2Team

How would i set it up so each group will there their own schema, and they can create / change / objects in there...

Hi there,

I was wondering if you could have maybe 2 schemas:

schemaCreateObjects (allows you to create tables, view, sp in the database)

schemaSelect (allows you select records from the objects in the...

thanks for the reply.. that made it clearer..

Could you also, give a schema like DDL access as well? like groups that below in a certain schema can say only create...

Elliott W (7/9/2009)

---

have two seperate issues here.

1. All domain users have access to the tables.. How? What role do they have? Are they all administrators? Has the...

Hi there

Bit of legacy app and has been around for like 10 years.. Not too sure why it was designed like this.

Hi and thanks for your reply. Sorry I just try and clarify.

We not using the application role within sql. Withing DB1 we have a security table that stores the username,...

oops, yes - my typo.

So does this mean it's best practice to setup each db in this way.

Data_file1.mdf on primary

Log_file on FG_UserData

Data_file2.ndf on FG_UserData

So there should be 3 files for every database?

cheers

Thanks, yea I logged off as that user and logged on again and it pickup the sysadmin role.

thanks