Viewing 15 posts - 3,046 through 3,060 (of 9,715 total)
Been on PTO for a week, so didn't catch up to this thread until now...
Regarding the app that doesn't prompt for SQL password changes, depending on how big your company...
December 1, 2014 at 11:48 am
psc032802 (12/1/2014)
December 1, 2014 at 11:39 am
This is getting seriously annoying. I tried switching out to a Script Task and again, this works in BIDS without an issue, but the SQL job seems to hate me...
November 21, 2014 at 9:04 am
Markus (11/21/2014)
November 21, 2014 at 8:07 am
sqldriver (11/21/2014)
Every application I support uses SQL logins, and they all require at minimum the dbcreator role assigned.
Yikes! What kind of application spawns its own databases? And how many databases...
November 21, 2014 at 8:02 am
It is fair to say the concern that started this thread terrifies me.
In our environment, we don't give users SQL logins. We use windows authentication. SQL Logins are reserved for...
November 21, 2014 at 7:35 am
Koen Verbeeck (11/21/2014)
jacksonandrew321 (11/21/2014)
so can't we use that SSIS funtions on that? If yes then its possible to use SSIS right from there.
I'll repeat it again:
if you want to use...
November 21, 2014 at 5:51 am
A few thoughts.
1) Ask him what the primary purpose of his program is. He should be able to tell you this in one sentence. If he can't, then he hasn't...
November 21, 2014 at 5:48 am
If you don't have the Integration Services components set up on the machine in question, then SSIS won't work. Just because the Client Tools give you the option of logging...
November 21, 2014 at 5:33 am
Thanks, everyone. I appreciate all this information.
November 20, 2014 at 6:06 am
The argument appears to be won without the expected inkshed and tantrums. The Dev in question has fixes for the issue.
YAY!
November 14, 2014 at 11:49 am
Kevin, thanks for the links. Now I have more questions.
Is Primary Replica the database of origin or just the first replica that was set up?
TheSQLGuru (11/13/2014)
http://technet.microsoft.com/en-us/library/ff878253(v=sql.110).aspx
Per the above link:
As soon...
November 14, 2014 at 11:44 am
Perry Whittle (11/13/2014)
Brandie Tarvin (11/12/2014)
1) Both FCI and AG require windows clustering in order to work.
Yes, both technologies require a functional Windows Server Failover Cluster.
Note that you may also use...
November 13, 2014 at 10:56 am
Shawn Melton (11/12/2014)
November 13, 2014 at 5:33 am
Steve Jones - SSC Editor (11/12/2014)
November 13, 2014 at 5:30 am
Viewing 15 posts - 3,046 through 3,060 (of 9,715 total)