Jeff Moden (10/17/2014)

---

Heh... I like the OP's idea of doing this all from T-SQL. I...

OK, now that your SSMS works, take a minute to think about those data files on a SMB share.

If you're not expecting any performance from this database, it might also...

What kind of replication are you trying to set up?

pharmkittie (10/17/2014)

---

I can run queries from SSMS on my pown workstation but if I try the same using SSMS on the server I get an error saying "Access to the...

You can use the undocumented and usupported stored procedure sp_msforeachdb. Actually it has some issues (every now and then it skips a database, to name one), so you can use...

I see. I'm not Gail's advocate, but you should also consider that she may have asked to know if you had constraints against using the new client tools. Actually, she...

Correct

dapoole (10/17/2014)

---

Koen Verbeeck (10/17/2014)

---

If you find that any advice given to you was below your standards of quality, the people that gave you the advice will...

No, it's http://www.sqlservercentral.com/Forums/FindPost1626609.aspx

Don't cross post please.

Why are you using an external ftp client when you can use the SSIS ftp task?

Profiler can hurt performance of the monitored instance. Events are processed synchronously and the server may have to wait for Profiler to consume them all.

That said, what kind of timeout...

If this is an import project, SSIS might be what you're looking for

CLR is a possible solution, but I'm not sure I would use it.

I tend to do data focused operations in sql server and the rest outside SQL Server.

Are you sure...

SQL Server 2014 Management Studio Express is free.

Download it here http://www.microsoft.com/en-us/download/details.aspx?id=42299

Doesn't look like a good fit for a T-SQL solution.

I would use Powershell or a separate application instead.