Can't say that I've actually needed to change an IP on a SQL 2000 instance but I'm guessing it is a registry key.

The ones I have been involved in (DBA, Virtualization, Performance) have not had any sales pitch that I can recall.

Was is "it" you are trying to do in SQL 2000.

Also note you posted this in the SQL Server 2005...

According Microsoft this was a bug, but was fixed in the RTM release. You might want to verify you downloaded the current release for SQL 2008 Express.

http://connect.microsoft.com/SQLServer/feedback/details/356782/attach-database-from-sql-server-2008-express-advanced-services-rc0-x64

If you...

The Network Configuration equivalent for SQL 2000 is called: Server Network Utility

Under Start > Programs > Microsoft SQL Server

OR

Start > Run > type svrnetcn

That is awesome!!! They have a calendar too 😀

OK...I laughed at that one.:w00t:

Delete all the data in the database, then perform backup :hehe:

GilaMonster (9/21/2010)

---

I like this...

Logon triggers exist in SQL Server as well:

http://msdn.microsoft.com/en-us/library/bb326598(v=SQL.100).aspx

This should be tremendously...

shew (9/21/2010)

---

Tell me more.

For example, STIG DG0029 says, "If C2 Auditing is enabled (See Check DM0510: C2 audit mode), this check is Not a Finding." I think you are correct...

shew (9/21/2010)

---

EdVassie (9/21/2010)

---

Why are you looking at C2 auditing? This is an obsolete standard that does not match current compliance requirements. IMHO you should be looking at Common...

The file extension makes no difference. BAK and TRN...

Not sure why this matters?

SQLDCH (9/20/2010)I'm just curious why a manual, full backup contained...