You need to create the table with the primary key first (the table that the foreign key references).

Steve

When you do your full restore, use the "WITH NORECOVERY" clause.  This leaves it capable of restoring a log backup.  The log restores should use the "WITH STANDBY" clause which...

Try this -

declare @text varchar(100)

set @text = '12356 Square 1/2 inch Washer'

select substring(@text, 1, charindex(' ',@text))

--Steve

If the application is a third party application, I think I'd be checking it to see if they're trying to do your job.

Steve

OK, if you've removed the truncate_only from the proc, we have the critical issue taken care of.  Yes, with the truncate_only removed, you now have full recoverability.

There is, however, another...

Fred,

Your running the ShrinkLog proc every three hours?  Its doing a BACKUP LOG WITH TRUNCATE_ONLY.  If you do a truncate_only, your NOT backing up your transaction log, and therefore, cannot...

Fred,

Are you running FULL backups every 15 minutes to try to keep the logs from growing?  If so, that won't work.  Full backups don't truncate the logs.  Only a transaction...

Umm, you could write a TSQL script to do the search!

Steve (almost afraid to sign this one!)

Here's a script you can use to delete backup history.  I have it set to delete history older than three months, but you could modify it for whatever length of...

I just skimmed through this thread, so if this was covered, I apologise.  I wonder if the problem might be with TIME rather than the date.  The datetime data type...

You should be able to treat it just as though you were typing at the command prompt, ie

just enter the name of the batch file with or without the ".bat"...

Don't remember where I got this, but chances are pretty good that it was here.

Steve

CREATE PROCEDURE sp_diskspace

AS

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE @TotalSize varchar(20)

DECLARE @MB...

I can't say that Arcserv hasn't got the bugs worked out of their SQL agent, but we were using it on a large database, and discovered in a disaster recovery test,...

Considering that handing out the SA password to users/developers, etc, is a serious security risk, I think I'd tell them that I will create them a new id with the...

Enterprise Manager is notorious for not refreshing information unless you explicitly refresh it.  Don't have time right now to test it, but I figure if you refresh the database, and/or...