<div>
try this query <br />
<br />
exec sp_defaultdb 'LoginName', 'NewDefltDBName'<br />
<br />
This works in SQL 2k
</div>


try this query

exec sp_defaultdb 'LoginName', 'NewDefltDBName'

This works in SQL 2k

<div>
this ran without an error, but did not seem to work.
</div>


this ran without an error, but did not seem to work.

<div>
<div class="content wysiwyg-content">
I don't see how to change the default database.<br />
<br />
I have an ODBC connection in which I can tell it to use a different database than what the default database is, but if I delete that default database the ODBC connections fail. So I need to change the default database.
</div>
</div>


I don't see how to change the default database.

I have an ODBC connection in which I can tell it to use a different database than what the default database is, but if I delete that default database the ODBC connections fail. So I need to change the default database.

How to change the default database using SQL Server Management Studio

A font is a particular size, weight and style of a typeface. Each font is a matched set of type, one piece (called a "sort") for each glyph, and a typeface consists of a range of fonts that share an overall design. With the advent of digital typography, font is frequently synonymous with typeface, although the two terms do not necessarily mean the same thing. In particular, the use of "vector" or "outline" fonts means that different sizes of a typeface can be dynamically generated from one design. Each style may still be in a separate "font file" -- for instance, the typeface "Futura" may include the fonts "Futura roman", "Futura italic", "Futura bold" and "Futura extended" —- but the term "font" might be applied either to one of these alone or to the whole typeface.

Fonts Typography

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.