Forum Replies Created
Viewing 15 posts - 37,276 through 37,290 (of 39,720 total)
-
RE: 4.2 to 6.5 Conversion
bcp out, bcp in. Backups are not compatible.
Steve Jones
-
RE: Object ID in which Database?
search sysobjects in each database.
Steve Jones
-
RE: TRIGGER HELP!
use if
create trigger
as
if (select status from inserted) = 'Complete'
update table
set completedate = getdate()
from inserted
where table.pk =...
-
RE: Maintenance Plan Failure
Is there any history in the jobs? As Andy said, check that they are not running.
Steve Jones
-
RE: "DERIVEDTBL" ?
I saw this today in Access as well for a subquery.
Don't "build" queries. Write them.
Steve Jones
-
RE: Microsoft - Love 'em or Hate 'em?
They are. I think the message is out that security and stability are more important than features. Notice .NEt server went RC1 the other day. Was supposed to be gold...
-
RE: Cleaning Bad Database Design
I tend to do this on an ongoing basis. To revisit an entire design is not usually practical or possible given uptime needs.
In my last job, we would contstantly identidy...
-
RE: Null User
There is a syslogins table in master. It may be materialized, so do not use EM. Use Query Analyzer to run "select * from syslogins"
A domain group is an NT...
-
RE: Review: Microsoft Baseline Security Analyzer
Amazing. I was just starting to use this to get a feel for my new environment and, while not perfect, it handled a number of my needs. I guess it's...
-
RE: Searching for old posts
Good enhancement. We'll add it to the list.
Steve Jones
-
RE: Fault Tolerant Strategy?
Andy is correct. The main issue for me has been that I may rollover to another system and then want that to be the primary until I decide to move...
-
RE: What is the difference between SET and SELECT?
I don't think there is a performance difference, but I could be wrong.
Steve Jones
-
RE: DTS - How to Handle Column Name Changes
Not that I know of. I think you will have to go through each one.
Steve Jones
-
RE: Delete selected?
Aha! I see your issue. Sorry
What you need to do is capture the msgID from msgPopup. Then delete the MsgInfo table and finally the msgPopup (or...
-
RE: DBCC ReIndex via Maintenance Plan
Skip this in the maintenance plan and write a job to do this directly.
Steve Jones
Viewing 15 posts - 37,276 through 37,290 (of 39,720 total)