Except that it isnt really useful when trying to find the rogue who applied a schema change without recording it in version control. That schema report was/is great for that.

Sorry, He was an easy target to tweak.

karthikeyan (11/22/2007)

---

Andrew, I dont think so. Because i am not asking what is mean by programming ? i am asking the difference between programmer and good programmer.

I know the basic...

Seriously, if you dont know, then you should not be a Senior Software Engineer.

Things like the way you use naming conventions, how readable your code is (commenting), etc. It wil also greatly depend on the language you are programming (and speaking and writing...

Once again, Jeff proves to be awesome. (He is scary with some of this stuff)

Thanks for finding that post Vladan.

no, i get it. that was the first suggestion of a colleague, but I still need to know if there is a way to populate a numbers table using set based logic.

 

...thats kind of the point, I need to create it without using a loop or cursor. I have made it work with a while loop, but its not preferable to...

Thanks,

Do you know how to remove the double spacing I get saddled with when copy and pasting?

dig this if JDBC is'nt working well enough.

http://www.codeproject.com/useritems/SQLConsole.asp

Sorry I was missing the boat on that one.

If you felt devious you could directly update the sysprocesses table as part of the executed query =)

If your requirement...

Is the Mismatch between the Procedure name that SQL has on the error, and the actual assembly name a problem?

Are you running SQL Server as an account that has permission to...

Cant you append it to the connection string as "Application Name=Jeffs App;" or am i missing what you are asking for?

you can use @@SPID and get the job name from the master.dbo.sysprocesses.program_name column.

If you can parse that value out you can query msdb.dbo.sysjobsview to get the job name

Cursorless is easy. Try this method. Please forgive the syntax I dont have a copy of BOL handy.

/* This will give you all the objects...