Hi, I have the following scenario that i need help with I have a Login 'Smith' which is mapped to the user 'smith' and is member of the 'Public'...
Thanks for your message can you give some pesudo code example how to replace the UPDATE() function in the updated trigger that will handle multiple...
Thanks for your response, I understand the issue with multiple rows now but can you please also explain why the update via replication will be...
Satya, Thanks for your quick response. i am a bit confuse with your response. the fact that MS has givin us this option called "Not for Replication...
Hi, I have a problem with merge replication the senario is like this. The Replication Setup: Two tables on Publication Server Master table, log table...
HI,According to this link: http://streamyx-streamyx20370.blogspot.com/2008/06/notification-services-removed-from-sql.html MS have removed the...
Guys!! Many thanks to all of your for your quick reposnses, I think i will go with Frank's Solution. Frank re-arrange the following: Star!! are You a...
Adrian, There are approx 300 tables in the DB going through every single of them to modify the permission would be a painfull process. is there any...
A pirticular user only...
Hi, I want to find out what is the best way to make the whole DB readonly except one table can be left updateable within this db. Regards, Khan
Satya, Thanks for your response but do you have the screen shot of this option ? when i expand the formula in the Define Formula dialog box...
Report Builder help explains how to remove Dubplicates but there is no way to get to this option can anyone help.Depending on the subject of your...
Hi Thanks for the quick response checked with MS that is for queries taking long time to compile on 64Bit...
HI all , Have recently upgraded the Database to 2005 from 2000, did all the things to fix the issue but still having performance issues. 1-...
tcp:server1 gives the following error in the query window is the sytax correct ? Msg 102, Level 15, State 1, Line 1 Incorrect syntax near...
I am trying to register a SQL 2000 server from the SQL Management Studio of a SQL 2005 Server. I get the following error TITLE: Connect to Server...
Satya-- Thanks for the quick response. the link you have suggested is very useful i cam across this link in my search on google the only thing...
we have a SQL server 2005 database server with SSRS installed that sits behind the firewall, but our web server sits in the DMZ outside the...
Yes you guys are right there are 4 triggers on this table neither sp_help 'BL' or the other query is showing them just discoverd what the problem is...
No its not a view its just a simple table the database is not part of any replication there are no triggers involved on any table its really silly...
Separate names with a comma.
