Did you try logging on using Windows Authentication?

Before we even started the upgrading our DBs to SQL 2005, we did a dry run in our QA. There we found out that the application does not work. This...

I tried couple of experiments. I tried to cast it as Char. You will get results if you do a Like operation on the first digit. Example Like '8%' will...

You can use Dynamic SQL.

Yes, We have had the issue. And still have it unfortunately. So we are redoing the third party app In house thast works in SQL 2005 mode.

As per BOL, a user requires Schema Alter permission along with either CONTROL permission on the Tables or Db_DDLAdmin role. Can you double check if you have given the user...

We have had this issue when the profiler stops collecting accurate data. It looses the stats on some columns. What we used to do was to restart the server when...

Glad I could be of help

You should give execute permission to the stored Proc that the new user is trying to execute.

Do you have any tool for compressed back ups? Litespeed 2005 from Quest is pretty good for compressed DB back ups.

I hate it when programmers goes behind the back of DBA to get permission on DB's.

What you were doing might also work. But you will need to give two additional...

Only members of the sysadmin fixed server role can create jobs. That would mean that the user that has been granted access to create Jobs can do anything on the...

The Advisor will tell you what are the issues that you might face. Advisor will not upgrade the SQL engine to 2005.

The best way to do it would be...

Steve Jones - Editor (1/11/2008)

---

Best thing I could recommend is to use the Upgrade Advisor. I know there's not usually a lot of work done to move from 2 versions...

As per BOL..

When Database Engine Tuning Advisor creates recommendations, it automatically creates names for the objects that it recommends. These objects are indexes, indexed views, statistics, partition functions, or partition...