Howdy Phil,

I had problems though with the stored procedure. "Invalid pointer".

So I have decided to do this

Run stored procedure sp_help_revlogin

package selects * from #tmp and

transfers to text file.

drop #tmp table

Thanks...

Hi Phil the stored procedure that I am using does not return any rows?

The print command is being used.

BEGIN -- NT authenticated account/group

IF...

[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

Try applying the logs manually or restart the log shipping.

Ok I restarted the log shipping last night and all has been working great.

Now what I should have mentioned is that Iwas using one standby server and two primary’s....

Backup is happening on time. Copying is happening on time and restore being attempted on time. The copy on several occasions is 0. But then after that it will show...

Howdy Matt. If you are wanting to achieve smaller backup files of your databases then I would suggest litespeed. It's an excellent solution to reducing file sizes.

Yes it works.

How could I do this?

Thanks heaps.

Hi Andy,

I checked the dbid by looking in sysdatabases and did

select * from sysprocesses where dbid = '30'

Nothing.

Hi Andy I am unable to use this command as I do not have exclusive access to the database.

I have tried setting single user. But still the database is locked?

Can...

Hi Andy thanks but I get the following message

Server: Msg 5063, Level 16, State 1, Line 1

Database 'nab_pcs' is in warm standby. A warm-standby database is read-only.

Server: Msg 5069, Level...

The DB is read only. However replication is preventing me from

restoring a full standby, applying differentials or applying alter database to make it read/write. Also I am unable to...