Did you specify the restore must be done WITH STANDBY?

Edit: Nevermind. Must read posts more carefully in future.

Yeah but likes with leading wildcards will always, in the absence of other SARGable predicates do a full index/table scan

Grant Fritchey (8/6/2009)

---

Jeff Moden (8/6/2009)

---

I've not confirmed my plane reservations but I'm 99.99% sure that I'm going to be in Lil' Rhody from 9/6 to 9/12. That means that...

Remove the 'd'? (Why's it there in the first place?)

Cast to float then to decimal?

If you've backed up the system databases (specifically master and msdb) and restored those, the system will be as it was at midnight. If you haven't backed up the system...

It was a feature added in SQL 2005 for cases where an index needs to be dropped for data loads. It means that the index can be recreated without needing...

select message_id, severity, text from sys.messages where language_id = 1033

As for custom errors, from the Books Online entry for RAISERROR

msg_id

Is a user-defined error message number stored in the sys.messages...

I suspect you do have the wrong guy.

karthikeyan: http://www.sqlservercentral.com/Forums/UserInfo151404.aspx (today's poster)

karthikeyan: http://www.sqlservercentral.com/Forums/UserInfo449952.aspx (PhD...

Dump is gone in SQL 2008.

Try switching the table variables to temp tables, see if that make a difference.

If it doesn't, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Also, is that...

Not a bug.

Isnumeric returns true if the value passed can be converted to any of the data types.

select CAST('0.d00' as float)

Tell your colleagues that they should check with people before restoring backups.

Only if you have a backup.

What do you mean by resume?

Can you explain clearly what you've done, what the problem is and what help you need?