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 work out why the...

Waseem Jaleel (8/3/2008)

---

The only access the users need to have to the db is through the application, which connects to the db thru the specified app role.This is already present....

what do you want to do with them? the easiest way would be to output sp_who2 into a temp table and then work on it from there.

sqldba.hl (7/26/2008)

---

hI ,

I WANT TO KNOW ABOUT DBA RESPONSIBILITIES AND iNEED TO HELP SOLVE TO BELOW QUESTIONS.

CHECK JOB FAILURES? -- agent history - add notifications in to email you.

CHECK DISKSPACE?...

Farhad (7/25/2008)

---

Hello,

I am preparing for my 70-443 examn and I went thourgh the Sutdy Kit and I took the practice exman question that came with the kit and I am...

depending on what backup software your using you should be able to look if there is a batch command script attached to the pre and/or post backup run. Ask...

sometimes the culprit for this kind of thing can be backup software which runs a batch file to stop the sql services so it can copy the mdf and ldf...

No there are no simulations,...

anyone?

assuming you have created your secondary file group (lets call it second) you can use this

Create table dbo.MyTable

(

col1 int,

col2 varchar(10)

) on Second

Thanks for your quick reply Tim, do you have any links on a simple file import tutorial using the script task? There will ideally be two outputs, one for...

i...

Duran (7/10/2008)

---

Maryland,

Hey there, I am currenlty gearing up for 70-444, what did you use to study? I have read the reviews of the Microsoft press book and the sybex and...

one other piece of advice i would offer is that the case study text does provide an "ALL" page, which shows all the text rather than having to go through...

I passed!!! Cant believe it, and i got a score of 850, i'm still in shock. 70-443 is a very tough exam, and takes all the allocated time...