Ah it only supports 2 modes windows auth and mixed. How about changing a user password then and making windows auth read only?

This is correct but I need all my other selects in there as I pass this to a datatable for reportviewer.

thanks

Correct, I need to sum(Duration) grouped by Operator_Name and return the result desc based on the the sum for each operator.

Sorry I cant be any clearer, is there anything I...

Order by? top 50 what. Do I not need to sum the Duration then select the top 50 that what I don't understand

thanks

if not exists

(select * from syscolumns where id=object_id('ConfigTB') and name='DBVersion')

alter table ConfigTB add DBVersion int DEFAULT '1' NOT NULL

Any problem with this method?

Ok, I will look at this, but entertain me

insert [dbo].[AlarmDet]

(JobStart)

select

--convert (Jobsatrt (),101)

--SELECT convert(datetime, '23/07/2009', 103)

--convert (datetime, Jobstart,103)

--CONVERT(varchar, CONVERT(datetime, JobStart), 100)

--cast(JobStart as date)

from [SLADB].[dbo].[AlarmDetTest]

How...

Because I don't have the skill set to do that yet 🙁

In the end I opted for converting the flat file to csv then bulk inserting into a temp table all Varchar(100). Now this works great from my C# app but...

The file is 600mb + that I am trying to get to the tables, could I import all as string then copy to another table and parse on way. ?...

USE [SLADB]

GO

/****** Object: Table [dbo].[AlarmDet] Script Date: 08/10/2013 18:52:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[AlarmDet](

[Machine] [nchar](10) NULL,

[Job] [nchar](20) NULL,

[Mode] [nchar](10) NULL,

[User] [nchar](10) NULL,

[JobStart] [datetime] NULL,

[Object]...

[FieldFixedLength(10)] Machine;

[FieldFixedLength(20)] Job;

[FieldFixedLength(10)] Mode;

...

This is some sample Data

APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201013:41:48 Engine_Insert 10063Wed Mar...

doh! ^^

bcp SLADB.dbo.AlarmDetTB format nul -T -n -f ProdData-n.fmt -S localhost\DEV

works fine, thanks a lot.

My Next question is using that file is it possible to specify the format of...

SSMS connects using localhost\DEV

Ok Chris, I think I understand, but when I remove the simple data based on my table and use the real table it returns no results