Evil Kraig F (9/7/2012)

---

apache626 (9/7/2012)

---

I receive a flat file which I am importing with SSIS. The problem is the file does not contain a needed field(ssn). I have...

Lynn Pettis (9/7/2012)

---

Or maybe someone will write a client version of SSMS that meets this same need. Should be doable by some one who has excellent knowledge of SMO...

Just found this:

Connect > Management Studio should only show the databases that the login has access to by Mohamed

Another one closed as Won't fix :rolleyes:

RBarryYoung (9/7/2012)

---

opc.three (9/7/2012)

---

na1774 (9/7/2012)

---

So accoriding to the above logic. I have to Deny View Any DB first. THen make the login owner of the DB. Then it will be not...

I think you'll want to use the SSIS Lookup Transformation. There are many ways yo configure it to suit your scenario. Most considerations surround the number of records in the...

na1774 (9/7/2012)

---

So accoriding to the above logic. I have to Deny View Any DB first. THen make the login owner of the DB. Then it will be not be able...

Ignacio A. Salom Rangel (9/7/2012)

---

opc.three (9/7/2012)

---

Ignacio A. Salom Rangel (9/7/2012)

---

opc.three (9/7/2012)

---

Taking a differential backup from the primary and restoring it to the secondary will re-establish your log chain, just remember...

Ignacio A. Salom Rangel (9/7/2012)

---

opc.three (9/7/2012)

---

Taking a differential backup from the primary and restoring it to the secondary will re-establish your log chain, just remember to supply the proper option...

You're running into behavior set forth by something in SQL Server called 'deferred name resolution.' When your proc is first compiled your final table does not yet exist so SQL...

Taking a differential backup from the primary and restoring it to the secondary will re-establish your log chain, just remember to supply the proper option on the restore (STANDBY or...

I have a PowerShell script that does exactly what you're proposing. It's not much more than what you have. I have it explicitly write the IF EXISTS...DROP statement because as...

You can DENY VIEW ANY DATABASE (REVOKE is not enough) and make the user the database owner (different than being in the db_owner Role) of the database:

USE [master]

GO

DENY VIEW ANY...

Well something must differ between the servers. I am thinking code now. Are they running the exact same set of jobs?

Relevant link?

http://blogs.us.sogeti.com/sqlserver/monitor-sql-agent-memory-consumption/%5B/url%5D

Experience in DB testing does not necessarily imply developer-level skills. Quantifying what your team's skillset will help you make decisions. Since this is an established team it might be good...

I just learned about MAX_ODSOLE_OBJECTS. I traced your code and it looks like you're destroying all your created objects, i.e. no leaks, but it is quite odd that you;re dying...