Forum Replies Created

Viewing 11 posts - 16 through 26 (of 26 total)

  • RE: Replication issue....STAT!!!

    is there only one subscriber to the published database?

    did you drop replication from the publisher or the subscriber?  right or wrong, i've had to script (dropping AND creating) replication at the...

  • RE: SQL Agent puzzle

    Thank you for your responses, gentlemen.  I resolved this issue by configuring a new login, making it a member of the sysadmin server role, and then making it the owner...

  • RE: SQL Agent puzzle

    Interestingly enough, through the 'New Login' dialogue, I can search for and find 'MachineName\SQLServ'.  However, when I click 'OK' to create the login, I am treated to an error message...

  • RE: SQL Agent puzzle

    Thank you for the suggestion, Russell.  I can send a test email from the properties of the SQL Server Agent.  Nonetheless, I logged in to the machine where my SQL Server...

  • RE: SQL Agent puzzle

    Thanks, alzdba, but I've tried that, too.  No dice.  I understand it's proper to fully qualify things, but this job runs in the context of the AIS database.

  • RE: SQL Agent puzzle

    Select @@ServerName returns [MachineName], not [FormerMachineName]

    MyDomain\MyWindowsAccount is SA, it has access to the AIS database.  I can SELECT from the AIS table, and the view, when logged in as MyDomain\MyWindowsAccount.

    Thank...

  • RE: DBMail riddle

    Nevermind...  You have to have SP1 applied to the x64 edition to make Database Mail work.

    http://blogs.msdn.com/sanchan/archive/2006/04/23/581639.aspx

    "SQL Server 2005 RTM x64/IA64

    In SQL 2005 RTM x64 and IA64 bit versions, you...

  • RE: Sending SQL notifications with CDOSYS

    do you use Microsoft Outlook?  i'm using Outlook 2003.  if you are using Outlook, try selecting 'Tools' from the toolbar at the top, then 'Email Accounts...'.  From the wizard that...

  • RE: Access denied error while doing DrillThrough in OLAP

    could you please let us know what the user is accessing the OLAP cube with?  Excel?  i have experienced and solved some pretty funky errors generated by users accessing our...

  • RE: TurboCert Question

    I used books published by New Riders and braindumps (free websites offering recently tested individual's accounts of the subject matter tested) to earn my MCSE\MCDBA.  I was poor and ugly before...

  • RE: bulk insert fails when used with unc path

    Please let us know what error message says.

    Are the database and the format file both on BISMALLAH?   

    If no, then can you access \\BISMILLAH\bulk\format.txt from another computer?  You may not...

Viewing 11 posts - 16 through 26 (of 26 total)