Viewing 15 posts - 46 through 60 (of 789 total)
Senthil Varadharajan (10/19/2010)
While running the update statement, missed to select the where condition. So i need to restore data using the transaction logs. Can i know the process to...
October 19, 2010 at 9:23 am
Can you describe your problem more what happened and what are you trying to do ...!!! However if you have backup you can restore it ...!
October 19, 2010 at 5:50 am
Well you are going to create table where you will save the deleted records;
CREATE TABLE DELTAB
(
id VARCHAR(100),
part_number VARCHAR(100),
erial_no VARCHAR(20),
good_qty INT,
bad_qty INT,
locationname VARCHAR(20),
employeeno VARCHAR(20),
createdby VARCHAR(50),
creationdate DATETIME,
lastupdatedby VARCHAR(50),
lastupdatedate DATETIME,
lastupdatelogin VARCHAR(50),
downloadstatusflag VARCHAR(50),
downloadby VARCHAR(50),
downloaddate...
October 19, 2010 at 5:31 am
Tell us table definition and we can provide with the exact trigger ...!
Or if it is not allow to post you tab definition, you can try something like this:
CREATE THE...
October 19, 2010 at 2:44 am
Proud to be part of this great SQL Community ... Congrats and wish you (contributors) all the best ...!
October 7, 2010 at 12:00 pm
pshaship (9/27/2010)
What is the difference between the results displayed by sys.objects & sys.all_objects
I have executed the below in AdventureWorks database:
select * from sys.objects -->Returns 575 row(s)
select * from sys.all_objects-->...
September 27, 2010 at 5:24 pm
MudLuck (9/22/2010)
...Trying the idera tool now to see what type of tact that took to solve the problem..
Let us know if you succeed with Idera tool!?
September 22, 2010 at 2:25 pm
You can check for some info here ...>>> http://tinyurl.com/2u73lwf
September 7, 2010 at 5:21 pm
zawhtway (8/21/2010)
Hi,I wanna retrieve records for today. But not working?
Any idea?
select freedate from holidays where freedate = (getdate())
how can I retrieve for specific date?
rgds,
zhtway
You can do it like this:
SET DATEFORMAT...
August 21, 2010 at 3:24 am
scott.pletcher (8/5/2010)
When you look at the output of version, you see that the first four consecutive digits in the...
August 5, 2010 at 4:27 pm
AndrewSQLDBA (8/5/2010)
Yes, I think it is really Great. I would have never thought to use it, that is why I asked on here.Very nice script
Thank You again
Andrew SQLDBA
This is the...
August 5, 2010 at 4:24 pm
scott.pletcher (8/5/2010)
SELECT SUBSTRING(@@VERSION, PATINDEX('%[0-9][0-9][0-9][0-9]%', @@VERSION), 4)
That's great!!! - really!
Can you explain little bit, how you find the idea, to use PATINDEX like this in your very nice & simple script...
August 5, 2010 at 4:15 pm
I vote for both, salary & positive feedback!
I think some of you (DBAs) do not have idea how you will feel yourself if you as a very good DBA...
August 5, 2010 at 3:40 pm
premkuttan.lakshmanan (8/4/2010)
virus update is happening daily so i think there should be some other issue.....even in error log file there is no entry for this
It can be something corrupted at...
August 4, 2010 at 5:33 am
Viewing 15 posts - 46 through 60 (of 789 total)