When you enable the other network protocols you meust restart the sql server service for this to take effect so once the service is restarted all the other protocols that...

Ronald if it helps this works on my 2005 development box , I dont have any 2000 ones left unfortunately.

CREATE

PROCEDURE dbo.

Try shrinking the files instead of the database that usually does the trick

hth

David

Ronald

Couple of other bits I don't know what options you have set in query analyzer but

IF (@servername <> null)  will not work in a default setup you need to change...

Ronald you need to lose the  [ ] brackets around the variable names these make SQl server treat the variables as identifiers hence the error

SET @sql = 'INSERT INTO

The syntax your are trying use I believe is from SQL Sever mobile which for some reason has a slightly diffrent syntax for certain commands to do this in sql...

If a columns in your table nullable SQL Server must maintain a special bitmap for each row to indicate which columns are nullable which is an overhead.

If the columns are...

You need to make the insert into some dynamic sql as per below to achieve this

DECLARE @sql nvarchar(4000)

SET @sql = 'INSERT INTO Requests.dbo.'+[@current_table]+

' SELECT * FROM [Unicenter Server FinalSQL].dbo.'+[@current_table]+

' WHERE...

If you go tp help in management studio and click on about it will list the versions of all the client tools management studio should be 9.00.2047 if sp1 has...

select * from ThisTable where Name = 'Mike''s Ball'

hth

David

Something of the form

Select DivisonCode

from EquipmentTable

where DivisionCode NOT IN (SELECT DivisionCode

                                      FROM Divisions)

Yeh thats it.

This is intentional behaviour see the link below

http://nickbarclay.blogspot.com/2006/04/ssrs-disappearing-select-all-parameter.html

hth

David

It just enumrates each table in the database so to use it in a particular database you would just do this

USE Database

GO

sp_MSforeachtable @command1 = "print '?' dbcc DBREINDEX ('?')"

This...

This should do it

sp_MSforeachtable

@command1="print '?' dbcc DBREINDEX ('?')"

so_MSForEachTable is undocumnented stored procedure

hth

David