Viewing 15 posts - 706 through 720 (of 2,008 total)
assistan11 (12/21/2011)
Hi Dev,If you can see the first screenshot on my opening post, look at the SQL query and there you'll find "FAST 5" and ", PT" 😛
I was assuming...
December 21, 2011 at 12:41 am
Would you mind sharing your script here? Its SSC tradition and it will complete the thread. 🙂
December 21, 2011 at 12:38 am
Suresh B. (12/21/2011)
Bhuvnesh (12/20/2011)
waseem.shahzad 45937 (12/19/2011)
I want to Monitor My SQL Server's Database events. Whenever there would be a change in My Schema,Execution of SP/Trigger/View/DDL/DML part>> The User's Machine...
December 21, 2011 at 12:27 am
Varun R (12/21/2011)
@dev : I am restricted to post the code...sorry...
Pseudo code is also fine. Rename your table / column names in the script and share it with us. Otherwise...
December 21, 2011 at 12:09 am
You posted your question yesterday but didn't get any response. Would you like to know why?
We expect some information from you to help you better. It’s Explained in the article...
December 21, 2011 at 12:04 am
Koen Verbeeck (12/20/2011)
Dev (12/20/2011)
Koen Verbeeck (12/20/2011)
Dev (12/20/2011)
... the psychologist use ink blot cards (Rorschach test) to read the minds.
I'm not locked in here with you! You're...
December 21, 2011 at 12:00 am
@varun: To avoid series of questions, please post your script here.
December 20, 2011 at 11:54 pm
I am not able to find any 'FAST 5' or '(", PT")' anywhere in the thread. What am I missing?
December 20, 2011 at 11:49 pm
Koen Verbeeck (12/20/2011)
Dev (12/20/2011)
... the psychologist use ink blot cards (Rorschach test) to read the minds.
I'm not locked in here with you! You're locked in here with me!
Ahem...
10...
December 20, 2011 at 11:47 pm
ONDEMAND_TASK_QUEUE
Occurs while a background task waits for high priority system task requests. Long wait times indicate that there have been no high priority requests to process, and should not...
December 20, 2011 at 11:16 pm
Bhuvnesh (12/20/2011)
waseem.shahzad 45937 (12/19/2011)
I want to Monitor My SQL Server's Database events. Whenever there would be a change in My Schema,Execution of SP/Trigger/View/DDL/DML part>> The User's Machine Name emailed...
December 20, 2011 at 11:08 pm
Don't get into the habit of using BETWEEN for dates. I guarantee that it'll bite you some time in the future.
Agree. My initial example uses < / > operators...
December 20, 2011 at 11:00 pm
You can find answers for all of your questions here.
Selecting an Account for the SQL Server Agent Service
http://msdn.microsoft.com/en-us/library/ms191543.aspx
Now I have one question to you. Was this user 'SNJ282\SYSTEM' able to...
December 20, 2011 at 10:57 pm
December 20, 2011 at 10:51 pm
Example:
USE AdventureWorks2008R2;
GO
SELECT e.FirstName, e.LastName, ep.Rate
FROM HumanResources.vEmployee e
JOIN HumanResources.EmployeePayHistory ep
ON e.BusinessEntityID = ep.BusinessEntityID
WHERE ep.Rate > 27 AND ep.Rate < 30 -- Date columns here
ORDER BY...
December 20, 2011 at 10:47 pm
Viewing 15 posts - 706 through 720 (of 2,008 total)