Try this:

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D

schleep (8/4/2016)

---

I agree the search is simpler in T-SQL; it's the compiling of the affected code before runtime that I want automated.

Maybe I'm using the wrong word here: I want...

No difference other than in syntax. What...

schleep (8/4/2016)

---

Yes, using Powershell. I don't have access to SQL Search or VS.

Getting the dependencies is easy. It's finding out which ones will throw an error the next time they're...

frdrckmitchell7 (8/4/2016)

---

Hi guys

I have a csv file and column A has numeric values (1,2,3,etc), but when I create a File Connection Manager in SSIS and preview the data there are...

Paula-196779 (8/4/2016)

---

Apologies for such a question...

We have a supplier of a piece of software that is made up of an Access front end with a SQL Server back end. It...

You can also use Redgate SQL Search to search your entire database for references to the view.

And if you extract your database to a VS database project, you can look...

schleep (8/4/2016)

---

I'm trying to see which stored procs (and functions) might be affected by my having added a column to a view definition, which might cause ambiguity errors.

Is there a...

SSIS can run procs in parallel, no problem.

BWFC (8/4/2016)

---

Really sorry for a techie question on here but I'm not sure that this is worth a thread of its own.

When calling multiple stored procs from another, they executed...

joanna.seldon (8/4/2016)

---

I just need at the end of the view remove the records where if StudentTransportOrder has two instances of the same VehicleID, keep record of the VehicleType = Car...so...

Where are the truncation errors happening?

Are they at the flat file source, or the SQL Server destination?

Does running the package as a SQL Agent job work?

Please do not cross-post in future, it fragments responses and wastes people's time.

Responses here please.

J Livingston SQL (8/3/2016)

---

well I disagree.....on the assumption that you wish to plot the course of...