That's often the easy way out... unless you like to search for a few hours to find the relevant information .

The "this person" link to a 404 page.

Nice article .

Glad to hear that .

Wanna see un-civilised discussion??

Why the hell do you guys keep use those damn identity fields as clustered primary keys when you have natural keys???

Let's see the kind of answers you...

Hehe, I guess that 5000 less query/hour will do that to a server .

Can't either... maybe your could search the newsletters, or use the search engine... You'd surely have a hit eventually.

I don't know the versions with 7.0

maybe this will return more info : exec sp_server_info

Select count(*) opens the table and counts all the rows.

EM uses the information kept in the sysIndexes system table. This information is not kept up to date 100% of...

Is this for reporting only? Or do the students can then modify that data?

How long does it take to run one of these?

Let me rephrase that... what data do you need to retrieve?

But I still don't know how to solve your problem... or if it's even possible.

And what's the problem you're trying to solve with that query?

He means when he's debugging a proc with QA (line by line execution), he wants to have those global variables added all the time by default instead of having...

One thing would be to use make this script the template :

Create procedure dbo.SpName

As

SET NOCOUNT ON

SET NOCOUNT OFF

Go

That way dbo would be the owner by default