Backup usually takes less space, and significantly less if it's a compressed backup.

When restoring via SSMS you should see all the .mdf and .ndf files. You have to specify locations...

Strange. I run all of yours t-sql statements on a sql 2012 and sql 2008 r2 instances and they worked all.

I don't think it's the new installed instance of 2012.

You...

It's used in migrations. For example if you have to migrate users from one...

Hi

What about this

r.dbPatID, t.PatientFirstName, t.patientlastname, r.dbstatusdesc, r.dbAddDate, r.LastName, r.dbStaffLastName,

SUM(CASE WHEN t.LedgerAmount > 0 AND t.LedgerType != 1 THEN t.LedgerAmount ELSE 0.00 END) AS Charges,

SUM(CASE WHEN t.LedgerAmount < 0 AND...

sqldriver (2/15/2014)

---

Yeah, I think my plan is going to be using PS to generate a bulk insert for every file, naming the tables after the files before the .txt, and...

sqldriver (2/15/2014)

---

I really hate SSIS and was hoping to avoid it. I guess I could try doing this all in another language that handles large file operations better. Of course,...

Try to avoid the addition of the column into the files. Whatever approach you apply for that operation, it will be slow.

Doing the same in the db engine is pretty...

It's easy to give advises, but the hard part goes to you. You've already put some effort for a PS script to do it.

SSIS is designed for that, and...

Something similar that I once worked on, was on a migration process.

I had to change the recovery model to BULK_LOGGED and expanded the TLog file enough so that there was...

Can you send the sql statement that produces the result set?

Yes.

The author uses the reserved_page_count for both data and indexes.

Regards,

Igor

Can you log in with any account?

Is the other "domain\username" added to the AD? and if not, add it and then you should add it to the Logins too.

Do you...

Hi,

Here is a link for this: http://blog.sqlauthority.com/2013/09/12/sql-server-automatically-store-results-of-query-to-file-with-sqlcmd/

If you want to do it from t-sql, then you must enable xp_cmdshell and remote access to the server. Also check the "Named pipes"...

1. Yes, it gets created, and by default is disabled.

2. Yes we can, same ways as for the other logins.

Regards,

IgorMi

Yes you can. As described in previous post.

The job is actually a SP. So executing/creating a SP from a SP is possible.

Regards,

Igor