Mad-Dog (2/6/2010)

---

CirquedeSQLeil (2/5/2010)

---

Your regional settings determine the date format. However, that is why there are standards that many use to format the datestamp in a common format for servers...

Don't be too sure about that (evil chuckle)!!

The Dixie Flatline (2/6/2010)

---

... My impression is also that people don't click on signature links very much. An article would stand a much greater chance of being...

Ouch.

Hope you...

I typically use 13 and 111 in order to perform transcontinental 1TB database transfers to SQL Server VMs.

I am still working on integrating flag 138 to properly initialize the database...

This is rather simplistic.

Select pav.ProductAttributeValueID,pc.CategoryName, pca.ProductCategoryAttributeName,pav.AttributeValue

From ProductAttributeValue pav

Inner Join ProductCategoryAttribute pca

On pca.productcategoryattributeid = pav.productcategoryattributeid

Inner Join ProductCategory pc

On pc.ProductCategoryID = pca.ProductCategoryID

The answer to that question is: It Depends.

You will more than likely need numerous queries to support the various different aspects of your application. Some queries should require...

Knowing what the errors were would be good. Defining the table is a definite good method to perform this. It certainly simplifies the query and could make it...

WayneS (2/5/2010)

---

The Dixie Flatline (2/5/2010)

---

I loved the touch of Ella, bb.

Wayne, and anyone else, I've taken the liberty of creating a forum specifically for DBCC TIMEWARP here.

"SSC ... it's not...

It's new in 2008 R2D2.

Until you upgrade to that version, you must provide the minimum of 137 parameters. It is also highly recommended to use some of the 255...

innoculate

ennunciate

Chad Crawford (2/5/2010)

---

Maybe we could turn this into an April Fool question of the day.

Which of these methods can be used to restore a damaged database to the state...

Jack Corbett (2/5/2010)

---

Alvin Ramard (2/5/2010)

---

The Dixie Flatline (2/5/2010)

---

I am sending a rock to St. Lynn, who can cast the first stone at Alvin, before a Threadinator is sent from the...

That is a nice find.

Thanks Max