DB ghost will do some of that scripting for you, but its got some limitations that are still working out.

you could use a cursor (nobody beat me with 'Cursors...

Is application name an available property? I almost have to break fingers to get developers to use this!

Dont forget users copy and pasting from excel or access. Those two are buggers for adding 0A + 0D chars to data.

fn_get_sql is unreliable in returning results. Profiler is the only way. You could set it to display transactions that run longer than 2 seconds, and cut down on alot of...

try defragging your filesystem also.

you can also try just removing the where clause. it looks like what you are trying to do is sync the actId and Row id anyway.  If the server doesnt...

hands down one of the funniest things I have ever read.

http://chroniclesofgeorge.nanc.com/

if you want to log EVERYTHING, you can turn on C2 auditing. eek!

You may want to just create an audit table with column values...

theres a bunch of useful things in the scripts --> lock and connection management section. sp_what, sp_who3 are good places to start. they arent hard to mod to get you...

NOT NORMAL!

Terminal services manager does the same thing to me.

Go to the properties of the shortcut that you are launching, and change the Run Property to Maximized (not normal, not...

Its not your SQL.

You should have them add this to the .NET app. Since there are several methods in ADO.NET to open a database connection (sqlCommand, DataReader, DataAdapter), the connection...

top 1 will insert one row at a time, but youre not going to be able to do this with the existing table structures.

There is no strategy for mapping or...

howabout you add a column (timesDisplayed) to the ThoughtsStore table for the number of times the thought has been displayed.

insert into todays_thought

select top 1 * from thought_store order by...

I'm not sure what you are trying to do by date. How are you determining what day to use or if you have used this thought already?