Search results for query: *

I'm running a trace on a server to monitor which databases on the server are being used currently. In my trace columns I have DatabaseName and DatabaseID. Wouldn't you know, the databasename column remains empty throughout but databaseID column is populated by numbers (8, 2, 15, etc) When I run...

We have a CRM that connects to SQL server and has been administered haphazardly in the past. There are almost 50 SPID's and it's not possible to tell who is the user in most cases (the owner is Sess and Lock type = DB, Mode = S and Status = Grant) They mostly have the same "last TSQL Batch...

Hi all, I never did get this trigger to update the Contact1 table when 'CT' value is entered into Conthist. Simply put, nothing at all happens! I gave up on it for a while, but now I'd like to revisit the thing. Thanks for any insights .. ************************** IF EXISTS (SELECT name FROM...

Hi all -- I can't remember how to do this: I want to select distinct company, field2, datefield, field4 where field4 = 'Val'. Now, I only want one listing for the company, and that is the record with the most recent datefield. Make sense? Thanks a bunch "You cannot hold a torch to another...

Happy Friday! I'm running a trace to monitor users activities on a server and I want to save it as a readable document. Notepad saved as MyTrace.trc is unreadable. Any suggestions please? "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

Get it? The SQL? Har har. Anyway, this isn't working and I can't see what's wrong. When I update Conthist with the value 'CT' that's supposed to update contact1 (the Begin--End block) Thanks once again. ****************************** IF EXISTS (SELECT name FROM sysobjects WHERE name =...

When the sales rep updates a record with the value 'CT' we want to insert a date in another table (cast as Varchar, cuz it's a varchar field) This was the trigger I wrote but it ain't triggering!! (Key3 is not updating with the Date) *********************************** USE SalesCrm_06 IF EXISTS...

I think that I'm close here, but I'm getting errors, and what I am attempting to do is to pull that ch.accountno into the @accountno variable so that the update in the contact1 occurs where that accountno (unique) is. **************************************** CREATE TRIGGER TrgLastCont ON Ch...

Please disregard the thread "Hi Experts". It has the wrong email address as return address!! This is my first attempt at a trigger, and doing a keyword search on triggers (tek-tips) produced no results, so thus, this post. The SQL Server BOL starts with: *************** If exists (select name...

Hi all -- I'm trying to get a query which will return ONLY results which have a count greater than a certain number (in this case, 200, but that's arbitrary) but my query is returning odd results so I don't trust it. *************************************** select count(*) as No_imports...

Hi all -- this query hangs forever, so I don't know if it is the hardware (512 mb RAM) or the query. ******************************** select count(*) from contact1 c1 where c1.accountno not in (select accountno from conthist) and c1.accountno not in (select accountno from cal) and...