Are the hardware specs exactly the same on both machines?

Are these join queries run during the day in production or can they be batched for overnight processing?

I'm not seeing a way to order them in BIDS. I do see what you are talking about when you try to move them around to order them manually. Seems...

Sounds like a logical way to group them. Where are you trying to accomplish this? Are you viewing them in SSMS (connected to the SSIS server), file system, Solution Explorer...

Where are you trying to resequence the order of the packages?

My experience with this says yes, you can use the same provider to write back. One gotcha to watch out for though. When I first started doing this, I was...

Are there any relations between the views? What about creating a single view that access the data directly rather than accessing other views?

I'm not aware of a tool that will "downconvert" from SQL Server to Access. Further, I do not believe that your stored procedures will go anywhere in Access. I am...

I would guess that SMS is carrier specific so there wouldn't be a generic method to accomplish this. I know that AT&T has a domain setup that will allow sending...

neil (5/30/2008)

---

For SQL 2005 If you have three SQL Servers each client-access-per-device, and 10 clients each of which needs to be connect to all three servers, do you need one...

Try this: http://www.manuelabadia.com/blog/PermaLink,guid,7228d85d-c0c4-4497-be63-1fa5edcf6fa3.aspx

This link will provide good information on how to do this:

http://www.sqlservercentral.com/articles/Administering/movingyouruserswiththeirdatabases/2124/

Jeffrey Williams (5/22/2008)

---

The standard maintenance cleanup task will not remove files that are not native backup files. Since you are using a 3rd party backup utility (SQL Litespeed?), you...

If someone else has a more automated way to do this, I hope they will post a response for you. Otherwise, I would take the following steps:

1. Create the empty...

You can also enter a query as the data source to do the same. Use SSMS to get the query working the way you like then simply copy/paste the query...