one other thing you could do in SSMS is set the rowcount to be, say, 10000. that way every query they run will be limited by that. They...

it was everything, even trying to connect through SSMS failed. 10+ apps failed with the same messages. Backups failed overnight because they couldnt connect as well.

use the import/export wizard and make sure you have the "enable identity insert" option selected

what problem are you getting?

its because the table is so small. You should ignore fragmentation results for tables less than 1000 rows

one way i guess you could do it is write an sp that uses the send mail procedure and pass in a parameter of a job name. then in...

the main reason given would be that data files are accessed randomly whereas log files are written to sequentially. to optimise performance it is best to keep log files...

The way i do it is backup to a local drive and then use an application called SyncToy (http://www.microsoft.com/downloads/details.aspx?FamilyId=E0FC1154-C975-4814-9649-CCE41AF06EB7&displaylang=en)

to move the backups to another server.

Get the MS Self paced books, they are good. I think ExamCram did a book for 70-431 which is a great book but they didnt do one for 444...

Hi,

The remote servers that you have admin access on, is that using the same account as you are running management studio as on your PC? For example, im a...

I believe this is when you dont have access to see the service states on the server in question

weirdly this seems to be down to the name of the trigger?? If i create exact same trigger but call it [dbo].[UPTrg_StatusChanges] it seems to work fine?!?

I will confirm...

Back again,

Been doing some tests just now and i created a trigger on one of the tables (dbo.Employee), the syntax shown below

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter trigger dbo.UPTrg_StatusChanges

on dbo.Employee

AFTER Update

as

begin

SET...

If you cant stop people installing query analyser, and you cant lock down the security then you could possibly write a logon trigger that uses eventdata to pick up the...

Jeffrey Williams (8/3/2008)

---

Animal Magic (8/3/2008)

---

Many thanks for the detailed reply, at least now i understand why that message is appearing after the update statement from the application. I couldn't...