Try to restore full database and recovery it to see whether database was in 'simple' recovery mode when you backed it up.

If the database was backed up in 'full' recovery...

Trun off both 'Truncate log on checkpoint' and ' Select into/bulk copy' will set database in 'Full' recovery mode.

create function paydate (@first_paydate datetime, @given_date datetime)

returns datetime

as

begin

declare @next_paydate datetime

select @next_paydate = dateadd(day, 14, @first_paydate)

while 1=1

begin

 if datediff(day, @next_paydate, @given_date) > 0

           select @next_paydate = dateadd(day, 14, @next_paydate)

 else

    break

end

return(@next_paydate)

end

SELECT dbo.paydate('2004-01-02', '2004-02-20')...

From BOL.

"If a torn page is detected, an I/O error is raised and the connection is killed. If the torn page is detected during recovery, the database is also marked...

1. Drop it by sp_dropserver

2. Restart SQL Server

3. Add it back by sp_addserver 'servername', 'local'

4. Restart SQL Server

5. select @@servername

The dbo is a user that has implied permissions to perform all activities in the database. Any member of the sysadmin fixed server role who uses a database is mapped...

Try sp_addserver 'yourservername', 'local' and restart SQL Server.

"You need consider where is your current SQL binaries. On the cluster, SQL binaries need on the shared cluster drive. "

It is true in SQL Server 7.0 but In...

Either reinstall or rebuild master database.

Run sp_addserver.

Alter your stored procedure and place constant values in your queries, or assigning values to your variables in the stored procedure to test whether or not the procedure compiles with...

DBO doesn't have sysadmin fixed server role . objects created by members of the sysadmin fixed server role (or by the dbo user) belong to dbo.

You can perform full backup to MSDB no matter it is in simple or full recovery mode.

Once a login has been mapped to dbo in your database, no other logins can be mapped to dbo in same database.

User can be added to dbo database role. After that,...

First you have to set MSDB database recovery mode to 'full' before you setup the logshipping.

You can script the jobs and apply them to your standby server without logshipping the...