ALTER DATABASE <database name> SET RECOVERY FULL

Please first read the two article I referenced above.

Recovery model has no effect whatsoever on replication, that goes for publisher and subscriber alike.

sys.sysmembers (Transact-SQL)

This SQL Server 2000 system table is included as a view for backward compatibility. This feature will be removed in a future version of Microsoft SQL Server. Avoid...

Have a read through these:

http://www.sqlservercentral.com/articles/Administration/75461/

http://www.sqlservercentral.com/articles/Administration/64582/

Please don't cross post. It just wastes people's time and fragments replies

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1519531-391-1.aspx

Luis Cazares (12/3/2013)

---

The second option is to default the values to NULL and assign values dinamically.

CREATE PROCEDURE MyProcedure(

@Param1 int = NULL,

...

I don't know if it's due to permission because you still haven't posted the error. If there's an error, it would have been displayed in a dialog.

Have you tried using...

'Save as text file' is not an error. It's very hard to help you without knowing exactly what you're doing and having a description of the error you're getting.

Are you...

There's your problem. If a database is in full recovery, and for mirroring it has to...

Do you have regular log backups running? If not, that's why the log is so large.

Please read through these:

http://www.sqlservercentral.com/articles/Administration/64582/

http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

The problem occurs when the owner of the database does not map to a login on that instance. The solution is, as per those google results, change the owner to...

If the RAID was set up within Windows (software RAID), you can see it from disk management. If it was set up elsewhere, then you have to go and look...

What exactly are you trying to do, what is the exact error you're getting?

nagasai88 (12/3/2013)

---

but Sr. SQL developer in our company said that he had seen this kind of implemenation in his previous company so now he want's to implement same for CRM...

No.