I assume the version of SQL Server is 32bit, otherwise no need to put anything into boot.ini.

If the amount of RAM is less then 16GB than should put 3GB switch.

Is this is at all possible restarting the instance on which the database used to be may help. Sometimes when you detach the database the file may still have...

1. Create a login on the source server, give all the permissions you need on the standby database

2. Disable the login on the source server, so nobody can use it...

I understand if you restore from one server to another with different drive and folder names, you would need to specify "with move" option. If the folder and drive...

Ok, nvarchar(max) should resolve all your problems. Just change @s-2 declaration:

Declare @s-2 nvarchar(max)

Yes you can. You can use a larger datatype to fit your script and then just print it out. However 8000 character should work for your immidiate needs as...

Ok, what you could do is to declare two variables:

Declare @s-2 nvarchar(4000)

Declare @s1 nvarchar(4000)

After this line:

set @s-2 = @s-2 + '"' + @dfname + '" to "' + @newdatapath +...

Ok, your command is very long and does not fit into the string variable.

Try changing

Declare @s-2 nvarchar(1024)

to

Declare @s-2 nvarchar(4000)

I see, you probably run it like this:

EXEC usp_RestoreDBsFromFolder

@path = '\\OBBEAVER\PA\RevBudget.BAK',

@newdatapath = 'D:\SQLData\',

@newindexpath = 'D:\SQLData\',

@newfulltextpath = 'D:\SQLData\',

@newlogpath = 'E:\SQLLogs\'

You should run it like this instead:

EXEC usp_RestoreDBsFromFolder

@path = '\\OBBEAVER\PA\',

@newdatapath = 'D:\SQLData\',

@newindexpath...

You can not rename a named instance. If you rename your computer, then you can change the first part of the name to match the new name of the...

Mike,

Sorry for the delayed response. Try changing this line:

set @ext = (select substring(PhysicalName, charindex ( '.', PhysicalName, 18), 5) from #backuplist where LogicalName = @dfname)

to

set @ext = (select...

This is what I use. The SP would take all backups from a particular folder and then use xp_restore_filelistonly to extract the list of the files. It will...

This is what I found about "AUTO" option in BOL:

"Although changes can be propagated automatically, these changes may not be reflected immediately in the full-text index."

What is the typical lag...

I am not good with VB either. In fact I have no knowledge of it at all, because I am not a developer. I was just wondering if...

No, this is not what I want. I don't want a manual process, I want automatic. E.g. a job running every night and scripting all the jobs into...