A linked server should work. Haven't had a chance to try it yet, but it should be easy enough to set up. Will that do what you need?

Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10%5B1%5D.pdf

I haven't tried it myself, but it's entirely possible that Restore Log is only necessary if you're using options like stopping at a certain point in time. Haven't tried...

You can ask general help questions here. If they're not specific to a particular version of SQL Server, this forum is as good as any other.

k.subramanyam1017 (4/30/2012)

---

for example i install the enterprise editions of sql server2005 and 2008

if u dont mind the pls tell me atleast two difference of installation enterprise editions of...

Another thing you can usually do is use OpenRowset to query the file directly, without importing it into a staging table first.

On the file terminating unexpectedly, how big is it?

Birthday isn't a valid test for SSNs. It's only very recently that they started issuing them that early. I got mine when I was 18, when I first...

Honestly, partitioning is complex enough and very sensitive to the actual data it's being used on, that all I can suggest is testing it out. You'll find out more...

SELECT SALES.Reference AS 'SalesOrder Referance'

,SERV2.Reference AS 'ServiceOrder Reference'

,SALESTAT.NAME AS 'Sales Order Status'

,SALECAT.Category AS 'Sales Order Category'

,SOJ1.[No Of SOJ] AS 'NoOfSOJ'

,SOJ2.[JobNumber] AS 'SOJ Number'

,SUB1.[ActivityDate] AS 'Appointment Date'

,CUST1.ShortName AS 'ParentCustomer'

,SOJ2.JobStatusID

,PERS.ShortName

,CASE WHEN...

Nothing I know of does that.

That's what database inventories and documentation are for, really. I have an internal wiki where that kind of thing gets documented.

You can't, so far as I know, put a freeform text box in a report. It goes in a form that wraps around the report. It's part of...

No. Then you'd have to stitch them back together to actually show the image. (I'm assuming you mean something like JPG or PNG files when you say "images".)

The...

Not directly, so far as I know. You might be able to gleen some clues from the create date in sys.databases. If it was created before 2008, odds...

Further clarification:

If you read the data on http://msdn.microsoft.com/en-us/library/cc949109(v=SQL.100).aspx, you'll see that it says:

Note that it says, "name of...

The sharename has to be a local name, without a server/computer name on it. Filestream will then share the data. It isn't a UNC path, it's a local...