Viewing 15 posts - 1,051 through 1,065 (of 1,080 total)
Narendra-587652 (9/21/2009)
Hithank's for reply
can i know about (Client or Server) of a machine by seeing 'Add or Remove Programs'
If you chose "Client Tools Only" in the setup...
September 21, 2009 at 6:42 am
mchou (9/21/2009)
Does dynamic AWE add additional overhead to SQL Server?
Which version are you running?
running 64 bit wont have an influence.
running 32 bit and more than 16gb ram yes.
Please supply more...
September 21, 2009 at 6:33 am
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...
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'),...
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...
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...
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.
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...
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?
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...
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...
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.
September 18, 2009 at 4:55 am
try a lower resolution @ lower bits as well....
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...
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...
September 17, 2009 at 10:01 pm
Viewing 15 posts - 1,051 through 1,065 (of 1,080 total)