Viewing 15 posts - 331 through 345 (of 2,897 total)
An example is an INSERT TRIGGER that runs this statement.
execute @nReturn = SPName N'INS', @dDATE, @nREADING
But, If I run this, I see it in my trace:
DECLARE @nReturn varchar(100) execute @nReturn...
June 16, 2020 at 2:46 pm
I came up with an idea to run a trace file capturing events.
Then list all database objects to a table
Then search the trace file where TEXTDATA LIKE the object name.
A...
May 14, 2020 at 3:29 pm
I'm a moron. Somehow the job step was set to fail the job, even on success. Not sure how that happened.
May 22, 2019 at 6:06 am
What I'm wondering is if the data is only 50 characters, the remaining 450 characters will be blank. So is an index on basically the first 50 characters of a...
May 21, 2019 at 2:58 pm
It's happened two days in a row now. Maybe killing any SPIDs found in sysprocesses first ?
May 21, 2019 at 12:06 pm
This statement is right before the restore, and has been for years without problems, to prevent "Database in use" type errors
ALTER DATABASE MyDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE
Is there a...
May 21, 2019 at 9:29 am
Auto Create Statistics & Auto Update statistics are both set to "True"
April 15, 2019 at 3:28 pm
Seems strange not to have a "RUN" button inside a stand-alone package.
April 11, 2019 at 1:32 pm
Resolution: Looks like the problem was a password connecting to an FTP site, not a local SQL password.
April 10, 2019 at 7:25 pm
Test connections work when editing the package. I have an old package that works, and can't see what's different.
I need an SSIS for Dummies book I think.
April 10, 2019 at 6:18 pm
Bad habit of (*) perhaps. Thinking "It's just a count"
April 7, 2019 at 12:49 pm
Looks like a forum software downgrade to me. Yuck.
April 6, 2019 at 11:56 pm
I can't figure out these damn BBCodes.
April 6, 2019 at 11:04 pm
Viewing 15 posts - 331 through 345 (of 2,897 total)