I had created the user and gave access to the database. I did find the further permission restriction at the table level. Thanks.

Thank you very much for your help. This worked great.

The actual tables are much more extensive.

CREATE TABLE [dbo].[tmpEntity](

[EntityID] [int] NULL,

[FirstName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LastName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[tmpAddress](

[ADDRESSID] [int] NOT NULL,

[ENTITYID] [int] NOT NULL,

[ADDRESSLINE1] [nvarchar](50)...

I used to be able to perform this function, but last week they had to do a password modification for the Windows login. What privilage)s) should be set?

Thanks. I executed that. The rows before and after were 6,196,124 and reserved before and after were 12,801,784.

Adding in the clustered indexes worked great for wiping out the unused space. What I am also seeing is this example:

table rows - 7,262369

table reserved - 13,214,512 kb

table data -...

This is SQL Server 2005.

This table has 19.8GB of used space. I tried the Alter Index All on hstordersummary REBUILD and it did not free up the unused space.

When I...

Thanks, guys. I have a maintenance plan to rebuild indexes once a month, but I see that I should chnage it a weekly process. We are running in about 5000...

Thank you.:)

I am looking at sp_AddLinkedServer, but am having syntax problems. I am using @server='LinkedServerName',@DataSrc='1.1.1.1' and am getting error that it needs a provider name. When I add @Provider='SQLNLCI',...