Forum Replies Created

Viewing 15 posts - 511 through 525 (of 541 total)

  • RE: Create 'Vanilla Database'

    Thanks Guys. Just need to fill in the blanks then (should only take me a week or two!!) 🙂

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 23, 2008 at 6:53 am

    #770876

  • RE: Administer SQL from XP Workstation

    Thanks guys.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 7, 2008 at 9:53 am

    #765424

  • RE: Orphaned Users

    Thanks Damon.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 29, 2007 at 2:25 am

    #763496

  • RE: Orphaned Users

    Hi.

    [Quote]You are missing the Logins[/Quote]

    How do I rectify or clear (purge)? Or maybe it is not a problem?

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 21, 2007 at 4:48 am

    #762048

  • RE: Orphaned Users

    You are right, just looked myself! It was not like that when I reviewed it locally.......honest!

    I will have another go.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 20, 2007 at 8:53 am

    #761785

  • RE: Orphaned Users

    Thanks for the response guys. Did you review the attached file?

    I will follow the links provided.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 19, 2007 at 2:54 pm

    #761601

  • RE: Email Notification

    Thanks Scott. I am the only DBA here (well plan to be with another course or 3 under my belt plus some real world experiance!!).

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 19, 2007 at 3:17 am

    #761326

  • RE: Email Notification

    Hi Guys. The 'Restart' did the trick 🙂

    So I now have a single Database Mail Profile + a single Operator. The email notification is quite basic but it tells me...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2007 at 1:35 pm

    #761217

  • RE: Email Notification

    Hi. Here you go:

    [Quote]

    Date,Source,Severity,Log ID,Message,Process ID,Mail Item ID,Account ID,Last Modified,Last Modified By,Plan Name,SubPlan Name,Task Name,Duration

    12/18/2007 15:36:28,,Unknown,,,,,,,,Clean Up Maintenance Plan History,Subplan_1,,00:00:00

    12/18/2007 15:36:28,,Unknown,,,,,,,,,,Clean Up History (SQL-MASTER),00:00:00

    12/18/2007 15:35:49,,Information,4,DatabaseMail process is shutting down,4496,,,18/12/2007 15:35:49,FERNAU\SQLSvc,,,,

    12/18/2007...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2007 at 9:58 am

    #761120

  • RE: Email Notification

    Thanks guys. I have now configured 'SQL Server Agent'. Do I need to define a value for 'Alias Local Host Server'. Reason, I have no value and notification still failing!!...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2007 at 8:24 am

    #761052

  • RE: Backup Order

    Thanks guys. The shrink database option was initially set up by the application vendor, although they are not SQL specialists (I do have one coming in January).

    I will have to...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2007 at 12:11 am

    #760903

  • RE: Backup Order

    One more question! I would like a maintenance plan to delete .bak & Log files older than say 1 week. Is this achieved via 'Clean Up History' 'Maintenance Plan...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 17, 2007 at 1:17 pm

    #760804

  • RE: Backup Order

    Adam many thanks for your efforts. The DB is not OLTP. I will make use of your advice as the project progresses.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 17, 2007 at 12:32 pm

    #760794

  • RE: Backup Order

    Thanks Adam I will take a look at the recovery mode tomorrow. Pretty sure they were set to Full unless the developers have been having a play!! I will implement...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 17, 2007 at 12:10 pm

    #760785

  • RE: Install Management Tools

    Thanks for the reply.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 12, 2007 at 4:01 pm

    #759636

Viewing 15 posts - 511 through 525 (of 541 total)