Upgrade your access database - data and all. Then, use SSIS to copy your objects from SQL Server to SQL Server without the data.

You probably have a security issue. Since you are not getting the error from a local browser and you are using a linked server, you most likely are getting...

You have selected the wrong job type. Your job type is for running an SSIS package. To run a batch file or a command line, choose the Operating...

I always forget about reporting services. I agree - keeping that off of your SQL server is a good idea. All of these servers should have sufficient bandwidth...

Ignore the data type in the table for a minute and look at the data type of the INPUT buffer on the data reader or OLEDB source in your data...

If you deploy a package to an SSIS server, it will put it in the root of the msdb "folder" on that SSIS server by default.

NULL of not, integer columns take up the same amount of space in SQL 2005.

You have a design problem. You should not normally have that may columns, and if...

Yes, you can.

If it helps, you can replicate between two databases on the same SQL instance. You can make a publication of some tables from one database and subscribe...

I have implemented it in two test environments (just to try it) and it worked fine. I have not used mirroring in production so I don't have any long-term...

Don't take this the wrong way, but did you try right clicking on the output grid and selecting "Save As"?

You can save a result grid in management studio to csv...

If they will accept it "in memory", then try to get them to go one step further and see if they will accept it in a temp table. You...

What is the volume of these scan events?

It may not really need to be event driven. You could create a report that would run on a schedule every 10...

Depending on what you are doing with your huge list of objects being displayed, you may find that the SMO objects are a lot of unnecessary overhead.

Look at the Information_Schema...

It is probably fantastic, but it is a wrapper around BLAST for Solaris systems that are using 32 or more processors and are having trouble reading data fast enough.

I managed...

I have had two "hanging" problems with jobs and they both turned out to be somewhat based on security. One was a bad proxy account and the other was...