Hi Roy,

Checked that and its not a problem.

For the time being (since this is invoked from the c#) I have got the builtin\administrator group via the SID

string myAdminAccount = new...

Hi,

a while ago I had to create an environment copy for a large database at a client site.

I tried several methods to copy the large tables, but the one which...

Hi,

just saw your post and thought I'd add my agreement to this - its not in proportion to the SQL side of things.

For us, given the low volume of report...

Hi Derek,

I dont think I would use SMO for general "day to day" tasks.

However, if you are looking to automate operational tasks or integrate from a line of business application...

Hi Rich,

sure it would!

However, like I said at the bottom of the article, it was a little contrived to highlight certain parts of SMO.

Cheers

Peter

Hi guys,

thanks for the replies.

It looks like we are going to go down the Azure route with mutiple apps deployed to different data centres. Given the cost of servers...

Hi Gary,

Looking at your scenario a couple of key points came out

1) Change data

2) Schema changes

3) Replication

This sounds like synch services to me as you can

1) Replicate in groups...

Hi ,

Looking at what you are up to, I would plumb for a single product table with additional attributes supported by additional tables.

The reason why I would do this is...

Hi Steve,

The following is the code snippet in C#

"myJob.DeleteLevel = CompletionAction.OnSuccess;"

In terms of the wider picture, you are right the actual usage depends on the type of operations the...

Hi Steve,

nope ! There is a nice little flag which says "delete on sucess" 🙂

So the only ones that are left are the ones that are a problem...

Hi,

I have skimmed your post and Evil Kraig F is pretty much bang on - with one exception.

What you are trying to do is not standard a standard...

Hi,

not sure how much coding you want to do, but we create an agent job "on the fly" using SMO and through the creation change the user parameter.

Take a look...

Hi rootfixxxer,

I think you have two choices for this:

1) Put the time name into the time table

2) Create a new table for the project time types

I have used...

Hi,

when you say that you have created indexes for the key fields, is this over the view or the table?

I have found that you need to index the view to...