You need some type of server side component to do this, like an ASP page. There are some articles on the site showing this. Or you might to better searching on 4GuysFromRolla.com. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-07
Just make sure it does not take a snapshot in time and comapre it to another snapshot in time otherwise you may take out users you don't mean to. For example you do a select against sysprocess at 10:00 AM to get the spid and loginnae of each inactive user, do the same thing at […]
2003-06-20
1 reads
Some additional information that might be helpful is on this web site:
2003-06-17
1 reads
You can also use BULK INSERT (Which is rapped by BCP) from within script of a proc. See BOL for help on that. Works well and fast. Cheers, Crispin
2003-06-17
Thanks. That's a solution that I can use! I added a SQL task (following the transform data task) that counts the records using the same query and setting a global variable. It works! Is it also possible to get the record count from the transform data task directly (not using a count(*) query but by […]
2003-05-26
create a parameter-table with a column "lastkeyvalue". Read that value for update and than its all up to you. Others cannot reach it until you release it. That is if you want to have a key sequence. You could also use uniqueidentifiers. Then you can just generate them at clientside. They are considered to be […]
2003-05-08
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