the [] are commonly used to negate SQL keywords.

say you had a column in a table called object_id, to reference it as a column and not a keyword is like...

this link covers logon triggers

http://technet.microsoft.com/en-us/library/bb326598.aspx

you could have the trigger check the client_host event data using the eventdata function for a known set of addresses and deny logon that way!

of course...

do you mean deploy a database using a windows form or deploying sql server express using a windows form?

to attach the database, copy the files to the desitred location and use the following T-SQL

sp_attach_db 'dbname', 'drive:\path\filename.mdf', 'drive:\path\fiilename_log.ldf'

oh OK. There are advantages and disadvantages of both, the following link details rebuild vs drop and create

http://msdn.microsoft.com/en-us/library/ms189858.aspx

couldnt agree with you more

i seem to remember this. The first release MS made of SQL 2005 SP2 had a bug with maintenance plans. Get the latest version of the SQL 2005 SP2 and...

thats the way i understood it to be

in perfmon under Memory check "available bytes" too.

i could be wrong but i get the feeling he was trying to achieve it without the use of a cursor

BOL implies this is done on a transactional basis not a time basis?

SET @DBName = ''

WHILE @DBName IS NOT NULL

...

check this info on recovery interval option

http://msdn.microsoft.com/en-us/library/ms191154.aspx

checkpoints occur for a number of reasons

what are you shrinking data files or log files

SQL server will not shrink past an active portion of the file, if that happens to be near the end of the...

or choose script to new query window then close it and save as .sql script