ok, here we go production: SQL:StmtCompleted Duration 242 CPU 0 Reads 53 Writes 0 development: SQL:StmtCompleted Duration 80 CPU 0 Reads 53 Writes 0 i'm accessing both from home so i don't know if that'll make a difference (dev box is in the office, production box is in the states)
2002-04-19
Thanks for the solution. I tried using SQL Profiler Objects Event. But it does not work. Object:Opened and Object:Closed is supposed to work for SELECT, INSERT and DELETE. But it does not fire when I do SELECT, INSERT. Object:created and Object:deleted works only for create and drop tables. Please suggest which events should I select […]
2002-04-18
Yes only the schema but with all the table constraints. quote: the copy table you're trying to create off of the original table, does it need to have the data in it, or just the table schema? Paras Shah Evision Technologies Mumbai, India
2002-04-18
the copy table you're trying to create off of the original table, does it need to have the data in it, or just the table schema?
2002-04-18
I use user_name() as well. Just another reason to use NT authentication. If you've built so that you your app uses stored procs exclusively, I think that adding the logging to each would work, if a little tedious and redundant. If you use ADO recordsets they contain the before and after values, you could code […]
2002-04-17
Defintely Check the SCRIPTS page. There are a lot of good examples in there. -jG -JG
2002-04-16
2002-04-16
Yes it is never advised to use any kind of relations on a subscribers tables but you can try a few things. (I have not tried this myself sorry, but the principal should be right) On the subscriber you may be able to set cascade updates and cascade deletes on table_a for table_b thus a […]
2002-04-15
I know just wondered if there was a script out there already didn't want to reinvent the wheel thanks
2002-04-15
Before we venture too far, why is it you cant get a folder with the needed permissions? Seems like that is the easiest way by far to resolve the issue. Andy
2002-04-12
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