Not exactly getting your need, you want to say there is an issue with the security or you are facing issues with migration of data to sql server.

Anyways, if it...

The best method would be to write a Maintenanceplan for doing all this.

Hello,

Check if the DTC Services is started, that can be a potential Issue.

Regards,

You can get the above details by running the below

USE master

Go

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

Go

EXEC sp_configure 'max server memory (MB)'

GO

hi ashok,

I feel firstly you have to run before you run dan's script.

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

Hope this helps.

hello,

you can get the required information from two tables one from sysfiles and the other from dbo.backupmediafamily in msdb.

hello, did you see sp_helpfile?

Brother, In Simple recovery model the logs are not saved or in other words truncated when ever there is a commit. It is not desirable to do this until unless...

A good method for deleting duplicates is using CTE.

it is nicely explained in the msdn site. http://msdn.microsoft.com/en-us/library/ms190766(SQL.90).aspx

Hope the above helps.

Sriram

Just wanted to know how you are running the query, is it through a linked server or from ssis.

transport level errors many a times get resolved when the query...

not exactly as we were able to integrate it into ssrs w/o .net. anyways hope http://support.dundas.com/Newsletter/09-06/newsletter.htm page gives you more details

stop all the activity on the db, if needed kill threads.

change the recovery model to simple and then shrink it.

Worst case even then if it is not resolved, dettacch the...

firstly, try to check whats the percentage of the log file that is in use by

DBCC SQLPERF(LOGSPACE)

or do like below for your database in non peek hours...

USE AdventureWorks;

GO

-- Truncate the...

I think sysfiles should help you out. select * from sysfiles