Hi,

I've done this lots of times and it works fine, so I was puzzled by the KB link/quote in your post. I've read it (twice) now and I think...

Hi,

Did you copy and paste Miguel's query? If so there's a typo - it should be sp_change_users_login 'Report' the 'c' was missing from 'change'. That should...

Hi,

I'm not sure if it's the default setting, but in my organisation the messenger service is always disabled as ICT view it as a security risk. If the...

No, you need the TLog backups to do a point in time restore.

Cath

Go to SSMS/Tools/Options and select Scripting. There's an option there to include 'IF NOT EXISTS'. If you set that to False, you should get what you want.

Cath

Hmm, was hoping you wouldn't ask that - I'm not a programmer, I just stumbled across that fix a while ago. I think it may have something to do...

Check Administrative Tools/ Services/SQL Server Agent. Is your agent running under the local service account? If so, there will be a checkbox underneath 'Allow service to interact with...

I've had the same problem and it came down to how Windows authenticates accounts and the Kerberos protocol - maybe it applies to your situation too.

My brain would explode if...

Yes, it would, though bear in mind that if you do a Full backup the TLog will continue to grow until you do a TLog backup. There are posts...

If a Full backup has never been taken, there is no way to recover the table - any backup taken after the table was deleted would not include the table....

As Gail said, you need the complete chain of Log backups from the last Full or Differential. Losing TLog1 would break the chain and you could only restore up...

Hi,

I know you said you'd looked in all the menus, but if you click on Filter in Job Activity Monitor you can select which columns you want. Don't know...

Hi,

There is no SP4 for SS2K5 (nor yet SP3). How did you check the version of your workstation tools? Sounds like they do need upgrading to SP2.

Cath

Hi,

Right click the database you want to back up, select Tasks, then Back Up. Enter all the details on the General and Options tabs then click the Script button...

Hi,

I had this problem on a case sensitive SS2K. I asked the network guys to change the AD login to the case SQL Server insisted on then all was...