Viewing 15 posts - 1 through 15 (of 17 total)
Hi,
Done.
Many Thanks to GilaMonster and also to all member who replies and try for my question.
Thanks
Pratik Asthana
August 27, 2010 at 2:42 am
Hi,
let me explain my situation in detail.
I have one old backup file name called "MyDBBackup.Bak" . now i want to know on which date i had taken backup of Database...
August 27, 2010 at 12:50 am
Thanks for Reply.
this option i have and i know it .
is there any other option or tool to show backup date .
August 27, 2010 at 12:12 am
Hi,
Many thanks for reply.
this query is new for my knowledge.
but this query not solve my problem yet ,actually i have problem that i have backup file on my local hard...
August 26, 2010 at 11:35 pm
Hi,
Thanks for reply
create procedure aa
as
begin
if exists (select * from sys.objects where name='bb')
begin
...
August 17, 2010 at 5:57 am
Hi,
Thanks for Reply.
I want to hide update information about stored procedure from the user.
August 13, 2010 at 4:47 am
Hi ,
Thanks for reply.
I just want to delete entry from sys.objects table in sql server 205 or if sql server 205 not allow delete on sys.objects table ,can i update...
August 13, 2010 at 2:52 am
Hi,
Can u delete two duplicate row using row_number function
if yes ,please let me know
April 12, 2010 at 1:33 am
Hi,
2 is the variable only.
u can set any value there like 1 ,3 etc as per your requirement.
April 12, 2010 at 1:01 am
Hi,
select * from tempdb.dbo.sysobjects where name=<Table Name>"
That statement will check the existance of temp table in temp database if it is exists in temp db it will not create the...
April 12, 2010 at 12:59 am
Hi,
2 is the variable ,u can set as your requirement.
u can set it to 3 or 1 also as your requirement.
April 12, 2010 at 12:06 am
Hi,
How can u say it irrelevant .
don`t be in over confidence and smart Mr. SSCertifiable
April 12, 2010 at 12:04 am
Hi ,
Did u try it Mr. SSCertifiable ?
April 12, 2010 at 12:00 am
Hi,
Use
set rowcount 2
for delete top 2 rows of matching criteria
April 9, 2010 at 5:59 am
Hi,
Use can use this statement to stop occuring of temp table creation/deletion
select * from tempdb.dbo.sysobjects where name=<Table Name>
April 9, 2010 at 5:53 am
Viewing 15 posts - 1 through 15 (of 17 total)