Forum Replies Created
Viewing 15 posts - 37,381 through 37,395 (of 39,818 total)
-
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
-
RE: Relational Database Without Relations
I sort of like the idea, though I tend to agree with the posters about the downfalls.
However, the intermediate table used to relate items and allow flexibility is a technique...
-
RE: Fault Tolerant Strategy?
I prefer log shipping or some variant I've developed. Easier to roll over/back to me, but I'm not a replication fan.
Steve Jones
-
RE: Parsing a delimited varchar column
Now that be slick!
Steve Jones
-
RE: Parsing a delimited varchar column
You could use a while loop to build the results, but it might be ugly if this is large.
I'm sure there is something, but can't think off the top of...
-
RE: Delete selected?
If these are in two tables, then you need two delete statements.
To delete the msgPopup,
delete msgpopup
FROM msgPopup INNER JOIN msgInfo
ON (msgPopup.msgID = msgInfo.msgID)
INNER JOIN msgMessage
ON (msgInfo.msgID = msgMessage.msgID)
WHERE
Sender...
-
RE: sp_execute
I believe this is how many ADO connections work. They "prepare" a statement on the server and execute it with sp_Executesql.
What are the front end connections?
Steve Jones
-
RE: shrink db doesn't work
Interesting. Hadn't noticed that since I tend to script things and never worried.
How big is the db and what was the original size?
Steve Jones
Viewing 15 posts - 37,381 through 37,395 (of 39,818 total)