Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)

  • RE: SQL Security

    Hi,

    Thank you for your reply.

    We don't have a QA environment separately. The Dev environment acts as the QA environment too.

    Thanks,

    Nsh.

  • RE: BI DBA

    hi,

    thanks for the tips.

    Natalie

  • RE: powershell email

    Hi,

    Will try out your suggestions.

    Thanks for your reply.

    Natalie.

  • RE: Career Growth for a DBA

    Thank you all for the responses.

  • RE: shortcut keys in sql server2005

    It works when a new query window connection is opened.

    Thanks!

  • RE: Scheduled Tasks

    Hi,

    Thanks for the link.

    Natalie.

  • RE: system table: sysdatabases

    Hi,

    It was restored - and it was showing null because the 'auto-close' option was selected.

    Thanks.

  • RE: stored procedure error

    Hi,

    After including version is not null (as per ur suggestion) - its working fine.

    Thanks a lot.

  • RE: logins

    Hi,

    thnx for the code......

    i came across another syntax too :

    declare

    @login sysname

    declare @dbname

  • RE: Dynamic Properties task

    Hi,

    Thanks - went through your blog link. I will try one following your example.

    Thanks again.

    Natalie

  • RE: command line/batch file

    Hi,

    Sorry i am still having trouble in getting my xcacls to work.

    Should the xcacls.vbs be download into a specific path....?

    I downloaded the xcalcs.vbs into this path: C:\Documents and Settings\UN\My...

  • RE: DOS related

    Hi,

    I want to view the existing permission of a folder and then set the folder permission through command line or batch file.

    when i use calcs "D:\Test"  in the dos...

  • RE: osql

    Hi,

    I have a test.sql - which contains about 4 stored procedure (create proc t1, t2,t3,t4) within it.

    I want to call and execute this through a batch file.

    so...

  • RE: DB Maintenance Plan

    Hi,

    I have the following code:

    declare @new_plan_id uniqueidentifier

    declare @new_command nvarchar(1000)

    exec msdb.dbo.sp_add_maintenance_plan 'System DB Maint',@plan_id=@new_plan_id output

    exec msdb.dbo.sp_add_maintenance_plan_db @new_plan_id, 'All System Databases'

    /* entry for max_history_rows field. */

    IF EXISTS (SELECT *

                    FROM msdb.dbo.sysdbmaintplans

                    WHERE...

  • RE: RTRIM

    I am able to receive the email notifications.

    It was just that i didnt have @From in my code....... guess all statements are required for the email notifications to get...

Viewing 15 posts - 1 through 15 (of 22 total)