Viewing 15 posts - 106 through 120 (of 125 total)
Exactly, there is no distinction, based on data, user can change/update whole record any column coz i don't know what changes user do but not the primary key (Auto ID). I want to...
July 25, 2007 at 10:31 pm
If there is no such trigger on tables, how your replication is working? without Triggers I never saw database that replicates somewhere. Due you realize it or not?
December 26, 2006 at 6:30 am
If you don't have permission to see distribution database, see triggers of that table for Database B, if there are three triggers (insert, update and delete) it may looks like...
December 26, 2006 at 1:16 am
Which Query Analyzer version ur using, In Management Studio 2005 query analyzer has an option to save login id and password when selecting SQK authentication but in SQL Server 2000...
November 10, 2006 at 7:25 am
Thanks for suggestion, I have opended a new Thread for help.
Plz help me solving my query.
Thanks once again.
Shamshad Ali
November 1, 2006 at 4:14 am
Hi all,
I want result in one select of following table as below:
RowID Message MessageType
1 To ‘some name’
2 From ‘My Name’
3 To ...
November 1, 2006 at 3:41 am
Thanks for pointing out my mistake, Try following- if this help out :
/*Generate the 'sp_change_users_login' statements necessary to synch all users in all databases on the server.*/
set...
June 1, 2006 at 6:59 am
Replace your cursor query with the following, first you test your query then put for cursor, I have not yet tested your all lines of script.
SELECT @UserName
May 31, 2006 at 6:49 am
From that Reference link it also saying as below:
You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schemas.
I...
May 11, 2006 at 4:02 am
I have fixed it.
Thanks for closing this POST.
======================================
Here is the solution:
You should make sure that Visual Studio is still installed.
If you didn't previously have VS installed, the BI Dev...
March 2, 2006 at 2:09 am
Yes these days question are usually from SQL SERVER 2005. Until we all move to SQL Server 2005 we must mention to which version of SQL Server it belonging.
From BOL as it states that:...
February 7, 2006 at 11:10 pm
use the Enterprise Manager to remove- It will remove all its dependent objects aswell, then you run sp_RemoveDBReplication
Shamshad Ali.
November 9, 2005 at 2:30 am
With continuation of my last post/query, My top priority is to let down the CPU usage at the Main Publisher Server, coz if the error is removed by applying...
June 23, 2005 at 1:57 am
Hi,
Further more, I have same scenario, we have Merge replication 1 publication is running without any filtered (horizontal filtration) replication and works fine, but 7 publications has...
June 23, 2005 at 1:45 am
We are running our Application on Access with Backend in SQL Server since past 4 years now(there are some reasons/ features we need from access and we still use it). Initially...
February 17, 2005 at 4:09 am
Viewing 15 posts - 106 through 120 (of 125 total)