Heh... in cases like this, I believe that being cynical is a healthy thing to do.

I wouldn't isolate the converstation nor the requirements to just the DBA... there may be...

Jeffrey Williams (3/8/2009)

---

I may be missing something - so please correct me if I am wrong, but don't you need to specify which server you are going to connect to...

radek (3/8/2009)

---

Hi I have other question about indexes:-)

I read something about indexes, that indexes is good create in "big table"

But when I create table in MS SQL by GUI and...

I agree, Flo... I just want to make sure what the OP means by "Deleted"... sometimes folks just mean "not included in the result set" and I wanted to be...

Those would certainly qualify as "housekeeping" stored procedures. I'm curious... why the question?

Chris Morris (3/8/2009)

---

GilaMonster (3/8/2009)

---

Mike is one of those people on my blacklist, due to his repeated...

Heh... even after the typo was repaired, no one got the correct answer because it wasn't listed. The correct answer should be...

"Who cares? Rewrite the code to be...

vasimihalca (3/8/2009)

---

Hello !!

This is my first post on this forum, and I have a little problem at work that I don`t know how to resolve it.

I have experience on writing...

Heh... That's not actually a BCP error... I'm pretty sure that the JPCFHONYVLDATA database doesn't actually have a copy of xp_CmdShell in it. The following command...

[font="Arial Black"]EXEC [highlight="YELLOW"]JPCFHONYVLDATA..[/highlight]xp_cmdshell @bcpCommand[/font]

......

GilaMonster (3/8/2009)

---

Mike is one of those people on my blacklist, due to his repeated demonstrations that...

musheik (3/8/2009)

---

Thanks you all, for your valuable suggestions. i am concluding that with sql server we will be slower than Oracle,And we cant do much modifications with sql server...

nelson.ahrens (3/6/2009)

---

I'm trying to group by a field named Vehiclename but also need all the other fields listed in my select statement below. I understand about the aggregate error...

Ummmm.... if they don't have sensitive information in them, why would someone encrypt them? Also, if you really need to have them decrypted, see the person with the encryption...

RBarryYoung (3/7/2009)

---

Jeff Moden (3/7/2009)

---

I'd recommend that you never import 3rd party directly to permanent tables. I always do the imports to temporary staging tables so I can validate the...

Heh... it's obvious that a lot of the articles on other sites, including SQL Mag, aren't deeply reviewed for technical content either. Some of those articles are nothing more...