I'd try doing a copy-only backup first. If that fails, then it'll probably be a matter of table-by-table data copying. SSMS for SQL 2008 has features for scripting...

WebTechie38 (1/21/2011)

---

I checked the box for traverse sub folders. When debugging, it told me it didn't find any files. That means it didn't traverse the subfolders, because I...

Are you using something like OpenRowset to query Excel? Or a linked server? How are you doing it?

You should be able to use a derived table, or CTE,...

Jeffrey Williams-493691 (1/21/2011)

---

As long as you have at least one user with sysadmin privileges that can login to that instance, then you do not need to know the sa password.

In...

It's very possible. It should be automatic, unless you have the transactions defined incorrectly.

I'd have to see more of the procedure code to help more.

The For...Each loops in SSIS can specify that they are for each file. There's an option for including subfolders.

Craig: If I were in the job market, that's one I would apply for. If that helps.

Looks like.

Can you create a Validations DLL file using .NET studio and pass the data through that?

Visio should be fine for this.

Does the data on this page help: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Looks like it might be a PHP problem. Have you tried asking on a site that focuses on PHP?

Are you familiar with "being transaction" and "commit"/"rollback"?

If you issue a rollback command, it will roll back the WHOLE transaction, including both the nested procedure and the outer procedure.

select Col1

from MyTable

union all

select Col2

from MyTable

Union statements will do that very easily. There are more complex methods, but this one is easiest.

Brandie Tarvin (1/21/2011)

---

Silly question.

Does the job description necessarily have to = the classified ad?

Sure, the legal department wants to cover the company by having everything in the job description, but...