Forum Replies Created

Viewing 15 posts - 76 through 90 (of 104 total)

  • RE: Finding logins in a group account

    Carl Federl (5/24/2008)


    There is also an extended stored procedure that can be used but the resource usage is substantionally higher than a distributed SQL to AD.

    exec master.dbo.xp_logininfo 'BUILTIN\Administrators','members'

    Nice one Carl.

  • RE: Finding logins in a group account

    Hi there,

    - Run 'compmgmt.msc'.

    - Expand System Tools & then local users & groups.

    - Select the groups folder.

    - Check the properties of the Administrators group.

    Regards,

    Lian

  • RE: how to stroe the text of an sp into a variable

    You can this:

    declare @input varchar(100),

    @id int,

    @helpText varchar(max)

    set @input = 'Your Stored Proc Name'

    set @id =(select top 1 object_id

    from sys.objects

    where [name] = @input

    and type_desc =...

  • RE: How do I know if the database log file is almost full?

    Thanks Gail. Just double-checked on my side as well... 56GB :blink:

  • RE: T-SQL to Perform Backups

    - In Management Studio, right click on the database.

    - Select tasks -> Backup...

    - There's a button called 'Script' at the top of the next screen that will create a...

  • RE: IT and Musicians?

    Never really thought about it that way.

    I occasionally play guitar & enjoy the break from using technology i.e PC's, games, TV, microwaves (:D) etc...

    But deep down I probably aproach...

  • RE: How do I know if the database log file is almost full?

    jeff.williams3188 (5/14/2008)


    The best way to shrink is: DON'T. Size your database and log files appropriately and expand them as needed.

    See: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

    Hi Jeff,

    Will backing up the transaction log not also...

  • RE: Shrink Database

    Is the cost of drive space higher than the cost of the database being offline?

  • RE: Shrink Database

    Gareth, you should be fine with either one. Just read up in Books Online for syntax etc.

  • RE: Shrink Database

    What's the size of the database? Transaction log file?

    You can create a job that backs up the transaction log, say, every hour... Depending on the amount of transactions, the backup...

  • RE: MCITP change - no recertification needed

    Nice... I'm writing one next week :unsure:

  • RE: Writing

    I'll only write on topics that I have experienced extensively.

    Being fairly new(1-2 years) to SQL also holds me back confidence-wise. I don't want to post/write something only to find...

  • RE: SQL Script Output to EXCEL - How?

    Steve Jones - Editor (5/5/2008)


    I'd suggest using the data export wizard, saving the package, and then adding the email task.

    Exactly what I did 😉

  • RE: Get datafile size

    Gordon (5/5/2008)


    When you add a datafile to an existing filegroup, the SQL server will balance the storage across the files automatically. It won't move old data to the new...

  • RE: SQL Script Output to EXCEL - How?

    Hi Dave,

    Have you tried using Integration Services?

    I did something similar & it's pretty reliable.

Viewing 15 posts - 76 through 90 (of 104 total)