johnnyrmtl (3/20/2013)

---

Since the trace will never be closed and it will be started via command line , how would I go upon this if at all possible in validating which...

johnnyrmtl (3/20/2013)

---

K thanks !

I've launched a profiler trace and piped it towards a directory and a file...

I see 2 ID's within sys.traces but with the one I launched has a...

johnnyrmtl (3/20/2013)

---

Just to clarify ... if I am starting a custom trace ( not server default ) from profiler and would like to confirm the events that I am tracing...

i cannot imagine any way to automate this;

this really requires someone to go thru the data, and familiar with a lot more than just the names/users;

you don't have any other...

akberali67 (3/20/2013)

---

CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

davidandrews13 (3/20/2013)

---

are you doing something that...

there's far more information out there than we can provide in a simple forum post; forum posts are great for specific questions, but not so much for general research.

i...

most foreign key constraints are placed in a column that allows NULL, which is undefined;

if you are storing 'empty' or an empty string or anything else that's not in the...

kapil_kk (3/20/2013)

---

Hi,

I have a scenario according I have to create a table struture. As I have never designed any table structure based on a scenario of SRS. Plz guide in...

have the developer change the application connection string.

both SQLOLEDB and SQLNCLI providers have a default timeout of 30 seconds unless otherwise overridden in the connection string created by the application.

if...

peter.griffin 45527 (3/19/2013)

---

Hi,

I hope this is the correct location for my question.

I have written a simple piece of VBA to convert some data and save as a csv file which...

i think it has nothing to do with SQL, but rather the ACE drivers that are used to access via Excel;

the ACE driver does the peek at the first 100...

the OP's data as sample data:

i got that far, but my eyes blurred on the expectations:

With MySampleData (Date, Name, ID, Result )

AS

(

SELECT CONVERT(datetime,'3/18/2013') ,'A',1,5 UNION ALL

SELECT '3/18/2013','B',2,16 UNION...

look your command over again, it's got multiple places where other dual-single quotes exist.

try this line instead:

SET @sql ='bcp DatabaseName.[dbo].ABt_file_load_2012 in "' + @IncomingPath + @FileName + '" -c...

oops sorry: it's from an article i posted here:

sp_GetDDL_Latest.txt (scripts any object, returns varchar(max)

sp_GetDDLa_Latest.txt (scripts any object, returns multi row recordset)

the issue is subtle: you need to use dbl quotes, and not two single quotes, to identify teh field and row delimiters:

Declare @sql varchar(8000),@IncomingPath varchar(500),@FileName varchar(500)

set @FileName='12272012_114537_AB123.txt'

set...