Viewing 15 posts - 1,051 through 1,065 (of 1,079 total)
Sergey Vavinskiy (9/21/2009)
Here are a couple a good strategies:
You can choose, do you want to know the process, or just catch it to investigte?
1. Traceon can cath your deadock info...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:30 am
Narendra-587652 (9/21/2009)
Hello All,How can we find the installation type of SQl on machine
mens is client or server is isntalled on the server .
-Narendra
Hi Narendra
Start bychecking your version
use:
SELECT @@VERSION
or use:
SELECT SERVERPROPERTY('productversion'),...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:25 am
Lowell (9/18/2009)
i'd do it almost the same as the thetodaisies,just changed it to be ready for more dates to exclude:valuedate NOT IN('20070731','20070724' )
Question is a bit fague, but I...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 6:21 am
BPA = Best Practise Analyzer
Download Here:
This will evaluate your SQL Server and provide a very detailed report on all recommendations (as per Microsoft)
Show's vulnerabilities, issues with growth etc...
Handly tool for...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 5:46 am
CREATE Trigger [dbo].[tr_UsrUsers_Audit] on [dbo].[USR_USERS] for insert, update, delete
as.........
Check BOL for a detailed explanation -but a Trigger is the way to go.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 5:21 am
allan.kendall (9/18/2009)
I can confirm that remote connections is selected. I can also confirm that this is a new installation of SS2005. I should comment that I am logged...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 5:13 am
Run SQL BPA maybe you'll get some answers there? I know I have.
Sounds like an underlying problem, and directly related to your hardware or drivers?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 5:10 am
Dugi (9/18/2009)
1. Backups
2. Disk Space
3. Job Failures
4. System Checks
5. Performance
6. Connectivity
7. Replication ( If you have...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 5:08 am
Is this a new Intallation of SS? Did you configure the remote allow settings?
" be caused by the fact that under the default settings SQL Server does not allow remote...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 5:00 am
Also remember that they all need to be the same exact size for the algorythm to work optimal.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 4:55 am
try a lower resolution @ lower bits as well....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 18, 2009 at 4:53 am
In your AD create a group like "Site_DB_Auth" as an example.
Ad all the members to this AD group.
Add this group, and assign a role like "public" or whatever access you...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 17, 2009 at 11:57 pm
Steve, I make use of every little piece of paper and example I can get my hands on, I'm part of that self-taught-DBA-generation 🙂
Still, sometimes you need someone more experienced...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 17, 2009 at 10:01 pm
Steve - why I said "proper education" is because the training acadamies in South Africa are more about making money, than actually training people, and sending them in a good...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 16, 2009 at 10:20 pm
I have never been one for opening a book and studying...hands-on is more my style...
But yes, I do think that education is vital. Most employers are amazed when you can...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 16, 2009 at 12:25 am
Viewing 15 posts - 1,051 through 1,065 (of 1,079 total)