Can a User with dbcreator server role drop the databse ?

Ohh Thank you so much.

Users in ddl_admin role can not edit tables through design mode(GUI) but they can do using sql queries?

is this how SSMS works which we cant change?

any comments

But can a non DBA do this ?

Jeff , could you please breif me about non declared cross join. how could i declare in my query?

I dont think i cna bakup a database which is in single user mode. i get this error

Msg 62309, Level 19, State 1, Line 0

SQL Server has returned a failure...

But iam dealing with 150 databases from one server to another.

If i put singloe user before backup and restore on another server , the destination server will resotre in single...

Ok. After trying to execute the query by part only this part of the query is taking too long

empcode between '99201' and '99205' or empcode between '99211' and '99215' or...

Also tried taking NOT LIKE off the query and executed but still the same time.

is there any other way i can query to get the same result ?

Actually i am looking help to create indexed views or any type of views that can be created on fly during query execution and so i have given my existing...

any idea how to start with ?

what i mean to say is in my table where i save all trace data more than half of the total records has NULL for textdata column.

but unfortunately text data is not captured in all events, i say NULLs in most places for textdata.

Has anyone already implemented this kind of audit in sql 2005 to find out when a db or object is read/write/updated ?