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...

Ninja's_RGR'us (4/28/2011)

---

Thanks Albaza.

I'll put in an official request for my toy DB and I'll go from there.

We have a test environement but I can't overwrite it at will...

http://msdn.microsoft.com/en-us/library/ms174901%28v=sql.90%29.aspx

AFAIK: 3ways:

- the bol profiler way: http://msdn.microsoft.com/en-us/library/ms189604%28v=SQL.90%29.aspx

- the dta way: database tuning advisor ( been a while since I used that tool so I don't know how far that will...

just my 2ct.

Since you aim for minimal prod sys interference .... let's keep it simple.

How about lightweight tracing just for the the sp_prepare and sp_execute statements (of course capture...

As you have experienced, control server results in the same permission set as sysadmin.

A very good SSC ref pointing to this issue: http://www.sqlservercentral.com/blogs/brian_kelley/archive/2010/09/02/for-sql-server-2005-2008-consider-securityadmin-sysadmin.aspx

forsqlserver (4/27/2011)

---

I have SS2008R2 in mixed mode auth.I have forgot my sa password.

Only sa has sysadmin.

Before 11 months I have add one windows domain user 'sqladmin' as login and I...