Forum Replies Created

Viewing 15 posts - 211 through 225 (of 312 total)

  • RE: Report Filter: Summary of Detail level

    Thats pretty much what I'm trying to do, although I'm not 100% on how to go about it.

    If you take a look at the attached screen shot, I have a...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 17, 2009 at 2:15 am

    #1080101

  • RE: Why is SQL Server lying about the backup duration????

    Hi,

    Yeah, I done it about 4 times. But backups to a UNC are accurate and repeatable

    We do have 2 processors on the server - both the same spec, so...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 30, 2009 at 4:31 am

    #1073014

  • RE: Error trying to display Properties is SSMS

    That worked. Thanks again JL 😀

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 20, 2009 at 2:17 am

    #1068015

  • RE: Error trying to display Properties is SSMS

    Thanks JL - I've give it a go

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 20, 2009 at 2:02 am

    #1068011

  • RE: Transaction log queries

    1. Yes, I believe it is more of less real time.

    2. Yeah I would. Try to manage the log file size by doing sensible backups, and if you...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 14, 2009 at 5:44 am

    #1065601

  • RE: Restore the backup from appended .bak file

    Hi Clive,

    I'm setting up backups for an SQL 2005 Database.

    My backup plan so far is:

    1. @ 4am - Create a a full backup to C:\backups\{dayName}\MyDB.bak

    2. every 4 hours from 8am...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 14, 2009 at 4:38 am

    #1065575

  • RE: Transaction log queries

    1. Transactions are committed when the database command 'COMMIT TRANSACTION ' is submitted, OR after an implicit transaction completes (http://msdn.microsoft.com/en-us/library/ms188317(SQL.90).aspx)

    2. You can fix the log file size to...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 14, 2009 at 4:11 am

    #1065564

  • RE: mirroring: two instances, one machine

    t-jonat (8/19/2009)

    hello all,

    i'm trying to set up mirroring between two databases that are installed on two different instances of sql server on the same machine.

    Hi,

    Quick question about setting up...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    September 14, 2009 at 6:21 am

    #1053128

  • RE: SSIS & WMI Data Reader Task Query

    Sorry, your perfectly right, the FELC for step 6 should be on the control flow screen. Bit of a typo I'm afraid. If you get any other problems then let...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    September 14, 2009 at 2:35 am

    #1053007

  • RE: Installing SSRS on Developer edition

    I'm running Windows Vista Ultimate, so I'll check the windows features. I think that is where the problem is as I have IIS installed

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    September 3, 2009 at 2:35 am

    #1048579

  • RE: SSIS & WMI Data Reader Task Query

    Thanks 😀

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    September 1, 2009 at 5:38 am

    #1047419

  • RE: File watcher task question

    well, I don't really want to limit myself - my question is more - from yours (and others) experience do you get issues with some of these additional components and...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    August 3, 2009 at 7:33 am

    #1033638

  • RE: File watcher task question

    For those of you who have implemented this File Watcher Task - do you think it's better to use this file watcher task or go with the standard wmi watch...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    August 3, 2009 at 6:06 am

    #1033601

  • RE: Active Directory LDAP Query via a Linked Server

    Works a treat - thank you.

    Do you mind me asking, if you know the anwser that is, Why does it use single quotes??

    I wrongly assumed it would appear that...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    July 14, 2009 at 7:33 am

    #1024395

  • RE: Query LDAP server from SQL Server

    Hi hopefully someone can help me with this as well.

    as above, I'm trying to query my LDAP server.

    This is what I have setup:

    I have access to our Active Directory and...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    July 9, 2009 at 8:12 am

    #1022388

Viewing 15 posts - 211 through 225 (of 312 total)