u must have full Backup sets or Devices or files to restore a database . it not possible to bakeup to more than one device or media and restore from...

by using Datename() function u can group

in weekly or monthly

sql server store this info in sysdatabase table of master database . it is not possible to edit this value by default . U have to use "Allowupdate" option .

...

u can use update statement .

update Table set column=value where column is null

if u r adding a new column in an existing table u can avoid null using with value...

if u want info about active connection u can get those from master.sysprocesses

it is not possible to get data if there is no backup .

if u got .LDF upto date u can try some tool

to get data back.

Try this...

there are number of ways u can find registered servers . one is

"select * from

sysservers " .

This is system table which is in master database .

IF u are...

Try Join Hints or option with Join .

The Query Optimizer always tries to identify the fastest way to JOIN tables.

The fastest JOIN method is the Loop JOIN, followed by...

Andy ,

I want to register sqldmo.rll and sqlresld.dll,sqlsvc.dll,sqlwid.dll,w95scm.dll

[]

Can you post the code?

''~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

'' Author PADMAKUMAR

'' Restore DATABASE To standby Server

''

''~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Private WithEvents oRestore ...