If you want to do transaction log backups, turn off the SELECT INTO/BULK COPY option.

Use this to start at 00:00:01

where createdatetime between dateadd(dd,datediff(dd,0,getdate()),'00:01:00.000') and getdate()

Are the references to other databases to tables and views in other databases, or to stored procedures in other databases?

If they only reference tables and views in other databases, you...

This works with SQL Server 7, 2000, and 2005:

if exists ( select * from master.dbo.sysprocesses where  program_name like 'SQLAgent%')
begin print 'SQL Agent running' end else begin print 'SQL Agent not...

This command will disconnect all users of the database and keep them out.  Once the database is offline, no one can connect to it until you put it back online.

alter...

I don't understand why you have a group by clause in the subquery.  It will fail if it returns more than one row anyway, bacause you can't assign more than...

The second link only applies to SQL Server 6.5.

I am fairly certain that the problem is what I said it was in my previous post.  When the database is in...

"In the presence of an appropriate index, DClark's method and the following method both work at about the same speed and both do the same thing functionally...

 DELETE...

Maybe I am mistaken, but I thought that the procedure cache was an in-memory only set of data that is shared by all databases.  In that case, I don't think...

You cannot restore a database, make changes to it, and then do additional restores that leave those changes in place.

You cannot do any changes to the database until you do...

You should use the universal date format for date strings in SQL Server:

YYYYMMDD HH:MM:SS.MIL ( Example: 20061231 23:59:59.997 ).

If you are after data for June 13th and 14th,...

A likely cause of the problem is that is that you don't have indexes on foreign key columns.

When deleting from a table that is referenced by a foreign key, SQL Server...

As long as the database is in Full Recovery mode, the transaction log will continue to grow until you run a transaction log backup.

You can setup scheduled transaction log backups...

Deleting based on the latest identity value does not take into account the possibility that rows in the latest 50 have been deleted, or that the identity seed was incremented...

A table with 2 million rows is fairly trivial and commonplace.

The other design, with a table per customer, will be a source of endless problems.