Click here to Skip to main content
15,900,973 members
Home / Discussions / Database
   

Database

 
GeneralRe: SELECT column FROM table WHERE time = @time ISSUE Pin
sonia.sardana23-Apr-08 23:43
sonia.sardana23-Apr-08 23:43 
GeneralRe: SELECT column FROM table WHERE time = @time ISSUE Pin
Sivu21-Apr-08 23:53
Sivu21-Apr-08 23:53 
GeneralProblem with timeout in accessing Excel file Pin
Rocky#21-Apr-08 23:06
Rocky#21-Apr-08 23:06 
GeneralRe: Problem with timeout in accessing Excel file Pin
Blue_Boy22-Apr-08 0:20
Blue_Boy22-Apr-08 0:20 
GeneralRe: Problem with timeout in accessing Excel file Pin
Rocky#22-Apr-08 0:28
Rocky#22-Apr-08 0:28 
GeneralRe: Problem with timeout in accessing Excel file Pin
Michael Potter22-Apr-08 4:12
Michael Potter22-Apr-08 4:12 
GeneralRe: Problem with timeout in accessing Excel file Pin
Rocky#22-Apr-08 4:17
Rocky#22-Apr-08 4:17 
GeneralSqlDumpExceptionHandler Error Pin
Vimalsoft(Pty) Ltd21-Apr-08 22:18
professionalVimalsoft(Pty) Ltd21-Apr-08 22:18 
Good Morning All

i have the Following Query

---------------------------------------------------------
--Updating the Actual_Extent  with a Floor Area
update  Tshwane_Valuations_Train.sde.Property_Summary_Backup
set Actual_Extent = ip.Actual_Extent
from  Tshwane_Valuations_Train.sde.Property_Summary_Backup p 
inner Join  Returned_file_GEOSS ip on 
p.Property_ID  = ip.Property_ID
where ip.Property_ID = p.Property_ID
And Propery_ID in  
(
select Property_ID from Property_Summary
where Actual_Extent is null
And Func_key like 'GEOSS%'
And Archive_Date is Null
union all
select Property_ID from Property_Summary
where Actual_Extent in (0,1,2,3,4,5,6,7,8,9)
And Func_key like 'GEOSS%'
And Archive_Date is null
 )


This when i tryt to run the query , i get the Following Error

Msg 0, Level 19, State 0, Line 3
SqlDumpExceptionHandler: Process 149 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.


What is Wrong,

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za


GeneralRe: SqlDumpExceptionHandler Error Pin
SimulationofSai21-Apr-08 22:57
SimulationofSai21-Apr-08 22:57 
GeneralRe: SqlDumpExceptionHandler Error Pin
Vimalsoft(Pty) Ltd21-Apr-08 23:10
professionalVimalsoft(Pty) Ltd21-Apr-08 23:10 
GeneralSQL server mdf and ldf Pin
new2pgrmg21-Apr-08 19:19
new2pgrmg21-Apr-08 19:19 
GeneralRe: SQL server mdf and ldf Pin
Sivu21-Apr-08 21:32
Sivu21-Apr-08 21:32 
GeneralRe: SQL server mdf and ldf Pin
SimulationofSai21-Apr-08 21:34
SimulationofSai21-Apr-08 21:34 
GeneralRe: SQL server mdf and ldf Pin
new2pgrmg21-Apr-08 22:12
new2pgrmg21-Apr-08 22:12 
GeneralColumn lenth as read from syscolumns table Pin
WBurgMo21-Apr-08 15:44
WBurgMo21-Apr-08 15:44 
GeneralRe: Column lenth as read from syscolumns table Pin
Ashfield21-Apr-08 20:02
Ashfield21-Apr-08 20:02 
AnswerRe: Column lenth as read from syscolumns table Pin
WBurgMo22-Apr-08 9:33
WBurgMo22-Apr-08 9:33 
GeneralRe: Column lenth as read from syscolumns table Pin
Ashfield22-Apr-08 21:15
Ashfield22-Apr-08 21:15 
QuestionSQL HELP Pin
n1coltsfan21-Apr-08 5:38
n1coltsfan21-Apr-08 5:38 
GeneralRe: SQL HELP Pin
Michael Potter21-Apr-08 8:21
Michael Potter21-Apr-08 8:21 
GeneralRe: SQL HELP Pin
n1coltsfan21-Apr-08 8:36
n1coltsfan21-Apr-08 8:36 
GeneralRe: SQL HELP Pin
Michael Potter21-Apr-08 8:56
Michael Potter21-Apr-08 8:56 
GeneralRe: SQL HELP [modified] Pin
Blue_Boy21-Apr-08 9:17
Blue_Boy21-Apr-08 9:17 
GeneralRe: SQL HELP Pin
n1coltsfan22-Apr-08 8:44
n1coltsfan22-Apr-08 8:44 
QuestionHow to write the multiple query in single store procedure? [modified] Pin
bruze21-Apr-08 1:11
bruze21-Apr-08 1:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.