Viewing 15 posts - 316 through 330 (of 1,079 total)
is it a compulsory to install sql configuration manager on the apps server?
No, if set up correctly, it should accept the name as a connection from any source as well.
Try...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 12:33 am
Yes, alias will work, or DNS forwarding.
Alias: Servername\Instance2
Port:1433
Protocol: tcp/ip
Servername: Servername
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 12:24 am
Feeg (4/12/2012)
Been pulled in SAP BW and it's just not for me :pinch:
Busy studying to upgrade my MCITP...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 12:12 am
Trying to forecast results by means of old results and statistical calculations?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 6:36 am
any errors from log you can provide?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 5:39 am
Honestly, the chance of interviewing someone for a mid-level DBA job that even knows what an allocation pages is is pretty slim
Agreed. But I'd rather have honesty than "winging...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 4:40 am
GilaMonster (4/12/2012)
Henrico Bekker (4/12/2012)
When I used to interview someone, I would ask one unanswerable question
I've done it as well... "how do you detach a Log Shipped tempdb that is in...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 4:33 am
Which SQL Management Studio version are you on?
I've seen this on SSMS's that just needed a CU or SP loaded.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 4:21 am
Turn off UAC.
Steps in the links below:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 1:00 am
When I used to interview someone, I would ask one unanswerable question
I've done it as well... "how do you detach a Log Shipped tempdb that is in Read Only mode?"
You'll...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 12:41 am
What is the best way to convince employers to give me a chance, having lots of experience with another platform (Oracle) and MCTS SQL 2008 Certificate, but with limited and...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2012 at 12:22 am
Good one on 2012 range of QOTD...havent seen too many yet.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 11, 2012 at 11:52 pm
Lynn Pettis (4/9/2012)
Henrico Bekker (4/9/2012)
Duplicate post - Replies here: http://www.sqlservercentral.com/Forums/Topic1280599-145-1.aspxNot really, same topic title, different question.
Yes, saw it a minute too late, but edited.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 9, 2012 at 10:52 pm
http://www.techrepublic.com/article/making-use-of-instead-of-triggers-in-sql-server-2005/6113179
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 9, 2012 at 10:44 pm
Koen Verbeeck (4/4/2012)
How to get your cube to the other server:
Analysis Services Deployment Methods
(this was the first result for the google search deploy ssas)
Or just deploy from...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 4, 2012 at 11:56 pm
Viewing 15 posts - 316 through 330 (of 1,079 total)