Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9283,9293,9303,9313,932»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 9:15 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 12:35 PM
Points: 672, Visits: 6,765
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...

I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...


And it is this sort of crap that causes people to just use their admin login all the time.

Either you have the perms or you don't. Make it simple and just have the one login.


I think you can do a shorcut and bury the Run As in it.
Post #1437959
Posted Tuesday, April 2, 2013 9:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:13 PM
Points: 13,085, Visits: 12,551
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx

I know it isn't too difficult I just can't seem to figure out what they want.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1437964
Posted Tuesday, April 2, 2013 9:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:50 AM
Points: 2,825, Visits: 5,720
Greg Edwards-268690 (4/2/2013)
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...

I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...


And it is this sort of crap that causes people to just use their admin login all the time.

Either you have the perms or you don't. Make it simple and just have the one login.


I think you can do a shorcut and bury the Run As in it.


That's how I had to do it at my last place. Include /SAVECRED and you don't have to keep entering your password, except when it get's changed.

Rodders...



Post #1437977
Posted Tuesday, April 2, 2013 12:58 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:30 AM
Points: 13,291, Visits: 11,078
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...

I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...


And it is this sort of crap that causes people to just use their admin login all the time.

Either you have the perms or you don't. Make it simple and just have the one login.


Maybe a more useful scenario is when you want to test security with other logins.
For example an unattended domain account used to run the SSRS reports and you want to check if it can access the ReportDB correctly.

Just thinking out of the box here




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1438062
Posted Tuesday, April 2, 2013 6:09 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
Koen Verbeeck (4/2/2013)
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...

I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...


And it is this sort of crap that causes people to just use their admin login all the time.

Either you have the perms or you don't. Make it simple and just have the one login.


Maybe a more useful scenario is when you want to test security with other logins.
For example an unattended domain account used to run the SSRS reports and you want to check if it can access the ReportDB correctly.

Just thinking out of the box here


I can see having an account or two around for things like that (we all have to test perms now and again). I also would not advocate that such an account not be disabled unless in use for very specific durations for said testing.

That said, having each admin user have an account that is privileged and one that is not wreaks of over zealousness and stupidity imnho. In my experience, any user with two accounts will use one and shun the other. It doesn't lessen the exposure risk much if any.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1438139
Posted Tuesday, April 2, 2013 6:48 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:08 PM
Points: 5,401, Visits: 7,514
I just saw a rather disconcerting event (which was in my favor) where a local white hat broke open my PC's administrator password in about 20 seconds from a cold reboot.

Reminded me of the desperate need to encrypt your hard drive.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1438143
Posted Wednesday, April 3, 2013 2:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 6,801, Visits: 14,016
Sean Lange (4/2/2013)
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx

I know it isn't too difficult I just can't seem to figure out what they want.


Touched.
It will still be tricky, even with a full explanation.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1438198
Posted Wednesday, April 3, 2013 3:49 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:50 AM
Points: 561, Visits: 1,209
The date I have been told at this time is June 23rd


Good luck. I know plenty of civilians working out there supporting our troops and as long as you follow the rules it's safe enough and they seem to have plenty of fun too.
Post #1438236
Posted Wednesday, April 3, 2013 7:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:02 AM
Points: 125, Visits: 674
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx

I'm fairly sure he's trying to front load the Qty into the Aging column which is actually a capacity. I've put a better explanation in the thread which will hopefully add some clarity. Damned if I know how you'd achieve it though and the data structure he's working from seems bizarre.
Post #1438315
Posted Wednesday, April 3, 2013 7:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:13 PM
Points: 13,085, Visits: 12,551
FunkyDexter (4/3/2013)
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx

I'm fairly sure he's trying to front load the Qty into the Aging column which is actually a capacity. I've put a better explanation in the thread which will hopefully add some clarity. Damned if I know how you'd achieve it though and the data structure he's working from seems bizarre.


Yeah it is quite strange. Thanks to you and Chris. The OP seems like somebody who is willing to help but the language barrier is a challenge. The requirements are as strange as the ddl.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1438326
« Prev Topic | Next Topic »

Add to briefcase «««3,9283,9293,9303,9313,932»»»

Permissions Expand / Collapse