1) how to check sort order in collation setting?
2) How to change sort order to Binary?
from sweelian

The transaction log backups of my two databases are usually very small.  
But, at midnight or 1 AM, they are huge.  Why is that?  Is it because I have
full backups running at 11PM.
childofthe1980s

I configured two SQL 2005 backup jobs--one for the data files and one for
the transaction logs.
An IT person says that I should configure these automated maintenance plans
to have the backups overwrite rather than append.

We have a problem with Web app that uses a SQL 2005 DB -
error= "Invalid object name 'tblCustomer".
This happened after the Domain name the SQL Server resides in was
changed.

I am learning sql and joins.  Let me know if this looks right, or how
it can be improved:
I have playlists that contains songs.  My query is to return the name
the first song in each playlist.  However, the songs are in different

For SQL Server 2000 I was able to run a script that looped over all messages
and performed the following action:
exec master..sp_altermessage @err, 'WITH_LOG', 'true'
This no longer works on SQL Server 2005 and gives the error message:

I have a problem that I need to be able to take care of fast if possible.
I've developed an app in VS2005 and its ben working fine until the last few
days. I beleive someone is purposely deleting data out of the database and
I'd like to setup a trigger to log the person how is ...

What is the standard collation to use when setting up a migration from SQL
2000 to a SQL 2005 server?
I had some issues with the text from a migrated database requiring the SQL
Collation statement to be used in all joins between two databases on the same

In the current installation of SS2005 that I have, I'm unable to locate the
DMV's.
Under [master] - [Views] - [System Views] - the usual system views like
sysconstraints, syslogins, etc.. and information_schema.* views exist.

a) I'm pretty new and "high level" as a DBA.
b) I'm working with a multitude of db's that have either been created
by others or most likely migrated from 2000.  We had many developers
gripe that CDW didn't work for them and they were unwilling to correct

I had to change the service account logon of MSSQL SERVER and SQL SERVER
AGENT to a new domain account.  Everything worked fine except SQL Mail did
not function.  I created new Mail Profile in Control Panel-Mail but could not
change it in SQL Server - Support Services and SQL ...

I want to run database on removable Disk. I have formatted the flash
drive in NTFS and copied mdf & ldf to flash drive. I attached the mdf
and ldf. My application runs fine but my problem is sometimes my
application gives error, I/O error. There is no password protection or

I've got SQL2000 installed on my web server.
Due to one of the previous employees in-experience, we've now got
close to 900,000 thumbnail images in one directory on the webserver!
They are all 'jpg' files and less than 4kb in size.

I had a database that was in 2000.  We upgraded to 2005.  We restored
the 2000 DB in 2005. These tables linked into an Access 2000 front
end. While we were on SQL 2000 all worked fine.  but now that we've
upgraded several of the tables show #NAME? when I open them.  I tried

Im looking for an app that can help me monitor the performance, number of
connections , execute time in SQL server standard 2005.
Im running windows perf mon + sql profiler looking for large running
queries. Any other thrid party tools that may help me ?