ugg... programming a solution because someone doesn't like to click print 3 times.....they don't need to File...Print...change to 3...just teach them to click the print button off the tool bar...

just to clarify, an option or checkbox must have the CHECKED in it's definition:it's a keyword, and not the "value"

<FORM METHOD=POST ACTION="">

<INPUT TYPE="checkbox" NAME="firstcheck" value="Value to send Via GET or...

I think we need a bit more information before we can really offer meaningful suggestions...

by syncronization of data, do you mean one way, from 2000 to 2005, with a change...

can't you simply export as comma or tab delimited, but name the the file xls so that it will open in the expected program? I know I do that all...

not an "automatic" way that I'm aware of;

you can make it a habit  to recompile objects on a regular basis (exec sp_recompile object name) for all procs, views and functions,...

newid() is the function most people use in order to get random order, and random counts use the rand() function.

I had to build the schema and data in order to...

just pasting some code that might be helpful: my snippets catalog named this "Find and Replace TEXT/NTEXT" this is really for when you cannot display a TEXT/NTEXT because it's more...

losts of good suggestions here...I wanted to mention that you should look at what the jobs are doing as well....maybe they can be replaced outright.

I had a similar issue where...

connection broken is typically a one time kind of error, where you lost your connection to your database, whether a cable was kicked out, an admin killed your spid, or...

you'll want to do the following:

do this on test first, and not production. I'm recommending using Enterprise manager for part of this, because it will handle a lot of the...

I had previously written a script that does exactly that...build sthe commands: try this out:

not 100% sure that this is what you want, but this is pretty close: limiting to top 100 because this can be a whopper of a resultset.

there are several scripts in the scripts section that do this:

i searched "directory exists"

Verify Directory Exists and Create if Necessary

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1463

therre are several others as well:

don't try and find the items that are no longer in the view....create the OPPOSITE of the view, and have a schedule job email you or something for every item...

i typically bulk insert EVERYTHING into a staging table, and then in the staging table i would Select * from the column where column not (like HEDR%') and not like...