Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 7,164 total)

  • RE: Default Port

    sjimmo (1/15/2013)

    . If you have a firewall blocking 1433 requests from untrusted networks then the SQL Server will never even see the request.

    This is good as long as nobody...

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

    January 15, 2013 at 6:47 am

    #1577324

  • RE: View not working since moving database from SQL 2000 to SQL 2008

    What does this query yield?

    SELECT DISTINCT

    PERSONID AS EmpID,

    CONVERT(NUMERIC, 722) AS ClockNo, -- we know...

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

    January 15, 2013 at 6:43 am

    #1577319

  • RE: which configuration suggested for aspnet & sql server ?

    aykut canturk (1/15/2013)

    okay, not related with this topic but if I use ms azure for hosting instead of renting my own physical one, would I guarantee that my sql data...

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

    January 15, 2013 at 6:34 am

    #1577313

  • RE: SQL Security Best Practices - Dealing With User Name Changes

    ScottPletcher (1/14/2013)

    opc.three (1/14/2013)

    YSLGuru (1/14/2013)

    opc.three (1/12/2013)

    AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has...

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

    January 14, 2013 at 5:14 pm

    #1577120

  • RE: SQL Security Best Practices - Dealing With User Name Changes

    YSLGuru (1/14/2013)

    opc.three (1/12/2013)

    AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has been closed,...

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

    January 14, 2013 at 4:20 pm

    #1577112

  • RE: Need a Stored procedure

    I do not condone using xp_cmdshell at all, and especially not for something like this, but if you must here is someone who has detailed the technique from beginning to...

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

    January 14, 2013 at 3:53 pm

    #1577106

  • RE: Backup and restore databases and I/O usage

    sqlfriends (1/14/2013)

    I ask because our network people are investigating some SAN I/O issues.

    They are wondering the backup or restore could generate a lot of I/O and cause problems.

    They...

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

    January 14, 2013 at 3:38 pm

    #1577103

  • RE: Backup and restore databases and I/O usage

    sqlfriends (1/14/2013)

    Does backup and restore databases use a lot of I/O?

    Yes.

    And which one uses more I/O, backup or restore?

    It depends on where the backup file resides, whether compression is on...

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

    January 14, 2013 at 3:08 pm

    #1577095

  • RE: Is adding a User to the master Database a bad Idea?

    rynmthw3 (1/14/2013)

    Yes but to restict access to one specific login they would have to be in the master correct?

    I do not think so. SUSER_NAME() does not have a restriction related...

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

    January 14, 2013 at 3:05 pm

    #1577094

  • RE: Default Port

    It depends on what other controls are in place. If you have a firewall blocking 1433 requests from untrusted networks then the SQL Server will never even see the request....

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

    January 14, 2013 at 1:21 pm

    #1577071

  • RE: Is adding a User to the master Database a bad Idea?

    rynmthw3 (1/14/2013)

    I am setting up the Resource Governor on one of my servers and it creates a function in the master database. The function is used to point Users...

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

    January 14, 2013 at 1:18 pm

    #1577066

  • RE: sql procedure

    Ed Wagner (1/14/2013)

    Now I see the trouble with what you were asking. Does this give you what you're after? It uses a correlated subquery [child] to concatenate the...

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

    January 14, 2013 at 1:08 pm

    #1577062

  • RE: Export data using BCP command

    Dung Dinh (1/14/2013)

    Hi all,

    I have a request from my client that they need to export data to an excel using BCP command and the excel file is with format:

    Row 1:...

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

    January 14, 2013 at 12:44 pm

    #1577057

  • RE: Naming new SQL Server instance

    Abu Dina (1/14/2013)

    They say it's best practice to name a SQL instance even it's the only instance on the host server.

    I have not heard that one. Can you share a...

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

    January 14, 2013 at 12:36 pm

    #1577055

  • RE: sql procedure

    All you showed was the SELECT column list. Could you please provide the full query based on the test table I provided in an earlier post? I would like to...

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

    January 14, 2013 at 12:24 pm

    #1577047

Viewing 15 posts - 2,356 through 2,370 (of 7,164 total)