if you dont/wont need to make any changes to the packages, use DTS Backup 2000 application (http://www.sqldts.com/242.aspx) and run the DTS in legacy mode on the 2005 server....

Hey, I really appreciate the info from you guys. I have spent a couple weeks thoroughly researching sql injection, and i understand what needs to be done to protect...

hmmm, didnt know the urls were in the same class as "those of whom we do not speak"

probably smart, but it keeps googlers from answers. speaking of which, id...

ill give it a try, thanks a lot.

also, does anyone recommend a good tool for managing/visualizing scheduled jobs? i tried out the free idera job manager, but it crashed...

I dont think you can create an indexed view with Standard Edition (which we have. a bunch of a**holes set the environment up. pos is completely non-scalable). ...

ran this on the table last night. looks like there is a little fragmentation on some of the indexes, but not horrible- right?

/*-----------------------------

dbcc showcontig('katabat.dbo.inquirymanagerresponse') with all_indexes

-----------------------------*/

DBCC SHOWCONTIG scanning 'InquiryManagerResponse'...

the vast majority of the fields are varchar(50). the ids are decimal(18).

i have yet to find a nice simple tutorial on creating an indexed view. any recommendations?

thanks.

massawa (1/15/2008)

---

Hi, matt miller

I have copied the code that you gave me and pasted into SQL Query analyzer. and the error says-

...