Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 13,459 total)

  • RE: Problem with CLR Assembly call

    just like xp_cmdshell, the service account that SQL is using is the credentials used for accessing objects outside of SQL server.

    if your process was accessing local folders , special folders...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 10, 2015 at 5:43 am

    #1818493

  • RE: Would the Dedicated Admin Connection have helped here? No SYSADMIN members...

    Jason i know i inherited a ton of servers, where noone was still around to add users as sys admin, or there was no admin at all.

    I've got several scripts(powershell,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 1:34 pm

    #1818270

  • RE: Restricting Sysadmins from adding new sysadmins

    i took this post as an attempt to use a third party security audit solution that either has limited scope, or you might have limited experience with it.

    it's...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 1:26 pm

    #1818266

  • RE: Split column value after every 50 characrters without splitting words

    Sean Lange (8/7/2015)

    I was fiddling with a version of my own using that same function when Luis posted his. I scrapped mine immediately as I saw the approach he was...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 12:38 pm

    #1818251

  • RE: Split column value after every 50 characrters without splitting words

    just for reference, this is how i tried to solve it;

    i parsed everything with DelimitedSplit8K, and then just fiddled with columns that were larger than the target length.

    my sample...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 12:03 pm

    #1818235

  • RE: Split column value after every 50 characrters without splitting words

    ahh, better than what i was trying next, Luis!

    i started splitting the all data on CHAR(10), and then splitting whatever had a length that was over @MaxLength ;

    i like...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 10:07 am

    #1818191

  • RE: Split column value after every 50 characrters without splitting words

    when modified to your example, that's exactly what it does:

    /*--results:

    TheObjectNameLineNumberLine

    Some Comments1ENSURE THE PRODUCT CODE AND BATCH INFORMATION ON

    Some Comments2ROUTE CARD IS CORRECT AGAINST THE PICK SHEET &

    Some Comments3LABEL

    */

    --http://www.sqlservercentral.com/Forums/Topic677895-338-1.aspx

    DECLARE @MaxLength int...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 9:26 am

    #1818173

  • RE: Split column value after every 50 characrters without splitting words

    Sean pinged me on this one, and i've posted versions of it elsewhere, but i have code saved from other members posts, so let me point you to them.

    Lowell (11/13/2013)

    take...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 8:43 am

    #1818142

  • RE: Script task file check error

    if Dts.Variables["User::V_FileExistsFlg"].Value is a boolean, you should assign true or false, and not 1, right?

    Also,if you append strings like that together, you have to be absolutely sure of ending slashes,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2015 at 7:41 am

    #1818097

  • RE: Job Post: Database Administrator

    Luis Cazares (8/5/2015)

    That's not fair. Where were you a couple of months ago? 😛

    damnit i was looking for you!

    based on some of your comments, i suspected you might be local,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 5, 2015 at 11:38 am

    #1817650

  • RE: SQL Server for TFS Setup

    well, i don't consider TFS to be highly volatile, the developers might have what, a hundred or so check-ins a day?

    so this is my default setup for backups:

    ALL TFS...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 5, 2015 at 11:30 am

    #1817647

  • RE: SQL Server for TFS Setup

    i can tell you how my TFS is setup, and I've had no problems. use that to help make a more informed decision.

    my TFS is on a single virtual server...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 5, 2015 at 9:41 am

    #1817603

  • RE: SSIS 2012 Oledb script component

    Jo i use a script task to pull that out for other script tasks to consume all the time..

    here's a full script task example, but the piece you need is...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 4, 2015 at 11:35 am

    #1817255

  • RE: only show the duplicated records

    ;WITH MyCTE([Bf_ORGN_CD],[LEV5],[BF_ACTY_CD])

    AS

    (

    SELECT 'AC_21234_2','AC_21200_1','402' UNION ALL

    SELECT 'AC_21236_2','AC_21200_1','402' UNION ALL

    SELECT 'AC_21238_2','AC_21200_1','402' UNION ALL

    SELECT 'AC_29000_1','AC_29000_1','802' UNION ALL

    SELECT 'AC_29988_1','AC_29988_1','801' UNION ALL

    SELECT 'AC_40040_1','AC_40040_1','201' UNION ALL

    SELECT 'AC_41061_1','CA_41061_1','207' UNION ALL

    SELECT 'AC_41080_1','AC_41080_1','207' UNION ALL

    SELECT 'AC_41196_1','AC_41196_1','207' UNION ALL

    SELECT 'AC_42404_1','AC_42404_1','801'...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 4, 2015 at 11:20 am

    #1817247

  • RE: data type conversation

    the convert function has an optional parameter when you are converting dates;

    112 will give you the eight digit format you are looking for:

    SELECT CONVERT(VARCHAR,getdate(),112) --20150803

    SELECT Sub_date = CONVERT(VARCHAR,annual_date,112)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 3, 2015 at 3:27 pm

    #1816966

Viewing 15 posts - 1,591 through 1,605 (of 13,459 total)