This is part of a script that has the set statement and then the execute statement.

set @sqlstring = ('dbcc checkident '+@tab_name+')')

exec (@sqlstring)

Let me know if you need more detail...

You could limit the BUILTIN\Administrators login permissions by removing it from the System Administrators Server Role. This will clear your problem.

I personally would be wary of removing the login...

Joe,

Just out of curiousity, are you opposed to upgrading to SP3?

There is much value to the upgrade and not just in the fact that DTS between 7.0 and SQL...

If you are getting an error when you try to open it then, the only way to get past this is recreate the package on the 7.0 machine.

Steve mentioned...

My guess is that you are not running SP 3 on the 7.0 box. When you upgrade to that service pack, it will recognize the SQL 2K created packages.

Hope...

Thanks for the reply and the link. I had already found it a downloadable format at http://www.microsoft.com/sql/techinfo/administration/2000/RDBMSPerfTuning.doc and was already reading the information. (Sorry, should have posted earlier...

I hate to ask the stupid questions but, can you see the drive external of SQL Server and if so, can you write to it?

I have to agree with...

Steve,

I hate to pick your brain too much but, do you remember where you read this. I am looking into this as a possibility for performance improvement and if others...

Works for me. Can you give other details about the login (i.e. is it permitted use in any database, what roles are assigned to it), the version of SQL Server...

First thing to do would be to read up on restore in Books On Line. A basic script would look like the following;

restore database YourDB

from disk = 'f:\backup\YourDBBkUp'

The path specified...

Joe,

Not recommending any product line here but Compaq has a sizer utility that can be pretty handy. You would be best suited running this yourself as you can answer the...

You guys keep using words like "process" and "QA". I thought I was an english speaking citizen of the US but, I haven't heard those words before.

Call me picky but, easier is not always better. While the wizard provides a quick way to do general maint, it does not force one to really consider what they...

Brendan,

How much memory is being utilized with the 80 concurrent users? You may want to troubleshoot this further by looking at the user issue further. You touched on the fact...

Brian,

Great article and I agree, hybrid is the best way to be to ensure job security today. I too have walked into an environment which demands that type of...