It's not dead, but it's not absolutely vital, if, and it's a big if, the person actually loves doing this stuff. Some of the best I've dealt with are self-taught,...

My understanding is that as long as you have a CAL (either explicit, or implied in a per processor environment), you can use it for anything, even MSDE. If this...

I agree with Ninja's RGR'us about the skillset being far more important than the title, especially since many shops will gladly let you pick your own title.

"Want to name yourself the...

Did you possibly mean that you want the corresponding number of rows (not columns) for that Track_no? Something about the way you worded it makes me think that that's a...

If the aspx page is hosted on a different machine from the SQL Server, I don't think it's going to like "(local)" very much. Try changing that to the actual...

While some people might debate whether best practices require the brackets, it's certainly not bad programming practice to do so, so they're just covering their bases.

If you're going to do much of this remote stuff, I'd recommend looking into all of the PSTools.

It's a good practice, but many people don't do it. The reason why is so that you don't confuse the parser by using reserved words, spaces in column names, etc....

What about using the FTP task in DTS?

Is PSExec something like what you are looking for?

Does the SQL Server have an "e:" drive, and if so, does it have that file in that path? Your best bet is to use UNC naming, and to place...

Ah, I wasn't aware that that conversion takes place (and that's one reason that I hate implicit conversions), and BOL doesn't note that fact in the CHARINDEX entry. I did...

I'm confused when you say Charindex can't be used on this datatype. The following script returns 15.

CREATE TABLE tblNText

 (

 ntxColumn ntext

  )

DECLARE

 @vchSearchString varchar(50)

 ,@bitIsDone   bit

 ,@intPosition  int

 ,@intOccurrences int

SET @vchSearchString = 'SQL'

INSERT INTO

 tblNText

VALUES

 (

 'This SQL insert, which is a SQL...

JuanBob, when using SCOPE_IDENTITY, the first thing I always do is pop it into a variable. That way it's reusable throughout the procedure, even if you do other operations which...

I don't think that writing a CDE is something that we can cover in a step-by-step process within the constraints of this forum, but if you want to learn how...