Have you checked on the Quest site for information regarding the error? You might find more information there.

John Hardin (12/30/2012)

---

L' Eomot Inversé (12/30/2012)

---

Jeff Moden (12/28/2012)

---

If you look at the execution plan, it doesn't actually use the "same list". CTEs have some wonderful advantages but they also...

To repeat:

GilaMonster (12/26/2012)

---

zi (12/26/2012)

---

1-1-How to know the fragmentation...

It is a permissions issue. You will need to check the permissions of the file on your system and resolve it such...

Looks like a permissions issue on the mdf file.

sanandh87 (12/30/2012)

---

I have tried to with ldf file also. I got the same issue.

Below the steps i followed to restore the database from disc.

step 1 : Logging sql server

step 2:...

You are trying to restore the mdf file. You need to attach the file to your server such that it recreates the ldf file. Not sure how you...

TryingToLearn (12/29/2012)

---

I now need to turn this into a insert statement, calls_key a the primary key and i'm getting a new error on that issue. Can you help on that?

Thank...

I would say something like this should work. I don't have a linked server of any kind on my system so I can't test it:

SELECT

dept = e.dept,

fname = e.fname,

lname...

TryingToLearn (12/29/2012)

---

i am querying a MySql view for data, but need to join to a sql table for three additional fields.

SET IDENTITY_INSERT CALLSNEW ON

INSERT INTO [cas].[dbo].[CALLSNEW]

...

John Mitchell-245523 (12/28/2012)

---

CELKO (12/28/2012)

---

Here is atrick weith a calendar table.

CREATE TABLE Calendar

(cal_date DATE NOT NULL PRIMARY KEY,

julian_business_nbr INTEGER NOT NULL,

...);

INSERT INTO Calendar

VALUES ('2007-04-05', 42),...

Dirk vd Watt (12/28/2012)

---

Hi,

Can you please test your new functions' performance against the following function :

CREATE FUNCTION [dbo].[ParseString]

(

@String VarChar(8000),

@Delimiter VarChar(1)

) RETURNS TABLE

AS

RETURN

(

...

smthembu (12/21/2012)

---

Hi All

I need assistance with the below, attached pic is the table structure column (Client_User_Agent) I need to split data so that I can have the browser used and...

Upgrading my SQL Server 2008 R2 Developer Edition to SQL Server 2012 Developer Edition. Finally purchaesed a copy on Amazon.com and just got it today in the mail.

toddasd (12/27/2012)

---

Speak for yourself. You let...