Retriving Deleted Record From Database
Hi friends
I have a bit problem here
Just I want to get back all deleted record of database
How do I perform this task?
If It is possible then plz help me out?
Thanks in Advance
Khan
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Retriving The Id Of A New Record
Can anyone help with an effective way in retriving the id of the new record before input of any data into a form. We have a form where a few of the controls recordsource requires the new record id before they will display correctly. I have tried various ways to trigger the form afterupdate event in the hope that the id will be returned but get the error message "The data will be added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying recordsource" Thanks in advance
View Replies !
View Related
Retriving The ID Of The Last Record Inserted
I would appreciate help with retriving the ID of the last record inserted. Have spent considerable time in forums and google but can't find anything that works for me. Here is my VB Code Dim queryString As String = "INSERT INTO [DUALML] ([UseriD], [Company]) VALUES (@UseriD, @Company)" Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dbParam_useriD As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_useriD.ParameterName = "@UseriD" dbParam_useriD.Value = useriD dbParam_useriD.DbType = System.Data.DbType.Int32 dbCommand.Parameters.Add(dbParam_useriD) Dim dbParam_company As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_company.ParameterName = "@Company" dbParam_company.Value = company dbParam_company.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_company) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try Return rowsAffected End Function
View Replies !
View Related
Retriving Previous 5 Rows And Next 5 Rows And The Searched Record
Dear All I have a table with the following structure in sql server 2005 create table app( sno int, name varchar(50), add varchar(50), city varchar(50), state varchar(50) ) it contains the follwing data ------------------------------------------ sno name add city state ------------------------------------------ 1 mark street no1 newcity newstate 2 mark street no1 newcity newstate 3 mark street no1 newcity newstate 4 mark street no1 newcity newstate 5 mark street no1 newcity newstate 6 mark street no1 newcity newstate 7 mark street no1 newcity newstate 8 mark street no1 newcity newstate 9 mark street no1 newcity newstate 10 mark street no1 newcity newstate 11 mark street no1 newcity newstate 12 mark street no1 newcity newstate 13 mark street no1 newcity newstate 14 mark street no1 newcity newstate 15 mark street no1 newcity newstate 16 mark street no1 newcity newstate 17 mark street no1 newcity newstate 18 mark street no1 newcity newstate 19 mark street no1 newcity newstate 20 mark street no1 newcity newstate ---------------------------------------- I want to retrive previous 5 records, next 5 records and the record that meet the where condition of a select query. When I run select sno,add,name,city,state from app where sno=7 I want the following result ------------------------------------------ sno name add city state ------------------------------------------ 2 mark street no1 newcity newstate | 3 mark street no1 newcity newstate | 4 mark street no1 newcity newstate | -- previous 5 records 5 mark street no1 newcity newstate | 6 mark street no1 newcity newstate | 7 mark street no1 newcity newstate --- searched record 8 mark street no1 newcity newstate | 9 mark street no1 newcity newstate | 10 mark street no1 newcity newstate |--- next 5 records 11 mark street no1 newcity newstate | 12 mark street no1 newcity newstate | ---------------------------------------- if there is a method to get the above result set, kindly post the query.
View Replies !
View Related
How To Find How A Record Was Deleted
Is there a way to tell who or what process deleted a record in a SQL table.I know you can setup triggers or Profiler - but is there a way to see how arecord was deleted if you DO NOT have a trigger or Profiler already running?This is SQL 2000 Standard, sp3a with default options and configuration.Thanks
View Replies !
View Related
#Deleted When A Record Is Changed
First of all, let me apoligize if this is a stupid question, but just a few days ago I decided to change my FE/BE database from Ms Access to SQL Server Express. Now I have a FE in ACC2002 and a BE in SQL SERVER (the two connected via ODBC). Anyway, this is my question: When everything was in Access I had a form retreiving a series of records based on a filter - for understanding purpose let's say that a field must have been 'Not Null'. The operator then filled that field with data. With Access everything was static, and the operator could see all the records, the ones already changed and the ones not changed. With SQL now: everytime the operator fills in the field, the record changes to #Deleted. I assume that that is happening because the query - someway - is "alive" and is "filtering data alive"... or is updating records instantly. Just to make things more clear: is the record changed immediately so it is not considered part of the filtered data by the query, thus being change to #Deleted? What could I do to prevent this? Thanks a lot for your help.
View Replies !
View Related
Stopping A Single Record From Being Deleted
I am using a drop down list box to select values from an SQL 2000 DB. I have put a record into the table which says"...Select Item"I used the dots so that It will apear at the top of the list and therefore display at startup. I also have a gridview to allow users to edit and delete from the same table.I am worried that a user may accidently delete the "...Select Item" row from the table.Can anyone think of a way round this? Is it possible with SQL Server 2000 to stop a single record from being deleted?Any help would be most appreciated.ThanksPaul
View Replies !
View Related
Retriving Varchar(max) Value From Database
Hello, I am using datareader to retrive the varchar (max) value from the database. But it is reteriving only 8000 why ? I am not using normal varchar datatype. Below is the sample code. Convert.ToString(_oDr["MyVar"]) where _oDr is the datareader MyVar is defined of type varchar (max) in the sql 2005 database. Any help will be appreciated.
View Replies !
View Related
Manipulate The 'deleted Record' Flag On DBF Files
Hi, I am using OLE DB provider for Foxpro (VFPOLEDB.1) to query DBF files. I need to migrate the content of these files to a SQL Server 2005 database. These DBF files have some (actually a lot) records marked as deleted using the DBF 'deleted' flag. When I submit a SELECT command to the OLE DB Provider, it returns me all the non-deleted records from the file. It is very Ok as long as the 'deleted' rows actually have no more business value, but in my case, I need to do some processing on them, and even to migrate their data. What are the options available for me to be able to query and differentiate the 'deleted' records ? Thank you in advance, Bertrand Larsy
View Replies !
View Related
Please Correct This Error While I Retriving Image From Database
private void Page_Load(object sender, System.EventArgs e){ // Put user code to initialize the page here MemoryStream stream = new MemoryStream (); SqlConnection connection = new SqlConnection (@"..."); try { connection.Open (); SqlCommand command = new SqlCommand ("select Picture from Image", connection); byte[] image = (byte[]) command.ExecuteScalar (); stream.Write (image, 0, image.Length); Bitmap bitmap = new Bitmap (stream); Response.ContentType = "image/gif"; bitmap.Save (Response.OutputStream, ImageFormat.Gif); } finally { connection.Close (); stream.Close (); } Error: byte[] image = (byte[]) command.ExecuteScalar (); Unable to cast object of type 'System.Int32' to type 'System.Byte[]'.
View Replies !
View Related
Inserting And Retriving Datetime Field In Database MSSQL 2000
Hi, Assume I have a table name "myTime". This table is simply only have 1 (one) DATETIME field "MyTestTime" (also serve as a primary number).Table MyTime- MyTestTime : SQLTYPE DATETIMETo insert a new row into this field, I simply wrote :SqlCommand sqlCommand = new SqlCommand("insert into MyTime values('2006-01-09')", sqlConnection); I got the value of "2006-01-09" from a textbox or other relevan control.I realize when I try to use "SELECT * FROM MyTime" statement, MSSQL server 2000 automatically convert my date value from "2006-01-09" to "01/09/2006" (from YYYY-MM-DD to MM/DD/YYYY). I don't know why this one must be converted to MM/DD/YYYY automatically (I believe this behavior is depend on some "setting option" in my MSSQL server - but I don't know which one).The challenge is :In my country, the actual date format is like German Date format (DD-MM-YYY). Well I know this is only "Customization" problem. But how insert datetime value given from sql query to a datetime variable?// Connect to database, make a query, get the datareader result, and bla bla blaDateTime aDateTime = new DateTime;aDateTime = Convert.ToDateTime(myDataReader["PostDate"].ToString());// close connectionMy question isHow can I make sure that aDateTime's day is 09 not 01. How my program know that 09 is day not month. I can't use string.split() method because it's possible that my database setting will change from "mm-dd-yyyy" to "dd-mm-yyyy"thanks
View Replies !
View Related
Deleted Database
Our past CIO deleted a SQL Server database because he didn't know what it was or if we needed it. Guess what we do! We were able to undelete the backup files but when we try to restore from it we get the error "No a valid backup" Any ideas? Thank you for any help. :eek:
View Replies !
View Related
Records Don't Get Deleted From The Database!
I am using this code to delete records from a table in the database that has two fields (both are primary keys) I am not getting any error, but nothing gets deleted. Thanks for the help. Code:protected void btnRemove_Click(object sender, EventArgs e) { Remove();Response.Redirect("RegisteredCompanies.aspx"); }protected void Remove() { //update database with filename //Save Changes connection.Open();using (SqlTransaction trans = connection.BeginTransaction()) { try { SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "spRemoveCompany", new SqlParameter("@Userid", getGdUserID(Profile.UserName)),new SqlParameter("@BusinessID", getBusinessID()); }catch (Exception err) { // throw exception trans.Rollback(); lblStatus.Text = "An error has occurred in the delete process. Please try again."; } } Here is the stored procedure:ALTER PROCEDURE [dbo].[spRemoveCompany] @Userid uniqueidentifier OUTPUT, @BusinessID uniqueidentifier OUTPUT ASDELETE FROM Associations2 WHERE Userid = @Userid AND BusinessID = @BusinessID RETURN
View Replies !
View Related
Help, Database Deleted When Restoring
Hi Have a problem restoring a largish 6Gb database onto a SQL7 server using Veritas Backup Exec or Disk file. Using the Force restore option in both Backup Exec and Enterprise manager, the database in question is instantly removed once the OK button is pressed. The restore continues seemingly unaffected until it completes with either a Backup Exec error "Connection to the restore target has been lost." or Enterprise Manager "Cannot Restore Database When Model is in Use" or a "Restore failed, try using Move option" or others. The same backups tapes and disk files have worked seamlessly when used other servers. Any ideas?
View Replies !
View Related
Default Database Deleted
Dear All, i'm using sql server 2005. I've one default database named testdb. unexpectedly that was deleted. now i was unable to connect to the server. what is the solution for this Vinod Even you learn 1%, Learn it with 100% confidence.
View Replies !
View Related
Recover A Deleted SQL Express Database
One of my SQL Express databases was deleted by mistake through MS SQL Server Management Studio Express. It is not in the Recycle Bin and I have tried to use a tool such a Active@ Undelete to recover the file but it cannot find the deleted file. I have a backup file *.bak in the ....MSSQLBackup folder I made using MS SQL Server Management Studio Express. When I try to use the restore database feature in SSMSE I get various errors. Any Suggestions on how to recover the deleted file or Any suggestions or documentation on using the restore feature in SSMSE? Any help at all? Thanks George
View Replies !
View Related
Deleted My Database Log File, Can't Reattach
Hello,A utility I was running caused our database's log file to run out ofhard drive.So, I detached the database, deleted the log file, and tried toreattach.SQL server fails to reattach because it cant find the log file. (Whyit cant just create a new default one is beyond me...but...)EXEC sp_attach_single_file_db @dbname = 'sgvault',@physname = 'c:Program FilesMicrosoft SQLServerMSSQLDatasgvault.mdf''Could not open new database 'sgvault'. CREATE DATABASE is aborted.Device activation error. The physical file name 'C:ProgramFilesMicrosoft SQL ServerMSSQLdatasgvault_log.LDF' may beincorrect.Do you know how I can fix this dilemma? Thanks!
View Replies !
View Related
Purging Deleted Database Names
When connecting to an SQL Server (v7 in this case) the log file shows that old and deleted databases are still being opened as part of the process. Further, these db names are now reserved and cannot be reused, even thought I've deleted them. Is there any way I can purge all traces of these deleted db names? You might have guessed, I'm a newbie, which is why there are a few dozen deleted DBs. Thanks for any help Max atomax@gmx.net
View Replies !
View Related
How Do I Clean Up Database Deleted By ClickOnce With T-SQL?
I posted this in the SQL Server Express forum as well... My app deployed via ClickOnce. It ships with a database creation script which creates the database in the ClickOnce data directory. Upon uninstall, the entire data folder is deleted successfully. But if you then reinstall the app, SQL Server Express still thinks the database exists. Right now, to get a re-install to work, I have to go into Management Studio Express, click on the db (get an pop-up error as the physical db file is no longer there) and then click delete. So my question is... what system proc should I execute in the db creation script before I run the CREATE DATABASE command?
View Replies !
View Related
Physical Files Can Not Be Deleted After Database Detached
I have detached the database via sp_detach_db in a job, (I was trying to use a job to detach the database, then make copies of the mdf file, then attach the databases as different copies, somehow the job failed due to file locked) I tried to delete the physical files, but they were still locked. I tried several times, two of them I was able to delete the mdf files, but not the ldf file. The other one both mdf file and ldf file can not be deleted. I was not able to see the database via Management studio. Can anyone help? Thanks
View Replies !
View Related
Database Logfile In Sysfiles(mssql7)deleted
Accidently, I(we) deleted the Logfile.LDF in sysfiles folder on the mssql server and now can't enter the database, which status now is set SUSPECT. Before deleting the logfile I did a Transaction-Logfile Backup and there is maybe an older version of full database backup somewhere. Trying to restore database with enterprise manager, restoring from the Transaction Logfile Backup, enterprise manager tells me: 'The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence specifying WITH NORECOVERY or WITH STANDBY for all but the final step.Backup or restore operation terminating abnormally.' How to restore the database, I put two weeks of work in it... Please help, somebody. THX, Georg.
View Replies !
View Related
DataSet Rows Being Deleted, But After The Update , The Sql Database Is Not Updated. The Delete Rows Still In The Database.
Stepping thru the code with the debugger shows the dataset rows being deleted. After executing the code, and getting to the page presentation. Then I stop the debug and start the page creation process again ( Page_Load ). The database still has the original deleted dataset rows. Adding rows works, then updating works fine, but deleting rows, does not seem to work. The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet. cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId); rowCountDb = cDependChildDs._ClientDependentChild.Count; for (row = 0; row < rowCountDb; row++) { dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0]; dr_dependentChild.Delete(); //cDependChildDs._ClientDependentChild.Rows.RemoveAt(0); //cDependChildDs._ClientDependentChild.Rows.Remove(0); /* update the Client Process Table Adapter*/ // cDependChildTA.Update(cDependChildDs._ClientDependentChild); // cDependChildTA.Update(cDependChildDs._ClientDependentChild); } /* zero rows in the DataSet at this point */ /* update the Child Table Adapter */ cDependChildTA.Update(cDependChildDs._ClientDependentChild);
View Replies !
View Related
Retriving Position In A Field
Hi All. Is there a way to retrieve the position of a word, phrase or sign in a field? For example, Field content is ABCDEFG1239/1002STJ I would like to get the exact position of / which will be position 12. Thank you. Best regards
View Replies !
View Related
Retriving Data Fromsql Using Asp.net
every time i try to get data of a student stored in SQL server 2000 in the student table it gives me an error Login failed for user '???????????ASPNET' Exception Details: System.Data.SqlClient.SqlException: Login failed for user '??????????ASPNET'. works fine normally its only when i try to reteive actuall data stored on the server. theres obviously something wrong the server side. help help help
View Replies !
View Related
Retriving Data From Table In SQL CE
Hi I am trying to retrive data from table store in .sdf database file but not able to do it. where i will use select * from xyz in project. I am developing it on desktop using vc++ 2005 in SQL server compact edition. am using hr = pICmdText->Execute(NULL, IID_NULL, param, NULL, NULL); It is not easy for me to see data of table from sdf file so plz reply
View Replies !
View Related
Retriving Data From More Then Two Table
Baby writes "how to retrive data from four table four tables have same column number and name i am trying to retrive one column data from all the table i am trying these :- to get the result select mutual_fund.customer_id,insurance.customer_id,fixed_dep.customer_id,home_loan.customer_id from mutual_fund,insurance,fixed_dep,home_loan where (mutual_fund.customer_id=fixed_dep.customer_id and mutual_fund.customer_id=home_loan.customer_id and fixed_dep.customer_id=home_loan.customer_id) or (mutual_fund.customer_id=fixed_dep.customer_id and mutual_fund.customer_id=insurance.customer_id and fixed_dep.customer_id=insurance.customer_id) or (mutual_fund.customer_id=home_loan.customer_id and mutual_fund.customer_id=insurance.customer_id and home_loan.customer_id=insurance.customer_id) or (fixed_dep.customer_id=home_loan.customer_id and fixed_dep.customer_id=insurance.customer_id and home_loan.customer_id=insurance.customer_id) the comparision working in the query please help me tell me how to solve my problem"
View Replies !
View Related
Retriving Data From 2 Views By The Value In A Textbox
i have a textbox which a user enters a numeric value i want it to use SqlDataSource and check if the value exists in any of the tables. in my text box the users would enter starting from '100000' or '200000' i want it to check the view that starts the # with '100000' and 2ed view starts '200000' With this i can check in one of the tables and make the selection. <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:imacstestConnectionString %>" SelectCommand="SELECT [ReportNumber] FROM [AppraisalSummaryBlue] WHERE ([ReportNumber] = @ReportNumber)"> <SelectParameters> <asp:ControlParameter ControlID="txtReport" Name="ReportNumber" PropertyName="Text" Type="String" /> </SelectParameters> </asp:SqlDataSource> How can i make this possible ? i was thinking putting a second sqldatasource and have that check the second view but how can i make the textbox goto the correct selectcommand ?
View Replies !
View Related
Retriving An Xml String Stored In Varchar(max)
I try to retrive an xml portion (<points><point><x>1</x></point></points>) stored in a varchar(max) column, this is my code dr = cmd.ExecuteReader(); _xmlFile = dr.GetSqlString(dr.GetOrdinal("XmlJoin")).ToString(); Label1.Text = _xmlFile; and this is what I get "12"Maybe I missed something to get the whole XML String
View Replies !
View Related
Retriving Data From SQL Text Field
I have a text column in my db which stores more than 8000 characters. When I retrieve the values from the column in query analyzer (I have set the output buffer to 8000), it only shows me first 8000 chars only. How do I display all the text from the text field?
View Replies !
View Related
Retriving Latest Job From Msdb..sysjobhistory
Hi, Can any one suggest me how to retrieve most recent job from msdb..sysjobhistory table? I want to supply the job name which has more than 1 steps. Step 1 or more is already completed ( success/failure) and in the last step I am trying to retrieve sysjobhistory.messages(success/failure) stored in the sysjobhistory table for the steps already executed. I want the records related with last/current job executed. Thanks.
View Replies !
View Related
Error Retriving Backup Filelistonly
Hi Guys. i have write a store procedure which take few input and then backup the database and at the same time it's restore the database with new name, but i m hving a error code. what this program do in restore section, it's read the backup file and all give me list of all the file with the location and then i can rename them. actually the purpose of doing this is to create a new database on behalf of old database. plz have alook code PLZ, PLZ help me, it's really geting headach USE [master] GO /****** Object: StoredProcedure [dbo].[CreateNewDB] Script Date: 01/28/2008 17:13:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[CreateNewDB] @ActualDb varchar(128), @dbname sysname , @recipients varchar(128) AS SET NOCOUNT ON Declare @cmd sysname , @filename varchar(128) , @Backuppath varchar(1000), @LogicalName varchar(2000), @ActualPath varchar(2000), @Aloop int, @FileID int, @sql nvarchar(4000) SET @Backuppath = 'C:' + @dbname -- TAKE BACKUP BACKUP DATABASE @ActualDb TO DISK = @Backuppath WITH NOFORMAT, INIT, NAME = 'DBBackup-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 -- Get files in backup select @cmd = 'restore filelistonly from disk = ''' + @Backuppath + '''' CREATE table #RestoreFileListOnly ( LogicalName sysname, PhysicalName sysname, type char(1), FileGroupName sysname, [size] bigint, [MaxSize] bigint, FileID int ) INSERT into #RestoreFileListOnly exec(@cmd) -- buld the restore command set @Aloop=1 set @FileID=0 set @sql= '' set @sql = @sql + 'RESTORE DATABASE ' + @dbname + CHAR(10) set @sql = @sql + ' FROM DISK = ''' + @Backuppath + '''' + CHAR(10) set @sql= @sql + ' WITH FILE = 1' + CHAR(10) WHILE (@aloop <= @@ROWCOUNT) BEGIN SELECT @LogicalName = LogicalName , @FileID = FileID, @ActualPath = Left(PhysicalName, len(PhysicalName)-charindex('',reverse(PhysicalName))+1) FROM #RestoreFileListOnly WHERE FILEID > @FileID SET @sql= @sql + ',' + CHAR(10) SET @sql= @sql + CHAR(9) + 'MOVE''' + @LogicalName + '''TO''' + @ActualPath + '''' + @dbname + '''' -- @sql= @sql + 'MOVE '''+ + '' TO N'C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDATAMALIK.mdf' SET @Aloop=@Aloop+1 END SET @sql = @sql + ', NOUNLOAD, STATS = 10' -- Restore the database print @sql EXEC (@sql) Drop table #RestoreFileListOnly -- send email to the define person. EXEC master..xp_sendmail @subject = @cmd, @recipients = @recipients, @message = @@servername ERROR: Msg 213, Level 16, State 7, Line 1 Insert Error: Column name or number of supplied values does not match table definition. Msg 3013, Level 16, State 1, Line 1 RESTORE FILELIST is terminating abnormally.
View Replies !
View Related
Retriving Duplicate Records From The Table
Hello, I need some help on this. I want to retrieve all the duplicate records from a particulat column. For eg suppose i have a table named testtable columns in the table : item_id,ref_no,title,address now i need to check if there are any duplicate entries in the ref_no column and if there are any retrieve the records. Gaurish Salunke Software Developer OPSPL
View Replies !
View Related
|
TRACKER
