books online will have all the examples you need to start with.

topic "restore"

When using sql server management studio, you can also have it restore your database to a new...

keep in mind the engine states the error on your object 'dbo.Command' !

You'll have to investigate that table ( i assume ) and the indexes, constraints, .. on it.

In a clear moment you may be able to spot this kind of things .... if you have been bitten by it yourself frequently enough 😀

While it is fun conversing about the situation and the brain storm sessions about it, it'll not be fun for Gail.

As much as I have the impression supporting software vendors...

Actually you've posted a nice example on how partitioning with sliding windows can help out very much when trying to keep "current" tables small and not losing online data with...

I think your only resource then would be

DBCC ind ( <database_name>, <table_name>, non clustered index_id*)

Have a look at Paul Randal s blog for more info of dbcc...

IMO you are fooling yourself by using the wrong PF with the correct table in your select query.

SELECT *

, $PARTITION.AnnualDateRange_PartitionFunction(OrderDate) AS PartitionNumber

,...

Have a look at "Managing Space Used by Objects" for the internals, how the engine manages it all.

Have a look at the poster Aaron Bertrand points to: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/01/28/sql-server-2008-system-views-poster-is-now-available-for-download.aspx to get...

I've been out for the day :Whistling:

Anyway, any rollback statement will undo your whole transaction (including the original inserts and other stuff in the same transaction scope), so be careful...

did you manage to get your install corrected ?

just came across this art today at sqlblog : http://sqlblog.com/blogs/davide_mauri/archive/2011/02/13/sys2-scripts-updated-scripts-to-monitor-database-backup-database-space-usage-and-memory-grants-now-available.aspx

Maybe this can help you out.

I thought he was whispering it and SSC doesn't supply...

a trigger is declared on an object and objects don't share triggers (afaik).

So you'll end up creating the trigger ( same or different content ) as n triggers, at...

1) are the spaces ( after % and before the second % ) in your patindex needed ?

2) I would use datalength(pattern) in stead of len.

This is my ref url for mirroring:

http://support.microsoft.com/kb/2001270

monitoring state changes

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

Follow up is based on these scripts:

/*

* DB Mirroring : followup

*

*/

/* show mirrored databases and their mirror-state */

Select db_name(database_id) as...