someone must have SA rights to the server who can see the error logs?

why not use SSIS which is a part of SQL for your ETL

you will want to take a look at the keywords, try, catch, xact_state, error_number, error_message and transaction which can be found in BOL and Google.

do the insert inside the try...

can you view the sql error log as error 18456 has a number of states which determine that the actual cause is. SSMS will only usually show state 1...

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...