sql-smo

SQL SMO not enumerating tables

I feel like a dork just for asking this, but I'm not getting any help from Google, and I paged through all of SO's results on a simple search for SMO and didn't see it either. The short version is that I'm starting to play around with T4. I'm expanding on Oleg Sych's initial tutorial to provide enumeration over all tables to create a (I...

Minimum privileges to read SQL Jobs using SQL SMO

I wrote an application to use SQL SMO to find all SQL Servers, databases, jobs and job outcomes. This application is executed through a scheduled task using a local service account. This service account is local to the application server only and is not present in any SQL Server to be inspected. I am having problems getting information o...

C# Scripting - advice required please

I am developing an application to carry out pre-defined "tasks" on MSSQL database tables. It is really a tool to help with some repetitive data conversion/import tasks we have. In its SIMPLEST form it could be an "instruction" acting on a table ie. Take the contents of Field A and merge with Field B then write to Field C I have implem...