Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 7,164 total)

  • RE: Silly newbie question

    Anytime. Thanks for the positive feedback!

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

    April 20, 2012 at 12:23 pm

    #1476880

  • RE: The DELETE statement conflicted with the REFERENCE constraint "". The conflict occurred in database

    drew.allen (4/20/2012)

    There is a third option. Update the rows in Table2 so that the constraint will still be valid after the delete. You can either update that column...

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

    April 20, 2012 at 11:51 am

    #1476849

  • RE: The DELETE statement conflicted with the REFERENCE constraint "". The conflict occurred in database

    kodalisridevi (4/20/2012)

    I need to delete rows in table 1 :

    I am getting an Error message :

    The DELETE statement conflicted with the REFERENCE constraint "FK_Users_Divisions". The conflict occurred in database "BidManagerCommon",...

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

    April 20, 2012 at 11:43 am

    #1476845

  • RE: How to I trap the first error in a process that has failed (Only using restore DB snapshot as an example)

    Please do not cross-post. It only fragments replies and wastes people's time. Direct all replies here:

    http://www.sqlservercentral.com/Forums/Topic1287003-146-1.aspx

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

    April 20, 2012 at 11:32 am

    #1476842

  • RE: Golden Gate for SQL Replication

    I assume you're planning to replicate from Oracle to SQL Server or vice-versa? Golden Gate being an Oracle product you may do better on Oracle Technet.

    For the record SQL Server...

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

    April 20, 2012 at 11:25 am

    #1476834

  • RE: sp:completed Vs RPC:Completed

    S_Kumar_S (4/20/2012)

    Hi

    Although I have seen clarifications on the difference between these 2 events, but I am still not very clear practically.

    My purpose is to run a trace that captures procedure...

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

    April 20, 2012 at 11:23 am

    #1476829

  • RE: SSIS 2008 R2 - Error level log of SSIS packages called by batch file

    DTLoggedExec[/url]

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

    April 20, 2012 at 11:11 am

    #1476823

  • RE: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

    I have seen that happen when a Domain Controller is restarted. If the Domain Controller restarted was the one cached by your application server the authentication errors begin...and unfortunately the...

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

    April 20, 2012 at 11:09 am

    #1476822

  • RE: Silly newbie question

    rickeb1 (4/20/2012)

    Thanks very much for the response! Yep, doing that worked fine. So now my question is, if I have a function (and only the function) defined in...

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

    April 20, 2012 at 10:57 am

    #1476818

  • RE: ssis configs

    What do you mean by "dynamically". I usually create a config file through one of the packages, then if I want to use that config in another package I'll open...

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

    April 20, 2012 at 10:42 am

    #1476805

  • RE: Online Indexing

    Note that ONLINE indexing is only available in Enterprise, Developer and Evaluation Editions of SQL Server 2005 and above.

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

    April 20, 2012 at 10:35 am

    #1476801

  • RE: Silly newbie question

    If the only contents of your script are the function definition you showed, then all your script does is define a function...now you have to call it 🙂

    Try running a...

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

    April 20, 2012 at 10:12 am

    #1476785

  • RE: wql query to check for creation of multiple files in a directory

    AIRWALKER-375999 (4/20/2012)

    ...but it seems like I cant have 2 constraints pointing to the same task..is there a way around this?

    Sure you can...I do it all the time. When you have...

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

    April 20, 2012 at 10:01 am

    #1476776

  • RE: CTE - Being executed twice?

    One neat little easter-egg about CTEs that I'll throw out there is that they can be executed multiples times if they are referenced multiple times by your query. It is...

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

    April 20, 2012 at 9:43 am

    #1476765

  • RE: Calling a powershell script from TSQL

    cARBONc (4/20/2012)

    I actually loop, about every few seconds, requesting the agent job status. Once the status says it's complete, you are good to continue.

    I wrote a proc several years...

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

    April 20, 2012 at 9:38 am

    #1476758

Viewing 15 posts - 4,396 through 4,410 (of 7,164 total)