Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 7,164 total)

  • RE: Japanese characters as question marks

    erikd (4/11/2013)

    The other fields it's occurring in are first name, last name, and company name. Crud.

    It should be a quick fix to the cursor declaration I showed above so those...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 12, 2013 at 8:23 am

    #1605989

  • RE: Japanese characters as question marks

    As suspected

    [Prefix] [varchar](64) NULL,

    in the "load" table is the best candidate for causing the issue. Should be NVARCHAR.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 10:06 pm

    #1605848

  • RE: Japanese characters as question marks

    Where I have your workflow:

    1. dbo.LoadPreLoadFromExcel brings the contents of the Excel into a new "load" table

    2. dbo.CreateTargetTable creates a new "target" table with typed columns from data in sample_fields...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 9:32 pm

    #1605838

  • RE: Domain users not in sys.server_principles

    You cannot rely on sys.server_principals to resolve the names of job owners that are entering the instance via a Windows Group. Use SUSER_SNAME() instead:

    SELECT sj.name AS 'job',

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 8:45 pm

    #1605827

  • RE: The Command Shell

    Jeff Moden (4/11/2013)

    opc.three (4/8/2013)

    If nuclear blasts were the only reason to leave xp_cmdshell disabled then you would have a great point. Unfortunately, that is simply too narrow a view.

    The circle...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 8:41 pm

    #1605826

  • RE: Japanese characters as question marks

    I need the contents of Sample.dbo.sample_fields in order to know the second table definition. Can you simply script out the resulting table definitions for the project_id in question?

    This query in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 8:16 pm

    #1605822

  • RE: Japanese characters as question marks

    Cool. I can't get to dropbox from here but I'll have a look when I am home.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 1:36 pm

    #1605765

  • RE: Inserting into an auto increment PK field

    If you do not need unbroken sequence don't reinvent the wheel, use an IDENTITY column. It hamdles concurrency for you and when relying on auto-generation will guarantee uniqueness.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 9:37 am

    #1605658

  • RE: Japanese characters as question marks

    Sure. Post it. If you want to attach some sample UPDATE statements and the table defs too as a text file so the browser doesn't get in the way that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 9:34 am

    #1605656

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    Steve Jones - SSC Editor (4/10/2013)

    In 2008, you should have queueing. DB MAil uses Service Broker under the covers, so I wouldn't worry about that.

    http://msdn.microsoft.com/en-us/library/ms190307.aspx

    +1 Database Mail in 2005+ uses...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 9:05 am

    #1605636

  • RE: Cannot generate SSPI context. (.Net SqlClient Data Provider)

    You are sure nothing else changed with the service account? Check the SQL Server error log for messages about the SPN being registered where it wasn't before the change, or...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 9:01 am

    #1605629

  • RE: Japanese characters as question marks

    For terminology's sake so we're speaking the same language:

    ANSI = VARCHAR/CHAR

    Unicode = NVARCHAR/NCHAR

    In SQL Server, Unicode = UCS-2

    Still not clear if all your columns are Unicode or whether you have...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 8:53 am

    #1605624

  • RE: Inserting into an auto increment PK field

    What happens if after you get the next number from [dbo].[GetNextRowId] you try to do the insert into the base table and it fails? That's the same problem an IDENTITY...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 8:47 am

    #1605618

  • RE: Today's Random Word!

    crookj (4/11/2013)

    Daniel Bowlin (4/10/2013)

    cloy

    Glut

    Se7en[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 8:02 am

    #1605594

  • RE: ANSI to UTF-8 conversion

    mister.magoo (4/11/2013)

    Thanks for that - will take a look.

    Much appreciated.

    If you did happen to grab the download before I took it down, don't bother looking. I was misreading the BOM...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 11, 2013 at 7:46 am

    #1605586

Viewing 15 posts - 1,276 through 1,290 (of 7,164 total)