Viewing 15 posts - 12,946 through 12,960 (of 13,459 total)
aww nevermind; you stated that it occurs every time; that shoots down the easy fix;
October 25, 2006 at 2:21 pm
Greg is every connection, or just once in a while? if it is just once in a while, could it be something as simple as the db AUTOCLOSE being set...
October 25, 2006 at 2:08 pm
the bugs are from the forum converting things like semicolon + close parenthesis into a winking smily face.
the code worked perfect when i posted it; it just got a but...
October 25, 2006 at 1:56 pm
October 24, 2006 at 7:20 am
I've seen this before; it is caused by editing the name directly in Enterprise manager, and not via drop create/alter statements;
to prove it:
go to enterprise manager and find any view;
click...
October 24, 2006 at 6:34 am
usually, you get a collection of rows from the datatable, and loop thru the rows:
Dim
dt As DataTable
Dim
a()
October 24, 2006 at 6:19 am
there's pretty much only two ways; setting up a trace, which you stated you wanted to avoid;
you'd need to set up a trace to capture TSQL statement completed, and then...
October 20, 2006 at 12:37 pm
Greg's example is actually a bit better;
your example script would work, but it would always say 50000 rows affected, as there is no where clause. with no where clause,...
October 20, 2006 at 9:53 am
constraints are enforced acrross all data in the table, and there's no conditional constraints.... so you can't have a constraint Client_id and Code_id where isactive_flag = 'N' and a different...
October 19, 2006 at 7:21 am
Rgr is absolutely right....if you had a stored proc that was 30K in length, it would just occupy 7 rows in the syscomments table(30K /4K = 7 rows)
your boss on high...
October 19, 2006 at 6:02 am
and to expand on what Ken said, if the table doesn't exist yet, you can use the INTO command to create it on the fly:
SELECT Col1, Col2, ...
INTO MyNewTable
FROM YourView
October 18, 2006 at 11:12 am
From what you stated, I think I'd add a linked server for the Pervasive database, then write a procedure to grab the data from the ERP/Pervasive database, and insert that...
October 18, 2006 at 11:05 am
something like:
CREATE TRIGGER tr1 ON Transactions
AFTER INSERT,UPDATE AS
INSERT INTO TransactionLog(TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments )
--the table [INSERTED] is the data being affected by insert/update:
SELECT TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments FROM...
October 18, 2006 at 9:23 am
i'm assuming you want the trigger to insert data that is placed in an SQL table to also be propigated to a non-SQL table; you know that the virtual table[INSERTED]...
October 18, 2006 at 9:13 am
I think you'll want to avoid any functions like CONVERT and CHARINDEX in your joins/where clauses, as that requires a full table scan in order to get the data so...
October 17, 2006 at 1:01 pm
Viewing 15 posts - 12,946 through 12,960 (of 13,459 total)