This check constraint should work also:

alter table dbo.MyTable

add constraint CHK__MyTable__MyDate_time_is_midnight

check ( MyDate = dateadd(dd,datediff(dd,0,MyDate),0) )

I don’t think there is much use for Application roles except for client server applications.

Most of our applications are web based and end-users do not have logins in the database....

Danster (7/24/2008)

---

There's nothing "at play".

I just like editing data directly in a multi-table view. It is fast, easy, safe (if you're careful) and convenient.

Usually it is to quickly make...

It’s not arrogant if you can back it up.

However, there are plenty of people that are arrogant that can’t back it up. An arrogant attitude is often a cover...

As for why it excludes the trailing spaces, who knows? It is working as documented in SQL Server Books Online:

"Returns the number of characters, rather than the number of...

The thing that no one ever asks (or answers) when a system is being implemented is “How long do we keep the data?” If you do get an answer,...

You might find a data model here that you can use or adapt to your needs:

http://www.databaseanswers.org/data_models/

This is a good article on how to avoid SQL Injection, even if you do not use stored procedures.

Always Use Parameters. Even if you don't use Stored Procedures.

http://weblogs.sqlteam.com/jeffs/archive/2006/07/21/10728.aspx

This script will give you what you want with SQL Server 7.0, 2000, or 2005. It gets the file information for every database on a server, and gives various...

That's really quite common. It's nothing to worry about.

Milliseconds/60000.

Set the database offline before you start the restore. That will prevent users from connecting to it.

use master

alter database MyDatabase set offline with rollback immediate

restore database MyDatabase...

You might find that it performs better if the server has multiple CPUs. I doubt that it will perform worse.

I would be more concerned about the hosting company. ...

It is really a dynamic process. You need to look at a number of metrics to understand what is happening.

[SQLServer:Buffer Manager][Page life expectancy]

[SQLServer:Buffer Manager][Page lookups/sec]

[SQLServer:Buffer Manager][Page reads/sec]

[SQLServer:Buffer Manager][Page writes/sec]

It...

Are you asking how to backup a SQL Server or Exchange Server?