vidya_pande (3/17/2010)

---

This is very common issue. But no out box solution for this.

You can have another database created from full back up. Then restore log backups on that up to...

The error 15105 means - the SQL service account does not have permission on the folder where the files are now. Can you check that and let us know...

please provide the table structures soon..;-)

Did you find a working solution yet?

I guess I overlooked your criteria of a Non SSIS based solution :hehe:

You can use SSIS to accomplish this.

Use a flat file source(Delimited) and specify column size to say 5000.

Then use a derived column task and create columns on a fixed width...

Why are you reorganizing the indexes after rebuilding them?, apparently that's what the green arrow between Rebuild and Reorganize does.

Instead take out the green arrow and redirect it to maintenance...

Check if moving tempdb to new location works..USE master;

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'D:\tempdb.mdf'); --new location

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = templog, FILENAME = 'D:\templog.ldf') --new...

Firstly, why did you increase the size to 100gb?

You can alter the db file size to a value higher than the existing size.

DBCC Shrinkfile only reclaims the empty space...

For that you need to specify each column names instead of * and then at the date field use the custom date, something like below

insert into desttable (col1,col2,date,col4)

select

col1,col2,convert(varchar,getdate(),101),col4 from sourcetable

HTH...

Try this...

Select Distinct(DG.UserID)

, DG.UserName

, DG.LastName

, DG.FirstName

From DGUsers DG

where DG.UserID in (select UserId from Orders)

Order by DG.UserID

Gail, I think I missed it completely. I removed the distinct from the second query...

Sorry Gail..I guess i posted my reply about the same time as you asked us to redirect our replies..

Let me know if the below script works better...

Select Distinct(DG.UserID)

, DG.UserName

, DG.LastName

, DG.FirstName

From DGUsers DG

where DG.UserID in (select distinct UserId from Orders)

Order by DG.UserID

Below script can be used to find the number of records and the size of each table in a database

CREATE TABLE #temp (

table_name sysname ,

row_count INT,

reserved_size VARCHAR(50),

data_size VARCHAR(50),

index_size VARCHAR(50),

unused_size VARCHAR(50))

SET...

It seems there is a DDL trigger that is aborting such operations. Check with the Sr DBA if you can be allowed to Disable Triggers otherwise you will keep getting...