Script solving your sp_helpfile issue..

DECLARE @db varchar(1024)

DECLARE @statement varchar(1024)

CREATE TABLE helpfile

(

name varchar(22),

fileid int,

filename varchar(4000),

filegroup nvarchar(100),

size varchar(15),

maxsize varchar(100),

growth varchar(15),

usage varchar(200) )

DECLARE db CURSOR FOR

SELECT name FROM master..sysdatabases

OPEN db

FETCH NEXT FROM...

Got this script from one of the topics here in sqlservercentral

select

name as [DB_NAME]

, isnull(case when status & 1 = 1 then 'autoclose' else null end + ',', '')

+ isnull(case...

Thank you very much....

Thanks for the compliment 🙂

Thanks Steve good point 🙂

If you want to script out users from production database to your stand by database hope this script of mine can help you. Just run this script to your production...

Thanks for the correction James like i said in my first post this scripts has limitations hmm just revised it to add the recreation of index can someone check this...

dhara is right you can use DTS for transferring tables but if you want to use a script there are some that can provide you what you want just like...

Thank you very much very well said....

Wow very informative thanks..

Some clarifications..

1. In cases where in production server fails and i can make a last tlog backup from it you are saying that i must apply first...

First of all thanks for the link that you gave me ill browse to see if there are informations in there regarding my problem. As to our connectivity yes its...

How big is your data and transaction log file?? i think you can truncate then shrink your transaction log but truncating and shrinking the data is not recommended. If you...

The publisher has a table called holiday table which is the list of declared national holiday and it must be sync with the branch databases (Bank). I used snapshot replication...

I think sql 7 and 2000 is the same when it comes to truncate and shrink. Just be informed that in most cases database didn't shrink or truncate because it...

Another question... I thought SP4 is an updated version of SP3 (correct me if im wrong) so if i applied SP4 in a SP3 database its like applying additional features...