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'...
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...
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
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 all , Have recently upgraded the Database to 2005 from 2000, did all the things to fix the issue but still having performance issues. 1-...
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...
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...
I am running the following query on our sql 2005 database Update [BL ] set bl_issue_dt = DATEADD(month,4 ,bl_issue_dt ) where bl_issue_dt is...
Hi- We have a sql 2000 database and I have a very strange problem with the stored procedure. when i run the stored procedure with from the query...
Hi-- Currently the replication monitor has been displaying the message"delivering replication transaction" from my distribution agent for the last...
Hi-- Every now and again the views on our SQL server 2000 become very slow any query referenceing the view also gets too slow some time takes ages...
Separate names with a comma.
