PUBLIC

Technical Article

RE: Changing Authentication Modes in SQL Server 2000

  • Reply

Changing to Windows Authentication Only mode won't affect the databases. For instance, when you set up a SQL Server out of the box with Windows Authentication, master, model, msdb, Northwind, pubs, and tempdb are all owned by sa. The db_owner is internal to SQL Server.... it's a mapping between sysxlogins and sysdatabases. So long as […]

You rated this post out of 5. Change rating

2003-07-16

Technical Article

RE: Thanks for taking the test!

  • Reply

I liked the test...I'm disappointed in what I don't know...but I keep learning everyday. ON the question 14 about changing your SQL Server login's password, I chose the wrong answer because there wasn't a (') after MYLogin and so I figured it wasn't the correct answer. Otherwise, Thanks and keep them coming!

You rated this post out of 5. Change rating

2003-05-29

1 reads

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers