It isn't necessary to post in more than one forum. It just duplicates effort for those helping and fragments any answers you get.

Direct replies to http://www.sqlservercentral.com/Forums/Topic1579175-148-1.aspx

Or maybe the DBAs looking at the editorial agree so completely that there's nothing more to say. I myself sometimes wonder if the SAN administrators get a bonus for...

Minnu (6/10/2014)

---

Hi team,

created a job to delete all the records from table 'Unify 'daily. i want the same job to take the backup of table before deleting the records.

Is it...

zedtec (6/10/2014)

---

Ok I will check that thanks.

I have also tried to restore by adding my .bak file onto a folder on the C drive locally.

When I try to do a...

Klingon

I learned something new today, so thanks for the question.

GilaMonster (6/9/2014)

---

Ed Wagner (6/9/2014)

---

Backing it up will also mark the pages in the transaction log as backed up, so they'll be available for reuse. That means it won't have...

I don't know this for sure, but if you're selecting p.subjectnumber, it looks to me like that's the patient number and you want a total per patient. If you...

I don't see what the problem is either. Perhaps you could explain what you mean.

However, I did notice that you're comparing a varchar column against an nvarchar value. ...

Castle

Page

If the load needs to be repeated, I've always found a stored procedure that uses bulk insert to be very reliable. Create your format file and your staging table...

You need to put your return statement in an IF, not in a SELECT. Example:

IF @isExist = 'No'

RETURN;

I have to ask why you have a database that hasn't been backed up in 2 years. I don't know what you mean by it being "stand alone", but...

I think the answer bothers me more than the question being repeated.