Recent content by vaidyanathanpc

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...

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

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...

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...

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...

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

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...

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...

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

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...

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...

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

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...

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...

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