Viewing 15 posts - 31 through 45 (of 137 total)
ps - Can you send me info. on your company? Website or something?
Darren
June 3, 2003 at 2:32 pm
Well, I live in Arlington and while I have the work ethic to work for your company, I probably don't have the experience. I've been with a startup since...
June 3, 2003 at 2:25 pm
I agree that is annoying. My only response would be to use Query Analyzer instead of EM whenever possible. Or add another server 😉
Darren
June 2, 2003 at 12:19 pm
What version of SQL are you using?
Darren
June 2, 2003 at 12:17 pm
I would send it back as it is bad practice and causes rows to be on more than one page (excluding text fields). We have a couple tables...
June 2, 2003 at 11:44 am
What data size and type of column are you importing into? I've had issues with a mixture of numbers and text importing from the same column. I had...
May 28, 2003 at 10:43 pm
I think we found the root cause. The MSDTC had stopped and was unable to start. The error said that it can't start because it wasn't configured to...
May 28, 2003 at 7:16 am
I'll check the passords, thanks.
It hasn't been evicted. It just lost communication. However, I can ping the server and it sees it. Also, should the Cluster Service always...
May 27, 2003 at 3:02 pm
I think this makes sense. I don't think there is a trust between the domains. So I have a SQL Mixed Mode login created on ServerA, so you're...
May 21, 2003 at 9:53 am
Personally, I prefer singular (Customer).
1) It's shorter
2) Sounds right. I have 1 Customer record. I have 200 Customer records.
q2 => I think you'd have Theme, Category,...
May 17, 2003 at 11:22 pm
This sql statement doesn't make sense? Did you mean select type, avg(price) as AvgPrice?
If so, you need the "as" because that is the column identifier in the avgprice table....
May 17, 2003 at 11:18 pm
I've found a workaround. I ended up piping the results of sp_helpdb to a temp table then querying off of that to my daily space utilization table. Thanks...
May 13, 2003 at 9:50 pm
I just responded to your other one and realized that you also need to join to either the "inserted" or "deleted" table when you do your update to tblContacts so...
May 13, 2003 at 9:46 pm
I would think you would only change a count on insert or delete so here it is:
CREATE TRIGGER trgMemoCnt
ON tblMemo
FOR INSERT, DELETE
AS
if exists (select * from...
May 13, 2003 at 9:45 pm
You want this all in 1 returned recordset? I'd recommend a union. The first select gets the company contacts and company memos. Then select the memos associated with...
May 13, 2003 at 9:36 pm
Viewing 15 posts - 31 through 45 (of 137 total)