Viewing 15 posts - 1,576 through 1,590 (of 1,654 total)
Try this
select MIN (intID),vchrCode,vchrDescription,lngValue from TableName
group by vchrCode,vchrdescription,lngvalue
HAVING COUNT(vchrCode)=1
June 26, 2003 at 3:20 am
If you do a straight upgrade, you don't have the option to change the collation. You have to install a named instance if you want to change that.
June 25, 2003 at 1:17 am
quote:
Here in Europe M$ seems to like holding conference in Barcelona. That should also be worthwhile.
June 24, 2003 at 12:04 pm
Which version of SQL Server do you run, which Service Pack. I've seen my share of replication problems but never experienced orphaned agents. Do you allow anonymous subscriptions? What is...
June 24, 2003 at 12:00 pm
I'm a member of PASS, although not very active during the last couple of months. What I found really worth the money are the annnual conferences (PASS Summit). No better...
June 24, 2003 at 8:41 am
DTS always looks for files on the local machine where it is initiated. So when runnning through a schedule it will look on the server. If you run it through...
June 24, 2003 at 3:45 am
HI Steve, I haven't done any benchmarking myself but I remember an article telling that hyperthreading gives you about 1.2 times the performance of a single CPU. Unfortunately I can't...
June 24, 2003 at 1:31 am
It's in the recistry under
HKey_Local_Machine>Software>Microsoft>Microsoft SQL Server>80>Registration
June 24, 2003 at 1:23 am
Sorry no answer yet, but cold you post your function and the way you want to run it. I assume with
quote:
I...
June 24, 2003 at 1:18 am
Sorry no answer yet, but cold you post your function and the way you want to runit. I assume with
quote:
I again...
June 24, 2003 at 1:18 am
From what you tell it sounds very much like the server accepts Windows authentication only. The sa account is no Windows NT account and therefore can't log on if you...
June 20, 2003 at 1:17 am
As far as I remember you're not allowed to create triggers on system tables. So are you sure the trigger is created succesfully on sysdatabases?
June 19, 2003 at 6:18 am
Sorry mate, editing the t-log is not possible (thanks god). My usual way of fixing such a situation would be make a t-log backup and do restore with stopat just...
June 18, 2003 at 1:53 am
Viewing 15 posts - 1,576 through 1,590 (of 1,654 total)