John Mitchell-245523 (1/9/2013)

---

The your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:

SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME...

No, it is not giving me...

Hi,

Again found a new term as 'Table Fragmentation'. Now this term makes sense to me , because consider one table having clustered index on one column. The content of...

yup :w00t: It was Data File Fragmentation. Can you please refer me some resource which can give me practical & theoretical knowledge about Data File Fragmentation wrt SQL Server.

Hi Lavanya,

Did the above mention code solved your Problem or are you still facing it?

Chandan,

Would like to know what did you did in this scenario?

Abu Dina (12/21/2012)

---

When I script out a stored procedure in SSMS, the SET QUOTED_IDENTIFIER ON is placed above the Stored procedure declaration. So I'm wondering, are you sure you're including...

Al right .But they are totally different object . I mean to say one is a table and another SP. So that means you are saying that i cannot give...

anthony.green (12/10/2012)

---

You could check the default trace, but that only keeps so much information before it is lost, so highly unlikely that it will be in the trace.

Again custom auditing...

anthony.green (12/10/2012)

---

As you dont have custom auditing in place, finding historic updates/deletes will not be possible.

Look at building custom auditing procedures on the tables you require to know who updated...

Do you have custom auditing in place?. I am not...

Sean Lange (12/4/2012)

---

Shadab Shah (12/4/2012)

---

anthony.green (12/4/2012)

---

GO is a batch sperator.

So you could say

Do Something

Do Something Else

Do Something More

GO

Do Something Even More

Do Something Better Than Before

GO

And it would execute the first...

anthony.green (12/4/2012)

---

GO is a batch sperator.

So you could say

Do Something

Do Something Else

Do Something More

GO

Do Something Even More

Do Something Better Than Before

GO

And it would execute the first three things in one...

Chris Harshman (11/30/2012)

---

Have you looked at the execution plan of the query to see what part seems to be a bottleneck? It could be possible that an index that...

Eugene Elutin (11/30/2012)

---

Shadab Shah (11/30/2012)

---

This has being a common observation since last few days. The server through which i am connected is taking long time to respond like long time...