SELECT
ts.[EmployeeId]
,p.[FirstName]
,p.[LastName]
[Code].....
This query should show people that have worked under 4 days but it displays the full database including all the people with 4 or more entries.
It works if the [StartedAt] and [HoursWorked] Fields are not included but I need these fields included.
Does anyone lese get the same results that I do?
tblTest has an id field and a testName field....table has 2 records:
1 kevin test 1
2 kevin test 3
SELECT *
FROM tblTest t
INNER JOIN CONTAINSTABLE(tblTest,*,'"kevin test 1"') as A ON t.id = A.[KEY]
Result is both records returned, but since the search is in quotes as an exact phrase, should not just the first record be returned?
According to MS, GetLocalTime() (in C++) is only accurate to approx asecond,even though it reports milliseconds, and calling it twice and computingtheinterval can on occasion lead to a negative interval.Is T-SQL's GetDate() more accurate than that, or at leastnon-decreasing?Thanks,Jim
View 4 Replies View RelatedHello,
I'm just trying out this new try-catch stuff in sql server 2005....
Using the example from the help, "Using TRY... CATCH in Transact-SQL" , it shows how things are done in the adventure works database.. loggin the error to the errorlog table and all that... looks great.. but I notice that when I implement this code in my project.. and tested by putting in a line that causes a divide by zero error... that the line number reported by error_line is acutally not the line at which the divide by zero code resides....
Any suggestions as to what would put the error_line out of whack? I have comments and some string literals in the code..would they be throwing it?
Thanks
Hi, how can i get a accurate division in tsql - is there some way of casting?
Problem is simple, "SELECT 3 / 2" is "1" - what can i do to get 1.5 as result?
I am newish to databases and would appreciate some
advise. I think I have a solution to my
problem but it is going to take me a lot of time to get it running. If there is a better way of doing it I would
like to know.
I have a table :-
“eventDates� with
columns (id, date, eventID,
eventCount)
The id auto increments as a Primary Key.
date holds the date of the
event.
EventID references another
table with info about the events
Up to 9 eventIDs can be added
for each date and I want eventCount to hold an integer (1 to 9) to allow me to “pivot�
the data to the table below
“results� with columns (date,
eventCount1, eventCount2 …..eventCount9) so each row will hold a date and non
to nine eventIDs occurring on that date.
Is there an easy way to keep eventCount accurate or do I
just have to write a lot of code? I
will need to be able to remove events as well as add them. I will use a mixture of stored procedures
and VB.Net I guess?
Many thanks for any advice.
Mike
I do hourly transaction log backups at 9,10, 11 etc...
When I restore from a 9:00 backup I clearly see changes that I made after 9:00 am!!!
I then noticed when I go to my scheduled backups that a 10 am backup was indeed done
but in the "restore from device" tab it says the last backup was at 9 am.
Apparently it is not showing the actual latest backup that was done. This explains why
when restoring from a 9am backup I am seeing changes after 9, because in reality
I am restoring from a 10 am backup!
Is this a bug? I am running on 6.5 sp 5a.
thanks in advance....Mary
I want to test some times it takes for a proc to run. Since I work for a large company, I rarely have access to the SQL server in a capacity where I can use profiler and such. Are there any quick and easy ways to just surround blocks of code in a T-SQL statement to get an accurate reading on how long it takes?I.e., if I surround with GETDATE() before and after, does that also measure the round trips to the server, or just the execution time.I want to just compare some different methods and see what is quicker. THX.
View 4 Replies View RelatedHow do I get an accurate count of workstations connected to a database?
View 7 Replies View RelatedSample Table
USE [Testing]
GO
/****** Object: Table [dbo].[Testing] Script Date: 4/25/2014 11:08:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
[Code] ....
It seems to work fine with one million records.
Each primary key is unique, but the begindate is non-unique, and i guess even if i use datetime2 and add nanoseconds, from what i have read, there is a chance that i could have a duplicate datetime since the date is imported via XML from multiple sources.
Hi,
I am using SQL Server 2005,
while trying to retrieve data from the database; I am getting the following
error:
A transport-level error has occurred when receiving results
from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)
But I am getting this error randomly.
Can some one help me out?
Waiting for your response
Sudhakar
Hi,
Basically the error that I am getting is in our test automation when running as non-admin on the box (regular user). We use .Net C# SQLConnection class to connect to SQL express 2005 impersonating with admin credentials. After getting the connection we try to execute a select command and it some time fails with following error:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The handle is invalid.) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader()
This happen only in the non-admin scenario mentioned above. Any idea what is triggering this?
Thanks in advance for all replies.
I have looked at other threads regarding errors similar to this, but I think mine is a bit different.
I am using SQL2005 Standard Edition and my application is coded with C# using ADO.Net. OLEDB connection is used. The error occurs when the application has only one thread accessing the database. It does not happen consistently, so it is very puzzling.
I am wondering if anyone could offer any tip to diagnose this.
Thanks in advance!
Hi,
I created a DTS package to populate no of tables from text files.
I created more database connetion and spreaded among the tables to load parrelly. I have specified an exception file for logging errors.
I am getting the following errors while executing the package.
connection is busy with results for another command
Cannot open file. Log file is being used by another progroram.
Any help please?
Thanks
John Jayaseelan
I'm currently trying to using this bcp script to export results to a csv.
USE crm001_spark
GO
EXEC xp_cmdshell 'bcp "SELECT top 10 * FROM [datebasename].dbo.table name]" queryout "C:Customers.csv" -c -b 10000 -t , -T -S [server]datebasename'
and the ERROR that is coming out is
SQLState = 08001, NativeError = -1
NULL
Error = [Microsoft][SQL Native Client]Login timeout expired
Error = [Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
SQLState = 08001, NativeError = -1
Error = [Microsoft][SQL Native Client]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.
SQLState = S1T00, NativeError = 0
I have checked the server config manager TCP port and it is pointing to the correct port 1433. What else could be causing the error ?
I have an Excel/ vba module to update a SQL database. One of the data is numeric. If the data is a positive number, there is no problem, but if the number (zscore) in Excel is negative an error pops up: Error converting datatype varchar to numeric.
zscore = Range("J" & mytel99)
rc.Open "INSERT INTO dbo.QHSE_3rdline_history (RvA_Nr, RvA_Letter, Afdeling, Datum, Organisator, NummerRO, Eenheid, ALC, RO, Interpretatie) " _
& "VALUES ('" & rva1 & "', '" & rva2 & "', '" & Range("B" & mytel99) & "', '" & datum & "', '" & Range("B1") & "', '" & Range("B2") & "', '" & Range("G" & mytel99) & "', '" & Range("H" & mytel99) & "', '" & Range("I" & mytel99) & "', '" & Range("K" & mytel99) & "')", con
rc.Open "UPDATE dbo.QHSE_3rdline_history SET [Matrix] = '" & Range("C" & mytel99) & "', [Component] = '" & Range("D" & mytel99) & "', [Zscore] = '" &
[code]....
how to get negative data in a numeric SQL table?
I am using snapshot replication to copy data from one database to another. I truncate the destination table first. The publisher and the subscriber are different databases on the same server. The data turns into 1 unrecognizable row.
Here is what the source table looks like:
displayTypeID, displayType
1, Title List Formats
2, Title Details
3, Title List Export
4, Pricing Notes
5, clone Mask 001
6, clone Mask 002
7, clone Mask 004
8, clone Mask 008
9, hide From Admin
10, not Common Attr
11, Insert Title
12, title Types
The resulting data looks like this:
DisplayType, displayTypeId
, 1660953600
I see no errors in replication and nothing in the source table looks like bad data that could cause such a malady. I see the problem on two different servers now and identified the source of the problem, the column order is reversed in the source and destination tables. The data types do not even match so I would at the very least expect an error from bcp.
I got the above error executing a stored procedure from .Net app and I isolated the issue on the following sql statement inside the sp. I executed the statement manually inside the MSSQL Mgt Studio and got the same error as above. Here is the sql statement:
SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29 from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=E:\TPSDATA\az\;','select * from prohist.csv where f1 < 0 ')
the data file exists in the directory 'E: psdataazprohist.csv' . I'm running on SQL2005 version 9.00.3054.00. Any ideas what the problem is? Appreciate any feedback
Hi,
I am hosting my ASP.NET application on a Host and after some time I get this error
(Don't get it on my development machine):
A severe error occurred on the current command. The results, if any, should be discarded.
And then it says this on the same page:
Exception Details: System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[SqlException: A severe error occurred on the current command. The results, if any, should be discarded.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +643
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +9
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId)
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs e)
System.Web.SyncEventExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
I thought this is a problem with max pool size and I did it max pool size = 5000, now application runs ok for some time and then produces this error but some times this comes very soon.
As a solution, I have to copy my dll in bin directory again and application restarts and works properly but then after some time this happenes again.
Please let me know whats the problem.
I checked all of my SqlDataReaders and SqlConnections are closed properly.
Any help would be appreciated.
Thanks.
Rahul.
Hi all. I am running on SQL 2005 Standard eddition SP2, Also did install " KB Article Number(s): 944929, 946608, 948490, 949118". Running on 2003 server.
Error:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I have 2 servers. One of them is free text seach with files stored in DB. On main server there is a link back to this file DB server.
I am trying to run this script and then error from above... link_kance_doc is link to table on other server. Strange thing is when I run this same script on server 3 with same link to file DB server it works. It also works when runed on file DB server.
Also, if I dont use WHERE CONTRAINS SQL does return Dataset..
SELECT link_kance_doc.ID, link_kance_doc.DocName, link_kance_doc.DocExtension, link_kance_doc.KancelID, link_kance_doc.Comments,
link_kance_doc.CreateByUser, link_kance_doc.CreateTS, link_kance_doc.ActiveYN
FROM link_kance_doc
where Contains(*,'"murte"')
Any ideas..
Server LOG
02/26/2008 16:54:05,Server,Unknown,A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
02/26/2008 16:54:05,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
02/26/2008 16:54:05,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
02/26/2008 16:54:04,spid57,Unknown,Stack Signature for the dump is 0x28BDEE59
02/26/2008 16:54:04,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
02/26/2008 16:54:04,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
02/26/2008 16:54:04,spid57,Unknown,010B9201 Module(sqlservr+000B9201)
02/26/2008 16:54:04,spid57,Unknown,010B9064 Module(sqlservr+000B9064)
02/26/2008 16:54:04,spid57,Unknown,010B939C Module(sqlservr+000B939C)
02/26/2008 16:54:04,spid57,Unknown,010B94A5 Module(sqlservr+000B94A5)
02/26/2008 16:54:04,spid57,Unknown,010075DC Module(sqlservr+000075DC)
02/26/2008 16:54:04,spid57,Unknown,010078CC Module(sqlservr+000078CC)
02/26/2008 16:54:04,spid57,Unknown,010077A6 Module(sqlservr+000077A6)
02/26/2008 16:54:04,spid57,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
02/26/2008 16:54:04,spid57,Unknown,01032A36 Module(sqlservr+00032A36)
02/26/2008 16:54:04,spid57,Unknown,01028600 Module(sqlservr+00028600)
02/26/2008 16:54:04,spid57,Unknown,0134752A Module(sqlservr+0034752A)
02/26/2008 16:54:04,spid57,Unknown,01430633 Module(sqlservr+00430633)
02/26/2008 16:54:04,spid57,Unknown,01346B6B Module(sqlservr+00346B6B)
02/26/2008 16:54:04,spid57,Unknown,013A929A Module(sqlservr+003A929A)
02/26/2008 16:54:04,spid57,Unknown,01368BB2 Module(sqlservr+00368BB2)
02/26/2008 16:54:04,spid57,Unknown,013A9BDC Module(sqlservr+003A9BDC)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013AFC6E Module(sqlservr+003AFC6E)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013AF8D0 Module(sqlservr+003AF8D0)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013B0CC7 Module(sqlservr+003B0CC7)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013A9DC5 Module(sqlservr+003A9DC5)
02/26/2008 16:54:04,spid57,Unknown,013A9F20 Module(sqlservr+003A9F20)
02/26/2008 16:54:04,spid57,Unknown,01B2E1B9 Module(sqlservr+00B2E1B9)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,01B24372 Module(sqlservr+00B24372)
02/26/2008 16:54:04,spid57,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
02/26/2008 16:54:04,spid57,Unknown,0149C867 Module(sqlservr+0049C867)
02/26/2008 16:54:04,spid57,Unknown,0170D0CD Module(sqlservr+0070D0CD)
02/26/2008 16:54:04,spid57,Unknown,0170F7E3 Module(sqlservr+0070F7E3)
02/26/2008 16:54:04,spid57,Unknown,0170FB90 Module(sqlservr+0070FB90)
02/26/2008 16:54:04,spid57,Unknown,01702514 Module(sqlservr+00702514)
02/26/2008 16:54:04,spid57,Unknown,010A0F91 Module(sqlservr+000A0F91)
02/26/2008 16:54:04,spid57,Unknown,* Short Stack Dump
02/26/2008 16:54:04,spid57,Unknown,* -------------------------------------------------------------------------------
02/26/2008 16:54:04,spid57,Unknown,* *******************************************************************************
02/26/2008 16:54:04,spid57,Unknown,* SegSs: 00000023:
02/26/2008 16:54:04,spid57,Unknown,* Esp: 6373E24C: 00000004 00000000 6373E544 01702514 00000004 01019094
02/26/2008 16:54:04,spid57,Unknown,* EFlags: 00010206: 0055004E 0042004D 00520045 004F005F 005F0046 00520050
02/26/2008 16:54:04,spid57,Unknown,* SegCs: 0000001B:
02/26/2008 16:54:04,spid57,Unknown,* Ebp: 6373E254: 6373E544 01702514 00000004 01019094 637311EB 042DAD88
02/26/2008 16:54:04,spid57,Unknown,* Eip: 010A0F91: 103B118B B60FCD74 38B60F11 840FD72B 003D5E1C 01B8D285
02/26/2008 16:54:04,spid57,Unknown,* Edx: 042DAD48: 042DAAB8 042DA278 042DAA18 042DAD70 042DAF58 00000001
02/26/2008 16:54:04,spid57,Unknown,* Ecx: 00000004:
02/26/2008 16:54:04,spid57,Unknown,* Ebx: 05E929F8: 01622A98 00000001 00000000 00000000 00000000 00000000
02/26/2008 16:54:04,spid57,Unknown,* Eax: 01019094: 00000000 00000000 00000000 00000000 90909090 55FF8B90
02/26/2008 16:54:04,spid57,Unknown,* Esi: 00000010:
02/26/2008 16:54:04,spid57,Unknown,* Edi: 00000004:
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* dbghelp 64600000 64714FFF 00115000
02/26/2008 16:54:04,spid57,Unknown,* MSDATL3 64450000 64464FFF 00015000
02/26/2008 16:54:04,spid57,Unknown,* sqloledb 643C0000 64440FFF 00081000
02/26/2008 16:54:04,spid57,Unknown,* xpstar90 64390000 643B5FFF 00026000
02/26/2008 16:54:04,spid57,Unknown,* msadcer 64380000 64384FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* msadce 64320000 64377FFF 00058000
02/26/2008 16:54:04,spid57,Unknown,* OLEDB32R 64300000 64310FFF 00011000
02/26/2008 16:54:04,spid57,Unknown,* MSDART 64060000 64079FFF 0001a000
02/26/2008 16:54:04,spid57,Unknown,* oledb32 63FE0000 64058FFF 00079000
02/26/2008 16:54:04,spid57,Unknown,* odbcint 63FC0000 63FD6FFF 00017000
02/26/2008 16:54:04,spid57,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
02/26/2008 16:54:04,spid57,Unknown,* BatchParser90 63E50000 63E6EFFF 0001f000
02/26/2008 16:54:04,spid57,Unknown,* ODBC32 63E10000 63E4CFFF 0003d000
02/26/2008 16:54:04,spid57,Unknown,* SQLSCM90 63DF0000 63DF8FFF 00009000
02/26/2008 16:54:04,spid57,Unknown,* xpstar90 63D90000 63DD8FFF 00049000
02/26/2008 16:54:04,spid57,Unknown,* msftepxy 63600000 63614FFF 00015000
02/26/2008 16:54:04,spid57,Unknown,* SQLNCLIR 00830000 00862FFF 00033000
02/26/2008 16:54:04,spid57,Unknown,* comdlg32 762B0000 762F8FFF 00049000
02/26/2008 16:54:04,spid57,Unknown,* COMCTL32 77530000 775C6FFF 00097000
02/26/2008 16:54:04,spid57,Unknown,* sqlncli 631D0000 633F3FFF 00224000
02/26/2008 16:54:04,spid57,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
02/26/2008 16:54:04,spid57,Unknown,* xpsp2res 62F00000 631C4FFF 002c5000
02/26/2008 16:54:04,spid57,Unknown,* ntdsapi 766F0000 76703FFF 00014000
02/26/2008 16:54:04,spid57,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
02/26/2008 16:54:04,spid57,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
02/26/2008 16:54:04,spid57,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* hnetcfg 62E60000 62EB9FFF 0005a000
02/26/2008 16:54:04,spid57,Unknown,* dssenh 68100000 68126FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* imagehlp 76C10000 76C37FFF 00028000
02/26/2008 16:54:04,spid57,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
02/26/2008 16:54:04,spid57,Unknown,* dbghelp 62B00000 62C14FFF 00115000
02/26/2008 16:54:04,spid57,Unknown,* msfte 628A0000 62AF8FFF 00259000
02/26/2008 16:54:04,spid57,Unknown,* security 62210000 62213FFF 00004000
02/26/2008 16:54:04,spid57,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
02/26/2008 16:54:04,spid57,Unknown,* winrnr 76F70000 76F76FFF 00007000
02/26/2008 16:54:04,spid57,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
02/26/2008 16:54:04,spid57,Unknown,* RESUTILS 61DC0000 61DD2FFF 00013000
02/26/2008 16:54:04,spid57,Unknown,* CLUSAPI 61DA0000 61DB1FFF 00012000
02/26/2008 16:54:04,spid57,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
02/26/2008 16:54:04,spid57,Unknown,* VERSION 77B90000 77B97FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* MTXCLU 61D80000 61D98FFF 00019000
02/26/2008 16:54:04,spid57,Unknown,* msvcp60 61D10000 61D74FFF 00065000
02/26/2008 16:54:04,spid57,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
02/26/2008 16:54:04,spid57,Unknown,* MSDTCPRX 61C90000 61D08FFF 00079000
02/26/2008 16:54:04,spid57,Unknown,* XOLEHLP 61C80000 61C85FFF 00006000
02/26/2008 16:54:04,spid57,Unknown,* COMRES 77010000 770D5FFF 000c6000
02/26/2008 16:54:04,spid57,Unknown,* schannel 76750000 76776FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
02/26/2008 16:54:04,spid57,Unknown,* kerberos 61BD0000 61C27FFF 00058000
02/26/2008 16:54:04,spid57,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
02/26/2008 16:54:04,spid57,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* ole32 77670000 777A8FFF 00139000
02/26/2008 16:54:04,spid57,Unknown,* MSCOREE 34190000 341D4FFF 00045000
02/26/2008 16:54:04,spid57,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
02/26/2008 16:54:04,spid57,Unknown,* rsaenh 68000000 68034FFF 00035000
02/26/2008 16:54:04,spid57,Unknown,* SQLOS 344D0000 344D4FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
02/26/2008 16:54:04,spid57,Unknown,* instapi 48060000 48069FFF 0000a000
02/26/2008 16:54:04,spid57,Unknown,* psapi 76B70000 76B7AFFF 0000b000
02/26/2008 16:54:04,spid57,Unknown,* comctl32 77420000 77522FFF 00103000
02/26/2008 16:54:04,spid57,Unknown,* IMM32 76290000 762ACFFF 0001d000
02/26/2008 16:54:04,spid57,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
02/26/2008 16:54:04,spid57,Unknown,* SHELL32 7C8D0000 7D0CEFFF 007ff000
02/26/2008 16:54:04,spid57,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
02/26/2008 16:54:04,spid57,Unknown,* opends60 333E0000 333E6FFF 00007000
02/26/2008 16:54:04,spid57,Unknown,* USERENV 76920000 769E1FFF 000c2000
02/26/2008 16:54:04,spid57,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* WS2_32 71C00000 71C16FFF 00017000
02/26/2008 16:54:04,spid57,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
02/26/2008 16:54:04,spid57,Unknown,* MSASN1 76190000 761A1FFF 00012000
02/26/2008 16:54:04,spid57,Unknown,* CRYPT32 761B0000 76242FFF 00093000
02/26/2008 16:54:04,spid57,Unknown,* GDI32 77C00000 77C47FFF 00048000
02/26/2008 16:54:04,spid57,Unknown,* USER32 77380000 77410FFF 00091000
02/26/2008 16:54:04,spid57,Unknown,* Secur32 76F50000 76F62FFF 00013000
02/26/2008 16:54:04,spid57,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
02/26/2008 16:54:04,spid57,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
02/26/2008 16:54:04,spid57,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
02/26/2008 16:54:04,spid57,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
02/26/2008 16:54:04,spid57,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
02/26/2008 16:54:04,spid57,Unknown,* kernel32 77E40000 77F41FFF 00102000
02/26/2008 16:54:04,spid57,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
02/26/2008 16:54:04,spid57,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
02/26/2008 16:54:04,spid57,Unknown,* MODULE BASE END SIZE
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* ins(*<c/>'"murte"')
02/26/2008 16:54:04,spid57,Unknown,* teTS<c/> link_kance_doc.ActiveYN FROM link_kance_doc where Conta
02/26/2008 16:54:04,spid57,Unknown,* link_kance_doc.CreateByUser<c/> link_kance_doc.Crea
02/26/2008 16:54:04,spid57,Unknown,* nce_doc.DocExtension<c/> link_kance_doc.KancelID<c/> link_kance_doc.Comments<c/>
02/26/2008 16:54:04,spid57,Unknown,* SELECT link_kance_doc.ID<c/> link_kance_doc.DocName<c/> link_ka
02/26/2008 16:54:04,spid57,Unknown,* Input Buffer 510 bytes -
02/26/2008 16:54:04,spid57,Unknown,* Access Violation occurred reading address 00000004
02/26/2008 16:54:04,spid57,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
02/26/2008 16:54:04,spid57,Unknown,* Exception Address = 010A0F91 Module(sqlservr+000A0F91)
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* 02/26/08 16:54:04 spid 57
02/26/2008 16:54:04,spid57,Unknown,* BEGIN STACK DUMP:
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* *******************************************************************************
02/26/2008 16:54:04,spid57,Unknown,SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
02/26/2008 16:54:04,spid57,Unknown,***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0063.txt
02/26/2008 16:54:04,spid57,Unknown,Using 'dbghelp.dll' version '4.0.5'
02/26/2008 16:54:03,Server,Unknown,A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
02/26/2008 16:54:03,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
02/26/2008 16:54:03,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
02/26/2008 16:54:02,spid57,Unknown,Stack Signature for the dump is 0x28BDEE59
02/26/2008 16:54:02,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
02/26/2008 16:54:02,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
02/26/2008 16:54:02,spid57,Unknown,010B9201 Module(sqlservr+000B9201)
02/26/2008 16:54:02,spid57,Unknown,010B9064 Module(sqlservr+000B9064)
02/26/2008 16:54:02,spid57,Unknown,010B939C Module(sqlservr+000B939C)
02/26/2008 16:54:02,spid57,Unknown,010B94A5 Module(sqlservr+000B94A5)
02/26/2008 16:54:02,spid57,Unknown,010075DC Module(sqlservr+000075DC)
02/26/2008 16:54:02,spid57,Unknown,010078CC Module(sqlservr+000078CC)
02/26/2008 16:54:02,spid57,Unknown,010077A6 Module(sqlservr+000077A6)
02/26/2008 16:54:02,spid57,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
02/26/2008 16:54:02,spid57,Unknown,01032A36 Module(sqlservr+00032A36)
02/26/2008 16:54:02,spid57,Unknown,01028600 Module(sqlservr+00028600)
02/26/2008 16:54:02,spid57,Unknown,0134752A Module(sqlservr+0034752A)
02/26/2008 16:54:02,spid57,Unknown,01430633 Module(sqlservr+00430633)
02/26/2008 16:54:02,spid57,Unknown,01346B6B Module(sqlservr+00346B6B)
02/26/2008 16:54:02,spid57,Unknown,013A929A Module(sqlservr+003A929A)
02/26/2008 16:54:02,spid57,Unknown,01368BB2 Module(sqlservr+00368BB2)
02/26/2008 16:54:02,spid57,Unknown,013A9BDC Module(sqlservr+003A9BDC)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013AFC6E Module(sqlservr+003AFC6E)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013AF8D0 Module(sqlservr+003AF8D0)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013B0CC7 Module(sqlservr+003B0CC7)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013A9DC5 Module(sqlservr+003A9DC5)
02/26/2008 16:54:02,spid57,Unknown,013A9F20 Module(sqlservr+003A9F20)
02/26/2008 16:54:02,spid57,Unknown,01B2E1B9 Module(sqlservr+00B2E1B9)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,01B24372 Module(sqlservr+00B24372)
02/26/2008 16:54:02,spid57,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
02/26/2008 16:54:02,spid57,Unknown,0149C867 Module(sqlservr+0049C867)
02/26/2008 16:54:02,spid57,Unknown,0170D0CD Module(sqlservr+0070D0CD)
02/26/2008 16:54:02,spid57,Unknown,0170F7E3 Module(sqlservr+0070F7E3)
02/26/2008 16:54:02,spid57,Unknown,0170FB90 Module(sqlservr+0070FB90)
02/26/2008 16:54:02,spid57,Unknown,01702514 Module(sqlservr+00702514)
02/26/2008 16:54:02,spid57,Unknown,010A0F91 Module(sqlservr+000A0F91)
Hi all,
I
am trying to run a stored procedure which retreives 3 lakhs of records
and updates the data and moves few of those records to some tables.
Since the number of records are more , the time taken for the storede
procedure is around 30 minutes when i directly execute it in query
analyzer.
But I need to execute it from Visula Studio.Net 2005
(c#). Whole of the application contains only one form with a single
button.When I click on the button , this stored procure has to be
executed. But I am getting an error as shown below.
"A
transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)"
Database used is SqlServer 2000
How to solve this error?. Any ideas are really appreciated.
Thanks and Regards,
Sukanya.
Greetings,
Facing a strange problem, but obviously not expected earlier on, I am trying to execute a stored procedure via ADO which refrences a linked server table and I get an error specifying
"
OLEDB provider SQLOLEDB does not contain table "<DatabaseName>"."<owner>"."<tableName>"
"
Has any one else encountered this problem before ?
regards
Govind
hi, like, if i need to do delete some items with the id = 10000 then also need to update on the remaining items on the with the same idthen i will need to go through all the records to fetch the items with the same id right? so, is there something that i can use to hold those records so that i can do the delete and update just on those records and don't need to query twice? or is there a way to do that in one go ?thanks in advance!
View 1 Replies View RelatedI have four tables: Customer (CustomerId INT, CountyId INT), County (CountyId INT), Search(SearchId INT), and SearchCriteria (SearchCriteriaId INT, SearchId INT, CountyId INT, [others not related to this]).
I want to search Customer based off of the Search record, which could have multiple SearchCriteria records. However, if there aren't any SearchCriteria records with CountyId populated for a given Search, I want it to assume to get all Customer records, regardless of CountyId.
Right now, I'm doing it this way.
DECLARE @SearchId INT = 100
SELECT * FROM Customer WHERE
CountyId IN
(
SELECT CASE WHEN EXISTS(SELECT CountyId FROM SearchCriteria WHERE SearchId = @SearchId)
THEN SearchCriteria.CountyId
[Code] .....
This works; it just seems cludgy. Is there a more elegant way to do this?
Hello. I currently have a website that has a table on one webpage. When a record is clicked, the primary key of that record is transfered in the query string to another page and fed into an sql statement. In this case its selecting a project on the first page, and displaying all the scripts for that project on another page. I also have an additional dropdownlist on the second page that i use to filter the scripts by an attribute called 'testdomain'. At present this works to an extent. When i click a project, i am navigated to the scripts page which is empty except for the dropdownlist. i then select a 'testdomain' from the dropdownlist and the page populates with scripts (formview) for the particular test domain. what i would like is for all the scripts to be displayed using the formview in the first instance when the user arrives at the second page. from there, they can then filter the scripts using the dropdownlist.
My current SQL statement is as follows.
SelectCommand="SELECT * FROM [TestScript] WHERE (([ProjectID] = @ProjectID) AND ([TestDomain] = @TestDomain))"
So what is happening is when testdomain = a null value, it does not select any scripts. Is there a way i can achieve the behaivour of the page as i outlined above? Any help would be appreciated.
Thanks,
James.
Hi All,
I have a stored proc which is executing successfully...but the results of that stored proc are displaying in the Messages Tab instaed of results Tab. And in the Results Tab the results shows as 0..So, Any clue friends..it is very urgent..I am trying to call this stored proc in my Report in SSRS as well but the stored proc is not displaying there also...Please help me ASAP..
Thanks
dotnetdev1
Hi all, I have the following SQLDataSource statement which connects to my Gridview:<asp:SqlDataSource ID="SqlDataSourceStandings" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT P.firstName, P.lastName, T.teamName, IsNull(P.gamesPlayed, 0) as gamesPlayed, IsNull(P.plateAppearances,0) as plateAppearances, IsNull( (P.plateAppearances - (P.sacrifices + P.walks)) ,0) as atbats, IsNull(P.hits,0) as hits, P.hits/(CONVERT(Decimal(5,2), IsNull(NullIF(P.atbats, 0), 1))) AS [average], (P.hits + P.walks)/(CONVERT(Decimal(5,2), IsNull(NullIF( (P.atbats + P.sacrifices + P.walks) , 0), 1))) AS [OBP], (P.hits - (P.doubles + P.triples + P.homeRuns) + (2 * P.doubles) + (3 * P.triples) + (4 * P.homeRuns)) / (CONVERT(Decimal(5,2), IsNull(NullIF(P.atbats, 0), 1))) AS [SLG], P.singles, P.doubles, P.triples, P.homeRuns, P.walks, P.sacrifices, P.runs, P.rbis FROM Players P INNER JOIN Teams T ON P.team = T.teamID ORDER BY P.firstName, P.lastName"></asp:SqlDataSource>There are 8 teams in the database, and somehow the average and obp results are as expected for all teams except where T.teamID = 1. This doesn't make sense to me at all! For example, I get the following results with this same query: First NameLast NameTeamGPPAABHAVGOBPSLG1B2B3BHRBBSACRRBI
BrianAustinHope83432230.7187500.7352941.15625014612201221
GabrielHelbigSafe Haven62119141.0000000.9375002.1428576404111519
MarkusJavorSafe Haven82927200.8695650.8000001.21739114501021218
RobBennettMelville83029240.8275860.8333331.55172411904102117
AdamBiesenthalSafe Haven82929210.9130430.9130431.56521712631001015
ErikGalvezMelville82625180.7200000.7307691.24000011322101015 As you can see, all teams except for Safe Haven's have the correct AVG and OBP. Since AVG is simply H/AB, it doesn't make sense for Gabriel Helbig's results to be 1.00000. Can anyone shed ANY light on this please?Thank you in advance,Markuu ***As a side note, could anyone also let me know how I could format the output so that AVG and OBP are only 3 decimal places? (ex: 0.719 for the 1st result)***
Hi,
I have a web form that lets users search for people in my database they wish to contact. The database returns a paged set of results using a CTE, Top X, and Row_number().
I would like to give my users to option of removing individual people from this list but cannot find a way to do this.
I have tried creating a session variable with a comma delimited list of ID's that I pass to my sproc and use in a NOT IN() statement. But I keep getting a "Input string was not in a correct format." Error Message.
Is there any way to do this? I am still new to stored procedures so any advice would be helpful.
Thanks
Hi, when I copy and paste results from query analyzer into Excel it appears that values with zeroes at the end loose the zeroes. Example, if I copy and paste V128.0 into an Excel cell it comes out as V128 or if I copy 178.70 it displays as 178.7 - any ideas? I'm using SQL Enterprise Manager for 2000.
View 6 Replies View RelatedHi, I am seeking a hopefully easy solution to spit back an error message when a user receives no results from a SQL server db with no results. My code looks like this What is in bold is the relevant subroutine for this problem I'm having. Partial Class collegedb_Default Inherits System.Web.UI.Page Protected Sub submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit.Click SqlDataSource1.SelectCommand = "SELECT * FROM [college_db] WHERE [name] like '%" & textbox1.Text & "%'" SqlDataSource1.DataBind() If (SqlDataSource1 = System.DBNull) Then no_match.Text = "Your search returned no results, try looking manually." End If End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load SqlDataSource1.SelectCommand = "SELECT * FROM [college_db] ORDER BY [name]" SqlDataSource1.DataBind() End Sub Protected Sub reset_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles reset.Click SqlDataSource1.SelectCommand = "SELECT * FROM [college_db] ORDER BY [name]" SqlDataSource1.DataBind() End SubEnd Class I'm probably doing this completely wrong, I'm a .net newb. Any help would be appreciated. Basically I have GridView spitting out info from a db upon Page Load, but i also have a search bar above that. The search function works, but when it returns nothing, I want an error message to be displayed. I have a label setup called "no_match" but I'm getting compiler errors. Also, next to the submit button, I also have another button (Protected sub reset) that I was hoping to be able to return all results back on the page, similar to if a user is just loading the page fresh. I'd think that my logic would be OK, by just repeating the source code from page_load, but that doens't work.The button just does nothing. One final question, unrelated. After I set this default.aspx page up, sorting by number on the bottom of gridview, ie. 1,2,3,4, etc, worked fine. But now that paging feature, as long with the sorting headers, don't work! I do notice on the status bar in the browser, that I receive an error that says, "error on page...and it referers to javascript:_doPostBack('GridView1, etc etc)...I have no clue why this happened. Any help would be appreciated, thanks!
View 2 Replies View RelatedWe've devoted a resource to this today, but I have to believe it's something easy that we're overlooking. The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end. This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions. So, after the upgrade we now receive 100's of thexe SQL excptions per day:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Does anyone know what we've overlooked that's causing this issue?Thanks for any help!
View 2 Replies View RelatedHi, i wanted to know if there is a way that we can know if Sqldatasource retrieved 0 results, i wanted that cause i want to make a condition that if 0 results retrieves a page with the text "No news"...Thanks in advance.
View 2 Replies View RelatedSQL Server 2000
i have made a table(EmployeeRole) consists of the following fields :
Appname
EmployeeID
RoleID
ProjectID
QMS
1353
1
BI0362
QMS
1353
3
BI0362
QMS
1379
1
BI0362
QMS
1379
13
BI0362and another table called employee
EmployeeID
FirstName
LastName
1353
Wissam
Zein
1379
Wassim
Zeinand another table called Role:
RoleID
RoleName
1
User
3
PD
13
TeamLeaderi need to make a query that gives the following results:
EmployeeID
EmpName
RoleID
RoleName
1353
Wissam Zein
3
PD
1379
Wassin Zein
13
TeamLeader
thank you for the help and for the time