Grant Truncate Table Permissions in SQL Server without ALTER Table

How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.

ALTER

column & data type.

How to Drop Unused Empty Redundant columns

Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns

RE: Error 21776: [SQL-DMO] Error

You can check sp_helpdb to see if it is there. If it shows up there you might want to refresh your database list in Ent. Manager. Or even disconnect to the Server and reconnect. Good LuckChuck

RE: getting year from string

try this:SELECT substring(field,CHARINDEX('/', field)+1,4) from table

table name from variable

Hi all, I have this problem: I should make a script that open a table whose name is given dinamycally; so I tryed using a simple variable, but if i write a query like this:declare @tab varchar(20) set @tab = 'TABLE' select * from  @tabI get this error: Server: Msg 137, Level 15, State 2, […]

RE: Better way??

That worked much faster. It is now 4 seconds instead of 24. It seems I need to learn more about derived tables. I thank you very much.

RE: Problem with delete query across two databases

How many records are in each table? The main problem I see with queries using IN and EXISTS is the number of reads that are being performed.You could try the Non-ANSI double FROM,DELETE FROM database2.dbo.transactions del FROM database2.dbo.transactions del     INNER JOIN database1.dbo.transactions TR      ON del.oid = TR.oid 

Scrolling thru a large table to latest entry

Is there a simple way of going directly to the last line of a table, other than using the right hand scroll bar?yes   there is   two waysright click on any line and select 'last'  or..ctrl + end