You can choose, do you want to know the process, or just catch it to investigte?

1. Traceon can cath your deadock info...

Hi Narendra

Start bychecking your version

use:

SELECT @@VERSION

or use:

SELECT SERVERPROPERTY('productversion'),...

Question is a bit fague, but I...

BPA = Best Practise Analyzer

Download Here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

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...

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.

allan.kendall (9/18/2009)

---

Hey there,

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...

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?

Dugi (9/18/2009)

---

Ok I post some topics but in general, try to find more info from BOL:

1. Backups

2. Disk Space

3. Job Failures

4. System Checks

5. Performance

6. Connectivity

7. Replication ( If you have...

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...

Also remember that they all need to be the same exact size for the algorythm to work optimal.

try a lower resolution @ lower bits as well....

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...

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...

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...

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...