Viewing 15 posts - 931 through 945 (of 4,272 total)
I have a fair amount of experience with corporate security and almost none of them know shirt about databases. The smart security groups work cooperatively with the other groups....
October 19, 2011 at 1:22 pm
Beyond the monitoring software I use, I have been configuring policies on all my SQL 2008 servers that check to be sure that all but tempdb have had a full...
October 19, 2011 at 1:15 pm
we need additional detail as to how you want to or how you are trying to update that variable..
CEWII
October 19, 2011 at 1:01 pm
can I ask why you are using a linked server to talk to the other server and not connecting directly to it from SSIS?
CEWII
October 19, 2011 at 1:00 pm
For my sa accounts I set it to some random value and let it get changed by another piece of software we have every month, while the password can be...
October 19, 2011 at 12:55 pm
EjSQLme (10/19/2011)
No, unfortunately, I don't have a backup file.
(facepalm) If this is an important database I hope you can fix it or your resume is up to date. ...
October 19, 2011 at 12:43 pm
Sblackfo (10/19/2011)
Thanks for your...
October 19, 2011 at 12:37 pm
Thats pretty tricky to do in SSIS, you have to capture the identity value and pass it back out, which depending on how you are doing the insert may not...
October 19, 2011 at 12:35 pm
Is it a named instance it is trying to connect to?
CEWII
October 19, 2011 at 9:12 am
Yes, that is possible in one of two ways, you could not install that instance on Node 2 at all or you can go into the resource group for that...
October 19, 2011 at 9:10 am
I'm concerned about the no line breaks comment. This is just one long line? I don't think the flat file connection will handle that right. If not...
October 19, 2011 at 8:12 am
My first guess is that you are not picking up the correct value from the resultset. Such as there are 2-3 fields in the result set but you are...
October 19, 2011 at 8:09 am
The OS folks pressent the drive to the machine and I usually handle the mounting. But I have a concern with the "as I see fit" comment. We...
October 19, 2011 at 8:05 am
I tend to use PBM for server and database settings like xp_cmdshell is disabled and that no databases are trustworthy and what their minimum growth is and whether it is...
October 18, 2011 at 7:08 pm
There are some trade-offs to express, it doesn't come with SSMS or SQL Agent. But if you can live with the limitations, it is free. Technically you can...
October 18, 2011 at 7:03 pm
Viewing 15 posts - 931 through 945 (of 4,272 total)