Viewing 15 posts - 196 through 210 (of 667 total)
Evil Kraig F (6/18/2012)
Jan Van der Eecken (6/18/2012)
And JC went off on a rant again..Meh, I can't be bothered to de-rant him this time. Someone else do it...
I was...
June 18, 2012 at 5:40 pm
Evil Kraig F (6/18/2012)
Jan Van der Eecken (6/18/2012)
Oops, I misspelled your name. Apologies, Kraig!
LOL, at this point, either is acceptable. 😉 :w00t:
It just depends on which of the...
June 18, 2012 at 5:36 pm
And JC went off on a rant again..
June 18, 2012 at 5:28 pm
Evil Kraig F (6/18/2012)
Jan Van der Eecken (6/18/2012)
select * from sys.sysprocesses WHERE spid = @@SPID
does it give you what you need to know in the nt_domain and nt_username...
June 18, 2012 at 5:18 pm
Maybe use
FROM WhereEver WHERE CHARINDEX ( 'E0', MyColumn ) = 0
to not catch those guys who already have E0 in them? Not foolproof either. And you don't want to...
June 18, 2012 at 4:54 pm
If you run
select * from sys.sysprocesses WHERE spid = @@SPID
does it give you what you need to know in the nt_domain and nt_username columns? I'm running this on SQL 2012...
June 18, 2012 at 4:42 pm
Jan Van der Eecken (6/18/2012)
calvo (6/18/2012)
Speaking of the Reds, I had to watch this clip 10 times before I could tell for sure what happened.
Brilliant piece of fielding by Phillips...
June 18, 2012 at 3:49 pm
calvo (6/18/2012)
Speaking of the Reds, I had to watch this clip 10 times before I could tell for sure what happened.
Brilliant piece of fielding by Phillips to get that double...
June 18, 2012 at 3:41 pm
Jack Corbett (6/4/2012)
Brandie Tarvin (6/4/2012)
Gianluca Sartori (6/4/2012)
mtillman-921105 (6/1/2012)
So I suppose a lot of people rent in Europe?
70% of Italians own the house they live in.
Well, sort of.
Who owns...
June 4, 2012 at 9:30 am
On the project I'm working on I faced the same problem (xp_cmdshell disabled). What I came up with was an SSIS package that first calls an SP that returns the...
May 30, 2012 at 4:19 am
GilaMonster (5/29/2012)
Devs getting sysadmin on the shared development server - no. Db_owner on their databases, yes. Alter trace permissions, yes. DB_creator for some, yes....
May 29, 2012 at 5:00 am
dwain.c (5/17/2012)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE dbo.Test AS
BEGIN
DECLARE @sql NVARCHAR(100)
PRINT 'Entering...
May 17, 2012 at 4:53 am
Lynn Pettis (5/10/2012)
Jan Van der Eecken (5/10/2012)
Lynn Pettis (5/10/2012)
Jan Van der Eecken (5/10/2012)
May 10, 2012 at 4:16 pm
Jan Van der Eecken (5/10/2012)
Lynn Pettis (5/10/2012)
Jan Van der Eecken (5/10/2012)
May 10, 2012 at 4:09 pm
Viewing 15 posts - 196 through 210 (of 667 total)