About the data type, SQL Server determines it based upon what you provide as the calculation. That statement and more can be found at this link: http://www.winnetmag.com/Articles/Index.cfm?ArticleID=22831&DisplayTab=Article

It sounds like...

I believe the syntax you want for ElapsedDataTime is as follows:

, ElapsedDataTime AS DATEDIFF( minute, OnloadFormDateTime, FormDataInsertDateTime )

The above will define it as a calculated column meaning it has no...

Sorry. I forgot a string concatenation.

change:

SELECT @Members = case when @Members = '' then '' else ', ' end + FirstName + ' ' + LastName

to:

SELECT @Members = @Members  +...

I think a little more information is needed. Are you directly updating Customer_Payors or is there some sort of relationship being applied that is causing Customer_Payors to be updated indirectly?...

I believe the only set based way to do this is through the use of a function that performs in essence a subselect. Outside of a function I think you...

You can't use GROUP BY unless all non grouped columns are agregate results. If you want the 90% rows actually individually reported you have to drop GROUP BY and go...

Export it as described in my second post and import it into Excel.

Another option is to export the table content. From EM right click on any table (doesn't matter), choose "export data" within "All Tasks". Follow the guide. You can choose a...

Open Query Analyzer, enter your query, either choose "Results in Text" from the Query Menu or press CTRL-T, run your query, left click within the results pane, choose "Save As"...

I would say it can probably be determined, but I don't know what tools out there can perform the analysis. Basically, since everything (should) be logged, the transaction log file...

Look up fn_listextendedproperty within BOL (Books Online). We don't use them (knowingly) so I can't give you much more help than just pointing you to BOL.

Following is the procedure I use to defragment the database. 90% of it was originally stollen from somewhere. I think BOL. If not then I stole it from this site...

I have a scheduled job that defrags all indexes in all databases based upon DBCC SHOWCONTIG results. Over the weekend the job runs in about 30 seconds to handle about...

We have seen that as well. Once the device gets corrupted (such as the second version in my initial post) all subsequent attempts fail. We have corrected that by making...

Try changing database ownership to SA or whatever user you like to have as the owner.

You can test this on a not development box, or at least a non production...