Search results for query: *

...the objects being accessed and everything is fine.. Now when I try to access data from a table (table2 on database db2) in server2 such as select * from server2.db2.dbo.table2 I get the following error.. OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information...

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

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

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

...error but insert into TAB2 gives an error and the entire transaction rolls back and no rows are inserted into TAB1 and TAB2. i.e when I do a select * from TAB1 and TAB2, no rows are retrieved. This is when I try to insert rows through ASP. Now I'm executing the same transaction through SQl...

...error but insert into TAB2 gives an error and the entire transaction rolls back and no rows are inserted into TAB1 and TAB2. i.e when I do a select * from TAB1 and TAB2, no rows are retrieved. This is when I try to insert rows through ASP. Now I'm executing the same transaction through SQl...

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