Viewing 15 posts - 24,646 through 24,660 (of 39,817 total)
March 24, 2009 at 9:11 am
I think synonyms are always per object.
But if you call
Select * from Div1.POTable
in the Div 1 DB and then from Div 2
select * from Div2.POTable
You can make a synonym that...
March 24, 2009 at 8:52 am
I was thinking camera as well, but the VM thing makes sense. Assuming you're not capturing any hardware specific stuff.
March 24, 2009 at 8:38 am
Grant Fritchey (3/24/2009)
I think that would have required some pretty heavy commenting.
Like with a hammer?
March 24, 2009 at 8:29 am
SSC3D
My typo, sorry.
March 24, 2009 at 8:23 am
How about a separate synonym for each pair?
http://msdn.microsoft.com/en-us/library/ms187552.aspx
You could define the synonym differently in each db, but iwth the same name.
March 24, 2009 at 8:18 am
Have you tried restoring the original db (from the .bak) and then restoring a diff?
March 24, 2009 at 8:12 am
I'd avoid R5 if I could. I'd even put logs and data on an R10 together instead of R5 if this is a busy/critical databases.
For testing/dev, R5 works is OK.
Be...
March 24, 2009 at 8:11 am
SQL Saturday lists Jack slightly below 5' 7"
I'll claim 6', but I think I'm 5.9999' tall 🙂
March 23, 2009 at 3:18 pm
He's short, but not Yoda short.
I'll let Lynn post a closer photo if he likes.
March 23, 2009 at 2:45 pm
It is a paging issue, but it's also a source code issue. Short answer is how many results would matter?
March 23, 2009 at 2:45 pm
Yep, on my list for today.
Found there is a 150 limit for search results set. I'm not sure what it used to be, but that's where it is now. Any...
March 23, 2009 at 2:27 pm
If you can post a bit more information, we can likely help you to determine if a temp table makes sense. Show some DDL and code.
March 23, 2009 at 2:07 pm
Viewing 15 posts - 24,646 through 24,660 (of 39,817 total)