put logging on your SSIS package and view the output.

I think that anyone with Visual Studio 2005 also gets a sql 2005 developer license thrown in with that, so thats probably a few less licenses you would need.

Lynn Pettis (2/13/2008)

---

From what I have been able to determine, you need the Professional version of Visual Studio or better to debug stored procedures. That was one of my...

Follow Gails lead for now as it seems your SP can probably be optimised, but one thing maybe worth considering is bring the data from the remote server into a...

For dev why not use developer edition? it has all the functionality of enterprise and will save you lots of $$$

in your maintenance plan choose to backup to a file, and then select to overwrite the file rather than append. If you dont want to do that for all...

are you by any chance running sql express and not workgroup/dev/enterprise/standard edition? Express has a 4gb data limit which could be your issue. If not then at least...

Tommy, i think ive sorted it. I read the link you sent me and a few of the articles around it and even though it didnt help directly i...

Cheers tommy. I will try that. Is that...

I guess it completely depends on the need of the business. If the company thinks that the developers can do enough of the DBA side of things (backups\indexing\query plans\performance...

Erik Hansson (2/7/2008)

---

Thanks for the answer but if you set the model database in simple mode can I change some of my user database to be in full mode and...

Hi Andy,

At the moment the jobs are running under the sa account. I may at some point change them to a scaled down account. I was more curious as...

Another post i have found about this bizarre issue

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2490708&SiteID=17

Shows some kind of work around, definately some weird combination of service packs and OS that creates this error. ...

jeff.williams3188 (2/3/2008)

---

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select only those...

Script your tables first through SSMS right click databases, all tasks generate scripts, you get more options than just generating scripts from the table. make sure you set the...