Hi Matt - Yet another, Me too, please!

I'm new to the project world. At my last job, someone would say 'let's do this' and we just did it. ...

Ads generate revenue which then allow us to access this site for free. I gave up on the sqlmag.com site a long time ago, because everytime I tried to...

FYI: My databases are in Simple mode. This will only work if you only have one log file.

I detach the database, rename the log file to...

I don't notice issues and we do this all day, everyday.

Is the count(a.api)>1 and/or count(b.api)>1? If there are 'duplicates' you are having to generate more rows than...

I'm glad that I could help a bit. I get so much from this site that it is nice to find an opportunity to help others out a bit!

In my opinion, 70-431 is the first step in the new cert and not the equivalent of the MCDBA. After the MCTS, you then specialize by following one of...

They were probably thinking there were dupes and wanted only a distinct list. (I have a bunch of Access users that are trying to write T-SQL and they do...

IMHO -

If the reason for certification is for you and your possible future endeavors, I would certify in 2005. If your current company is using 2000 and will...

Take a look at the datediff function in Books Online...I think that will do what you need.

Prometric has started mailing results. Unfortunately, I have more studying ahead. Loner, I will go to http://learning.microsoft.com and use the free sql e-learning classes.

Also, pull down the objectives...

I use:

sp_changeobjectowner '[domain\user].objectname' , 'dbo'

Looking in Enterprise Manager, should tell you what objects are owned by whom.

Did you leave the filegroup as primary? If not, it won't fill the ndf files.

What does HSM stand for?

I have a hard time waiting. I always hunted for my christmas/birthday presents early too.

Thanks!

Also search Books Online for sp_makewebtask