How are you running the stored procedure? Are you running it via a job? If you are running it as a job, then it runs as the service login assigned...

From the sounds of it, you probably should be doing MERGE replication. I've never used it so you should read up on it in the BOL and GOOGLE it.

-SQLBill

I think it's because the question is designed to throw the reader off. You WANT to install that version, BUT managers don't have admin permission. SO what version DO...

Can't tell you about how much disk space would be needed by NetBackup.

I can tell you that the best practice is to use native SQL Server backup commands to back...

What do you mean you can't connect to it? How are you trying? Did you register the new instance in SSMS/Enterprise Manager? Are you getting any error messages?

-SQLBill

You misunderstood me....are other jobs/scripts running that have created locks. For example: running DBREINDEX will lock the table.

-SQLBill

Change your INNER JOIN to an OUTER JOIN. Inner joins do not return values when one is NULL. Outer joins will return values even if one of the values...

Does something have the space 'locked' when the backup tries to happen?

-SQLBill

They don't tell you which questions you got right or wrong.

I believe the points are weighted - the harder the question the more points.

-SQLBill

Because they don't have access?

Check to see that the user actually has a Windows Authentication login in SQL Server. ANd that they have access to one or more databases. Lastly,...

Once you move your databases over run the following:

sp_change_users_logins 'report'

That will give you a 'report' of logins that are not properly setup. Either they don't exist or they are orphaned.

If...

This is a link to that specific issue and the hotfix.

http://support.microsoft.com/kb/834688

-SQLBill

I agree with the poster that suggested changing the time of the job. If you do that and all stays the same, you know it's a problem with that...

Check with the vendor, they may actually have a reason for only doing one tlog backup that makes sense to them. One reason could be that they mistook tlog...

Do NOT overwrite every transaction log backup or they are really worthless for restoring. You need every transaction log since the full backup to be able to do the...