Hi Peter,

I think you are correct about sense and use of functions. I suggested to use different functions just to check this out or give a suitable workaround but I...

This is exactly what I mentioned earlier. SQL Server does not detect differences in function calls when they differ only in string constants though select shows the correct and differing...

I am using MSDASQL and an ODBC connection to access oracle. There I can use different owner specification to access different objects, but I have to put them into quotation...

Hi Ilijana,

I am not familiar with omitting the database name but it seems that omitting the owner name enables the MS-data-access-oracle-unit  (I think this is that MSDAORA) to find the table...

Hi Peter,

I don't think that Julian's claim is correct. For example

select left (filename, 1) as drive from master.dbo.sysaltfiles

group by left (filename, 1)

order by 1 

will yield the same result as

select...

Hi Carl,

another more simple workaround is to use the "text in columns" feature in the "data" menue in excel. Select the column(s) concerned, choose fixed size and two times click "next". Than...

Hi all,

I think this question is not as good as usual because there are at least two possible answers. Surely system_user is a solution because it returns the domain\user in...

Hi Jay,

I often heard inner join is to be preferred always. But there is another way to solve your problem using a simple where clause. This is easyer to write...

Hi Amit,

many thanks for your suggestion. It works now on the SQL Server 2000 directory. Unfortunatly, after completing the package an access violation error on...

Hi,

I have found an SP3 on the microsoft site and installed it. Afterwards I could no longer start Client Utilities of SQL Server 2000 so I tried to set up and run a...

Sounds good. Thank you very much. I have increased the total number of lines for jobhistory and will have a look on the history logs and the size of the...

Hi criswes,

same logical names for distinct physical databases are no problem. But database shrinking is deferred on SQL Server 7.0 so you will have to wait before you will detect...

Oh, thank you, this is where I can adjust the maximum number of lines of jobhistory entries. But the adjustments are identically on both instances. May be, the clearing of...

Thank you very much for this hint. I have installed no service packs at all since this installation is for test purposes only. But I will try to obtain an...