Try setting them to TEXT and then doing modify the datatypes once you have imported it

If you want to have mirroring on the same server then you will need to do this with two instances, you can't mirror onto the same instance.

And then it...

Excel does a lot of funny stuff to data-types and some of them do not import easily into SQL, you can try and set the datatypes in the spreadsheet to...

Open up the .dat file in Textpad,

It may contain SQL scripts to create the required databse objects that you can apply to your database. Check that the scripts...

-Take a full backup

-Change database to Simple logging

-Shirnk Log

-Change database back to full logging

Be careful though as Log files grow to a size that they need to, at more...

The Tempdb will start as the intial size.

Change this in properties and then restart.

It will probably grow back out to 12g anyway. You should give temp DB some room to grow for optimal performance.

Restore from your most recent backup, into a new database and copy over the dropped rows/tables.

david.sims (7/24/2008)

---

This is originally how I set it up. The problem arises when you have a project that has not been billed. Because it has no billing activity,...

It looks like you do not have permission to access that folder. Get the sysadmins to give you permission and it should work.

Does your table have a time-stamp column?

http://www.sqlis.com/default.aspx

is an excellent site, it should have what you are after..

You should be able to dettach your database from one server, then copy the .ldf and .mdf file and re-attach these to your new server.

You should not have to copy...

Your statement looks fine, What error are you getting?

Are you able to post your entire query?

Quite a tricky question, I am not aware of a way that it can be done without using dynamic SQL.

Am interested if anyone has a solution ..