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 Chriss Miller 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. vaidyanathanpc

    OLEDB error when accessing data thru linked servers

    Hello, I have configured linked server on my SQL server (server1) to access data from a remote SQL server(server2). Both are SQL Server 2000. The linked server was setup without errors. I have checked the privileges on the objects being accessed and everything is fine.. Now when I try to...
  2. vaidyanathanpc

    Timeout expired

    Hi, I have a procedure. When I run it, I always get the error "timeout expired". Is there any way I can change the script time out or the query timeout to a higher value? Where can I set this value on my SQL server? Thanks P.C. Vaidyanathan
  3. vaidyanathanpc

    Transactional Replication

    Hi, I need a tutorial with examples on Transactional Replication. Can you suggest something on this. How to carry out transactional replication, what are the constraints etc. I have a database in which not all the tables have primary or unique keys. When I opt for transactional replication, the...
  4. vaidyanathanpc

    ODBC Error

    Hi, I'm trying to connect to a remote server using TCP/IP. I'm getting the following error. What could be the problem? "000000eefe136007 com.wm.app.b2b.server.DBConnectionException: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network...
  5. vaidyanathanpc

    User creation

    Hi, I am not know how to give access to a user as per the scenario below. I have a server (say Server1). I have put my database (DB1) on Server1. Now there is one more database (DB2)which is also going to sit on Server1. I want to create a user (login) who can do whatever he wants...
  6. vaidyanathanpc

    Route output to an excel sheet

    Hi, I want to route the output of a query to an excel sheet. How do I do this? I have a query.. Select column1, column2, column3 from table1 I want to route the o/p of this query to an excel sheet. Thanks P.C. Vaidyanathan
  7. vaidyanathanpc

    Scripting Jobs

    Hi, I have about ten jobs running under SQL Server agent on my server. I want to create a script file of three of the jobs to restore on to a different server. I selected all the three jobs -> right click -> generate SQL script. In the script generated, there was only one job scripted. The...
  8. vaidyanathanpc

    Distributed transaction error

    Hi, I have written a procedure as below. I'm connected to a remote server server1 with valid login id and permissions. When I run the procedure, I get the following error. Server: Msg 7391, Level 16, State 1, Procedure procAddMissingAssociates, Line 09 The operation could not be performed...
  9. vaidyanathanpc

    Job fails

    I right click on the job and start in again. Sometimes it runs sometimes it does not... In the view job history, the error mentioned above is displayed.. Is there any limit on the number of linked servers that can be created? Regards, P.C. Vaidyanathan
  10. vaidyanathanpc

    Job fails

    Hi, I have scheduled a job to run everyday night. The job is failing sometimes and not always with this error. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312). The step failed. If I run the job again without changing anything, it...
  11. vaidyanathanpc

    Cross Tab Query giving error

    Hi, I'm having a problem while writing cross tab queries. The fact is I'm getting errors when I execute the query. The query is as follows. SELECT skill_Id, count(CASE final_rating WHEN 5 THEN assoc_name ELSE 0 END) AS "5", count(CASE final_rating WHEN 4 THEN assoc_name ELSE...
  12. vaidyanathanpc

    Not able to update data using linked server

    There is no issue with case sensitivity. Both the servers are SQl Server 7.0 versions.
  13. vaidyanathanpc

    Not able to update data using linked server

    Sorry!!! Please read the update stmt as UPDATE remoteservername.DB2.DBO.tablename SET column1 = column1 + 200, UPDATED_DATE = GETDATE() WHERE colume2 = 2181 Sorry for the confusion... Also in the error msg please read "pwallet" as DB2 and "pw_tbl_redeempoints" as...
  14. vaidyanathanpc

    Not able to update data using linked server

    Hi, I am working on the database DB1 and have created a linked server to a database DB2. I have the login and password to access the remote server. The user has access to insert, update and delete data on the remote server. When i connect to the linked server and try to update an existing...
  15. vaidyanathanpc

    Script tables with data in SQL Server 7.0

    Hi, How can I generate a script file for all the tables in my database with the data. The script file when run should create all the tables with the constraints and also have the data inserted into them. Thanks in advance P.C. Vaidyanathan
  16. vaidyanathanpc

    Suppress error messages from being displayed

    Hi, I have written a procedure to send mail. CREATE procedure PCWishes as declare @rc int Begin exec @rc = master.dbo.xp_sendmail @recipients='Murali_K', @Subject='Service Anniversary!!',@Message='Hello' if @rc = 1 begin print 'Error' end End The mail id given in the recepients...
  17. vaidyanathanpc

    SQL Mail

    Hi, I have SQL Server installed on a WINDOWS NT 4.0 server. I am using SQL Mail to send mails. Is it possible to have two profiles configured to send mails thru SQL Server? What I mean is, for application1 I want to send mails through profile1 and for another application2 I want to send mails...
  18. vaidyanathanpc

    Getting different results when using transactions

    Hi, I need some help in using transactions. I'm running a transaction in ASP as shown in the code below which inserts data into two tables. Dim conSQL Dim conSQL1 Dim strSQL Set conSQL = Server.CreateObject ("ADODB.Connection") conSQL.Open...
  19. vaidyanathanpc

    Using transactions

    Hi, I need some help in using transactions. I'm running a transaction in ASP as shown in the code below which inserts data into two tables. Dim conSQL Dim conSQL1 Dim strSQL Set conSQL = Server.CreateObject ("ADODB.Connection") conSQL.Open...
  20. vaidyanathanpc

    Help on Stored Procedure

    CREATE PROCEDURE CreateMenuItems @in_cls_id int AS declare ..... DECLARE cursor_name CURSOR FOR SELECT DISTINCT column1,column1,column3 .... FROM viewUserPrivileges WHERE ..... ORDER BY ..... OPEN cursor_name FETCH NEXT FROM cursor_name INTO declared local variables while...

Part and Inventory Search

Back
Top