Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 7,164 total)

  • RE: Sending remote attachments using sp_send_dbmail

    From what I have read the Server Proxy applies only to xp_cmdshell but the documentation is in lack of clarity in terms of whether the proxy also pertains to external...

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

  • RE: Access question

    sunny.tjk (10/31/2012)


    I can think of DENY SELECT but not sure how to implement it. I'd like to accomplish DENY SELECT to everyone except to the members of the approved group.

    Here...

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

  • RE: BCP text file is adding an extra line at the end of the file

    Upon looking some more, ordering may not be your issue if the blank line in between the header and rest of the file is showing properly. I am thinking the...

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

  • RE: BCP text file is adding an extra line at the end of the file

    You may be running into an ordering issue with bcp. Order is not guaranteed without an ORDER BY. See if something along these lines will work for you:

    CREATE TABLE test(test_id...

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

  • RE: BCP text file is adding an extra line at the end of the file

    That is one possibility if the query or table has only a single column and the file is defined as delimited. While NULL may amount to no value going to...

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

  • RE: BCP text file is adding an extra line at the end of the file

    Can you please provide repro code including CREATE TABLE, INSERT statements to populate table and complete bcp command being used?

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

  • RE: Monitoring Windows Event Logs

    Thanks for all the replies!

    I appreciate the insight into what others are doing. I think I would prefer to use SCOM but it's not available in the current shop unfortunately....

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

  • RE: Sending remote attachments using sp_send_dbmail

    Good call, I didn't think to ask about the server proxy. It is worth checking in the instance as it could be the root cause of the behavior. By default...

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

  • RE: WMI task and WQL query

    eclispe66 (10/30/2012)


    Hi opc.three I will review the link you sent thanks. So far nothing I have tried has worked. I asked our IS to look into it but I have...

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

  • RE: Permission question

    sqlnaive (10/30/2012)


    Suppose there is a tableA and trigger defined for Insert, Update and delete to populate audit table say tableB. Now If i want to give a user U1 write...

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

  • RE: update from trial version

    Yes, Evaluation to Standard is a supported upgrade path.

    Upgrade to a Different Edition of SQL Server 2012 (Setup)

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

  • RE: Does updating the key value on a partioned table cause the row to move partitions?

    If updating the key then if required SQL Server will move the record to the correct partition per the answer to the partition function. It does this by deleting the...

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

  • RE: SQL client performance

    When you setup the DSN which ODBC driver are you using? ODBC connections can be pooled meaning the connection will not be destroyed after every query. If you're not using...

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

  • RE: sysadmin vs serveradmin

    Here is the list of what each Server Role can do:

    Permissions of Fixed Server Roles (2008 R2)

    serveradmin can only do these things: ALTER ANY ENDPOINT, ALTER RESOURCES, ALTER SERVER STATE,...

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

  • RE: sp_addlinkedsrvlogin access for non-admin user

    Instead of using EXECUTE AS LOGIN = in the proc that creates the Linked Server and granting impersonation rights to your user base for that LOGIN you can try using...

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

Viewing 15 posts - 2,851 through 2,865 (of 7,164 total)