i mean to say that..if database is in simple recovery model and still it is giving log full error, it means there is a requirement of more log space.

you can use replication for synchronization.

for DTS to SSIS migration is the biggest challenge while ugrading SQL from 2000 to 2005/2008.. it wont be that straight forward..

First you can try...

yes u can do that..you can select the sheet name also while selecting source..

this is awesome support Kingston:-)

if DB is in simple recovery model you need to create more space for log file. either by increasing he max limit or by adding more files.

can u please paste the alert information?

why can not u replace SITE[space] with SITE1

yes u can do that

read more on

sp_deach_db

and

sp_attach_db

this is nice to have feature.. i guess this feature is available with Oracle Export.

Try this one? In certain circumtances this can improve the performance..

INSERT INTO DATABASE..STAG_TEMP_TABLE

SELECT ABC,SUM(ZXC)ZXC,SUM(XYZ)XYZ

FROM

(

SELECT ABC,SUM(ZXC)ZXC,SUM(XYZ)XYZ

...

run

DBCC FREEPROCCACHE

and

DBCC DROPCLEANBUFFERS

while running the queries again to test the performance. This will make sure you are comparing perfoamnce with correct values

if u have autogenerated/ identity EmpID

select top 10 * from emp order by EmpID desc

select top 10 * from TableName order by ColumnName desc

This will give you last 10 records when ordered by columnName

:hehe:

for second question--

Search object across all databases in instance--

http://www.sqlservercentral.com/Contributions/Edit/31650

Table partitioning is one of the the easiest way of doing horizontal partitioning.