Hello George,

Log Shipping and Mirroring are complementary approaches to data availability and integrity.  We are very happy with the performance of mirroring, but we continue to use log shipping for the...

Excellent!

I didn't know about this option in the ROUND function. 

Plunk!!  (that's the sound of my UDF hitting the wastebasket)

Thanks, Elliott

OK, I got it.  The FLOOR function will eliminate the "extra" digits:

Declare @num decimal(18,9)

Set @num=99.021377000  -- goal is to eliminate last 5 digits

Set @num=@num * 10000  -- put the decimal...

sam,

I am using exactly that syntax with no problems. 

Since the error complained that the event does not exist in that namespace, you might want to try another valid WMI...

Good point.  The vendor named the file "xxx_index.ndf", so I'm making an assumption here.  But I think it's correct.  Is there any way to check it?

I agree on the disk...

Thanks for both replies.  I will take your advice about avoiding shrinkfile operations.

My impression of the vendor's index strategy was that the indexes covered every possible column.  And my questions...

Update for general interest.

The Job was failing because of a single test database which had been set up as a mirrored database, but became orphaned when the partner server was...

Noel,

I am creating a new database using EM and trying to select my WindowsGroup

Login ("Able") as the database owner.  I receive the error message that "the proposed new db...

Thanks.

I checked it out.  Same error message, but apparently a different problem.  My mirroring is performing fine.  It's only the Mirroring Monitor Job that is failing ("internal error"), and the...

Thanks Derelict (did I catch your ref, correctly?)

I'm still hoping for a T-SQL solution to Identity so that I don't have to cut and paste between virtual servers.

Elliott

Oh No!

I feel like that person in the Alaska Airlines commercial:  "Wanna Get Away??"

I thought that it was the Query Analyzer that was limiting my result.

Thanks for the help,

Elliott

Yes, the query result is a concatenation of string values.  Here is the stored procedure that takes a table name and produces a list of the column names and datatypes:

CREATE PROCEDURE...

Mohammed,

Thanks.  I'm not sure why we're getting different results.  I changed the Max Char per Column setting to 8192 and set the results to Grid.  On my SQL 2000 system,...

I've written a proc which captures the column names and datatypes for a db and table input to the proc.  The proc concatenates these "words" into the desired text string.

The proc...

I'm expecting a concatenated text string of about 4000 characters in length