Viewing 15 posts - 16 through 30 (of 110 total)
Already ahead of you on these.
The http://localhost and http://<computername> are already added to the trusted sites (and the settings turned right down to low). Https...
November 30, 2011 at 7:09 am
We have resolved the issue - somehow - though we aren't sure how or why.
The packages in question were using Trusted Authentication (I thought ehy were using sql authentication) -...
October 12, 2011 at 5:15 am
Sorted it!
Took me a while to find the system view sys.fulltext_system_stopwords which gave me the list I needed. Having used this to exclude words from my search criteria and...
September 13, 2011 at 7:45 am
Okay, now I'm getting more confused. According to BOL, the 2005 noise word file has been superseded with stopwords and stoplists in SQL Server 2008.
The test database I am working...
September 13, 2011 at 3:08 am
Excellent, thanks!
That was the final part of the puzzle. I am definitely dealing with a bad execution plan here. At least I can now concentrate now on finding...
July 1, 2011 at 1:36 am
Actually, I've just answered this myself.
If I set ANSI WARNINGS ON, no matter what I set ARITHABORT to, a divide by zero error
Set it OFF and ARITHABORT affects the outcome...
June 30, 2011 at 8:59 am
Hmm. Just checked.
When a .NET application connects, this is what is sent through with the connection.
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set...
June 30, 2011 at 8:53 am
Okay, one last question regarding the settings (ARITHABORT and the likes).
I have now checked the connections between the applications and the databases and can't quite believe what I am seeing.
I...
June 30, 2011 at 8:16 am
Many thanks.
This has been one helluva learning curve for me over the past few days digging into all of this and I'm finally getting to a stage where I can...
June 30, 2011 at 4:46 am
Did you get a solution to this?
I have a similar issue in that i can only see the SQL Server Browser and nothing else.
June 2, 2011 at 2:38 am
We finally tracked it down to the SAN. Our parent company has installed a network backup solution which scanned across the LAN and WAN for SQL Server databases and...
May 27, 2011 at 8:31 am
I can agree with the last two posts.
Agencies can be sods. I interviewed a guy for one position and when I asked him about his experiences with one technology he...
February 7, 2011 at 9:19 am
I get paid to solve problems, not to know all the answers.
Wise words indeed. I'll put that on my next pay review. 😎
February 7, 2011 at 5:21 am
I suppose most people exaggerate their knowledge to get into a job, and eventually they do hit a brick wall where their knowledge fails them, but they did say in...
February 7, 2011 at 3:13 am
Argh!
Missed this one, thanks.
This is going to make administering the logins a pain, lol. :hehe:
December 2, 2010 at 12:58 am
Viewing 15 posts - 16 through 30 (of 110 total)