Forum Replies Created

Viewing 15 posts - 151 through 165 (of 347 total)

  • RE: Why become a DBA?

    I forgot one things... sorry.  To be available for on call 24X7.  Well here we have a team so I am not on call 52 weeks a year.  I used...

  • RE: Why become a DBA?

    Like I said it all depends on your situation and of course perception.

    I hope I didn't get into your way.  If I do let me know I'll walk out of...

  • RE: Attach DB - Network Device Not Supported?

    Have you tried to copy the file from the old location and move it to the new location before trying to attach it?

     

    mom

  • RE: xp_sendmail and SQL 6.5

    Does the service account for sql service the same as whatever the account you use to login and send email via outlook?  It should be the same.

     

    mom

  • RE: Why become a DBA?

    Because I like to be GOD

    I like my job as dba because I want to take time out from doing day to day development. ...

  • RE: dropped a TEXT column, Filegroup remains large.

    Before you drop that column, did you find out how many of the email has attachment?  Sometimes it is true that you don't have that many attachments, thus not saving...

  • RE: Table Population

    I would think most jobs stored command and it is in text.  I don't think you can match it up to that level of detail info.

     

    mom

  • RE: Resync Dbo

    have you try to reset dbo first to sa and then back to the old dbo's login?  This usually works for me.

    exec sp_changedbowner 'sa'

    exec sp_changedbowner 'userlogin'

     

     

    mom

  • RE: sql service does not start

    Did you put back the permission on the disk correctly to allow the sql service account full rights?

     

    mom

  • RE: Need to run a sql script each 10 minutes

    I have stuff run all the time say every 15 minutes of every day to check something using sql agent schedule task.  Why would it be hard in your situation?

     

    mom

  • RE: The Case for GUIDs

    I think everyone is losing the point about using GUID on sql server...  I have a problem with this before because one in 20 milion or so I got duplicate...

  • RE: Wrong Edition Installed

    I have downgrade from Enterprise to Standard I would assume it is the same step.

    The key question is how much time do you have to get it convert?

    I would calmly...

  • RE: Which is higher status in your company - DBA or developer?

    Obviousely DBA are much more experience then developer.  I used to do development work on my first job.  But as years went by I outgrow into DBA.  Being DBA you...

  • RE: SQL Service won''''t start

    You got a broken path by deleting file from your server.

     

    'my computer' right click->property-> advance tab ->environment variables->system variable section-> look for 'path'->edit

     

    copy and past your path to a note...

  • RE: SQL login issues

    I think the problem is the fact that your login has a default database that the user has no access.  The best practice is to have all login default to...

Viewing 15 posts - 151 through 165 (of 347 total)