Yes, you can use wide tables which allow up-to 30,000 columns look for more in Books...

When you create the logins, using the dialog box (not from Query Editor), under user mappings, you can select the database(s) which a user should be able to access, you...

I guess Gail and I answered it already, You cannot add the MDF files of SQL Server 2005 to SQL Server...

Is it still running ?

If you stop and re-run it what happens??

I haven't seen any significant difference. But I am no SSIS expert, both have worked for me..

That seems to be too generic error message..

Have you taken a look at the SQL Server Error Log anything mentioned there?

Was there any issue with the disk when the...

What do you mean by setting up subscription, what steps have you performed?

Is the data currently available on the subscriber?

ALZDBA (2/9/2010)

---

If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.

This way, you will find a "database opened" message...

You may also log into Integration Services (in SSMS) navigate to stored packages and right click on MSDB and select Import package and under package location choose file system from...

Look at this blog which explains how to deploy SSIS Packages..

Deploying SSIS Packages[/url]

By last accessed do you mean last modified or just reading it?

I would suggest you follow Lynn's / Gail's suggestion on mirroring, I forgot to mention that.

That's understood, but you have not responded to Jeff's question earlier, do you take T-log backups regularly?

I am not sure if there is a straight way in finding what you wanted. There must have been any workarounds for this given by someone..

Since you have posted this...

As you have mentioned your client cannot afford for a 3rd server in setting up Mirroring, have you thought about the option of Log Shipping? Again it would not be...