Hey,

thanks a lot, the minute mistake which we had done is, for dbo schema related table we had not added dbo.tblUserBookMapping for the dbo schema related tables.

thanks for making me...

I tried, the same way but dint work 🙁

i also tried this way, i removed all the contents of the procedure, i replaced the below 2 statements

Select *...

tblUserBookMapping is of dbo schema

I am executing the Procedures as below

exec [MyBook].uspGetCatelogues @userid=1,@RoleId=1,@CodeStatus='999999'

i am not getting any error, the same if i try this way i am getting the output that to...

Sorry for not texting the procedure

procedure is as follows all the tables and sps are in sql2005

CREATE PROCEDURE [MyBook].[uspGetCatelogues]

(

@user-id BIGINT, ...

Hi,

I am here with sending the code. Here i am trying to avoid others IP than the mentioned one in the code.

CREATE TRIGGER tr_logon_hostname_whitelist

ON ALL SERVER WITH EXECUTE AS 'sa'

FOR...

Hi,

Sorry i have one more query, assuming i have 16 Cores of CPU with 2 SQL instances. For 1 SQL Instance i have alloted 4 Cores and for other i...

Ok Thanks, i will read on this.

Hi,

thanks a lot for the response, 1 more request is to know is it good or bad to acheieve the same. Or pros and cons on the same

With Regards

Dakshina Murthy

What should be the output of this query,

SELECT DATABASEPROPERTYEX('Your Database Name', 'IsSyncWithBackup');

how to check the latency is there any query to do the same, please help.

As of now i have re created the replication and hence its working, now if i execute the mentioned query i am getting 0 as the output. Please help me...

It is through a transactional replication with the help snapshot, initialy main db was backuped, restored in a different server, then create a publisher and snapshot created then the subscriber...

It doesnt fire any error in the replication monitor, if i try to update any existing value of any table it will not replicate.

Hi,

thanks a lot, i just modified after i got your query. it was really usefull thank you.

select column_name = c.name, object_name(ic.object_id), Si.Name

from sys.index_columns ic

inner join

sys.columns c

on ic.object_id = c.object_id and...

Hi,

i am using like this

insert into dbo.changelog(databasename, eventtype,

objectname, objecttype, sqlcommand, loginname)

values(

@data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)'),

@data.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(50)'),

@data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)'),

@data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'varchar(25)'),...