okay,

declare @value int;

update sometable set

somecolume = somevalue;

set @value = @@rowcont;

exec dbo.InsertRowCount 26,'Description',@value;

Help a little more?

As to writing your code for you, no. You give it...

Also, the table and data provided to seem to match what you showed us in your original post. How about a little more information about what you are looking...

It would also be nice if you had two or three individuals in the sample data instead of just one.

Okay, but what about the expected results based on the sample data?

General frame work:

update tablename set

somecolumn = @somevalue;

set @value = @@rowcount -- capture how many rows were updated;

exec dbo.insertcounts 26,'description',@value;

Does this hint help?

Is CDate the leading column on any or all of the indexes?

Look up Query Notifications in BOL (Books Online). It was a feature added in SQL Server 2005. This is probably what you are looking for.

Okay, still haven't had enough caffine this morning. I got this one wrong because i misread the question.

The reason it is failing is because your default date format is dmy. Here is some test code I ran here at home.

set dateformat mdy

select cast('2009-07-23 00:00:00' as datetime)...

Sorry, still half a sleep. Need more caffine.

Actually...

You can not restore a SQL Server 2008 backup to a SQL Server 2005 system regardless of the compatibility mode of the database.

If you need to move a database from...

sarvesh singh (7/22/2009)

---

When i do rt click properties on SQL server it says language spanish.

When i run a query :

select * from shifthistory where vfrom='2009-07-23 00:00:00'. i get an error.

...

Not sure what you mean by an external device, but one possible cause could be permissions. A second could be a network error or problem with the network configuration.

Just a guess based on my knowledge of backups and restores only, haven't worked in a logshipping environment yet, but no I don't think you can do that.