Does anyone know of a way I can more-or-less duplicate the SQL Profiler in VB.NET? (C# if necessary, but VB if possible) I need to monitor a database for incoming SQL/Transactions so I can duplicate them on another system. I can't use replication, as most of the tables get...
Hi. I'm using a copy of SQL7 and have this trigger written:
alter trigger u_per_master on per_master
for update
as
begin
declare @counter int
declare @fieldcounter int
declare @fieldname varchar(50)
declare @fieldnumber int
declare @oldvalue varchar(50)
declare @newvalue varchar(50)...
I've got a SQLBase8.0 database which I can connect to successfully with the SQLBase DBA Utility and through Crystal Reports. However, I have had absolutely NO luck trying my own ODBC connections. Could someone post a successfully working connection string that I could play with? Thanks! =)...
As far as I know, you could only get the name of the function from the stack, which is probably a bit beyond most VB programmers (myself inclueded!). Personally, I don't think that it's too big of a deal to copy/paste the name of the event-sub (Command1_Click) and have the AddError2DB sub...
I originally learned SQL Server on the 2000 version. Due to the economy, I've had to move across the country (to indiana of all places) where they can't(won't?) upgrade. I need to be able to add some users to the system, however in the New User dialogue box, the "Login name" combo...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.