When I am saving a record thru Great Plains, the system dont save data and an
error message is appearing on screen which says "Save operation on table
"<Table Name>" failed accessing SQL Data. The dbo is trying to write the data
on back group.
Anybody can suggest a way forward.
Thanks
Huaim
Hi
Contact Greap Plains PSS and see what they say. That is not a SQL Server
error message.
Cheers
Mike
"Huaim" wrote:
> When I am saving a record thru Great Plains, the system dont save data and an
> error message is appearing on screen which says "Save operation on table
> "<Table Name>" failed accessing SQL Data. The dbo is trying to write the data
> on back group.
> Anybody can suggest a way forward.
> Thanks
> Huaim
Showing posts with label save. Show all posts
Showing posts with label save. Show all posts
Thursday, March 22, 2012
Data save failed
When I am saving a record thru Great Plains, the system dont save data and an
error message is appearing on screen which says "Save operation on table
"<Table Name>" failed accessing SQL Data. The dbo is trying to write the data
on back group.
Anybody can suggest a way forward.
Thanks
HuaimHi
Contact Greap Plains PSS and see what they say. That is not a SQL Server
error message.
Cheers
Mike
"Huaim" wrote:
> When I am saving a record thru Great Plains, the system dont save data and an
> error message is appearing on screen which says "Save operation on table
> "<Table Name>" failed accessing SQL Data. The dbo is trying to write the data
> on back group.
> Anybody can suggest a way forward.
> Thanks
> Huaim
error message is appearing on screen which says "Save operation on table
"<Table Name>" failed accessing SQL Data. The dbo is trying to write the data
on back group.
Anybody can suggest a way forward.
Thanks
HuaimHi
Contact Greap Plains PSS and see what they say. That is not a SQL Server
error message.
Cheers
Mike
"Huaim" wrote:
> When I am saving a record thru Great Plains, the system dont save data and an
> error message is appearing on screen which says "Save operation on table
> "<Table Name>" failed accessing SQL Data. The dbo is trying to write the data
> on back group.
> Anybody can suggest a way forward.
> Thanks
> Huaim
Data save failed
When I am saving a record thru Great Plains, the system dont save data and a
n
error message is appearing on screen which says "Save operation on table
"<Table Name>" failed accessing SQL Data. The dbo is trying to write the dat
a
on back group.
Anybody can suggest a way forward.
Thanks
HuaimHi
Contact Greap Plains PSS and see what they say. That is not a SQL Server
error message.
Cheers
Mike
"Huaim" wrote:
> When I am saving a record thru Great Plains, the system dont save data and
an
> error message is appearing on screen which says "Save operation on table
> "<Table Name>" failed accessing SQL Data. The dbo is trying to write the d
ata
> on back group.
> Anybody can suggest a way forward.
> Thanks
> Huaim
n
error message is appearing on screen which says "Save operation on table
"<Table Name>" failed accessing SQL Data. The dbo is trying to write the dat
a
on back group.
Anybody can suggest a way forward.
Thanks
HuaimHi
Contact Greap Plains PSS and see what they say. That is not a SQL Server
error message.
Cheers
Mike
"Huaim" wrote:
> When I am saving a record thru Great Plains, the system dont save data and
an
> error message is appearing on screen which says "Save operation on table
> "<Table Name>" failed accessing SQL Data. The dbo is trying to write the d
ata
> on back group.
> Anybody can suggest a way forward.
> Thanks
> Huaim
Wednesday, March 7, 2012
data mining
How can I mine data through SQL Server and can further save specific values to database ?Use Analysis Services to create models based on your SQL Database using BI Development Studio, then you can use Integration Services to put prediction results from the models back into a SQL database. You can also call Analysis Services directly using an OPENQUERY/OPENROWSET call from SQL in an INSERT INTO as well.|||If you decide to use the OPENQUERY/OPENROWSET approach , you can find some details at: http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3914.aspx
Friday, February 24, 2012
Data Lost , Help !!!
i make an application to insert data to sdf file and save it
when i colse the application and open it again i find my stored data on the sdf file well
and if i closed the application 1000 times i'll find my data ok
that's ok and that's not the problem
the problem that when i open this sdf file from sql server management studio and make a select on it i don't find any result and when i try to open the db from my application again i found it empty with no data
i realized that management studio delete's the data from my db
Any Ideas Here ?
I had a similar problem when I first used SQL CE1. Copied the demo Northwind.sdf into its own directory
2. Added it to my VS2005 project
3. Made changes during testing
4. Data not there when viewed from SQL Server Management tool
After that initial moment of panic I realised that VS2005 takes a COPY of the sdf file and puts it into the project directory. Tra la - that is where the updates went.
In VS2005 project put mouse over the .sdf file to get the address and then look there for the data.
Good luck|||
the problem that when i open this sdf file from sql server management studio and make a select on it i don't find any result and when i try to open the db from my application again i found it empty with no data
i realized that management studio delete's the data from my db
do u c what i wrote above in my case
ur answer isn't related to the problem i'm facing
but thx alot for help
but i know that vs2005 take a copy to the local folder and use it and it's optional cause vs2005 asks u if u wanna do this or not before copying the file to the local folder
thx alot
hey there any ideas
i'm gonna crazy
Data Lost , Help !!!
i make an application to insert data to sdf file and save it
when i colse the application and open it again i find my stored data on the sdf file well
and if i closed the application 1000 times i'll find my data ok
that's ok and that's not the problem
the problem that when i open this sdf file from sql server management studio and make a select on it i don't find any result and when i try to open the db from my application again i found it empty with no data
i realized that management studio delete's the data from my db
Any Ideas Here ?
I had a similar problem when I first used SQL CE1. Copied the demo Northwind.sdf into its own directory
2. Added it to my VS2005 project
3. Made changes during testing
4. Data not there when viewed from SQL Server Management tool
After that initial moment of panic I realised that VS2005 takes a COPY of the sdf file and puts it into the project directory. Tra la - that is where the updates went.
In VS2005 project put mouse over the .sdf file to get the address and then look there for the data.
Good luck|||
the problem that when i open this sdf file from sql server management studio and make a select on it i don't find any result and when i try to open the db from my application again i found it empty with no data
i realized that management studio delete's the data from my db
do u c what i wrote above in my case
ur answer isn't related to the problem i'm facing
but thx alot for help
but i know that vs2005 take a copy to the local folder and use it and it's optional cause vs2005 asks u if u wanna do this or not before copying the file to the local folder
thx alot
hey there any ideas
i'm gonna crazy
Data Lost
Excuse me if my redaction is bad, but I don't speak english very well.
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!
Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!
|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
[vbcol=seagreen]
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!
|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ? The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using to
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!
Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!
|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
[vbcol=seagreen]
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!
|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ? The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using to
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra
Data Lost
Excuse me if my redaction is bad, but I don't speak english very well.
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query agai
n
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to fin
d
> the phantom?
> Thanks!!!|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
[vbcol=seagreen]
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
>|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query agai
n
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to fin
d
> the phantom?
> Thanks!!!|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ? The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using t
o
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query agai
n
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to fin
d
> the phantom?
> Thanks!!!|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
[vbcol=seagreen]
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
>|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query agai
n
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to fin
d
> the phantom?
> Thanks!!!|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ? The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using t
o
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra
Data Lost
Excuse me if my redaction is bad, but I don't speak english very well.
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
> > Excuse me if my redaction is bad, but I don't speak english very well.
> >
> > My Question is:
> > I have a SQL DataBase in which every day I save a lot of records.
> > I'm sured that the records are in the Database because I can see them.
> > I made queries in DB using a Windows application but next day I query again
> > and I can't see the records.
> > There are no proccess like stored procedures that delete the records; even
> > the application doesn't have an option to delete them.
> > First time, I thougt the reason was the DataBase Server wasn't shut down
> > correctly. But this time Server wasn't shut down.
> > I really need help because it's very stranger. can somebody help me to find
> > the phantom?
> >
> > Thanks!!!|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ¿ The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using to
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
> > Excuse me if my redaction is bad, but I don't speak english very well.
> >
> > My Question is:
> > I have a SQL DataBase in which every day I save a lot of records.
> > I'm sured that the records are in the Database because I can see them.
> > I made queries in DB using a Windows application but next day I query again
> > and I can't see the records.
> > There are no proccess like stored procedures that delete the records; even
> > the application doesn't have an option to delete them.
> > First time, I thougt the reason was the DataBase Server wasn't shut down
> > correctly. But this time Server wasn't shut down.
> > I really need help because it's very stranger. can somebody help me to find
> > the phantom?
> >
> > Thanks!!!|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ¿ The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using to
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra
Subscribe to:
Posts (Atom)