Forum Replies Created

Viewing 15 posts - 931 through 945 (of 1,137 total)

  • RE: Am I the only DBA

    Gianluca Sartori (9/8/2009)


    laptop: got one, company paid

    sql books: never seen one

    university: cs degree

    driving license: you must have it here to survive

    certification: I'm planning to take one, but I will have...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/8/2009)


    Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009

    My money's on the pigeon.

    only if it has go-faster stripes on its wings 😀

  • RE: Last Interview

    Ells (9/8/2009)


    I have only had a limited number of telepjone interviews. The last one was not good. We did not even start before it was over. The agency failed to...

  • RE: shrinking offiles

    yes you can do both. you can backup before you shrink if you want to.

  • RE: Server and DB Access with out permissions?

    rockingadmin (9/7/2009)


    i want to know how to give view db access to a user on his specific database.

    ex: In SSMS, If one user has a db owner permission...

  • RE: shrinking offiles

    ramyours2003 (9/8/2009)


    can we shrink the primary data file ?

    You can using dbcc shrinkfile to shrink a file.

    have a good reason though for doing it, as shrinking a database will result...

  • RE: How to Recover Data If Mdf File is Corrupt or Damaged

    When you get the answer, post it, i would be interested to know what you come up with 😛

    Had a quick look at what you suggested Gail, very interesting, nice...

  • RE: Are the posted questions getting worse?

    Nope no idea, i Prefer ROFLMAO, which is of course. rolling on floor laughing my arse off.

  • RE: Am I the only DBA

    Nice to know people out there are suffering as much as I am 😛

  • RE: backup

    Your welcome 😛

  • RE: How to get new tables to point to new data file

    jabba (9/7/2009)


    I have created a new file, that points to a different path than my other database files. How do I get the new tables I create to point at...

  • RE: backup

    charipg (9/7/2009)


    i want to take the backup of db,so then db sould be offline or online ?

    maybe I misunderstood your question.

    if the database is offline, you cannot do a backup,...

  • RE: spid

    charipg (9/7/2009)


    how to findout the what command excuted by perticular spid?

    dbcc inputbuffer(Spid_Number)

  • RE: backup

    charipg (9/7/2009)


    i want to take the backup of db,so then db sould be offline or online ?

    :-P, not sure maybe it is both...

  • RE: !! Online SQL Server ??

    if you are serious about learning, I would suggest you get a cheap laptop or netbook and do it that way.

Viewing 15 posts - 931 through 945 (of 1,137 total)