Here is the script to find out last ran queries on sql server 2005

----------------------------------------------------------------------

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]

FROM sys.dm_exec_query_stats AS deqs

...

There must be some uncommited transactions are there in your database. After you did truncate only wait some time....the transactions will roll back and it will clear some space for...

I am sorry I also forget to mention this....

I tried

select * from dbo.emp

select * from dbo.EMP

select * from emp

select * from EMP

but it gives the same output like this...

Msg...

Adi

Answers:

1) I get same behavior for all the sessions by sql ids as well as windows authentication id that have all the permission..i also tried with "sa" user.

2)...

table names are,

emp

msa

reports

users

users_groups

users_groups_rel

xref...

etc..etc..etc...

on sysobject it is having name as tablename not as [tablename] or "tablename"

I forget to mention that it also works if we do select * from "tablename"

No it is not a reserved keyword...It is same for all the tables on a particular database.

Dude...read one book on sql server 2000 administration, one book on 2005 administration and one book on T-SQL.....You will be good to go....but most importantly develop interest in this subject...read...

Whatever step you want to run at a time....

on that step...

edit...goto advance tab...set following two options

on success action.....quit the job reporting success

on failure action.......quit the job reporting failure

Thanks all for your replies and very informative links...Let me try them and I will let you all know the result..

This is a great link...i got one sql server 2005 dev. edision for myself...

Thanks

I have a problem with sql server 2005 maintenance plan for Check Database Integrity task...It is getting failed and gives the error that you have to set quoted identifier value.....is...

It seems that in your application there are many open transactions by times i.e. it is a very busy database. What you need to do here is create a job...

Here is a script to reindex all user tables in a SQL Server (all databases)

----------------------------------------------------------------------------------------------

declare @dbid int

declare @reindexdbcommand varchar(128)

declare @ServerDBs table(dbid smallint, reindexdbcommand varchar(128))

insert into @ServerDBs (dbid, reindexdbcommand)

select dbid,...

Thank you Sir....I really appreciate