You could use an INT (4 bytes) and record February as 200602

You could use SMALLINT (2 bytes) and record February as 602. Of course your would face the a...

I saw something like this years ago in an Australian television program.

I believe that these windmills are called Darrius windmills.

The BBC played part of George Bush's state of the...

Try RESTORE DATATASE [Your-database-name]

set dtsPackage = DTSGlobalVariables.Parent

Set sourceConnection = dtsPackage.Connections("Text File (Source)")

sourceConnection.DataSource = DTSGlobalVariables("PollingBaseDirectory").Value

The preceding 3 lines are in a DTS I use to upload a text file as specified in...

The release notes for SP4 say that it cannot be rolled back therefore take a full backup of everything before your attempt and install.

That said, I have not had any...

I don't know about that but I would jump to hotfix 2040 because SP4 (2039) has a bug that stops the SQL seeing all the memory in your server if...

You want to take a look at the SQLXMLBULKLOAD process. There are lots of threads on the site but I had a similar problem to you and got

The ZIP is on a local drive.

I will try and use StdOut but I am not optimistic.

Brian,

You forgot to mention the snippets!

type in ssf and press TAB and you get SELECT * FROM.

You can add your own as well so I have set up

derr to bring...

I should like to get my full MCDBA but it is expensive and ultimately I don't think it is reasonable to expect a company to pay for it all, however,...

If it is doing it during DEBUG I would suggest printing the LEN and the CODE() for the character that is being passed in.

Clearly DEBUG is translating the space in...

The only way that I can think of is to use an OPENROWSET and predefined connection but that isn't a way I would choose to do it.

Are you using Windows...

I can't speak for the clustered environment but SQL2000 does NOT require the service accounts to be local administrators.

The accounts obviously need full privileges to the directories that SQL uses...

I believe that each filegroup gets assigned its own thread so the only benefit you will get will be from whatever using separate threads gives you.

If you pass in a string containing nothing but spaces LEN will return 0.