Can you run this and post the results ?

/*

* DB Mirroring : followup

*

*/

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

Select db_name(database_id) as dbName

, *

from sys.database_mirroring

Where mirroring_guid is...

Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.

(make sure you have the latest version of BOL !)

-SQL2005...

can you also insert/update/delete on the pricipal instance ?

SQL2005 : http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx

SQL2008: http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

Maybe.

However, when using windows groups to grant security, we don't have control about the actual account being used.

So finding the "exceptions" would be a trial and error thing :crazy:

and would...

Well, this is sql2005

xp_cmdshell is off by default.

You would be better off just exporting the result using SQLCMD or DBMail if you want to email it.

Check out BOL

e.g

sqlcmd -s yourserver\instance...

Grant Fritchey (12/19/2008)

---

A LAMBIC!!!!!

DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.

Belgians... They get a couple of things right (double, triple, & saison (very right))...

Finaly we are getting to the essence of being :w00t::w00t:

beer and food 🙂

I prefere a very good Geuze Lambic (the bottle with natural cork please) :smooooth:

I'm not that picky...

The strange thing is that I get a @@trancount = 3 at execution time ...

So that would get me to writing another

while @@trancount > 0

Begin

...

same player shoot again ... hit ball when lights are on ...

Select *

, Sum_Y - Sum_N as Subtracted

from (

select sum(CASE table1.column2 WHEN 'N' THEN table1.column1

ELSE 0

END ) as...

I'm glad one of our biztalk devs is very cooperative today 😉

Scenarion 1 : add begin tran ... commit tran

Just encapsulating the trigger with its own Begin tran ... commit...

Due to WWII we have 3 official languages 😉

tempdb is the system working area of sqlserver.

Probably it needed to extend one of its files and hasn't been able to do that within the timeout limit.

Check your tempdb files...

Without any select query example , this is the best I can come up with 😉

To get you on track ...

Select a.col1 as mygroupcolumn

, sum(b.colx) as sum_colx

, sum(c.col1a) as sum_col1a

from...

YSLGuru (12/17/2008)

---

...

HUH?

What makes you think I want this to rteurn more then 8000 bytes? The problem is that Replace() is retruning TOO MUCH text by adding a...