I think, but entirely sure that you can do this using the LIKE statement...at least accordng the BOL entry:

http://msdn.microsoft.com/en-us/library/ms187787.aspx

Not sure yout going to get the full performance benefit of...

Well i guess you could try taking a backup of the online database and restoring the db to a different server or location. Then you wll have another copy of...

Hi

I think your first problem maybe related to the fact that when your DBA left your sys admins probably disabled or deleted his windows account...which is usually the case...I...

user defined functions in WHERE clauses.

Hi Debbie not to sure what "Never Fail" is...

I have used clustering on both SQL Server 2000 and SQL Server 2005 and on test cluster with SQL Server 2008, all...

Just to add to what George said I too have been victim of something similar, my problem was caused by a third party monitoring tool that had been configured incorrectly...

This article will answer all your questions:

http://www.mssqltips.com/tip.asp?tip=1126

erm, what about the native backup software that ships with sql server? could you use that?

i would imagine there is an option to upgrade one instane at a time...if thats what you want to do.

Have you set the max and min server memory to be the same value?

if not what are these values?

could be somthing to do with the sync with backup option, haven;t done too much with replication but this maybe a place to start....

http://msdn.microsoft.com/en-us/library/ms151224.aspx

proably need to consider security too assuming that permissions and data access will differ between development and production

i guess that your using 32 bit sql server with awe enabled?

If so task manager will not accurately refelect the amount of memory being used by sql sever, as memory...

all the sp_revlogin sp will do is create sql accounts on the new server with same 'sids' as the old server, when the db gets restored from the old server...

not sure if its the same for 2008 but if you view the job history by right clikcing the on the job (through the job viewer) it should give the...