correct, it appears the identity is not part of the transaction. The main reason is that if someone else were to run this with you, you wouldn't want them to be blocked from insrting a row because you held a "lock" on the identity area. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com […]
2003-12-06
Thanks for your reply Gil_Adi. I've tried to reinitialize the subscription, but nothing changed. Only the snapshot is run again, when updating the data from subscriber the publisher no any update Thanks
2003-12-06
Also you can do this with a view in EM. After opening the view, mark the columns, Ctr+C and paste. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-27
Well having the staging table on SQL Server will give you a "more elegant" solution than using Access. For reference, importing data into staging tables, then performing data transformations whilst updating the production tables, is almost standard technique for most datawarehouse loads, regardless of the platform. Hope this helps Phill Carter -------------------- Colt 45 - […]
2003-11-26
Well, yeah, now that I know its the recommended method. We'll go straight to SQL. Access handles the dates from Fox Pro natively, so it was an easy move. I can do it either way.
2003-11-26
2003-11-26
Why are you using Access as the intermediate step? Can't you create a staging table in the SQL Server database? Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-11-26
Yeah, Phil, it helps... a little. I've tried the staging table already, using MS Access as an intermediate step. I'm kind of glad you suggested it, because I thought I was really dumb for having to do it that way. I'm moving upwards of 100,000 records at a time, so this option seems to be […]
2003-11-26
You have a few options, 1) define a seperate transformation for that column. DTS has a builtin datetime transformation task. 2) perform an ActiveXScript transformation for that column. This would be necessary if data conversion doesn't work with the previous method. 3) import the data into a staging table, with the date as text. Then […]
2003-11-26
If you're copying and pasting into Excel, output to text and change the results to tab-delimited. Then you can copy and paste the whole lot straight into Excel. Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-11-26
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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