Testing....

Using an inequality character

SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using escape codes for inequality

SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using angle brackets to designate a placeholder

USE <Database Name>

Using...

Please don't cross post. I'm dealing with your corruption problem in the other thread you started

No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic800236-5-1.aspx

Did the corruption happen at 12:56 or did you detect it at...

First, read this. http://www.sqlservercentral.com/articles/65804/

Second, run the following code, post the full results here.

DBCC CHECKDB ({Database Name}) WITH NO_INFOMSGS, ALL_ERRORMSGS

Do you have a clean backup? One that doesn't have the corruption...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic800194-360-1.aspx

ItalianOlgi (10/8/2009)

---

I am not sayign I will be lazy and just occupy space waiting to lose job! When some problem happen,I will do my best to resolve, find answers in...

GSquared (10/8/2009)

---

And, honestly, it's way more than I'd expect from most people in the US. Our "education" system is so weak that most don't know how to find answers,...

I'm consulting these days. If you'd asked that a year ago, the answer would have been yes. Providing you...

GSquared (10/8/2009)

---

On the other hand, I'd consider it a positive if it started with, "I haven't had to do that, so I'm not sure, but what I'd start with is...

Al-279884 (10/8/2009)

---

that is the table declaration as a parameter, not as a variable within your current session. The idea is that sp_executesql opens up a new session and runs a...

Table variables are only visible in the scope that they are created in. They are not visible inside dynamic SQL.

Only valid reason for multiple log files is space. If the drive that the log is on has...

Shark Energy (10/8/2009)

---

I struggle to read the results of that because I get all the data, I summarise it all, but I don't know what it means. internet articles tend...

Change in architecture. It was a major change SQL 2000 - SQL 2005

Most...

Silverfox (10/8/2009)

---

it looks like it just resized back to the free space in the log file and done nothing with the 2nd log file. if that is the case, then...