Ed Wagner (8/8/2013)

---

I'm not sure about using bcp, but here's how I would do it in a procedure.

BULK INSERT incoming_data

FROM 'L:\CurrentData.txt'

WITH (DATAFILETYPE = 'CHAR',

...

Hi, I installed ultraedit trial version....could anyone of you please help me how to bcp the data from text file ( null separated file ) to sql table....

I really appreciate...

Ed Wagner (8/7/2013)

---

The error says that you have an invalid column number in your format file. I know it can be a bit confusing at first, but once you...

Ed Wagner (8/6/2013)

---

For repeated data loads from text files, I find it better to use a format file to control what goes where. It takes a bit of work...

hi...

Lowell (8/6/2013)

---

open the file up in an enhanced text editor like NotePad++;

you'll be able to see what the row terminator actually is.

i think \r maps to CHAR(10), and \n...

Thanks Paul for quick response...

Good question...no linked server..since we have almost 150 servers in our environment...i would like to get a script that connects and retrieve the results...i think i...

Thanks steve....

Thanks Steve for your response and support to this community....

but i'm looking for a document that guides me step by step..if you or anyone has a link or document please...

thanks for the response....

but i dont see much activity in the instance...and it occured around 1:20 AM....

opc.three (5/16/2013)

---

chandan_jha18 (5/16/2013)

---

opc.three (5/16/2013)

---

chandan_jha18 (5/16/2013)

---

As you posted, you have already fixed SQL Server and given it a range between which it an fly up or down.

I would suggest to collect...

One application job has run from 3:30 AM to 5 AM today morning...we got the alert around...4:07 AM.

Not sure if its the reason...

Do i need to change the memory config...

Thanks for the repsonse guys...

Today it went to 99.33%

Here's the alert info...

5/16/2013 3:36:32 AM, OS Memory Usage (Percent) on XXX is Warning.

SQL Server instance XXX - The operating system has...

Thanks for the response...

Never mind our requirement has changed and we are going to do full db restore...

Thanks again

i'm missing something here....please let me know...

DECLARE @db varchar(100)

DECLARE @defaultDataLocation nvarchar(400)

DECLARE @defaultLogLocation nvarchar(400)

--if (@db = 'test_restore')

IF @db = 'test_restore'

PRINT 'The database exists'

Begin

select physical_name from sys.master_files where DB_NAME(database_id)...