The two links given above by Gail are exactly what you need at this point of time. Go through those links, they will help you to get the queries that...

greeshma.patla (8/28/2012)

---

Hi ,

I Dont have .mdf and .ldf files tooo 🙁

I have only Transaction Log file and Data File

Is it possible to restore db ?

Please help...

Very nicely written. Thanks for sharing 🙂

Make sure that sharing permissions have been set correctly...

Just remember that shrinking will cause the indexes to be fragmented. Therefore rebuilding the indexes will be required after shrinking has been done.

santhosh411 (8/27/2012)

---

I was trying to take the backup from GUI

When i selected the path the error i am getting is "can not verify the existence of the backup location do...

runal_jagtap (8/27/2012)

---

Thanks Gila & Divine 🙂

Will try out the steps but what should i be ready with apart from the steps???

I have got system with Enterprise edition & two servers...

runal_jagtap (8/27/2012)

---

I am New to the Log Shipping & DataBase Mirroring, unfortunately i am asked to perform this by Client 🙁

an any one help me as to how should i...

Sachin Butala-182900 (8/27/2012)

---

Hi,

If we keep SQL 2005 as primary and 2008 as secondry :-

The databases don't get upgraded along the way. The upgrade doesn't occur until the database is recovered....

Nice question! thanks.

sam.dahl (8/26/2012)

---

Secondly, I would have been wrong in any case because I tested this in SQL Server 2012 (since no version was specified I considered this valid):...

You can do it using CTE also.

--========= Student table

IF OBJECT_ID('tempdb..#Student') IS NOT NULL

BEGIN

DROP TABLE #Student

END

GO

CREATE TABLE #Student

(

StudID VARCHAR(100),

RollNo VARCHAR(100)

)

GO

INSERT INTO #Student VALUES('Alpha', 'D1234')

INSERT INTO #Student VALUES('beta', 'A1122')

INSERT INTO #Student VALUES('charlie',...

You can do this using the PIVOT table feature of SQL Server. Read more here.

For your problem:

IF OBJECT_ID ('tempdb..#CrimeDetails') IS NOT NULL

BEGIN

DROP TABLE #CrimeDetails

END

GO

CREATE TABLE #CrimeDetails

(

ID INT,

Category VARCHAR(100),

CrimeDate DATETIME

)

GO

INSERT INTO...

Thanks for the nice, easy question to start the friday :-)!!

Nice question! Thanks 🙂

Nice question :-). Thanks.