SQLServer2000 - Error Logs Change Loc

Jun 14, 2004

The SqlServer2000 error logs go to Program FilesMicrosoft SQL ServerMssqlLog directory by default.

How can I change their location. I could change SqlServerAgent logs but did not find any help or way to change the location of these. Would anyone please help?

Thanks
Vinnie

View 3 Replies


ADVERTISEMENT

UNABLE TO CONNECT TO SQLSERVER2000 FROM VS2005 .How To Enable Remote Connection On Sqlserver2000

Sep 10, 2007



Hi,

iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.


I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine

With regards
Mahender

View 1 Replies View Related

SQL Server Logs (error Logs)

Aug 28, 2001

When looking at SQL Server error logs, I noticed that the current error
log had grown to 1MB whereas most of the files are only a few KB.

QUESTION 1: Can I set the max size for an error log file? If so, how?

QUESTION 2: If not, is there a workaround?

Thanks

View 1 Replies View Related

Error On Win98 And Sqlserver2000

Aug 23, 2006

Wilson writes "Hi, I have Sql Server 2000 on win98, i can't retrieve any data. Instead, it shows an error, says that some files is missing or is not registered.

the mssql was reinstalled and it's goin then same.

what could be the problem? what could be the solution?"

View 1 Replies View Related

Error In Connecting To The Databse(sqlserver2000)

Apr 7, 2008

hiam working with VS2005(asp,c#),sql server2000.
i uploaded my application to the webserver.when i try to interact with database in my webpages.it is giving error
error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
 
actually am using   sqlserver2000,but it is giving error regarding 2005.how can i resolve this.
my web.config settings are like this.. 
<?xml version="1.0"?><!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
--><configuration>
<appSettings>
<add key="cn" value="User ID=redot;Password=redot;Data Source=216.185.43.148:8077;Initial Catalog=redot" />
 <!--<add name="redotConnectionString" connectionString="Data Source=REDOT;Initial Catalog=redot;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>-->
 
 <!--<add key="smtpServer" value="smtp.mydomain.com" />-->
</appSettings><connectionStrings>
<!--<remove name="LocalSqlServer"/>--><!--<add name="ConnectionString" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot; Password=redot"providerName="System.Data.SqlClient" />-->
 
<add name="redotConnectionString" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString1" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString2" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString3" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString4" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString5" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString6" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString7" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString8" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString9" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString10" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
</connectionStrings><system.web>
 
 
 
 <sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=216.185.43.148:8077;User ID=redot;Password=redot;Trusted_Connection=True"cookieless="false" timeout="60"
/>
<compilation debug="true" />
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user. -->
 
 
 <!--<customErrors mode="Off"></customErrors>-->
<!--<customErrors mode="On" defaultRedirect="error.aspx"/>--><!--<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />-->
 <customErrors defaultRedirect="http://seafarersjobs.com/errorStatus.htm" mode="On">
 <error statusCode="404" redirect="filenotfound.htm" />
</customErrors></system.web>
<system.net><mailSettings>
<smtp><network host="216.185.54.55" port="25" />
<!--password="123456" userName="redot"--></smtp>
</mailSettings></system.net>
</configuration>
 
 
 
 
can anyone help me ASAP ..pls
 
 
Thanks
Shobha

View 4 Replies View Related

Dataset.fill Error In Sqlserver2000 + ASP.net 2.0

Jun 12, 2006

Hi,I am unable to load data in dataset via sqlconncetion object. Always i get error at ds.fill.Thanks in advance. PLS Help.Sudipta Datta www.geocities.com/dattasudipta 

View 1 Replies View Related

Failed To Install Sqlserver2000 W/out Error Msg

Mar 26, 2008

hi... i need help.
i tried to install sql server 2000 on my laptop (WinXP os) and when i reach the form where im supposed to click "Install Database Server", the next form after clicking "Install Database Server" wont show, and there are no error messages. I tried everything i could but it didnt work. My last choice is to format my computer - but i dont want to do that.

there are two processes running on the background that has SQL in its name - SETUPSQL.EXE and SQLSTP.EXE. I think this shows that the setup is still running.

i need help asap please, and i dont want to format my computer...

thanks in advance!

View 2 Replies View Related

DTS Error Logs.

Mar 9, 2000

I am currently trying to export from SQL to notes via NotesSQL.I have set up the necessary ODBC data sources & DTS job. I am encountering errors when I attempt to execute the DTS package . I.e "job failed"
- How do I drill down to aquire more detailed error logging on the package to find out exactly what's wrong with DTS?

Thanks

Paul

View 1 Replies View Related

Error Logs

Oct 3, 2000

When I'm in EM, there is one log that when I click on it to view it hangs my EM. All other logs (current and others) I can click and view just fine. I'm on my way out to the server to see the log in the file directory but what could cause this?

Thanks..

View 2 Replies View Related

SQL Error Logs

Apr 18, 2000

Is there another way to restart the SQL Error Log without shutting down and restarting the MSSQLserver service?

View 2 Replies View Related

Error Logs For JOB

May 25, 2008

Hi ,

How can i create an error log txt file for the jobs at the sql2005? the same like it was in the 2000.

many thanks

View 5 Replies View Related

Error Logs

Mar 14, 2007

I created a package in SSIS, and used the SQL Server Agent to run the package. I get an error 'Package Execution Failed' everytime I run it throught the SQL Server Agent.I don't get an error if I run the package from SSIS.

I right-clicked in 'Control Flow' and clicked Logging to add a new log. After I re-run this again in the SQL Server Agent, where do I go to find the error log?

View 5 Replies View Related

DB Engine :: Write Logs To Windows Event Logs?

Aug 6, 2015

OS: Windows 2012 Enterprise

SQL Server: 2012 Enterprise

I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

View 3 Replies View Related

Out Of Control Error Logs

Jan 2, 2001

I have recently uncovered a problem we are experiencing with SQL Server 6.5 Service Pack 4 (Don't ask) and wonder if anyone has seen this before, and maybe has a solution.

When viewing an errorlog either current or historic, via either enterprise manager of xp_readerrlog, occassionaly the network connection is dropped and the process runs out of control. The process is unkillable, as it is in a 'Critical Section' and does not respond to kill. The real problem is that the process is logging millions of errors of the form "...cannot send results to the front end..." at a rate of around 1GB / hour.

Any help would be much appreciated.

Cheers
BP

View 1 Replies View Related

So Confused Need Help Regarding Error Logs And SQL

Jan 14, 2008

I was under the impression or i always got following entries in SQL Agent error log when server restart and there are some entries in sql error log as well which confirms that server restarted. but today when i was checking error log i saw same entreis in SQL agent error log but there were no entries in server error log. now i got really confused whether my server is restarted or not........... because if it is restarted then there must be some messages in server error log.....
can some one please let me know when and why following messages appear in SQL Agent Error Log



Information,[171] There are 9 alert(s) in the alert cache
Warning,[425] delay_between_response attribute (10 sec) of alert (9) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (8) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (7) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (6) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (5) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (4) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (3) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (1) is less than poll interval for this alert (20 sec)
Warning,[425] delay_between_response attribute (10 sec) of alert (2) is less than poll interval for this alert (20 sec)
Information,[170] Populating alert cache...
Information,[168] There are 3 job(s) [0 disabled] in the job cache
Information,[297] SQLServer Message: 0<c/> SQLServerAgent Monitor started successfully. [SQLSTATE 01000]
Information,[133] Support engine started
Information,[167] Populating job cache...
Information,[110] Starting SQLServerAgent Monitor using '' as the notification recipient...
Information,[193] Alert engine started (using Eventlog Events)
Information,[146] Request servicer engine started
Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Information,[174] Job scheduler engine started (maximum worker threads: 800)
Information,[129] SQLAgent$XYZ starting under Windows NT service control
Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
Information,[124] Subsystem 'ANALYSISCOMMAND' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'ANALYSISQUERY' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'QueueReader' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'Merge' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'Distribution' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'LogReader' successfully loaded (maximum concurrency: 200)
Information,[124] Subsystem 'Snapshot' successfully loaded (maximum concurrency: 800)
Information,[124] Subsystem 'CmdExec' successfully loaded (maximum concurrency: 80)
Information,[124] Subsystem 'ActiveScripting' successfully loaded (maximum concurrency: 80)
Information,[124] Subsystem 'TSQL' successfully loaded (maximum concurrency: 160)
Information,[432] There are 10 subsystems in the subsystems cache
Information,[431] Populating subsystems cache...
Information,[339] Local computer is ABC running Windows NT 5.2 (3790) Service Pack 1
Information,[310] ** processor(s) and **** MB RAM detected
Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is ServerName
Information,[102] SQL Server ODBC driver version 9.00.2047
Information,[101] SQL Server ABC version 9.00.2047 (0 connection limit)
Information,[100] Microsoft SQLServerAgent version 9.00.2047.00 (x86 unicode retail build) : Process ID 8100
Error,[298] SQLServer Error: 2812<c/> Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs)

View 4 Replies View Related

SSIS Error Logs

Apr 1, 2008



Hi Everyone,

I am very new to Integration Services and need some help on how to capture any errors generated in the SSIS package when executed. Any idea how I can accomplish this?

Thank You
-Sam

View 3 Replies View Related

Permission To View Error Logs

Jan 4, 2001

How can a person view the error logs without being an sa?

View 1 Replies View Related

Executive Error Logs---very Urgent

Jul 21, 2000

Hi,
I want to see my sql executive error log but it grown like anything.
How i have to trucate my error log. I cannot stop my server now.
i am getting following message. and also suggest me what i have to do not to grow like this means 56.01 mb size.
The sql executive error log is 56.01 mb in size and loading it will consume considerble memory and may take several minutes to complete.
Now i want to see my executive error log , pls tell me what i have to do.

--rk

View 1 Replies View Related

How To Write Error Logs In Notepad

Nov 27, 2013

how to write a error logs in notepad in sql server 2008

View 3 Replies View Related

SSIS Logs Vs Custom Logs Components

Feb 12, 2007

Hi,

In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.

Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though.

Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised.

Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error.

What do you think? Kindly advise.

Thanks in advance for your help and time.

Regards,

$wapnil

View 3 Replies View Related

Trace Logs And Finding Error Source

Apr 19, 2006

Hi All! Looking for some help with SQL errors.
We are using SQL 2005. Our server has been failing (service just stops responding) several times a week. We don't have a DB admin, just me, the developer, so please be patient.
I can view all the errors in the existing trace through the Profiler, but not sure how to follow error to query source.
How do you use the trace logs to find the problem query?
I have two significant errors in my logs. One is Hash Warning and the other is Missing Join Operand. I'm not interested in the general causes of these types of errors, that info has been easy to find.
I don't know how to link or otherwise associate a particular instance of an error in the trace logs to the query that caused it to determine the query that is causing the trouble.
The traces are already on the server. I've never created a new trace. I believe they are generated automatically by the server...
Can someone shed some light on how these existing traces are being generated and how I can modify them to include the data I need? When I open an existing trace on the server and view the properties, events tab, there appears to be no way to select the column "TextData" (no checkboxes) for the two errors we are seeing (listed above).
If the TextData column for the errors will allow me to see the offending query, can someone please tell me how to enable that column in my traces that are currently being generated on the server?
Thank you!
 
Drew

View 4 Replies View Related

Setup Failed For Error Logs And Cnfgsvr.out

Feb 22, 2001

I am trying to install the SQL7 server, at the end of the installation before
rebooting the server I got the following error:
"Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information". I have not seen that error before. I cannot install the SQL7 because I always get the same message. Your help would be very appreciate helping me to solve this problem.

Thanks.

View 2 Replies View Related

Timestamp Error While Restoring Transaction Logs

Feb 10, 2000

I have scheduled a database backup at 9 pm and 5 Transaction Log backups. The transaction Log backups happen at 11 am, 1 pm, 3 pm and 5 pm (device does not get initialized) and one at 11 pm where i initialize the backup device. now i have another server with the same database on it. I restore these backups on to this server by simple copying the files and then doing Restore ...From Device...Add file...option. I am able to restore the DB backup but when i try to restore the log backups it get the error msg -

'Specified file 'G:...' is out of sequence. current time stamp is Feb 9 2000 3:54 pm while dump was from Feb 9 2000 3 pm.'

When i am restoring the logs i start from the 1st backup buyt still i get this error. Can someone pls let me know what the problem is and how to resolve it. Thanks.

View 2 Replies View Related

Default Number Of Error Logs=6 - What Is Best Practice?

May 8, 2007

What is best practise for what this number should be?



I have seen guidance saying set to a number greater than 25000, but not from any source I particularly know or trust. (I checked SANS, NIST-CIS and the NSA, but I couldn't find anything.

View 1 Replies View Related

SQL Server 2005 Error Logs Grow Exponentially

Dec 12, 2007

I have seen a couple of cases where an error occurs on a server running SQL Server 2005, and very quickly the log folder at MSSQL.1MSSQLLOG starts filling up with files, and does not stop until the entire hard drive is full (at which time the server stops responding). Is there any way to limit the number of .dmp files that are written?

View 7 Replies View Related

Locked Process Hang Ups Not In Error Logs?? Memory Usage Too??

Jul 20, 2005

Details:MS SQL 2000 dual Intel 1.2 GHz processors.1 GB RAM2.1 GB dBDynamic Memory Managment.No other apps running on this server.First question:Since I have Dynamic Memory Managment setup, Is it usuall that thesqlsrv.exe process on the server steadily climbs and is in the 800 to900 MB range. There is only about 20 MB free. In theory this is howDMM can work, but do people really see it work this way.Second question:I had users complaining about lockups in the app I have to supportthat connects to this dB. At first I thought it was the large use ofmemory, but once I was able to see in Enterprise Manager that therewas process blocking several other processes. EM then locked up and Icouldn't get to the details of what the exact process was that wasdoing the blocking. After restarting SQL services things were fine.When I checked the logs there was nothing there about a hung process.The logs seemed very sparse. Why would there not be anything in thelogs about it. The logs actually seem very thin on any information.Thanks,T.

View 1 Replies View Related

Error/Failure Audit In Event Logs (SQL 2005 Express) [Advanced Services]

Aug 9, 2007

Q1: Any way to control which db loads when, and perhaps stop this error from happening? Again- when all is said and done, the report server functions, and I am able to access just fine.

Q2: What kind of recovery is being referred to? Given the message type- I assume it's nothing of concern- probably more to do with a system that doesn't run all the time.

Okay- so I get these two event messages each time I boot.

Below are two error message I see daily with each system boot- the services mentioned do "actually" function, and are running- as not 10 seconds after these messages are logged, the successfully loaded messages appear. It's almost as if report services tries to connect before the databases are up and running.

Basically the sequence (today) was:

1. 05:49:01 Failure Audit (MSSQL$SQLEXPRESS)
2. 05:49:01 Error (Report Server Windows Service (SQLEXPRESS)
3. 05:49:02 Recovery is complete. (EventID 3408 MSSQL$SQLEXPRESS)
4. 05:49:06 Starting up database 'ReportServer'
5. 05:49:09 Server Resumed execution (MSSQL$SQLEXPRESS)

I'm assuming based on the events that Report Server Service attempts to connect to the ReportServer database before it's actually started. Doesn't really explain the failure audit-


1. Failure Audit:

Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 8/9/2007
Time: 05:49:01
User: <MACHINENAME><LOCALUSER>
Computer: <MACHINENAME>
Description:
Login failed for user '<MACHINENAME><LOCALUSER>'.
[CLIENT: <local machine>]


This is almost immediately followed by this (which I consider a no-brainer, considering the above):

2. Error:


Event Type: Error
Event Source: Report Server Windows Service (SQLEXPRESS)
Event Category: Management
Event ID: 107
Date: 8/9/2007
Time: 05:49:01
User: N/A
Computer: <MACHINENAME>
Description:
Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database.


View 1 Replies View Related

SQLServer2000 Vs ADO VB6

Aug 4, 2004

Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6

In a code snipplet a have something like:

Conn1.BeginTrans

Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")

Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans


and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"

However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I canīt execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
Iīve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.

Why does this occurs? Is there a way to solve it?

NOTE: I need forcely to execute that SELECT before the DELETE.

Thanks for the time
Roland

View 2 Replies View Related

SQLServer2000 Vs ADO VB6

Aug 4, 2004

Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6

In a code snipplet a have something like:

Conn1.BeginTrans

Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")

Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans


and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"

However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I canīt execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
Iīve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.

Why does this occurs? Is there a way to solve it?

NOTE: I need forcely to execute that SELECT before the DELETE.

Thanks for the time
Roland

View 2 Replies View Related

SQL Server Error Logs: What Events Is It Logging? Can We Edit And Include DDL Events?

Jun 20, 2007

Hello experts. I have been searching for anything about this but found very little. What are the events logged in SQL Server Error Logs aside from Successful/Failed Login, Backup/Restore/Recover database and, start/init sql server? Can we configure this to log other events, like CREATE or DBCC events for example? If so, how? Thanks a lot.

View 1 Replies View Related

In Sqlserver2000 Date ?

Oct 11, 2006

date(m/dd/yyyy)9/18/2006 In this above table i want to select only the month in this format Sep 2006 . How to do that ?  

View 1 Replies View Related

Cannot Connect To SQLServer2000

Jul 3, 2007

Hello everyone,My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.

View 1 Replies View Related

Top Not Getting Supported In Sqlserver2000

Nov 10, 2007

Hi, 
I have  created the below procedure in SQL SERVER 2005.
But when I copy out the same in SQL SERVER 2000. I get an error at the underlined place. It says
Line 32: Incorrect syntax near '('.
 ALTER procedure [dbo].[VTELcardvalidation1]
@CardValue1 int,
@CardValue2 int,
@CardValue3 int,@Result nvarchar(50)output
as
begin
declare @CrdPinNo varchar(100)
declare @CrdNo nvarchar(100)declare @count int
declare @inc int
declare @concat nvarchar(200)create table #temptable(crno nvarchar(50),pno nvarchar(50))
 
--First Card
--Change here
select @count=count(cardno) from vendorcardvalidation where cardvalue=1500 and flag=0if (@count)>@CardValue1
begin
declare cur1 cursor forselect top(@CardValue1) pin,cardno from vendorcardvalidation where cardvalue=1500 and flag=0 order by cardno
open cur1fetch next from cur1 into @CrdPinNo,@CrdNo
while(@@fetch_status=0)
beginupdate vendorcardvalidation set flag=1 where cardno=@CrdNo
insert into #temptable values(1500,@CrdPinNo)fetch next from cur1 into @CrdPinNo,@CrdNo
endclose cur1
deallocate cur1
set @Result='Success'end
else
begin
set @Result='Failure'
end
select * from #temptable
drop table #temptable
end
 
 
It seems the the word 'top' will not be supported in sqlserver 2000. What should I do?
Regards
cmrhema
 
 
 

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved