Search results for query: *

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

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

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

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

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

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

Hi, I have two different servers Server1 and Server2. I had a database DB1 on Server1 which I restored onto the server Server2 with the same name DB1. Then I deleted the database DB1 from the server Server1. Now when I try to establish snapshot replication of DB1 from Server2 onto the...

Hi, We have an up and running web application. Yesterday we added two more systems to our application. The two systems are connected to our SQl Server through WAN using sp_addlinked server. Now the performance of our system has gone down like anything. When we removed the linked server the...

Hi, I'm having problems while running distributed transactions on two different servers. I have two servers 'EPOOL5' and 'EPOOL9' respectively running SQl servers. I have linked both the servers using Sp_addlinkedserver 'EPOOL5' and sp_addlinkedserver 'EPOOL9' on EPOOL9 and EPOOL5...