nwinningham (8/11/2008)

---

How can I get this information to come back in one row?

Thomas Hainey 999999 NULL ...

I am happy that you are now able to move forward. Glad we could help.

Jeff Moden (8/10/2008)

---

I believe the question is how to load the Word file into the VARCHAR(MAX) element.

And, yes, I agree... it's probably better to store the name of the file...

rbarryyoung (8/10/2008)

---

Hmm, yeah I see where it says that Jeff. I may be wrong here, when I wrote my view (about 2-3 years ago) I was still working on...

Well, according to BOL - no, you don't have to update usage.

Reports and corrects...

I have absolutely no idea on what additional information you need. How you implement storing image data in SQL Server all depends upon what you need to do.

For example,...

For SQL Server 2005 and greater - there is no need to cursor at all. Just use the DMV sys.dm_db_partition_stats as in the following:

Select object_schema_name(object_id) As SchemaName

...

Instead of dropping/recreating the indexes - look at just disabling the indexes and rebuilding them after the process has completed.

ALTER INDEX index ON table DISABLE; --disables the index

You still...

Use the varbinary(max) data type. Also, look at SQO Server 2008 and filestream objects, which will work a lot better when storing this kind of data.

To upgrade your client tools, you need to run the service pack upgrade on your PC. You validate that the client tools have been upgraded by going to Help...

Disregard my previous post - I see the problem you are having. Stored procedures are created and stored in the database - not in the report.

Open SSMS, connect to...

Can you also post your full create procedure statement? And, please try executing the procedure in a query window as:

Execute 'your procedure name here';

And post the results of the...

Lookup linked servers in Books Online. What you are going to need to do is install the ODBC drivers for Oracle and Postgres on the server, then setup your...

Are you talking about the About window in SSMS showing the RTM version? Or, are you looking at the connection in Object Explorer? If the latter, then -...

The only other tool I know about is the SQL Server Health and History tool from Microsoft. It can be downloaded from: http://www.microsoft.com/downloads/details.aspx?familyid=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en