.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 09, 2010    Points: 0   Category :Sql Server
In what circumstances do we get the below error. Shouldn't it be a little more descriptive?

The statement has been terminated. [SQLSTATE 01000]

This is for an SQL SERVER 2005 SP2. I am running a rebuild index using a TSQL job. The rebuild runs fine for a while giving this error later.

View Complete Post

More Related Resource Links


Does anyone know how to suprime
the error message [SQLSTATE 01000} that comes at the end of a Print line?
Thank you.

SQLSTATE 42000- Error 15404 with ADS

Hello, I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2.  Here is the error message: == The job failed.  Unable to determine if the owner (ADS\me) of job eFASRtest has server access (reason: Could not obtain information about Windows NT group/user 'ADS\me', error code 0x5. [SQLSTATE 42000] (Error 15404)). ==   also this message in log: == [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADS\me, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin) ==     I already tested the suggested:   execute as login='ads\me' and I get the same error on both (my local installations and production)   appreciate your help

SQLState=S1000, NativeError=0

I am trying to use the BCP command to execute the following statement, but I keep getting the following error: Starting copy... SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file 0 rows copied. Network packet size (bytes): 4096 Clock Time (ms.) Total     : 1 My BCP command: bcp Development.dbo.wbl_Load in zSkywardEWCodes.xml -m50 -e ErrorLog -b100 -S just5clicks.com -U###### -P###### and the "#"s represent my username and password   This is a very small XML file and here are it's contents: <xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'  xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'  xmlns:rs='urn:schemas-microsoft-com:rowset'  xmlns:z='#RowsetSchema'> <s:Schema id='RowsetSchema'>  <s:ElementType name='row' content='eltOnly'>   <s:AttributeType name='c0' rs:name='WITHDRAWAL-CODE' rs:number='1'>    <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='6' rs:maybenull='false'/>   </s:AttributeType>   <s:AttributeType name='c1' rs:name='WITHDRAWAL-SDESC' rs:number='2' rs:nullable='true'>    <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='30'/>   </s:Attribut

exception "ORA-01000: maximum open cursors exceeded"

Now, I use ado.net access oracle. when i execute a sql many time, OracleException class throw a exception, upon.

What's it cause ? And how do I solve it ?

Nested SQLException; SQLState: 08S01 Vendor Code: 0 Message: Connection reset

I get this error on my web page whenever i keep open some applications. I browsed through some links which say that it could be a network issue. Though I havn't received any convincing answer though. Any idea why this happens?

ODBC Error: SQLState 28000 & Server Error 18452



We have an application that connects to SQL 2005 thru ODBC with the following string:

driver=SQL Server;server=server1;database=db2005;uid=serveruser;pwd=pwd1;

When our administrators login on the workstation the application works well. But when ordinary users login they get the following error. (We only have 1 domain)

SQLState: 28000

SQL Server Error: 18452

Login failed for user ". The user is not associated with a trusted SQL Server connection.

Then the standard SQL Server Login window pops up asking for the Login ID and Password. On the window the 'Use Trusted Connection' is checked and the name of the user on the workstation appears on the LoginID. What we do is uncheck the 'Use Trusted Connection' then login using the credentials above.

Need help on this one please. Thanks.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend