Viewing 15 posts - 1 through 15 (of 49 total)
Timedout from a client application. Thanks.
October 14, 2015 at 10:54 am
Thanks Gsquared.
Anyway to cause the Schema1 to access objects in the dbo schema as default.
Ex:
--Start
create proc Schema1.Test
as
Select * from tblA
Select * from Schema1.TblA
--End
So when we execute the Schema1.Test proc, we...
April 11, 2012 at 11:59 am
Thanks Lynn, Sean and GSquared.
(Yes, there is another table in both the schemas with the same name(surprisingly) with different data.)
April 9, 2012 at 3:27 pm
Thank you GSquared. I think you have nailed it. Here is how I have:
The stored proc I created is in a different schema:
create proc Schema1.Test
as
select CodeValue from TableA...
April 9, 2012 at 2:56 pm
Sorry, I am not following you here...
April 9, 2012 at 12:45 pm
Thanks, but doesn't help here 😉
Very stumped on this one!!
April 9, 2012 at 12:31 pm
create proc Test
as
select CodeValue from TableA whereID = 1334802
Exec Test returns a value different from running the select stmt by itself
April 9, 2012 at 12:20 pm
Thanks,
Yes, it is a 64-bit that I installed (for a 64-bit SQL).
January 25, 2012 at 6:19 pm
Thanks for your input, Paul.
Still scratching on this one.
I did install/load the right filters, however it(.docX) is not showing up in the list when I ran: SELECT * FROM sys.fulltext_document_types
The...
January 25, 2012 at 6:04 pm
Thanks for your input.
But, I am able to search fine on my local machine (with SQL 2008 32bit), not so on the server (64bit).
I did install the filters too!
January 24, 2012 at 5:43 pm
Note:
I added another document with a .doc extension, and I was able to see the search results.
So, the problem is when I add the document as .docx, the search does...
January 24, 2012 at 4:43 pm
Hello again,
Little twist here:
I removed all the entries in the table, and re-inserted the same document, and re-populated the indexes.
But, the search now does not yield results!
Anything I am missing?
Thanks...
January 24, 2012 at 4:19 pm
Ok, thanks, Paul
January 24, 2012 at 9:43 am
Viewing 15 posts - 1 through 15 (of 49 total)