Viewing 15 posts - 226 through 240 (of 488 total)
Wow, good to know.
It appears you can use an ip address, perhaps that will allow you to move forward while they debate changes to the naming convention.
May 28, 2013 at 6:50 am
Try with square brackets? [server-name]?
May 24, 2013 at 6:11 am
As a DBA and occasional AD admin, Powershell considerably simplifies my life.
Goodbye .bat, see ya later mmc AD. SQL OLE Automation was, IMHO, nearly unusable.
I do have the luxury of...
May 7, 2013 at 8:46 am
Same here. I had a quick look at Tableau BOL, I must say, it seems a little obscure to me. Or maybe I also need more coffee.
March 26, 2013 at 7:09 am
Sure you can: My AD account does not have a Windows SQL Login, but I am a member of a group that does.
SELECT SUSER_NAME(); returns me (not the group).
go
-- ...
March 26, 2013 at 6:44 am
It is possible, if the login you're using has the correct permissions. See EXECUTE AS in BOL.
March 26, 2013 at 5:40 am
Yikes. Thanks for pointing that out Jeff.
I've only (reluctantly) used it with very small sets, mostly in pre-2K5 code.
I'll be checking my code now...
March 19, 2013 at 9:41 am
How about:
IF OBJECT_ID('MyTable') IS NOT NULL
DROP TABLE MyTable
GO
SELECT * INTO MyTable
FROM (VALUES(1,19), (2,90), (3,20), (4,8), (5, 9)) AS M(ID, VALUE)
GO
SELECTm.Id, SUM(m2.Value)
FROMMytable m
JOINMytablem2ON m2.ID <= m.id
GROUP...
March 19, 2013 at 5:33 am
Right. And I didn't have RPC:Starting in my trace definition. Well that explains it.
Thanks!
P
March 12, 2013 at 5:06 am
In my experience, it's the front ends that come and go, back ends tend to be more stable. Granted there has been a bit of a shake-up with the availability...
March 11, 2013 at 9:40 am
This might help: psftp has a public key option.
http://the.earth.li/~sgtatham/putty/0.52/htmldoc/Chapter6.html
February 14, 2013 at 8:35 am
Yeah, I know it's a cmd hack, and you're right, it'll only work for a single response.
In my particular case, that's all that would have been required.
I got around it...
February 14, 2013 at 7:46 am
Hmmmmm.
I found this on the net; the author plainly states it's a bit of a hack, but also claims to have made it work for him. I've not been able...
February 14, 2013 at 7:08 am
In fact, neither works when inserting >1 parents.
I was simply wondering if I could save myself some code and a step with some fancy DRI.
Now I see that while it...
December 27, 2012 at 11:15 am
Viewing 15 posts - 226 through 240 (of 488 total)