If you open any .sql file, visual studio will display a toolbar related to SQL commands. One of the items on the toolbar is a button "SqlCmd Mode" -...

@lowell

How did you upload the image to the forum post?

Edit: I managed this by uploading the image to my Flickr account and linking to the static image....

can you clarify?

Do you want to rename a table by calling a command-line utility from with a program created in Visual Studio 2010.

Or do you want to rename a table...

Great. So I can bypass the need to put the dll on the Server by just scripting out my dll as a binay object and Lowell says - and...

Without your table definitions and scripts to create the sample data, it is difficult to work out an exact solution, however looking at your query and, I guess sample before...

They want it to run in a 5-minute slot, during a break when production activity is very low, and complete before production resumes. It usually finishes within 1 minute,...

No, its not reporting services. Its a complex stored procedure.

Thanks Paul - now I get it. (its been a long day)

-- Must be very early over there - or are you not in NZ at the moment.

I already get grief here for writing 'newfangled clever stuff that no-one understands' (I obviously spend too much time reading SSC :-D). It would be a sisyphean struggle...

Thanks for all your contributions. Race condition is a possibility where this proc is used, and so is @@ROWCOUNT being affected by triggers.

I think I will rationalise the proc using...

Thanks G^2

But I've managed to work it out with BOL on sp_trace_setevent

I needed to track events SP:Starting and SP:Completed for calls by the application, and SQL:BatchStarting and SQL:BatchCompleted for...

Is there a trick to setting up traces?

I have a trace - all set up and working, and collecting data - with the filter set on textdata like '%MyProcName%'

exec sp_trace_setfilter...

GSquared (1/9/2012)

Check out sp_trace_create, and fn_trace_getinfo, and fn_trace_gettable. Takes a little bit of study and usually a tiny bit of trial and error, but once you get how to...

Thanks, The profiler creates exactly what I want.

But on production I don't have access to profiler, only SSMS. Can I script the profiler actions to create a table...

My word Jeff! A lot of thinking for a single point, considering I got 7 points for counting Santa's reindeer.

Keep 'em coming. I need the mental exercise.