Again, the old answer..... It depends

For a website app, SQL Auth with a login that has no permissions. For a users login, Windows Auth. I mean, you are not going...

You can update the data in the column

UPDATE <TableName>

SET <ColumnName> = ABS(<ColumnName>)

Read the SQL Books Online for all the database and function syntax.

I would highly recommend that you use SSMS...

Yes, you are correct, My fingers are flying faster than my tiny pea sized brain is processing.

Andrew SQLDBA

You canot have only SQL Auth, you can have mixed mode, which is Windows and SQL Auth. Log into the database using Windows Authentication. Of log into Windows as someone...

It's worth it to me. I really do not like what some fool named this instance

Thanks

Andrew SQLDBA

Differential backups would be taken on a daily or multiple times thru the day and night to accommodate that if a failure were to happen, the database and the data...

You need to think about the maintenance of the database. With a shared database server, the database will reside on a database server with others. There are no issues with...

I never use a third party tool when working with SQL Server, it can just about anything, and it can sure handle copying a file across the network to another...

I use caution when coding, but it is really just a matter of using your best judgment. Once you look at the SQLDTS site, you will see that it is...

SQL DTS is very simple, and you use VBSCript as your coding language. All you have to do to create a function to move a file or delete a file,...

I use SSIS for everything. There is just about nothing that I cannot do. Especially with SQL 2005. I can move files around, create directories. You can also do the...

For only that many records, enter them by hand. You could have been finished by now. Or better yet, get the person that did not perform their job correctly to...

You stated that you are using Access, but you keep mentioning SQL Server. How many actual databases are you using? And why?

If you are using SQL as the back-end database....

Thanks for the info Gail.

I know that I had everything in Full Recovery mode, maybe I changed it for the demo. Been over a year now, I cannot remember that...

I was at the understanding, and have tested this, that once the data is committed to the database, that is can be removed from the transaction log. I was able...