Took a guess based on other objects having scopes at the session and global level like temp tables and variables, and got it right.

Very cool. Nice question.

I have used this before to test something... but I can't remember what it was!!!

Except I used

WHERE 1=0

My brain is all RAM and no HD... now where did that swapfile...

Thanks for the easy question. 🙂

Albatross

bcsims 90437 (6/21/2011)

---

tying in 2 threads....

-ate and getting to 100 family members

John and K-ate plus 8

Peter, if you get to the mid-90's, you could probably make a bunch of...

What if you change it to:

declare @test-2 table ( d1 int )

insert into @test-2 values ( 5 )

insert into @test-2 values ( 15 )

insert...

I love Excel! I wrote my first GUI "app" as a bunch of macro buttons and learned alot about VB from reading and manipulating the resulting code of the created...

Awesome! I have a goal to break 100... not that I have any really say...

I actually call my kids by number for fun...

I test publishers and subscribers the same way in testing, on the same instance. Only mirroring requires multiple instances since the database name must be identical.

Great question!

Very important question, thanks Steve!

I was unaware that the data was decrypted before being replicated, although it makes perfect sense. Time to revisit 2 projects :/

Lots of moving parts to...

of 9

The long way to say silicosis. Having lived in the desert most of my life, I know alot of people who have it... breathing dust...

Missed it! But learned some important detail.

Great question!

Summer!