Hello. How would one go about granting Truncate permssions to a few
specific user tables in SQL Server 2000? As far I've read there doesn't
appear to be a grant option in giving a user truncate permissions so would
it be assigning this particular user to a fixed database role like
db_ddladmin? I just want to give this user the least amount of privileges
within in our db in not being able to perform truncate operations on any
other user or system tables.
Re: What is going on??? Error 834, Severity 24, State:1etc ... that dbcccheckdb always gives consistency errors only on ... >I support the Professional Association of SQL Server... The only difference between night job... while the night job truncate and ... (microsoft.public.sqlserver.server)
Re: What is going on??? Error 834, Severity 24, State:1etc ... Truncating the table while another processis running should NOT corrupt the ... Wayne Snyder, MCDBA, SQL Server MVP... while the night job truncate and then ... > on a table while ArcServe is backing datafile up to tape ... (microsoft.public.sqlserver.server)
Re: Large table structure ... >> Tibor Karaszi, SQL Server MVP... >>> Got a database in from a client that surpasses the 2 gig limit. ... >>>> Tibor Karaszi, SQL Server MVP ... >>>>> you truncate the table it's ... (microsoft.public.sqlserver.server)
Truncate all tables in SQL Server db ... this will truncate all the tables in your database.... >I'm moving VB 6 project from Access to SQL Server.... then to run DTS to ... (microsoft.public.sqlserver.programming)
Re: Insert Into Without Log ...transaction log.... For instance a truncate can be rolled back if it is within ... Looking for a SQL Server replication book?... > "Hilary Cotter" ha scritto nel messaggio ... (microsoft.public.sqlserver.fulltext)
