Viewing 15 posts - 1,126 through 1,140 (of 2,008 total)
Kit G (12/3/2011)
Thanks for all the congratulations on our anniversary. 🙂 Had a really nice day and am looking forward to the vacation with my hubbie.
I knew only...
December 3, 2011 at 6:45 am
I didn’t want to ask for it but did you restart services / server after upgrade?
Is downtime acceptable?
December 3, 2011 at 6:41 am
My doubt is more on file permissions only.
Can you login on server (Windows Login) and open '\\efs2\e$\WebFiles\Uploads\boaMother.csv' file in excel or notepad?
December 3, 2011 at 6:33 am
Chuck 17099 (12/3/2011)
Here is the code:bulk insert #t2 from '\\efs2\e$\WebFiles\Uploads\boaMother.csv' with(firstrow=5,fieldterminator=',',rowterminator='
Is bulk insert considered Ad Hoc?
Chuck
Nope.
December 3, 2011 at 6:29 am
And why do you want to do that? If you have the execution plans (estimated / actual), you know very well what are the bottlenecks? Its cost distribution & execution...
December 3, 2011 at 6:00 am
Is there any reason not to remove the default schema on any principals where the schema is not in use? With a few exceptions such as dbo and guest. I'm...
December 3, 2011 at 5:52 am
I guess these two culprits. Can you please post your Bulk Insert code?
ad hoc distributed queries Option
By default, SQL Server does not allow ad hoc distributed queries using OPENROWSET and...
December 3, 2011 at 5:37 am
Please check the permissions on the file "<<file.csv>>".
December 3, 2011 at 5:19 am
How are you importing from flat files? What’s the error message?
I believe advanced options might have reset. Please crosscheck those.
Setting Server Configuration Options
December 3, 2011 at 4:31 am
Something to start with... 😉
Stairway to Database Design
December 3, 2011 at 4:17 am
hitechimp (12/2/2011)
...
Please reply here for hitechimp's question.
http://www.sqlservercentral.com/Forums/Topic1215777-1550-1.aspx
December 3, 2011 at 4:12 am
Three Options:
Reboot the Server. It will restart all the services in proper sequence.
OR
Check your privileges. You might not have sufficient privileges to see SQL Server Agent.
OR
Last Resort... Uninstall SQL Server...
December 3, 2011 at 3:55 am
GilaMonster (12/2/2011)
Dev (12/2/2011)
GilaMonster (12/2/2011)
MyDoggieJessie (12/2/2011)
...can I restore just the last differntial back, then restore the TRN files since that backup?
No, once you recover the database no more backups...
December 2, 2011 at 10:36 am
dcw8888 (12/2/2011)
Yes, I tried Import Wizard and also create a linked server to the mdb file and query the table directly.... still not seeing the milliseconds.
In Import Wizard you can...
December 2, 2011 at 10:28 am
GilaMonster (12/2/2011)
MyDoggieJessie (12/2/2011)
...can I restore just the last differntial back, then restore the TRN files since that backup?
No, once you recover the database no more backups (differential or log) can...
December 2, 2011 at 10:24 am
Viewing 15 posts - 1,126 through 1,140 (of 2,008 total)