Ther has been a known issue with using SELECT INTO into temp tables with regular SQL and may apply here. Try Create Table for the temp table then use INSERT...

Well there are all kinds of ways to do this. Can you be a lot less vague. How do the tables relate, the data fit in the new table and...

What does the stored procedure do? If it touches something outside of the SQL Server then the account Agent is running under sounds like it doesn't have sufficient permissions.

"Don't roll...

In your DTS import you can specify the target table which unless you built will build for you. Using the Import/Export Wizard, when you get to "Select Source Tables and...

I have not noticed this but there are some changes in the way 2000 does the backups that may compress a bit. However if you are saving to file you...

First it depends on how you perform them. If the the maintainence wizard or thru EM there are options for that you can choose or fill in. if thru BACKUP...

Here is another list

2000.8.00.534 SQL Server 2000 SP2

2000.8.00.384 SQL Server 2000 SP1

2000.8.00.194.0 SQL Server 2000 "gold" release, no SP

7.00.623 SQL Server 7.0 "gold" release, no SP

7.00.677...

If they cumulative then they are. SPs genrally are all cumulative. The other three do not mention a relationship between each other and most likely are not cumulative. But...

I do believe the answer is no. We tried ourselves and never found a way.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Preferable if you want to get maximum performance for writes then use a RAID 10 array (more costly but well worth it).

Also having each DB on it's own array or...

Try this.

--SNIP--

BrowseSP

(@searchIn varchar(1000),@bool varchar(3))

AS

SET NOCOUNT ON

DECLARE @search as varchar(3000)

DECLARE @strPos as int

SET @search = ''

SET @searchIn=ltrim(rtrim(@searchIn))

SET @bool = ltrim(rtrim(@bool))

SET @strPos=charindex(' ',@searchIn)

WHILE (@strPos > 0)

BEGIN

SET @search = @search +...

Take a look here. http://www.aspemporium.com/aspEmporium/help/helpsys.asp?PRB027

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Forward all the chain email you get back to everyone on the list of the people who sent it to you with the standard proper email use message, but add...

Either, or. Doesn't matter. Some folks I know prefer to use the numbers on the base keyboard and the keypad is for the mouse keys. Personally I prefer the keypad...

First with if a column that is part of a clustered index is updated then all indexes are updated so if you have 15 indexes it will take a...