Forum Replies Created

Viewing 15 posts - 826 through 840 (of 859 total)

  • RE: how often we need to update the windows patches in production and reboot them?

    Ideally every time a new update comes out. realistically we install updates at least once a month if they are needed.

    As far as how to reboot the servers? ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 15, 2012 at 5:10 pm

    #1460256

  • RE: Missing key

    PaulB-TheOneAndOnly (3/15/2012)

    Koen Verbeeck (3/15/2012)

    It seems there are 2 correct answers :w00t:

    Finally! I knew quantum mechanics would sooner or later apply to our trade 😀

    but alas the entanglement does not...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 15, 2012 at 8:51 am

    #1459918

  • RE: Database Backup via T-SQL

    I wonder why he would need the backup. Would not an SQL select statement to.csv or similar work better. Unless the ENTIRE database is needed for some reason?...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 15, 2012 at 7:35 am

    #1459839

  • RE: Inserting Results from Stored Proc into another Database Table

    to add the insert you just need to change each block of code like the one below. Also i dont think you need the dynamic SQL as i believe...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 14, 2012 at 11:22 pm

    #1459634

  • RE: Using IF EXISTS & NOT EXISTS DROP Primary Key Constraint

    This should be what you are looking for. First one checks if the object exists in the sys.objects "Table" and then drops it if true, the second checks if...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 14, 2012 at 4:11 pm

    #1459538

  • RE: Process is still "cancelling"

    SQL Guy 1 (3/13/2012)

    But can we restore a database in at least one connection is not closed ?

    no Restore requires exclusive access to the database. with the canceling...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 5:22 pm

    #1458936

  • RE: Clear connections of a database

    lyang 88644 (3/13/2012)

    Yes. What I wanted to do is to drop the database connections without detaching the database. In SQL 2008 when I checked Drop connections and clicked...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 3:57 pm

    #1458896

  • RE: Automating an import routine for text files into SQL SERVER tables with Stored Procedures

    and I don't mind using sql injection with 29 stored proc.

    with sql injection an attacker can execute arbitrary code including possibly dropping tables if the permissions are not set correctly....

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 2:48 pm

    #1458859

  • RE: Login failedfor user

    shank-130731 (3/13/2012)

    <%

    'REMOTE CONNECT STRING

    Set MM_SQL31_STRING = Server.CreateObject("ADODB.Connection")

    MM_SQL31_STRING.Provider = "SQLOLEDB"

    MM_SQL31_STRING.Properties("Data Source").Value = "SQLB31.webcenter.com"

    MM_SQL31_STRING.Properties("Network Library").Value = "dbmssocn"

    MM_SQL31_STRING.Properties("Initial Catalog").Value = "ukk"

    MM_SQL31_STRING.Properties("User ID").Value = "ukk_admin"

    MM_SQL31_STRING.Properties("Password").Value = "ukk2000"

    MM_SQL31_STRING.open

    %>

    Set connOrders = Server.CreateObject("ADODB.Connection")

    connOrders.Open(MM_SQL31_STRING) '<-- LINE 111

    I...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 2:13 pm

    #1458835

  • RE: Automating an import routine for text files into SQL SERVER tables with Stored Procedures

    ok i have an idea of how to attack this. it may have the potential for sql injection as we are going to pass a file name as a...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 12:29 pm

    #1458751

  • RE: SQL Query Question: Working with Dates

    after playing with it in SSMS and figuring out what most of the code did that was the only part i was wondering about. i joined up here to...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 12:10 pm

    #1458734

  • RE: SQL Query Question: Working with Dates

    Lynn Pettis (3/13/2012)

    Here is a rewrite of the TVF as an inline TVF without a loop:

    looking at your code the only thing i dont understand (after looking at it and...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 13, 2012 at 11:57 am

    #1458723

  • RE: Using WAITFOR Time

    Long story short, I don't really want to get up that early to VPN in and press F5 once.

    That's one of the great things about being a DBA, long...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 12, 2012 at 5:21 pm

    #1458255

  • RE: How do I remove my stored password/username in SSMS 2008?

    MR@SD (3/12/2012)

    To change the password try to use sp_password (see help for details on it).

    not what the OP is looking for.

    im guessing you have tried closing SSMS THEN moving or...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 12, 2012 at 4:32 pm

    #1458247

  • RE: Automating an import routine for text files into SQL SERVER tables with Stored Procedures

    azdeji (3/12/2012)

    Thanks for getting back to me, the problem I'm having now is that the filename structure below will keep changing through the depending

    Projects_Russia_8_01_Country_Prog_V2_0_LFD_Project_Definition_SD

    “Country”“Template No. and “LFD_CP_Goals “SD” -These parts...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 12, 2012 at 4:22 pm

    #1458244

Viewing 15 posts - 826 through 840 (of 859 total)