Viewing 15 posts - 37,561 through 37,575 (of 39,510 total)
I believe for the context of the trigger, Andy is right. You can join on the table itself in the query (along with inserted) and it works.
Steve Jones
May 6, 2002 at 10:39 am
I've used their software, not sure if this model, and it wasn't always stable. Most of the time, but occassionaly it flipped. I'm guessing they don't want to spend the...
May 6, 2002 at 10:37 am
A parametized query will work. You can also use a second package to call your package repeatedly, changing the value of the query for each to match a new recordset.
Steve...
May 6, 2002 at 10:36 am
I've had this issue on SQL Server 2K as well. It seems sporadic and I can't pinpoint why. I do have multiple drives mapped, some to different domains, but I...
May 6, 2002 at 10:33 am
How are you transferring? By IP or FQDN (use FQDN) or by hostname? If hostname, then you might have name resolution problems. Setting up a good WINs setup is a...
May 6, 2002 at 10:31 am
Brian is on a good track. This is likely a security issue.
I did the reverse, sending from the colocaiton to our office, but I choose FTP. It was cleaner than...
May 4, 2002 at 1:45 pm
Only a few users/logins and they were synched with sp_change_users_login (we use SQLAuth). They were added with sp_addlogin because our backup box was "appropriated" a couple months ago for...
April 30, 2002 at 2:17 pm
April 30, 2002 at 2:12 pm
SQL 2000 has more trigger options, but I'm not sure there is any other difference.
Steve Jones
April 30, 2002 at 11:51 am
I had something like this. With only about 1.2GB of databases on a server with 2GB, I had SQL Server increase to 1.7GB and hold there over a few months....
April 30, 2002 at 10:50 am
Active Active refers to the two SQL Servers that form the cluster. In this mode, each serves it's own clients as well as being part of the virtual server. Or...
April 30, 2002 at 10:32 am
Is this W2K srever? There are some issues with installing 6.5 on 2k. There is a wokraround on Technet somewhere.
I'd stick with v4.0 or run SS2K in 6.5 mode.
Steve...
April 30, 2002 at 10:21 am
We used to use a tool from Quest Software. It had a high learning curve and takes time to use. They are alos Expensive $$$. You can rent them, but...
April 30, 2002 at 10:20 am
Strange. Never seen anything like this and I use SQLAgent all the time. Antares has a reasonable explanation that I'd buy.
Steve Jones
April 30, 2002 at 10:12 am
It seems like you are looking for whether it's better to put logic in a trigger or place it in a stored procedure. I'd tend to argue there is no...
April 30, 2002 at 10:09 am
Viewing 15 posts - 37,561 through 37,575 (of 39,510 total)