more info on temp tables:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/1e068443-b9ea-486a-804f-ce7b6e048e8b.htm

it puts the results of the query into a temporary table name #d

I would also like to add that there may or may not be performance issues with doing this method. I personally will stick to best practices.

Really you are just telling SQL server to count a static value. SQL Server will think the 1 is a hard coded value put at the end of each row...

I dont believe ORACLE can use TOP, you must use the RowNumber, as you have.

Your query should look like this though:

SELECT TOP 1 X

FROM @test-2

WHERE accepted = 0 and...

This is a script I pulled from this site some time ago. It displays databases with no backup history and also displays the history of the databases that do...

This does not necessarily mean that...

Sounds like your Service Account does not have permissions to the share. Do you have the service account running under a local account or domain account? Go to...

The account should be disabled if the user has exceeded the maximum number of attempts. When the password expires or the account is locked SQL Server should disable the...

I cannot find a better article to demonstrate step-for-step instruction, but there should be a similar option in your version. Different versions may have different looking screens, but the...

Good addition Gail. 😉

This looks like the same post but under a different login. See my response in the other post.

http://www.sqlservercentral.com/Forums/Topic438596-146-1.aspx

Do you have a policy where if the user mistypes his/her password x number of times it locks them out?

Either the file is marked as read-only, or the file is truly in use by another process.

Carefully and patiently.

This is a tedious process, as it requires careful planning and implementation. You should first design your data mapping strategy. The most difficult part of this...