Viewing 15 posts - 1,366 through 1,380 (of 4,272 total)
Jeff,
I agree that you can use xp_cmdshell in a *more* secure way but I just don't want to risk it. Maybe thats just me.. Mileage may vary.. ...
June 10, 2011 at 7:45 am
Hm, what edition of SQL are you trying to connect to? Is it on a seperate box? Also, why are you using named pipes? TCP/IP is much...
June 9, 2011 at 12:42 pm
Since you reference the DISA-STIG.. I assume you are referencing DG0167, this is a Category I item, and really only applies if you have sensitive/classified information or you are...
June 9, 2011 at 10:18 am
I would not select the table, I would build a query that selects only the columns you need and potentially includes the DISTINCT keyword. It is more efficient to...
June 9, 2011 at 9:58 am
Stringzz (6/8/2011)
June 9, 2011 at 9:43 am
Jeff,
I have to fundamentally disagree. xp_cmdshell allows you to run commands in the same context as the SQL server, now depending on the user and the rights you...
June 9, 2011 at 9:41 am
If you goto a comand prompt and type SET and hit enter, look for the item: USERDNSDOMAIN that should be the AD domain name. It is for me..
CEWII
June 8, 2011 at 4:24 pm
Its pretty easy to figure out in most cases. if you look at the example in the article it references ”LDAP://DC=whaever,DC=domain,DC=org” which means their AD domain is whaever.domain.org and...
June 8, 2011 at 3:16 pm
Ok, so yo are pulling data from a table. Are you using the OLE DB Source? Did you simply select the table or did you construct a query...
June 8, 2011 at 1:50 pm
Given what you describe I would go single table. Even if you had 25 int columns your effective row size would be about 210 bytes and you could get...
June 8, 2011 at 1:47 pm
You can make some assumptions about what happened even if you haven't seperated the triggers out to individual actions (I/U/D). For example:
inserted will be empty for a delete
deleted will be...
June 8, 2011 at 1:38 pm
The best way is to eliminate the dupes at the source query. what is your source, did you specify a query, or just select a table?
CEWII
June 8, 2011 at 1:27 pm
You have not provided enough information to help guide you. Are all 25 fields related to a single entity? If you have several tables are you going to...
June 8, 2011 at 1:25 pm
Revenant (6/8/2011)
I read your reply and wonder whenre does the former employer's right to cover their *** ends and where my right to get technically relevant information about a prospective...
June 8, 2011 at 1:20 pm
Viewing 15 posts - 1,366 through 1,380 (of 4,272 total)