Hi Ed,

Can you post your create script of the table, which column you want as your primary key and some sample rows that are causing the problem (just examples) so...

Are you unable to shrink because of an error or is it just not shrinking?

run this and let us know what it returned:

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name = 'HFM_Prod_Data'

looks like it...

Got it right! Playing euromillion today! (I work with 2008)

+1 :hehe:

The worst commenting, not comment, ever was when i found my stored procedure is not working for some reason:

CREATE PROCEDURE dbo.Procedure

AS

---BEGIN

---The whole procedure code commented

---END

Not sure if it counts...

Now when i look at it, it actually looks like one of the EDI formats. I did have a chance to work with EDIFACT files before but i remember that...

You can't use WHERE with BULK INSERT.

Your alternative may be the way to go in this case.

Not only row 2 is connected but other rows are connected in column A10 as well.

Could you attach a sample text file? I would like to have a look at...

You need these options on to use xp_cmdshell

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

EXEC sp_configure 'xp_cmdshell', 1

RECONFIGURE

EXEC xp_cmdshell 'osql -E -S "SERVER.edu" -d "DBNAME" -i "E:\ACRC443\event_echo_1\event_echo_ins_1_1.sql" '

Are you sure VARCHAR(100) is long enough for this second statement?

Try

GRANT VIEW DEFINITION

https://technet.microsoft.com/en-us/library/ms175808(v=sql.105).aspx

Hi Martin,

I had to create that table within my logins tablespace, I have no idea why i couldn't grant access to that table instead of recreating it under different schema....

Finally i've got a success connection message !!

I had to play a little bit with Oracle Net Manager and now using ServerName:Port/ServiceName and SYSTEM login i'm able to connect.

Now... I...

HI Martin,

Yes...

I'm lost, please help...