Mr Young,

Thank you for setting me straight. 🙂

I appreciate & respect your input.

If you think of any instructional articles and if you get an chance I would appreciate if you...

Sorry about that. I did not realize that they were not clickable

Thanks for letting me know and for all of your contributions to this forum.

What is the definition of the Change Column; what does it mean & how can it be derived, i.e what is the formula for determining the Change column or is...

The following articles describe how to create a Database using Powershell:

http://arcware.net/creating-a-sql-server-database-from-powershell/

http://sqlblog.com/blogs/allen_white/archive/2008/04/28/create-database-from-powershell.aspx

I believe that this is what you are asking.

Replace [YOUR TABLE NAME] with the name of the table.

SELECT Date, [Close change]

FROM [YOUR TABLE NAME]

ORDER BY [Close change] DESC

I hope that the following links are helpful to you:

http://msdn.microsoft.com/en-us/library/ms177461.aspx

http://msdn.microsoft.com/en-us/library/ms177461.aspx

For SQL Server 2000 osql -- sqlcmd utility introduced in SQL Server 2005

http://www.sqlservercentral.com/articles/Administration/failed_jobs/803/

http://www.mssqltips.com/tip.asp?tip=1865

I have only used Lightspeed.

I was not sure what meant by:

but a light setting on a server that was used constantly and we didn't want the CPU hit from the...

How does SQL Server 2008 Backup Compression perform compared to Litespeed & Redgate's product?

I apologize for not taking the time as Paul did to fully explain the implications concerning the use of a Text Field.

You are right, it does not work.

You can create a view, preferably an Indexed View if the table is large.

I tried to find out why Access is limited but I...

No this is not allowed on a Text Data Type.

Try it...

Did it ever work?

If so when did it stop working?

You may want to start from scratch.

Respectfully, do you have any documentation on the setup, configuration & troubleshooting of an SSRS...

How did you configure SSRS using the Configuration Manager Tool (rscong.exe)?

What did you do when you used the rskeymgtmt.exe encryption tool?

What options did you select when you ran the rs.exe...

Are you logging on as the Service Account when you log in?

That is really wierd. The database is in use and it would appear that the operation that your are attempting to perform requires Exclusive Access.

Exclusive access could not be obtained...