stop what job? we haven't created any jobs?

if you follow the steps

create the tables in connection 1

begin tran in connection 1

update table1 in connection 1 --this one will complete

begin...

CTRL+A --> Delete

in windows 1 run the below

USE TEMPDB

CREATE TABLE dbo.foo (col1 INT)

INSERT dbo.foo SELECT 1

CREATE TABLE dbo.bar (col1 INT)

INSERT dbo.bar SELECT 1

Then clear the text from the window

Then run in the...

please take a look here, this is what I use to test out my deadlock alerts

dont know if this is the right cause but

it might be down to the time it takes for the SQL Agent job to execute, so if it takes longer than...

No its not historical. For that you would have to build some custom monitoring scripts, run a profile trace or purchase a 3rd party monitoring software

+1 on what GSquared said.

One way to stop such a thing would be to limit the application to one user and then give it a really complex password. You...

you can manually type in the domain extension into the login box instead of searching for the users if the domains are not in the same forest, if they are...

i'm still interested to know if the card details are stored in the DB in clear text on this one

I haven't tested this so please take what I give as a guide

Ok for the weekly report running from Monday @ 00:00:00 to Saturday @ 00:00:00, you can use these...

I ran into this issue a hell of a lot in a multi domain environment.

user machines and accounts where in subdomain.domain.com and servers where in domain.com

we would detach a database...

Daniel Bowlin (3/21/2012)

---

Query the full month's worth of data into your dataset.

Put a filter on your weekly that is something like Datefield >= Dateadd("d",-7,Today()).

Put a filter on your monthly that...

yeah will be do able, can do it in the t-sql for the data set or in the tablix properties as a filter expression.

i'm leaving the office for the day...

Lynn Pettis (3/21/2012)

---

Steve Jones - SSC Editor (3/21/2012)

---

Lynn Pettis (3/21/2012)

---

Some people. Let's report a problem trying to save changes from the UI but able to do it with an...

in terms of past week is it say, I run the report on a Friday so I want to see data from Friday to Friday (exact 7 days) or is...