Personally I would preprocess the data outside of sql then load.But if you want to use sql1. DTS the data into staging table (varchar columns as Mike suggested) including an IDENTITY column 2. Parse the data into rows of ColumnName,Data pairs (including identity) 3. Create table consisting of all columns 4. Insert.Update table with data […]
2004-01-30
Helder, Try creating a table with a single column VARCHAR(2000) and build the FTP command into a string and then INSERT that string into the table you just created.You can then review the information that you are passing into the FTP command and see where it is going. I agree with you that the problem […]
2004-01-29
B) I always thought an MSDN subscription was the most cost-effective way of licensing SQL Server (and other dev tools) for a development environment...? I agree. I think it is interesting that the most common answer by far is that the developer edition is free. That's what I said. It may not be free exactly, but […]
2004-01-29
With MSDE 2000 the default security is Windows Authentication. If you change the following registry settings this will allow you to use SQL logins.Change the loginmode file from 1 to 2HKEY_LOCAL_MACHINE/ SOFTWARE / MICROSOFT/MSSQLSERVER/MSSQLSERVER/loginmodecheers
2004-01-29
1 reads
This is a new thread of topic originally started under TSQL (Title= Spaced Out - Why large difference in Space Reserved). This may or may not be DTS transform specific problem. Problem is when record insert commit is set to 1 (comment individual recs) it uses significantly more space than when commit is set to 0 […]
2004-01-28
2 reads
I'm sorry, but I can do not completely understand your post. Are you executing SQL1, SQL2, SQL3 all in same script, one after the other?Whay can't SQL3 be:INSERT INTO [UserID] ([User_Id],[MasterOverride], [ConfigurationId]) VALUES (IDENT_CURRENT('[UserList]'), c_MasterOverride , c_ConfigurationId
2004-01-28
Dear ckempste,I already thought of your idea before but it takes a lot of time. I need to change quite a lot of tables. Any other ideas?
2004-01-27
Hi All,I got an error while restoring a database . The error is "Exclusive access is could not be obtained because the database in use". I took the backup using the same user using ' BACKUP DATABASE test TO DISK = 'C:\test.bak' ' . When I tried to restore the databse from the backup file using […]
2004-01-27
2 reads
Okay, I see why that "correlated derived table" works. It doesn't need to be a derived table, and the query optimizer automatically reduces it to a simple correlated subquery.
2004-01-26
1 reads
Tom,I was not actually talking about your requirements. I understand that in some cases business or technical requirements overrule best(?) practices.I was asking EdVassie about why he would rather have the images in the DB. I have always though it would be better for lon-term managment of the system to keep the images separate, but I […]
2004-01-26
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers