J.K (3/25/2009)

---

And now i just want to check which all queries i had executed the very last day.I mean i want to know which all queries i had executed for...

I take people...

I used to read while driving to work. 😀

I used to have...

angels4kali (3/24/2009)

---

For that matter, all my databases, including those that weren't dropped think they had a full backup taken on 3/15 and none of the full backup files exist

Any idea...

Try typing the restore command manually. I seem to recall running into an issue with Copy-only and the GUI restore window.

We...

balbirsinghsodhi (3/24/2009)

---

Actually, this is the stored procedure I ran every night and stored in the Missing_Indexes table. In the table , I check the column called Overall_Impact, if the this...

Still need the sample data.

Looks OK. The only thing I'd change is that if statement. If there's an update that sets some usernames to null and others to a non-null value, the IF may...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

RBarryYoung (3/24/2009)

---

It's like the old joke:

Q: How many psychiatrists does it take to change a light bulb?

A: Only one. But it takes a very long time and the light...

Lookup the RIGHT function in Books Online. To get the results you want, you may need to combine it with LEN to get all the string except the first two...

By doing that you're telling SQL that is is one backup striped across two files, which it is not.

Select restore,...

foxjazz (3/24/2009)

---

I have an idea on how this could be done.

Create 2 new tables with an identity, insert the records and join on identity.

But I don't think that is a...

Please post 2005-related questions in the 2005 forums in the future. I'm not asking to be pedantic. I'm asking...