There is also the extended stored procedure xp_fileexist. Want to learn more, google or bing xp_fileexist.

bullo (4/3/2012)

---

Thank you all. I knew it was goona be a difficult post....I think that in order to pinpoint a problem there are things that should be taken for granted....

Lowell (4/3/2012)

---

ricardo.cuevas (4/3/2012)

---

Greetings. Long time lurker first time poster. BTW I love this site. Very professional and educational. I'm looking to find orphan records on a...

Evil Kraig F (4/3/2012)

---

Lynn Pettis (4/3/2012)

---

Not you either, but I just saw...

capn.hector (4/3/2012)

---

lukebaker (4/3/2012)

---

SOLVED!!

I have reformated the dates in my table and used the below query and it worked 🙂

SELECT *

FROM v_stafftrainingDetails

WHERE (expiry_Date >= DATEADD(dd,...

aliskumardba (4/3/2012)

---

So what to do then? I am using SQL server 2008r2 Standard edition on PROD server. I can't block users while I am defragmenting indexes. Is there any option...

GilaMonster (4/3/2012)

---

Lynn Pettis (4/3/2012)

---

Take a t-log backup, restore the last full backup to another server, then load all t-log backups using the STOPAT clause on the last t-log to recover...

In your sample data, I see no dates in expiry_date that are between today and 60 days from now.

Not you either, but I just saw another who should be kept...

Updated code:

ALTER PROCEDURE InsertResource

(

@ResourceName nvarchar(256),

@Description nvarchar(256),

@DirectoryPathToFile nvarchar(256),

@UploadDate datetime2(7),

@resourcestatus nvarchar(256),

@Username nvarchar(256)

)

AS

BEGIN

declare @FileType nvarchar(max),

@FileName nvarchar(max),

...

No.

DBA_SQL (4/3/2012)

---

The data has got deleted with in the time log as mentioned earlier (20 mins) interval. TX log has not backed up. So, how can we get back the...

IGNORE, I need to make a few more changes.

Here is my rewrite:

ALTER PROCEDURE InsertResource

(

@ResourceName nvarchar(256),

@Description nvarchar(256),

@DirectoryPathToFile nvarchar(256),

@UploadDate datetime2(7),

@resourcestatus nvarchar(256),

@Username nvarchar(256)

)

AS

BEGIN

declare @FileType nvarchar(max),

...

Again, please read and follow the instructions provided in the first article I reference below in my signature block regarding asking for help. ...

D-SQL (4/3/2012)

---

Yes that is correct one column in the index. This should have been set these way before. We are changing a few thinks to use RANK and it's going...