Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to delete first couple of rows without knowing column name RE: How to delete first couple of rows without knowing column name

  • January 28, 2008 at 7:35 am

    #772413

    Ravi,

    It might be the DBA doesn't want to give that kind of access. But just in case the DBA really can't figure it out, tell him/her to grant you access to the BulkAdmin server role. Then you should be able to use Bulk Insert (assuming there are no other DENY permissions preventing you from doing this).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.