Viewing 15 posts - 1,141 through 1,155 (of 7,168 total)
wolfkillj (5/13/2013)
opc.three (5/13/2013)
May 13, 2013 at 4:42 pm
One way would be to switch to PowerShell.
$path = '\\server\path'
$filter = '*.bak'
$retentionDate= (Get-Date).AddHours(-12)
#################################################
Get-ChildItem (Join-Path $path $filter) -Recurse |? {($_.PSIsContainer -eq $false) -and ($_.LastWriteTime -lt $retentionDate)} | Remove-Item -WhatIf
Just remove the...
May 13, 2013 at 4:38 pm
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...
May 13, 2013 at 2:54 pm
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...
May 13, 2013 at 1:46 pm
The script does not take into account Database Users that were created without a login, a.k.a. loginless users.
May 13, 2013 at 12:16 pm
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...
May 13, 2013 at 11:33 am
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...
May 13, 2013 at 11:00 am
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...
May 10, 2013 at 1:51 pm
GilaMonster (5/10/2013)
Case is not a control flow statement, it can't return portions of the query. It returns expressions (values)
Precisely! Thank you for calling attention to it. It was my thought...
May 10, 2013 at 1:37 pm
Neeraj Dwivedi (5/10/2013)
What I was trying to ask that when ever a deadlock happens there are always 2 parties involved. Do by any chance you know the second party?
Not always....
May 10, 2013 at 1:08 pm
Puja Shah (5/8/2013)
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...
May 10, 2013 at 12:51 pm
pskoasha (5/10/2013)
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...
May 10, 2013 at 12:18 pm
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...
May 9, 2013 at 7:37 am
Neeraj Dwivedi (5/7/2013)
May 7, 2013 at 8:31 pm
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)...
May 7, 2013 at 8:30 am
Viewing 15 posts - 1,141 through 1,155 (of 7,168 total)