Hi,

I've literally got it working actually.

I couldn't simply update Tables C and D from the 1st trigger because the ID isnt the same in those tables. We...

Is the domain service account a member of the local group "SQLserveragentusers$SERVERNAME$INSTANCE" or similar

EDIT - this maybe useful but we may have covered it:http://www.mssqltips.com/sqlservertip/2317/running-sql-server-agent-with-a-least-privilege-service-account/

mike.whorley (11/26/2012)

---

Hi,

I've recently changed our SQL services to run under domain account instead of the local account they used to use. Since doing this i'm unable to start the agent....

Sqlsavy (11/26/2012)

---

full backups taken every day (deleteing old backup file from previous night) .Backups are copied daily to tape.

db size is around 800GB and Litespeed backup file size is around...

Sqlsavy (11/23/2012)

---

Hi All,

We use Litespeed to backup our databases. One particular database grows 330MB/day there is enough space on the data and log drives but I think backup drive will...

Mordred (11/23/2012)

---

Mordred (11/23/2012)

---

@ learning_sql, I am going to give that a try and I thank you for that.

@ Jason, I would love to be able to do a...

I will have to...

noted - I am running against some SQL2000 so...

Mordred (11/22/2012)

---

Hi Jeff, I tried that yesterday and I still received truncation errors because SSIS is still trying to separate the columns where there are commas within the quotes. ...

Koen Verbeeck (11/23/2012)

---

learning_sql (11/23/2012)

---

I added that to my create view statement (the ssis exports an entire...

I added that to my create view statement (the ssis exports an entire view) and it...

ok thanks...

I have solved my own problem by hard coding in credentials for a user with access only to the reportserver...using this forum post:

http://social.msdn.microsoft.com/Forums/da-DK/vsreportcontrols/thread/5aa7eee7-d4a7-427a-ab8d-7a3d4d4f0bf3

Thanks, I have already done that..it works when browsing to the pages directly from the users I have setup.

However how do I set it up so I can browse the...

Thanks for that - any more specific advice?

I have already configured the site and I...

RAID - Redundant Array of Independant Disks - it is a tool used to ensure data integrity. RAID uses a number of Hard Disks to ensure better data integrity...