wolfkillj (5/13/2013)

---

opc.three (5/13/2013)

---

If you are using either Snapshot Isolation or READ COMMITTED SNAPSHOT ISOLATION (RCSI) mode that could account for the behavior you are seeing. My comments are related to...

One way would be to switch to PowerShell.

Just remove the...

If you are using either Snapshot Isolation or READ COMMITTED SNAPSHOT ISOLATION (RCSI) mode that could account for the behavior you are seeing. My comments are related to the default...

The issuance of the IDENTITY column is part of the transaction so we are protected from loss of data.

In SSMS, Query Window 1, run this:

USE YourDatabaseName;

DROP TABLE dbo.StagingTable

CREATE TABLE dbo.StagingTable...

The script does not take into account Database Users that were created without a login, a.k.a. loginless users.

wolfkillj (5/13/2013)

---

Jeff Moden (5/10/2013)

---

wolfkillj (5/7/2013)

---

Phil Parkin (5/7/2013)

---

This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of the...

Thanks for having a look Wayne and for the nod. Also, congrats on recently becoming an MCM! That's an amazing accomplishment.

I agree that using sys.sql_logins is a cleaner way to...

A Database DDL Trigger for the events ADD_ROLE_MEMBER or DROP_ROLE_MEMBER might give you the oversight you want. Note that a member of db_owner or sysadmin can always circumvent the triggers...

Precisely! Thank you for calling attention to it. It was my thought...

Puja Shah (5/8/2013)

---

Hi,

When I try to open SSIS solution (created in BIDS on server having SSIS installed) on my local machine (do not have SSIS installed locally), I am getting...

pskoasha (5/10/2013)

---

Hi

firstly thanks for looking at this post.....

I am trying to implement a solution to fix our current security dilemma….i have created some security groups in AD where users are...

I can't really say the same but that's great for you. Like I said, I do not need a translator and your saying I do not understand him is a...

Neeraj Dwivedi (5/7/2013)

---

The only way I know you can set up a replication by creating a snapshot or initialize with backup. In both cases you have to have the...

With the help of this article I was able to work up a Console App in C# using VS 2012 to alert me when a specific type of process (cmd.exe)...

Jeff Moden (5/6/2013)

---

opc.three (5/6/2013)

---

At the Windows level I think you can intercept and prevent attempts by the sqlservr.exe process to spawn instances of cmd.exe. I am guessing this is done...