Yes, that is definitely helpful. Thanks! I will be making use of the USER() function and other pertaining to the currently logged on user (who create, last modified the row, in triggers for auditing, etc) - so I will have to consider the latter information you posted. Thanks!
2003-08-05
How do i read the log file, i should at least be able to find out as to who did it and when ? quote: Hi All, Today seems to be a bad day....i found that two tables in two databases that i have, have been truncated...... is there any way to know which user […]
2003-08-05
quote: Seems common sense made you choose the correct answer. Something that does not exsist in Incompetent Inc. Time for a friendly (or even hostile) takeover Cheers, Frank
2003-07-30
Thank you very much for your response!! But, Is there any GUI option to truncate transaction log (as in SQL Server 7) without setting the database options such as "Simple Rocovery model" etc,?
2003-07-29
Hi Andy, Thanx for the advice. This is what I am currently doing. I 'dim' the following objects Database, TransactionLog, FileGroups, FileGroup, DBFile & LogFile as SQLDMO objects. I 'Set' the following objects: oDatabase as the current selected database, oTransactionLog as oDatabase.TransactionLog, oFileGroups as oDatabase.filegroups. What happens then is that the selected database's options and […]
2003-07-28
Investigate removing permissions from any public user, then using the Access Workgroup file to control permissions. Just a warning, it can get very complicated.
2003-07-25
PS:Completed indicates the stored procedure has completed. RPC:Completed occurs When one instance of SQL Server send a request for another SQL Server to execute a remote procedure, the relational engine recognizes it, and shows in the profiler as RPC:Starting and RPC:Completed when it completes
2003-07-23
2003-07-22
This query should return what you need: Select Coalesce(a.year,b.year) as [Year], a.value as 'ValueOfSubID1', b.value as 'ValueOfSubID2' from (Select * From MyTable WHERE ID = 1 and SubID = 1) a FULL OUTER JOIN (Select * From MyTable WHERE ID = 1 and SubID = 2) b On a.Year = b.Year and a.ID = b.ID
2003-07-22
2 reads
What about running the trace on the server, storing the results in a table and querying the results from the client using Excel or Access ? Then you only need MDAC loaded on the client and not Profiler. Check out this article for more information on how to run the trace on the server:
2003-07-07
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