A full backup will reset the differential base, meaning diff backups cannot be applied to an older full backup.

Neither full nor diff backups truncate the transaction log, so you should...

p.beeke (4/18/2008)

---

CREATE PROCEDURE [DBO].[get_form_count] @return int output

AS

UPDATE form_count

SET form_count = form_count +1

I need to get the new form_count into the @return output param

I am a newbie and have not...

Not sure I fully understood what you want...

Here's a simple example of output parameters

CREATE PROCEDURE TestingOutput

@OutVar int OUTPUT

AS

SET @OutVar = 42

GO

DECLARE @a int

EXEC TestingOutput @OutVar = @a OUTPUT

PRINT @a

Does that...

What are you trying to open it with? SQL 2000's profiler won't open a trace file created with SQL 2005's profiler or server-side trace commands.

I tested and the error I...

Around here, I've found that either the recruiting companies or HR don't really know what the job requires, so scatter the add with buzzwords.

As far as I know, the smallest granularity for freeing the caches is at the database level.

Alter Index is only 2005 and higher. 2000 didn't have the command at all.

Not necessarily useless, just not of value for what you're doing. You can remove the starting event from the trace if you wish.

The client process ID is the ProcessID (from...

Are those from the Statement started events?

Those are logged when the statement begins. Since it hasn't finished, there's no duration, reads or CPU to log. Those are logged for the...

It's in microseconds on 2005, but in the profiler GUI it will probably...

Shouldn't cause any problems, unless you start tracing the very frequent events (object access, lock taken and such) but there's no need for that here.

The standard template is a good...

You've got 1 redundant index. Rest look OK. Depending on the queries, they could maybe be widened.

create index scanndx2 on scan(boxid,client)

create index Boxid_idx on scan(boxid) -- redundant

An aggregate with a group by will return the 1 value for each unique set of columns as per he group by.

In your case, it will return the max effective...

No replies here please.

Question has been reposted in the sQL 2000 forums

http://www.sqlservercentral.com/Forums/Topic486341-8-1.aspx

sp_executesql

DECLARE @SQLString nvarchar(500);

DECLARE @a int;

SET @SQLString = N'SELECT @OutVariable = bp_id from bug_posts where bp_bug=4648 ';

EXECUTE sp_executesql @SQLString, N'@OutVariable int OUTPUT', @OutVariable=@a OUTPUT;

PRINT @a