Crispin -

I don't have numbers to back this up. But I found better performance when I formatted my SAN with 64k clusters. We made this the standard on...

If the original field was a char(xx) field, then I think you do need the rtrim, then again, if it was char(xx) we would need to check that there is...

Hi Jag

That is the PrintArea of the particular spreadsheet.

Michelle

I don't have first hand knowledge...but

I talked with a Microsoft Employee at the PASS summitt. He suggested the book ISBN: 0316919160 How Would You Move Mount Fuji? Microsoft's Cult...

Is it possible that your file has fixed width columns instead of delimiters? If the spaces are used to make a column uniform in width down through the table,...

You can use multiple delimiters in the DTS import/export utility.

When you import a text file you will reach a screen that asks you if the data is delimited or fixed...

An Oldie:

MCSE: Minesweeper Consultant / Solitaire Expert

And I found this list with more play on the Microsoft Cert.

http://lists.essential.org/pipermail/am-info/Week-of-Mon-20011105/007738.html

I'm sure none of this is what the original poster had in...

TMI - Too Much Information

This is one I just heard recently.

Michelle

For completeness and future reference:

The problem must have been a corruption in ODBC. SQL was processing all the commands EM sent, but for some reason not sending them back???...

To try to help this problem, (I'm fortunate to not have 3rd party databases), I have a naming convention for the indexes. I#first_column#second_column or IC#first_column#... if clustered. It...

Yes, I missed that. Thanks! Michelle

--I haven't changed the password recently.

--I can run queries with either authentication.

--profiler shows all the queries/sp generated by EM and I don't see any errors.

--No errors in my event log...

I reapplied SP3 on my workstation and still have the same problem. It is happening with any EM I use, my workstation, the server's copy of EM, other Server's...

My understanding of VBTray.exe is that it is the 'real-time scanning' application of Symantec's AV product. But I can't find mention of it at their website. HQ is...

FeiFei -

We use 64k cluster size here when formatting the partitions. With 4k you can end up with very fragmented drives in no time due to a page in...