The USERS table is having only userid and associatedrecordid. Userid is a loginname. associatedrecordid is uniqueidentifier data type. Not only this, we have another problem. That is if...

The actual view definition is

CREATE view V1 as

SELECT

EMPLOYEEDETAILS.EMPLOYEEDETAILS_ID,EMPLOYEEDETAILS.FIRSTNAME,EMPLOYEEDETAILS.MIDDLENAME,EMPLOYEEDETAILS.LASTNAME,EMPLOYEEDETAILS.ADDRESS1,EMPLOYEEDETAILS.AGE,EMPLOYEEDETAILS.COMPANYOFFICE,EMPLOYEEDETAILS.DATEOFBIRTH,EMPLOYEEDETAILS.GRADE,EMPLOYEEDETAILS.HEALTHASSESSMENT,EMPLOYEEDETAILS.LOCATION,EMPLOYEEDETAILS.REPORTSTO

FROM EMPLOYEEDETAILS WHERE

EMPLOYEEDETAILS.EMPLOYEEDETAILS_ID IN

(

SELECT EMPLOYEEDETAILS.EMPLOYEEDETAILS_ID FROM EMPLOYEEDETAILS

WHERE EMPLOYEEDETAILS.MIDDLENAME IN

(select EMPLOYEEDETAILS.MIDDLENAME

from users

join EMPLOYEEDETAILS on users.associatedrecordid = EMPLOYEEDETAILS.EMPLOYEEDETAILS_ID

where USERS.UserID =...

Hi Sreevani

If you are modifing a record, first Sql server delets the record and then insert a new record with the modified value. Here the deleted table contains the...

Hi Blue use this query

Select customerID from customer_data where customerid not in (select customerid from customer_log where last_login_date > dateadd(day, -365, getdate())

The above query will solve your problem. All...

Same thing happend with my server also. I think data buffer is occuping the memory. But if the OS requests any memory it will release the unwanted data from...

You can use sp_grantdbaccess procedure.

1) Login as sa or dbo

2) USE HisDB

3) EXEC sp_grantdbaccess 'Cris', 'Cris'

Thanks

Regards

Ram

ram@cntit.com

Hi Jelena

To rectify this problem follow these steps.

1) In publisher select the database

2) Select Tools --> Replication --> Configure, Publisher, Subscriber and Distributor

3) In the wizard click on Subscribers tab

4)...

I faced the same problem, but in my case the publisher and subscriber are at two different places and connected by internet. Several times I broken the replication and...

Hi Mitra

You can see all the error messages in "sysmessages" system table. You can use like "select description from sysmessages where error= 207"

Thanks

Ram(DBA)

ramakrishna100@yahoo.com

If you want you can create the procedures and save at subscriber end. For creating procedures I will follow the following way. First create a dummy databse with the...

How you created the subscriber?

While creating subscriber in the "Initialize Subscription" Screen select "Initialize the schema and data at the subscriber. Then this will create procedures at subscriber end...

Are u started the snapshot or not? If you started the snapshot that will create the tables in subscriber database and replicate the data also. So, check whether...

What type of replication are you using?

Peter I want some more info to clarify your doubt. What version of SQL you are using? What kind of replication you are using?

Ram

SQL Server version is 7.0 with SP3. I changed the repinfo to 0 from 256 in sysobjects table for the PUb2 articles tables and tryed to delete the data...