I haven't worked in Access for so long I can't remember anything about...

I hope you're going to make that password a little more complex in production.

Your syntax is completely incorrect.

Update TargetTable

SET TargetColumn = SourceColumn

FROM TargetTable INNER JOIN ....

What do you mean by "performance is slow"

Is this normal, or is the server unusually slow?

Have you made any changes recently?

Are there more users than normal?

Is there excessive blocking?

Are you...

If you are using SQL 2005, rather use the sys.dm_exec_sql_text than inputbuffer.

Look up the EncryptByKey and DecryptByKey functions in Books Online.

Username is typically a very bad choice for a clustered index. It's wide, it's nowhere near unique and it's not ever increasing. LOG_DATE_TIME may be a good candidate. Still need...

Did you read the links that Pradeep provided?

DBCC TRACEON (1222,-1)

The -1 turns it on globally. Without that the traceflag is only enabled for a single session, the one that turned it on. Since deadlocks are detected by...

Never. The log is truncated on a checkpoint, meaning the inactive log records are discarded and the space made...

I haven't seen this for a while.

http://www.sqlservercentral.com/Forums/FindPost621760.aspx

Um, no. SQL will take what CPU it needs.

when we are taking the...

Is that in the AM20 database?

You gain points by posting (1 per post) or by answering the Question Of the Day correctly. Usually between 1 and 3 points

Forum Newbie - 0

Grasshopper - 10

SSC Rookie -...

Since you're on 2005, join to sys.tables. Only user tables appear in that view.

sysobjects is deprecated in 2005 and above and will be removed in a future version.