Viewing 15 posts - 6,361 through 6,375 (of 7,429 total)
Also what version of SQL are you using?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 18, 2002 at 10:00 am
Sorry try instead TSQL SQL:StmtCompleted and you will see the queries. You can also use Sotred Procedure items to see when a Procedure is used.
"Don't roll your eyes at me....
April 18, 2002 at 8:12 am
If ASP is runnign on a seperate server then your issue is probably from whatever version of the MDAC you are running. Install at least the one shipped on the...
April 18, 2002 at 6:46 am
Is you update being done thru stored procedure? I have not seen anything like this
quote:
Server: Msg 137, Level 15, State 2,...
April 18, 2002 at 5:12 am
Ok now it gets fun. I have a suspect on one reason but need some more details here. First what is the time difference now? Also can you post the...
April 18, 2002 at 4:58 am
Yes, an it can be a pain to figure out exactly why. Can you post the DDL of both tables please.
"Don't roll your eyes at me. I will tape them...
April 18, 2002 at 4:53 am
What is the problem the app is having? I have never seen an app freak based on sort order before as that effects that methodology for the sort to work...
April 18, 2002 at 4:30 am
I deal with limited space but so far my time has not been an issue. Plus I have a free drive with enough space for the backups without it being...
April 17, 2002 at 5:38 pm
Everyone seems to have the same feeling but 1 thing I don't agree with is not having anything in place. Remeber you do have executables and things do happen so...
April 17, 2002 at 3:51 pm
SELECTs can really only be caught via Profiler or other query monitoring method. The others can be done via triggers
Ex.
CREATE TRIGGER tr_AuditUse_tblX ON dbo.tblX
FOR INSERT, UPDATE, DELETE
AS
INSERT INTO tblAudit...
April 17, 2002 at 3:41 pm
Sorry BCP has a maximum of 65000 something ignores then no matter what your setting is it stops ignoring. You could break into batches with firstrow lastrow options. But the...
April 17, 2002 at 3:25 pm
Ok you stated you did not know about cleaning the tape drive. This needs to be done periodically to ensure tape mess and dust are not on the recording heads....
April 17, 2002 at 3:22 pm
Let us know if this goes away or if you have any other issues. Also just so I don't cause you any issues myself inadvertently. You should always perform a...
April 17, 2002 at 11:42 am
There is not much in the way of being able to trap errors in SQL. @@error will have the error number and you can use RAISERROR to pass a specific...
April 17, 2002 at 11:16 am
No other way, you hit it on the head.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 17, 2002 at 11:15 am
Viewing 15 posts - 6,361 through 6,375 (of 7,429 total)