FULL SERVER DOCUMENTATION -- HTML  and revised

Revise note: 1. reformat the result into HTML page.2. added script to find sql server service account, sqlserver agent account.3. added script to find sql server authentication mode.4. added script to find sql server startup parameters5. added table of contents and hyperlinks.6. add DOS batch script to run the script on all servers.     TRY […]

5 (1)

2007-02-20 (first published: )

1,422 reads

Blogs

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

[Coping] Hidden Wounds

By

Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs

Forums

Execute As not reading system view

By pdanes

I have a stored procedure with the following: SELECT physical_name FROM sys.master_files Where physical_name...

Find unmatched between 2 tables using field as selection criteria

By McGoo2000

I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...

update using self-join - confirm it looks at old values

By ztoddw

I'm doing an update using a self-join, and just want to confirm something.  If...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers