DECLARE @sql varchar(8000)

DECLARE @BAK_PATH VARCHAR(4000)

declare c_bak cursor FAST_FORWARD FOR

select name from sys.databases

OPEN c_bak

FETCH NEXT FROM c_bak INTO @BAK_PATH

WHILE @@FETCH_STATUS = 0

BEGIN

SET @sql...

Following is the scripts which Rebuild and Reorganize as per fragmentation of the idexex for all the tables of all databases in SQL server 2005...

declare @sql nvarchar(max)

DECLARE @dbname...

Is there any way to track Databbase object changes...so that after track those changes i can apply thos changes on live servers from scripts generated from track..???

Means i want to say that Mirroring ort shipping is best for both server which are on individual network..???

create table tablelist (DBName varchar(1000),TableName varchar(4000))

GO

DECLARE @sql varchar(8000)

DECLARE @BAK_PATH VARCHAR(4000)

declare c_bak cursor FAST_FORWARD FOR

select name from sys.databases

OPEN c_bak

FETCH NEXT FROM c_bak INTO @BAK_PATH

WHILE @@FETCH_STATUS...

In the database mirroring , transaction which are commited directly write to mirror server database files, whereever in transaction log shipping transaction log will be backup and resored on secondary...

Nothing??????

Please needfull to me to evaulate SQL Database versioning (SQL version control)..

I have face same problem again, I have tried to open remote sql server from one local machine i did not got..and i was got same error as attachement i...

I want to know , if i enable only named piped then what hapopen, and enable only tcp/ip than what happen? means what indiavidual purpose of both protocol?

Thanks guy,

can u tell u why required TCP/IP and Named Pipes in SQL server?.... for my info.

I am able to delete all files but not able to delete subfolders,

is there any option?

Yes, i can able to delete , Thanks for ur reply..

Please use following command :

select db_name(dbid),filename from sys.sysaltfiles

order by 1

Thanks guys

I got oldest active transactions which are remain to close from DMV which u have given.

Now I am able to kill or rollback those transactions.