you'd need a declare @id int

select @id = scope_identity()

however I'm not sure how you plan on using this in DTS or your Execute SQL task. Maybe if you explain what...

Is the SQL Server running? Is the database open, meaning not set to autoclose. If there was no activity, and including system activity like backups, this could be the case.

Why can you not use Performance Monitor? Those same counters are what SQL Server would report.

You can try sysperfinfo. not sure if that existed in SQL 7.

Shared Memory should be for local connections only. You should be using TCP Sockets for your app.

I don't see the problem. You say queries are correct either way.

What does the data represent? Those numbers?

You might have better luck posting on an encryption forum or a newsgroup like comp.sci.cryptography.

Good idea.

Added one under "Career"

http://www.sqlservercentral.com/Forums/Forum1199-1.aspx

Sorry, I was thinking PSS was common.

If you're having possible corruption issues, I'd worry about hardware. There could be issues somewhere with the underlying hardware, always a little scary....

Not in Toronto, but not at a great cost, my company has training in Orlando, FL at End to End Training (www.endtoendtraining.com).

If you have enough people, we'll come out or...

LogPI got purchased by Golden Gate Software.

ApexLog is another one from Apex SQL.

I use decimal. It's simple, easy, and if we need to go to foreign currency later (and add a "type" col), I don't worry about it. Never saw the need...

If you are, I am too!

There's a lot of stuff in the forums I don't use. And I wish was gone. I prefer the simpler you ask a question, someone...

Different question, poor editorial control.

I make up the questions at various times, often based on what I'm reading or seeing at some time. I don't search through old questions, so...

Keith,

We use Instant Forums (instantforum.co.uk) for the site. It's done ok , we have the code to integrate it into our .NET site. However we have some scale issues and...

What should the default be? Should all PKs be non-clustered? It has to be one way or the other in the system and I'd like to think that whoever build...

Good to hear! I'll make an announcement to the rest of the site.