Viewing 15 posts - 436 through 450 (of 4,272 total)
I'm wondering what the state of the login failed message was, that might give us a clue.. You could probably get that from the errorlog..
CEWII
March 12, 2012 at 3:56 pm
You can't name the named instance the same name as the computer but by default a default instance would be the same name.
CEWII
March 12, 2012 at 3:36 pm
No, it probably won't..
The tools by default look at port 1433 for TCP/IP and a named instance by default will NEVER be there. you have to force it there.
As...
March 12, 2012 at 2:59 pm
In a previous life we had a multi-lingual app that made these assumptions.
1. Show the localized versions if possible
2. If not possible show the english version.
This involved a fairly complex...
March 12, 2012 at 2:58 pm
Two steps..
Change the port that the named instance is listening on to 1433.
Add a DNS CNAME record for the name pointing at the QNXTDB02STL name.
OR
Better answer, uninstall, re-install as...
March 12, 2012 at 2:47 pm
Bob Abernethy (3/12/2012)
March 12, 2012 at 2:08 pm
Lynn Pettis (3/12/2012)
If tempdb is on an SSD drive, why would you want to move it to ram?
I would think RAM would be a little faster..
In SQL 6.5 and below...
March 12, 2012 at 1:27 pm
I thought there would be more to the SELECT statement. Such as a where clause.
Also its better not to go back and edit the posts, just add a new...
March 12, 2012 at 1:20 pm
That value is filled here I think:
Dim dteParm As Date = DateValue(Now)
'dteParm =...
March 12, 2012 at 1:08 pm
All I know for sure is that something builds a query for the population of Me.DsFutureHearings1.CaseStatusHist. And I would bet is is a simple select statement. This would...
March 12, 2012 at 12:44 pm
I saw where you didn't want to overwrite if they had tweaked them.
I have to say that his is a bad plan and bad code management. If you are...
March 12, 2012 at 12:32 pm
Hm, how about looking at their posts on SQL Server Central? Its a good way to see how you approach problems and see how you interact with others. ...
March 12, 2012 at 12:12 pm
farmkittie (3/12/2012)
March 12, 2012 at 12:05 pm
I think I might have the actual disk at home.. Scary..
CEWII
March 12, 2012 at 11:58 am
Jeff Moden would call this RBAR Row By Agonizing Row.. And it is..
I'm looking at the TAG1 section, trying to get a handle on what it does and why.
It...
March 12, 2012 at 10:54 am
Viewing 15 posts - 436 through 450 (of 4,272 total)