Viewing 15 posts - 1,576 through 1,590 (of 14,953 total)
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?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 10:14 am
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
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 10:13 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 10:05 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 8:58 am
k.subramanyam1017 (4/30/2012)
if u dont mind the pls tell me atleast two difference of installation enterprise editions of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 8:44 am
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?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 8:34 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 7:25 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 27, 2012 at 12:36 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 27, 2012 at 12:29 pm
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 26, 2012 at 2:00 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 26, 2012 at 1:59 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 26, 2012 at 1:54 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 26, 2012 at 1:52 pm
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:
Enter the name of the Windows share in the Windows Share Name box.
Note that it says, "name of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 26, 2012 at 1:43 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 26, 2012 at 1:39 pm
Viewing 15 posts - 1,576 through 1,590 (of 14,953 total)