Databaes has to be in full recovery mode for logshipping to function.

sp_helprotect

Returns a report with information about user permissions for an object, or statement permissions, in the current database.

quote:

---

sp_attatch_db 'H:\testjes.mdf' 'H:\testjestblParent.ndf' 'F:\testjes.log'

---

Your statemnet is incorrect. There is no database name.

Try following statement.

sp_attach_db @dbname...

Use DATEDIFF ( datepart , startdate , enddate ) funcation.

USE pubs

GO

SELECT DATEDIFF(day, pubdate, getdate()) AS no_of_days

FROM titles

GO

What I understand you want to protect the database backup be restored to somewhere. Try backup database with password option. Sets the password for the backup set. If a password...

First, Guest account has no any permission to any objects but it is in public role. You can't remove guest account from maste and tempdb. If you revoke permission from...

Try to search for any errors especially for login info.

This KB should answer your question.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

OBJECTPROPERTY ( object_id(tablename), 'IsAnsiNullsOn')

DATABASEPROPERTYEX( youedatabase , 'IsAnsiPaddingEnabled' )

DBCC USEROPTIONS

Can you post the errorlog of SQL Server and the statement that you used to re-attach the database back.

I have seen share c$, D$ or whatever disappear sometime. To comfirm it, Go to start --> run --> type \\servername\d$ to see whether you can go into the directory....

You can backup database to the local drive at active node but the backup will be inaccesable once SQL Server fails over to another node. For best practice, I would...

I would restore the production database and shrink the log file. Moving large MDF file can take a longer time.

Use Access 2000 to create linked table to the table that has date column defined with allow 'NULL' and insert data from Access. You will see 'Null' value will be...

ODBC administrator --> Tracing Tab --> Start trace --> Run your asp program --> review the trace log file.

Edited by - Allen_Cui on 06/04/2003 11:49:35 AM