The rule of thumb is to use Windows authentication whenever possible. There are obviously exceptions, but it ensures that there is one user account, one password. There is...

You'll find, though, that the majority consensus is not to use 3rd party agents to do backups of SQL Server. Safer to do the backup to the file system...

quote:

---

If you need to restart one of the instances of SQL Server

---

Which raises the question...

quote:

---

You'd think the Sql server name could be resolved by broadcast alone.

---

Is WINS in the...

It comes down to a measure of trust. Now, organizations that have 50-60 user accounts with Domain Admin rights immediately tend to raise flags from a security perspective, as...

Using CASE in the ORDER BY clause it's possible to select the columns:

USE Northwind

GO



DECLARE @sort_column varchar(10)

DECLARE @order char(1)



SET @sort_column = 'CustomerID'

SET @order = 'A'



SELECT CustomerID, ContactName

FROM...

Yes, a member of the local Administrators group could log in to SQL Server and change the settings back and forth between Windows authentication only or Mixed Mode (both Windows...

You can use the rebuildm.exe command from the command line. Make sure you have a SQL Server CD. This will replace the master, model, and msdb databases (so...

What version of the client tools (7 or 2000) and what service pack of SQL Server on the client side?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It looks like you're probably going to have to upgrade to MDAC 2.6 or MDAC 2.7. The work arounds given by Microsoft are to use aliasing:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274383

Since you've got the...

What happens when you execute the stored procedure through Query Analyzer?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

MDAC 2.6 and higher is required to access Virtual Instances without resorting to creating aliases or specifically configuring port configurations in the ODBC settings. MDAC 2.5 is what is...

A short list:

• Never be afraid to ask for help when stuck
• Always ask a peer to look over code for any issues when time and resources permit (and sometimes even if...

T-SQL is also the programming variant for Sybase, the DB Server from which Microsoft's SQL Server has its roots.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Be careful about using a cross join in this manner because if a cross join is specified with a where clause like this, it becomes an inner join. If...