Doing a quick google search on the subject you provided returned numerous links.  Perhaps that could help.  The first link I clicked on spoke of more information that was in...

David,

Earlier, you stated: "We use partitioned views as wrappers that hold the last 14 days as individual tables, as well as the last 100 or so weeks before that, in...

BOL

Syntax for CAST:

CAST ( expression AS data_type [ (length ) ])

Jeff,

I have never really looked that deeply into what the model is, but I thought the model was really nothing more than the base shell of any new db.  All...

Are you looking for the default db location for a new DB?  or, for an existing db?

For a new db, it uses model, so, this would work:

use

...

I agree.  D.

I use Diagnostic Manager (DM), honestly, I had never heard of TeraTrax, I may need to check that out.  That said, I cannot give an objective comparison of the two,...

Yeah - I was just about to reply that I had no issues with the SQL you had, then I saw MePoleCat's response, and confirmed the error:

create

...

what is the error message? 

Idera has a whole suite of products...and I have been looking at quite a few of them.  This one, when I need it, hands down, I would buy it again...now,...

First and foremost, I want to say, I am a DBA.  Can someone tell me why this is getting popular?  I read Steve Jones' article, and this one, and I...

I have seen this many times.  Someone please correct me if I am wrong, but here is how I understand this - SQL Server will, out of the box, take...

I would be curious to know how this ends up.  Please keep us informed!

Thanks SQLBill,

There was no corporate firewall between these domains, I was never really able to find out if windows 2003 had some sort of firewall or not that could have...

I was trying to recall that just today.  I cannot recall if it got fixed, or we worked around it.  Either way, right now, it is no longer an issue. ...