User Profile

Collapse

Profile Sidebar

Collapse
Derftics
Derftics
Last Activity: Dec 19 '07, 09:24 AM
Joined: Apr 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Derftics
    started a topic Sql Server Agent Service Account
    in SQL Server

    Sql Server Agent Service Account

    Hi to all,

    Good day. I am in need of help badly. My company have just give us guidelines for MSSQL secuirity hardening, part of it is to use a "WINDOWS LOCAL ACCOUNT THAT IS NOT A MEMBER OF ADMINISTRATOR GROUP" to run the SQL server agent service. As I change the current settings and apply the new local windows acoount using enterprise manager so that all the necessary priviledge for registry, folders and local policy are...
    See more | Go to post
    • Derftics
      started a topic SQL 2005 linked server problem
      in SQL Server

      SQL 2005 linked server problem

      Hello everybody,

      Did anyone of you know this problem?

      Goal: I need to created a SQL 2005 link server using the radio button "[I]Be made using login's current security context"[/I]

      Scenario 1: I created the link in my MMC client in my workstation and i encounter this error message.

      TITLE: Microsoft SQL Server Management Studio
      ------------------------------
      ...
      See more | Go to post
      • Derftics
        started a topic Users with permission to MSSQL 2005 objects
        in SQL Server

        Users with permission to MSSQL 2005 objects

        Hi Guys,

        Anyone knows how to script all the users with permission and access level to an object in MSSQL 2005?

        In MSSQL 2000 you can use the scripting in EM just go to the option "script secuirity option" when you script the object that you want but in MSSQL 2005 I cant find it.

        Thanks in advance.
        See more | Go to post
        • Derftics
          started a topic Help Please: Creating Transaction Log Backup
          in SQL Server

          Help Please: Creating Transaction Log Backup

          Hello,

          I am creating a transaction log backup in maintenance plan wizard for a database with bulk-logged recovery model but I am receiving this error. "The selected database does not have the Recovery Model property set to full. This is required in order to back up the transaction log." Kindly tell me how can I make a transaction log backup job for a database with nulk-logged recovery or is it possible?

          I...
          See more | Go to post
          • Derftics
            started a topic Transaction Log Backup in Bulk-Logged Recovery. help asap
            in SQL Server

            Transaction Log Backup in Bulk-Logged Recovery. help asap

            Hello,

            I have a maintenance plan that backups the transaction log of a database (the database recovery is Bulk-Logged), after i have run it no file was generated but the remarks was successful.

            I have tried manually backing up the tranasction log, same remarks was given but this time it generates the backup file.

            Why there's no backup file generated when i used the transaction log backup job in maintenance...
            See more | Go to post
            • Derftics
              started a topic MSSQL Audit using ArcSight
              in SQL Server

              MSSQL Audit using ArcSight

              Hi Guys,

              Is anyone of you have an idea how ArcSight works in MSSQL?
              Thanks....
              See more | Go to post
              • Derftics
                started a topic KILL Command in MSSQL Databases
                in SQL Server

                KILL Command in MSSQL Databases

                Hi,

                I would like to ask your opinion or idea. I have a user who wants to have an access to kill the processes in MSSQL that blocks his process (development side), unfortunately I cannot add his user id in the "sysadmin role". Due to some company ruling for developers.

                I have tried incorporating the "kill" command in a stored procedure to solve this problem unfortunately kill command doesnt except...
                See more | Go to post
                • Derftics
                  replied to SP_TRACE_CREATE in MSSQL 2000
                  in SQL Server
                  Thank you, I have tried it before but doesn't work. I guess I have no choice but to grant the user id with system administration role. Thanks again....
                  See more | Go to post

                    Leave a comment:

                  • Derftics
                    started a topic SP_TRACE_CREATE in MSSQL 2000
                    in SQL Server

                    SP_TRACE_CREATE in MSSQL 2000

                    Hello,

                    Is there a way how could I execute the stored procedure SP_TRACE_CREATE without granting a system administrator role to the login id that will execute the said stored procedure?

                    Thank you.
                    See more | Go to post
                    • Derftics
                      replied to MSSQL Profiler
                      in SQL Server
                      Hi,

                      Thanks a lot. You've been a great help....
                      See more | Go to post

                        Leave a comment:

                      • Derftics
                        replied to MSSQL Profiler
                        in SQL Server
                        Hello,

                        Thanks for the input. I have one more question, let's say that my database has the history of having a long run time and the problem was identified in 1 stored procedure but I want to make sure that I will filter all aspects that causes the long run time; is Profiler capable of activating itself whenever it reaches a certain threshold of long run time or is there something I could use for this kind of situation?

                        ...
                        See more | Go to post

                          Leave a comment:

                        • Derftics
                          started a topic MSSQL Profiler
                          in SQL Server

                          MSSQL Profiler

                          Hi everyone,

                          Please help me, I would like to monitor my database performance using MSSQL Profiler, what would be the ideal parameter that I would take in considerations and what are the baselines for the values.

                          Thanks a lot.
                          See more | Go to post
                          • Derftics
                            replied to help needed with update trigger in SQL Server 2005
                            in SQL Server
                            Hi,

                            Theres no problem with your script. I tried the multiple update in my database and found no problem with your trigger....
                            See more | Go to post

                              Leave a comment:

                            • Derftics
                              replied to Update Query
                              in SQL Server
                              Hi i have crated a script for you that you might use for updating. Im not sure if this is what you need cause your info above is incomplete. I have made your column ID as the link to the two tables and I assume that there are many records of QTY and COST in your TransDetail table that belongs to one ID.

                              select id, sum (Qty)QTY, sum(Cost)COST
                              into #sum
                              from TransDetail
                              group by ID, QTY, Cost

                              update...
                              See more | Go to post

                                Leave a comment:

                              • Derftics
                                replied to database transfer
                                in SQL Server
                                Hi,

                                I didnot understand your question, anyways I have a suggestion in transferring data from one database to another. Try using the DTS or the import/export tool of MSSQL....
                                See more | Go to post

                                  Leave a comment:

                                • Derftics
                                  started a topic MSSQL 2000 and MSSQL 2005 servers run in the same desktop machine
                                  in SQL Server

                                  MSSQL 2000 and MSSQL 2005 servers run in the same desktop machine

                                  Hi Guys,

                                  Is there anyone who have tried installing MSSQL 2000 and MSSQL 2005 servers in one desktop computer?

                                  I have tried using MSDE and successfully install the MSSQL 2000 server but when I tried installing MSSQL 2005, it allows only the client tools.

                                  I have revert the process and successfully install MSSQL 2005 server but now the MSDE was prompting me an error.

                                  Is possible to install...
                                  See more | Go to post
                                  No activity results to display
                                  Show More
                                  Working...