hashing the password is quite common and is usually required to pass security audits.

Does your program need to see the plain text passwords to work correctly?

I am not sure i fully understand, do you have an application that was written by another company and have they sent in an engineer to change it so...

setup a test db and then apply the recomendations one-by-one and test the performance gain you get and then see if you are happy.

no one can tell you whether or...

I dont see how people are saying this is dangerous, from looking at his code he does put Order by on each of the select statments so the data...

torpkev (9/14/2010)

---

My biggest annoyance with sa - quite outside of this discussion - is those people who use sa to connect to the database because they don't know any better...

There is something on your production server running that is trying connect, reinstalling the virtual server wont solve this, check the production server for agent jobs that may be...

in SQL 2005 you can change the logging options to log all successful and un-successful logins by click on the security tab under database properties.

To see who is currently...

torpkev (9/14/2010)

---

Less chance someone will try and access your system with some different named account rather than sa.

If you have the user sa active, then if I got access to...

I must have missed that second post.

It does seem like a permission issue, perhaps with the account IS is running under.

What service pack are you running?

what sort of maintainence plan are you trying to create?

I thought this article seemed very familiar..

Yes that is the current advice, start with one and monitor the tempdb for i/o issues and if needed add more.

As long as he got what he wants then i am happy (and confused)

I would like to see the code for the solution though and it may be useful for...

Do you have a primary key ? if not then it is not a table is is called a heap and makes the query a lot more complex and...

You shoud run the script on serverB (restore server)

and you wont need to create the database beforehand

you just need to ensure that the file path

E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

exists on...