Please note that we can take the database down for 1 dayif required.

Is there any other way to achieve the solution?

Thanks for your reply.

I am trying to shrink the datafiles using SSMS.

I am trying the same thing that lowel has suggessted. Still it is not working.

The datafiles are showing that...

When ran through the steps it failes at .refresh.

The excel is able to connect to the server. When I pull record for any table using the same connection...

Thanks for your reply.

With this code I am able to execute the stored procedure.

the stored proc is updating the required table in the database but is throwing an error saying...

Can anybody provide any suggestion on this?

My understanding is that I will ahve to get access for the SQL Server from someone who already has access to the SQL Server.

Thanks everybody for your inputs.

The following is the query.

Eg: select * from table

Error: Invalid object

select * from dbowner.table

returns result.

I want the query to be executed without using the dbowner in the identifier i.e. to...

Use Change Data Capture(CDC) capture the changes made in table.

Refer to the following link for details:

http://msdn.microsoft.com/en-us/library/bb522489.aspx

SQL Server does not stripe across multiple transaction log files. SQL Server uses the transaction log files sequentially.

It is better to have a single transaction log file in a larger...

Thanks Cinyaz for your help.

There are some objects owned by dbo and some others by the user mentioned.

As per requirement the stored procs must only be excutable when we login...

Hi Joie.

It's a SQL 2000 instance

Hello Everybody,

Can anybody help?

Do you have any sugesstions or similiar experience?

I shall be highly obliged if you can please share it.

Thanks a lot for your inputs

We update or delete around 10-15% of the total tables.

For deleting the data we need to search the data using a where clause on last modified date. Isn't it going...

Thanks Markus for your help