I'd insert into a temp table that does use an identity. You can set the seed to be the "pop" value from your separate table and then update that at the end. Be sure you lock this value until then (use a transaction). Insert into your table from the temp table.. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones […]
2003-07-24
Hi Frank, In Master. I'm on SQL7 SP4 may be it has been dropped in later versions!
2003-07-24
I have to agree with Mark on this one. I've watched people intentionally not listen to my mother because she was Japanese. It didn't matter that she was speaking perfectly clear English with only a hint of an accent. Because they said to themselves, "I won't understand her so I'm not going to even listen," […]
2003-07-21
1 reads
You cannot restore a SQL Server backup to MySQL. You can possibly use DTS or other facilities to transfer data though.
2003-07-21
1 reads
sounds like a locking problem - do the steps synchronously and insure that each step is complete before proceeding to the next step - haven't played w/c# yet, but you should be able to do this w/ado
2003-07-21
Master must have the guest user, so by default all users have access to it. Same is true of msdb. The guest account in master is required. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-12
Does the login you used have permission to run this command? Can you post exact error message from QA?
2003-07-09
a5xo3z1, thank for the answer, my script in asp are server side for accessing db, so i think it'll be the same for sql server, or no?? i know that its better the sql string anywhere but in my site there is an alternate type of access, sometimes i need string sql and sometimes i […]
2003-07-09
1 reads
quote: Don't think SQL Server does that. You may temporary deny database access to those logins you think they no longer need and see whether users complain about. Allen, Check this web site: http://documents.iss.net/literature/DatabaseScanner/reports/sql/SQLStaleLog.pdf They have a document that list stale Logins which is exactly what I am looking for, what they don't provide is […]
2003-06-27
quote: yes, one of the last things where Germany is ahead Ahem 5-1...sorry couldn't resist quote: I decided to blame every SQL error on RitchSQL You can't do that, MS will be blameless then Later Ritch *I didn't do anything it just got complicated*
2003-06-27
2 reads
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