its working using alt+shift not alt.

well i got only error.

safe way is select power(2.0,31)

Just look at here

http://www.databasejournal.com/features/mssql/article.php/3379901

Thanks

Amish Shah

Hi

You can do like this

select count(*) from tempdb..syscolumns where id = object_id(<temporary table name&gt

Thanks

Hi

you can also use

Set your recovery model to simple.

run the following

Backup log <dbname>  with no_log

set your recovery model to full

backup your database immediately.

Thanks

Amish