Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 7,164 total)

  • RE: function/code ??

    MisLead (4/24/2012)

    opc.three (4/24/2012)

    MisLead (4/24/2012)

    opc.three (4/24/2012)

    What is the data encoded in to start with? If they are truly multi-byte characters, i.e. Unicode on something other than plane-0, then you cannot store...

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

    April 24, 2012 at 2:57 pm

    #1478555

  • RE: function/code ??

    MisLead (4/24/2012)

    opc.three (4/24/2012)

    What is the data encoded in to start with? If they are truly multi-byte characters, i.e. Unicode on something other than plane-0, then you cannot store those in...

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

    April 24, 2012 at 2:22 pm

    #1478543

  • RE: C# conversion function

    MisLead (4/24/2012)

    opc.three (4/24/2012)

    MisLead (4/23/2012)

    I have no knowledge on c#. However i have the following code below that converts double byte to unicode. My requirement is reverse engineering i.e convert unicode...

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

    April 24, 2012 at 2:02 pm

    #1478531

  • RE: A question about connections

    Someone may have changed the configuration to 20, then changed it back. It does not require a restart. That action would be logged. Keep looking through the sql server error...

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

    April 24, 2012 at 1:47 pm

    #1478521

  • RE: Sql Servert Agent Not Run Help Me Please

    Ismael Aguilera Camacho (4/24/2012)

    This is the log to sql server agent

    2012-03-24 14:11:47 - ? [100] Microsoft SQLServerAgent version 10.0.5500.0 ((Unknown) unicode retail build) : Process ID 3732

    2012-03-24 14:11:47 - ?...

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

    April 24, 2012 at 1:43 pm

    #1478515

  • RE: A question about connections

    What does this return:

    SELECT name,

    value,

    value_in_use

    FROM sys.configurations

    WHERE name =...

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

    April 24, 2012 at 1:31 pm

    #1478504

  • RE: Making Excel desination dynamic..

    Sounds like you have it setup correctly...but problems nonetheless. Attach your SSIS package to this thread, or send me a PM with the package and I'll be happy to have...

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

    April 24, 2012 at 1:24 pm

    #1478497

  • RE: Schema/Owners question

    Gabriel P (4/24/2012)

    Hello, I have a situation in where I have one db user (let's call it webuser) that has access to multiple schemas in a database. So far everytime...

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

    April 24, 2012 at 1:17 pm

    #1478490

  • RE: Schema Qualified object Name

    I was going down the road of forcing schema-qualification in all queries, for example forcing all queries, say, within a stored procedure or script, to follow a form like this:

    SELECT...

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

    April 24, 2012 at 1:11 pm

    #1478487

  • RE: What are the best alerts to set up on a SQL server?

    Geoff A (4/24/2012)

    opc.three (4/24/2012)

    Geoff A (4/24/2012)

    if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not...

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

    April 24, 2012 at 11:19 am

    #1478414

  • RE: What are the best alerts to set up on a SQL server?

    I alert for sev 17 or higher, plus a handful of specific numbers including 825.

    Database Engine Error Severities

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

    April 24, 2012 at 11:18 am

    #1478413

  • RE: What are the best alerts to set up on a SQL server?

    Geoff A (4/24/2012)

    if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not rotate the logs...

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

    April 24, 2012 at 11:04 am

    #1478404

  • RE: data type conversion

    Heh, went and looked it up...not much more to say 😛

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

    April 24, 2012 at 10:57 am

    #1478400

  • RE: SSRS report export to Excel

    sql_ques (4/24/2012)

    Hi,

    When I export SSRS report (2008 report server) to excel the formatting is not the same as in report server. The rows are merged and collapsed. Is there a...

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

    April 24, 2012 at 10:53 am

    #1478395

  • RE: data type conversion

    deebabat (4/24/2012)

    I am trying to insert into a table by selecting from another table but one of the columns in the two tables have different data type. please how do...

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

    April 24, 2012 at 10:48 am

    #1478386

Viewing 15 posts - 4,351 through 4,365 (of 7,164 total)