Remember that system DBCC commands are checking the system for structural consistancy.  It could care less about the meaning of the data, it just wants the physical structure that holds...

Jersey:

Hmmm.  Here's the curious thing: I don't get the correct physical order when I run it!  Here's a result:

-----------------------------------------

8.0

36

------------------------------------------------------------------------------------

36      SQLCHAR       0      ...

Grrr.  Thanks for pointing out my ritual idiocy.   I have a lot of fun here at work, occasionally letting out a "What a...

ANSI_PADDING is a server configuration value.  In Enterprise Manager, right click on the server, select Properties.  Click on the Connections tab.  You'll see 'ANSI padding' in the list that comes...

(weird, the system just deleted PART of my post!)

If your data is not consistent, it's either going to have to be cleaned up so that it is or you're going...

What exactly are you trying to do?  If you want the view turned into a proc, then you might want to use the WITH RECOMPILE option, here's what BOL says:...

Just a thought, but it struck me that the difference between Consistency Check and Concole Command could possibly be significant in a certification exam.  I would really hate to miss...

Jersey, I myself love working with base tables, but would it be easier to use the metadata reference in INFORMATION_SCHEMA.COLUMNS?  I'm developing an Access app to work as sort of...

Personally I don't like maintenance plans because I want detailed results back.  I use isql and a batch file to do maintenance every night, the batch file does the following...

There are two problems with off-shoring (ok, slightly OT, but related, and as the topic is wandering back and forth I think I'm safe).  First, there is...

(As a side note to my previous post, as a consultant I do get health/dental benefits, but that’s it.)

I fully agree...

Jamie Thomson asked: "What do US workers get in terms of public holidays?"

How about zero.

I'm consulting right now, 3 months with a probability of renewing (said 3 months is up...

Yep, first computer I worked on was 110 baud acoustic coupled, IIRC.  It was later upgraded to 300 baud.  The first computer that I owned was a TRS-80 Model 100...

For myself, in my last job at a major installation I was both DBA and one of the three sysadmins.  I had two PCs with a KVM switch, one was...

Well, I had a very bad suggestion, but since this is going to be a web app it is utterly non-viable.   Trust me,...