You could accomplish your objective in an insert/update trigger, but you are setting yourself up for some maintenance headaches. Perhaps an alternative solution would be to just compute the...

Well, sometimes that is the price you pay for tinkering with the system tables. I have to give you high marks for your creative approach. I think you...

You are correct about the text qualifiers. They should ignore the embedded commas. Have you tried using the "{CR}{LF}" as the row delimiter? If that...

Do you have the ability to step through the source code while it executes the conenction and sql actions against the server and db? Sounds like you may be...

Adding a column to a table and altering an existing column are two different stories. Give it a try - you should find out pretty quickly if your theory...

I don't think you will be able to do this. I'm running SQL2K, but the same rule should still apply to 7.0. - can't alter a replicated column (it's...

You have a few options; you can export the dts package as a vbs file and incorporate that directly into your code; you can set up a dynamic properties...

It is possible, you just need to get a bit deeper into the guts of your DTS package. What version of SQL are you running?

It can be done, but is there a specific concern you have for the change?

Andy has a good point. If your developers have such a hard time with relinquishing "the power and control" of the sa login, bring the concept home to them...

When you say "they think it makes the developer's life a lot easier", who are you referring to? Is it your supervisor, or the developer's bosses? What do...

You can obtain a significant amount of information on SQL Server objects through SQL-DMO. VB and VBscript is a great way to use this object model.

Sean

You need to specify an OUTPUT parameter in your Create Proc statement, and assign the value of @test-2 to it. The resulting value will then be available...

Just to exend the example I copied from the Oracle site, if you have a table called "Universe" and two columns 'Parent" and "child", a similar result can be...

I wasn't familiar with this operator in Oracle (and many others, for that matter). Here's what I found on thier site:

SELECT RPAD( ' ',...