Taking one step back... Why do you need to add columns to a table in a stored procedure?

Did the installation of the patch give any errors?

I think you may want to take this issue to Microsoft's customer support. They're probably going to be able to help you...

Replication does not require any particular recovery model. All forms of replication (snapshot, transactional, merge) work fine...

Consider transactional replication rather.

Mirroring is a high-availability solution, not for reporting.

Call another procedure.

You'll have to generate scripts of all of the objects in the DB - tables, views, procedures, functions, users, etc. Then you'll have to export the data. bcp works, as...

Database restores (including log restores)

Autoclose (a good candidate on SQL Express)

Some sp_configure alterations

DBCC FREEPROCCACHE

Post it on Connect and see what the MS people say.

The info bar at the bottom of the screen does change colour (in SQL 2008) based on what server you're...

umanpowered (11/5/2008)

---

I went directly into a table in SQL 2005, and change a column. I closed

the table. The 'modify_date' is still showing the previous date.

I'm using the...

You can restore the backup to 2008. Databases can always be upgraded in version, never downgraded.

Try something like this

SELECT * , ROW_NUMBER() OVER (ORDER BY ID) % 2 AS AlternatingFlag

FROM SomeTable

The dead lock resources were on the two tables in...

As I said above, you don't need an update in the trigger. The trigger is fired by an update, there's no need to repeat that update within the trigger.

You don't...

That kind of catch-all query doesn't perform well at all. On SQL 2000 there's no way to make it perform well

Have a look at this thread - http://www.sqlservercentral.com/Forums/Topic599065-65-1.aspx

sp_help 'tbl'