Nice article.

Are there any new format options that go along with the new data types?

So when we currently say Convert(varchar,DATETIME,112) are there new options for

Convert(varchar,TIME,xxx)? I'm sure there must...

Nice article.  I particularly liked the showcasing of the usefullness of the new ROW_NUMBER() function in SQL Server 2005.  I typically stick to developing on the SQL Server side and...

I agree that the problem lies with the query plans sql server is generating.  Does the stored proc have input variables that need to be passed at run time?  Are...

well..before I start a revolt.  Those were things I heard from someone you is very plugged in to Microsoft and gets to see the early ideas.  The final result may...

pretty much anything that is an ActiveX task will be a problem.  Like Michael said, the DTS to SSIS migration won't be of much use.  It really only works well...

OK, thanks.  In a previous reply, you said you tried setting the owner to sa and received a similar error?  Could you post the exact error?  ...  reason being, it...

the sp_change_users_login procedure is only used for SQL server Logins.  When dealing with Windows Authentication, the SIDs assigned to a Domain user are set at the domain controller, so you...

In the interest of just getting it running, you may want to just change the job owner to <sa> and see if that allows the job to run.  Also, did...

oh, I see Julie already covered that one.  Sorry for being redundant.

somewhere rattling around in the back of my head..comes the fact that you cannot run the installer via an RDP session or something of the sorts.  You get that message...

Can you post the query, or an approximation, including the where clause an order by, if there is one?  Also, could you post the create script of the Index?  I'm...

Something else that I've noticed in 2005 vs. 2000 is the optimizer in 2005 appears to try to avoid a sort operation in the query plan at any cost.  This...

Great article.  It's nice to see some basic new features every once in a while.

Unfortunately, I presume that the fault of an all or nothing backup will make this too...

You could just rename your new server to match the old one ...  just kidding!

I agree with Michael Earl, that the best quick solution is either an alias to the...

You will need to update the link to the Sql Table in Access after adding the PK to the table.