This is moot because the OP got a solution, but since we're discussing...

Taking a FULL backup resets 'the differential base' unless taken with COPY_ONLY. NO_TRUNCATE may or may not reset...

na1774 (9/8/2012)

---

Hi All,

The issue is I have to give permisions to a user just to create objects in only one schema and deny creations in other schemas.

I am a...

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