Did you check if the SP is doing a recompile everytime it is running? Did you by any chance try to force it to recompile after updating the statistics? Maybe...

Cant you use Dynamic SQL? Create the string with your Select statement based upon the criterea and the execute it?

Please check for SQL Injection if you plan to use dynamic...

This is probably because there are still active connections to the DB that you are replacing with the new Back up. Check if there are Jobs running. You could stop...

When you do the select in the Sp, you just have to give a ISNULL. That should work

Select isNULL(dateColumn,getdate()) , col2 from table1

where ....

You can add this option while creating the Login. CHECK_EXPIRATION ={ ON }

Keep in mind that it is applicable only to SQL Logins and on Windows Server 2003 and...

There would never be any problem if you enumerate columns when ever you do an Insert or a Select.

We did a good thing at our company. We made it as...

If you have third party applications running, you should never try to change the compatibilty level to 90 without proper testing. You could run the upgrade advisor to find out...

Lowry Kozlowski (12/20/2007)

---

Security logins never seemed to come over correctly so I just got into habit of creating the logins on the new server prior to the move, and...

You could write a function that converts the string of numbers and returns a TABLE that contains the integers as values.

I think that is the easiest way to do and...

You should not have too many sysadmin accounts in your DB. Either keep the SA or remove it and add another one. Never let any admin privileged account access data...

Strange, Once you delete it , is the database still working?

Did you check the file path of the DB to make sure that the file you are able to...

You can just create a user and the role of SysAdmin.

Members of the sysadmin fixed server role can perform any activity in the server. By default, all members of the...

Why not set up the New SQL 2005 server as a warm stand by. Before the final plug is pulled, close all external connection to the 2000 DB. once the...

Hi Hasib,

you could always set up a server side trace as a job and copy the Job to different Servers with slight modification. Then have some reporting feature to get...

This could be because the Statistic on the table is not Updated. Maybe you should just Update the statisitics of the table before trying to do the update.