You should also be able to do this:

sp_MSforeachtable 'grant select, insert, update, delete on ? to public'

It still uses a cursor, but at least you don't have to.

Hi,

I think that your particular situation is much too difficult to understand without more detail.

jg

Rats.  I forgot to mention:  It is probably less work to add a dynamic properties task to each package and set the server connections from within an INI file.  This...

"I've looked at saving the DTS packages as VB files, which would allow replacement of connection information via a text search and replace. But I don't see a way to...

I think you should compare the execution plans in both scenarios to see if the difference is there.  Also check network adapters and make sure they are all running at...

I suppose that I should mention:  I've used the QODBC driver and it did what I needed.

jg

Try

http://www.qodbc.com

jg

Check your antivirus configuration as well.  It is possible that a scan-on-write action is causing problems, so  you might need to configure an exclusion for TRN files.

jg

I don't really know the "best way".  There may be some cool tricks in SSIS that I haven't used.  We're not implementing SQL2005 for a few months yet, so I...

I'm blind without the SQL server in front of me!  One thing you could try would be to design a view that gives you the results that you want.  Use...

Sorry, but I don't have SQL2005 available in front of me at the moment.

So you want to get some columns from 3 different tables in the same row where the...

Yes, you could.  I wouldn't do it that way.  For one thing, it is a lot of work.  The other thing I don't like about that is that when you...

It sounds to me that you do not want a union?  If you "union" three tables together, you will get what you have described:  All three tables sequentially.  If that...

I'm not sure about how to do something like that in SQL2005, but in SQL2000, you can periodically check master.dbo.sysprocesses.  The hostname column will (usually) tell you the name of the...

When guessing, never pick the highest or lowest number.

rats.