John,

A transaction log file is like a bucket.  If the bucket gets full, you don't have to throw it away and get a new one, you just empty it.  If...

Antares686,

You are absolutely right.  Thank you for catching that!

Steve

You must start SQL Server in single user mode to restore master by using startup parameter '-m'

Steve

This should speed it up (assuming views 2 and 3 have the same selection criteria as view1) ...

CREATE VIEW dbo.else_vw

AS SELECT UnlockID, dbo.TrimUser(UserCode) AS UserCode, ExpiryDate, Frequency, Attempted, LastAttemptDate,...

I would use a computed column for that.

create table #sales

 ([id] int,

 item varchar(30),

 cost money,

 quantity int,

 total as cost * quantity)

insert #sales

 values (1, 'widget', 1.99, 6)

select * from #sales

--...

I don't think you'll get around the multiple log files issue using a restore.  You'll either need to use your scripts to load the initial db as well, or what...

If the table has a clustered index, just rebuild it.  If not, create one, then you can drop it.  The data is stored in clustered index order, so building or...

How many 'I B M' s do you have?  Can you do a visual check to be sure no

' SANDI B McCOY ' or ' I B...

Several years ago, we were using Arcserve to backup a 60GB SQL database on one of our servers, not my idea and I protested it at the time.  It so happened that...

You can register a 6.5 server in 2000 EM, you just can't connect and manage it.  You will at least be able to see that the server is running.

Also, You...

Carl,

Here's a script that I already had in my archive.  It goes the other way, but you should be able to tweak it to get what you need.

Steve

declare

 @date  datetime,

 @num int,

 @result int,

 @txt2 varchar(9),

 @txt1 char(3),

 @txt3...

Here's a snippet from Brian Kelley's article from yesterday, "SQL Server Auditing - Part 1".

DECLARE @AuditLevel int

EXEC master..xp_regread 

  @rootkey='HKEY_LOCAL_MACHINE',

  @key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',

  @value_name='AuditLevel',

  @value=@AuditLevel OUTPUT

SELECT @AuditLevel

Brian is talking about retrieving...

No, the only backup that truncates the transaction log is a transaction log backup.  You'll be ok doing fulls and diffs.

Steve

Not an hour before I read this article, I was staring at a script in query analyzer, trying to figure out how I was going to import the current SQL error log...

Perhaps I'm missing something.  Why would your log shipping fail when your full b/u kicks in?  The log backups will still be in sequence, as a full backup does not...