bitbucket-25253 (5/4/2011)

---

Jeff Moden (5/3/2011)

---

mtassin (5/3/2011)

---

WayneS (5/3/2011)

---

ChrisM@home (5/3/2011)

---

Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for...

Gianluca Sartori (5/3/2011)

---

OK, now it definitely works.

I got it working after a long fight with permissions, policies, and registry keys.

...and I thought that a DBA didn't need to be...

Jeff Moden (5/3/2011)

---

ALZDBA (5/3/2011)

---

It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.

For sure it would have...

It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.

For sure it would have been a headliner...

IMO this thread http://www.sqlservercentral.com/Forums/Topic1044430-391-1.aspx is a very good ref on DISK/SAN troubleshooting.

did you check these resources :

- http://sqlblog.com/blogs/adam_machanic/archive/2010/05/28/sql-university-parallelism-week-part-3-settings-and-options.aspx

- http://www.sqlservercentral.com/blogs/glennberry/archive/2011/2/25/some-suggested-sql-server-2008-r2-instance-configuration-settings.aspx

are you running the same edition ( standard + standard / ent + ent )

Can you find any in info in the errorlog files of both instances ?

How about capturing...

Aaarch i overlooked the fact this thread is in the ssis forum, hence my nonsense answer to your Q.

Sorry for that.:blush:

Some state this setting is only for 64-bit.

http://msdn2.microsoft.com/en-us/library/aa366720.aspx

states "?WOW64 on Intel Itanium-based systems does not support 32-bit applications that use this feature. The applications should be recompiled as native 64-bit...

niteshrajgopal (4/29/2011)

---

Hi ALZDBA,

This looks very promising:-D I realised now that I need to return the table from a Function. I tried pasting the code into a Table Valued Function but...

Is this what you are looking for ?

Declare @Address table (FullAddress varchar(500) , Address1 varchar(500), Address2 varchar(500))

insert into @Address ( FullAddress ) values ( 'c/o Joel Robuck')

insert into @Address (...

apparently your mirroring partner hasn't been reachable.

Once both partners can see each other again, the mirroring will start to pull over the "missed" transactions and get itself into a "mirrored/synchronized/restoring"...

Maybe this can get you started

DECLARE @Loggings TABLE

(

[DATE] DATETIME NOT NULL

,[NAME] VARCHAR(100) NOT NULL

,[QTY] INT NOT NULL

...

Is deprecated ancient syntax ! ( get rid of it ! )

from BOL SQL2000:

Transact-SQL Joins

In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified...

Jeff Moden (4/28/2011)

---

Good golly, I missed it! I missed them both, in fact. Gail has recently gone over the 23K post mark and I passed the 25K...