One benefit I like of storing in MSDB is that the changes get versioned within msdb. Plus, I can backup the msdb database and know that those packages have...

Gianluca Sartori (1/16/2012)

---

Chad Crawford (1/16/2012)

---

I guess I should find it amusing...

... but my...

SQL Kiwi (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

Also, I don't find 2012 SSMS to be slow at all, even in a VM. I must admit that my laptop is a very fast machine...

WayneS (1/16/2012)

---

Even better - no pants...

I think the better method is to use a firewall. Through the firewall, put explicit permissions for IP addresses to access the Database Zone. This doesn't prevent somebody...

Chad Crawford (1/16/2012)

---

:hehe:

Jack Corbett (1/16/2012)

---

Yup. I got one last week. It went to spam and I left it there because...

Nicely done Roy.

Anybody else get a request like this recently?

thang_ngo_2002 (1/16/2012)

---

Could you please explain me why, I'm try that way, I can connect from my program and...

Gianluca Sartori (1/16/2012)

---

I did a similar thing some years ago.

Here's the code:

CREATE TRIGGER [TR_LOGON_APP]

ON ALL SERVER

FOR LOGON

AS

BEGIN

DECLARE @program_name nvarchar(128)

DECLARE @host_name nvarchar(128)

SELECT @program_name = program_name,

@host_name = host_name

FROM sys.dm_exec_sessions AS...

SQL Kiwi (1/16/2012)

---

I installed a 2000 VM recently just to test something specific. I had almost no clue where to...

GilaMonster (1/16/2012)

---

Revenant (1/15/2012)

---

the fact is that there is 2012 waiting for the official release; IMO all adequate tests today ought to be for that one - the newest version -,...

I was surprised to see a question about this here. Now that has me thinking of importing some rainbow tables into SQL Server...hmmm:cool:

Steve Jones - SSC Editor (1/14/2012)

---

Ultimately I think the exams aren't well done. They don't have a large enough pool of questions, they aren't "thinking" questions, and there's no feedback...