And in sql server 2000 how to list all the sysfiles

Need more clarifications didn't exactly understand your need.

to restrict the growth of your log file

USE [master]

GO

ALTER DATABASE [DB_TEST] MODIFY FILE ( NAME = N'DB_TEST_log', MAXSIZE = 2147473408KB )

GO

No

Try creating maintenance plan to execute your sp

select * from sysfiles

i changed the port one which sql server 2000 was listening since the default port 1433 was used by sql server 2005

and gave Server name as

instance_name,port_number

Now im able to...

Please Help..............

Please help........

Are you running the SQL Server services and the SSAS2005 services with the same or different accounts?

When you process a cube the SSAS2005 must have permissions to read data from...

Gila so what should be done when your log...

What is the space available.

Use import and export wizard........

In edit mapping Choose to append the data to the destination.

The new rows will be appended to the existing table.

Hi.

This might help

--

--SQL Server 2005

SELECT [Name], Create_Date, Modify_Date

FROM sys.objects

WHERE [type] = 'P' and [Name] = ''

--SQL Server 2000

select specific_Catalog,specific_name,created,last_altered

from information_schema.routines

WHERE

Routine_Type='procedure'

AND specific_Catalog='database'

--

Which is the table that has product.

I think you have to make a sales table that contains soled product.

It should contain soled products along with the tenant idnumber.

Join sales table...

QL Server Linked Servers feature lets you access Oracle data and data from other OLE DB/ODBc compatible data sources from SQL Server. Here are the basic steps for setting up...