Vampire (3/24/2009)

---

@Dugi

Thanks for your tip..it worked. Am now able to login. However,I have my SQL Browser running earlier too...

I earlier used this command to connect to DAC as Admin..but couldn't

...

Vampire (3/20/2009)

---

this is not inserting any @IP value in the ValidIP table. Does triggers have constraint of not inserting any value into the tables in execution.

3. If @IP value can't...

Ultimately you can't stop someone who wants to get at your code from doing so. Even if you put the BI in compiled code, a dissassembler would still reveal what...

Yes, downgrade rights are still available:

SQL Server 2008 Licensing FAQ

Look for the question "How do I downgrade to SQL Server 2005?" in Licensing. If you need media (the physical DVDs),...

In SQL Server 2008, sp_droptype is deprecated. You should use DROP TYPE instead. With that said, sp_droptype only drops types that are in the dbo schema. Date is a system...

Alvin Ramard (3/12/2009)

---

I have to wonder about that interview post when the OP kept referring to SQL Server 9 after being a DBA for a number of years. I've...

SAS70 compliance is hard to document for because it is based on the opinion (and the standard actually says opinion) of the independent auditor.

SAS No. 70 provides guidance to...

vgullotta (3/10/2009)

---

I am attempting to change a dbo login name and can't figure out how. Let me explain a little so you get what I am looking for.

This dbo login...

The error message gives you what you need to do. In order to setup an HTTP endpoint in SQL Server 2008 (or 2005), you must first reserve a URL which...

Jack Corbett (3/9/2009)

---

K. Brian Kelley (3/9/2009)

---

"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL...

Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:

"If you do not understand what this code is doing....

If you are logged on to the same computer as SQL Server, then use SQLCMD with the following flags:

SQLCMD -A...

RBarryYoung (3/9/2009)

---

Great article, Brian. Is the Client_Host ip information still available about a session later on, or would I need to store it from a Logon Trigger like yours...

DavidB (3/9/2009)

---

Laughing.... I have struggled down a path or two with that one before as well and found myself wondering if I was talking to two different people and then...

Ken Shapley (3/9/2009)

---

Nice trick.

Can you add some real life examples of where this was implemented? And the details of why it was absolutely necessary? And, were all other alternatives for...