Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mohsinnazir

    Remote Replication

    Thanks paul, I have set up the login for subscriber and publisher. Publisher using sql server agent default username and password and subscriber using database username and password subscriber user has db_owner rights
  2. mohsinnazir

    Remote Replication

    Hello Guys, I am trying to do remote transactional replication But it is giving me following error. Publisher is on server A Subscriber in on server B The process could not connect to Subscriber B Any suggection Appriciated
  3. mohsinnazir

    Create a SP to delete data from SQL table

    You can create a function in sql server e.g CREATE FUNCTION convertInToDate(@X varchar(20)) RETURNS smalldatetime AS BEGIN return cast(SUBSTRING ( '20070501000001' , 1 ,4)+'-'+SUBSTRING ( '20070501000001' , 5 ,2)+'-'+ SUBSTRING ( '20070501000001' , 7 ,2) + ' ' + SUBSTRING (...
  4. mohsinnazir

    Data update on two different SQl server database on different network

    Hello Guys, I need experts suggestion about this issue, At the moment we have one databse server which is connected to our web site and internal system and it is round about 20GB of size. Whenever user search some information from the web site system go to main databse server and gets the...

Part and Inventory Search

Back
Top