Forum Replies Created
Viewing 15 posts - 451 through 465 (of 790 total)
-
RE: Tricky triggers
You can try the following code (nb. "id" is the primary key field of your master table)
if update (col1)
begin
... -
RE: WMI objects through DTS
Beags,
I know pretty close to zilch about this subject, but is the following link any use?
In case the URL don't paste nicely, the thrust of the thread is:
-
RE: Best SQL Server book for a beginner
In that case, I don't want to sound like I'm plugging M$ here, but maybe go for the MS Press (or competitors') certification books. And DO the practical bits,...
-
RE: SqlJunkies.com: Just Launched Web Logs
Well, you're doing better than me Frank. I can't even find the site.
I think the special thing that we can look forward to...
-
RE: Trigger on a View in SQL 2000
One way to confirm your thinking on the Access front end is to REVOKE or DENY any privileges on the base table to their login. Just GRANT privileges on...
-
RE: Moving some DBs to another server
"dbcc memusage" gives a breakdown of buffer used by DBs, Objects. However, it's not documented.... well it IS documented, but here's the BOL entry...
August 11, 2003 at 3:03 am
-
RE: Moving some DBs to another server
Hi Roust_m,
IMHO, introducing over-the-network distributed transactions is going to make your problems worse. And, what do I base this opinion on? Just gut feel, so you're well...
-
RE: AFTER DDL ON DATABASE Trigger
G'day Frank.
Absolutely. I turned it on once, for 5 minutes, just to see what we got. Yuk!
BTW: I'm no longer getting email notifications "whenever...
-
RE: Required Query
Try something along the lines of:
select InterviewDate, PostId,
Selected = ISNULL(SUM(CASE WHEN status = 'Selected' THEN 1 ELSE 0 END),0),
... -
RE: Kicking off users
I used to do similar under SQL 7.0, but SQL 2000 made it much easier, with something like:
USE PUBS
ALTER DATABASE Pubs
... -
RE: Simple Query problem - QUery Analyser operation
I can't replicate the error. I don't have tbl_disk_SQL1, so I tried with Authors from Pubs. ie:
select * into #drive from pubs..authors... -
RE: Trigger on a View in SQL 2000
Chris,
I know you said you don't need to, but I can't let go of this one
... You can make the code cater for both single- and... -
RE: need help with dynamic stored procedures!
In what way will the SELECT clause change? Just the column name and where criterion? Will it always be just the 1 column selected, and just 1 column...
-
RE: Tricky triggers
Can you post your trigger code?
Cheers,
- Mark
-
RE: Full-text indexing
It could be because you have remove BUILTIN\Administrators from login. In which case you see an item count of zero when you view the properties of the FT (StevenBCatalog)...
... You can make the code cater for both single- and...Viewing 15 posts - 451 through 465 (of 790 total)