Thanks.

If I'm going to re-install SQL will it over-write the data files in the default data directory?

I've copied the files to another folder in case.

Thanks for the reply.

That has set my mind at ease.

Carl

Why not leave the dbo as sa?

The problem with creating databases via Windows Authentication logins arises when the user leaves the company and has their NT access removed.

Carl

Thanks for the reply Mike.

I have had a look at the different counters in perfmon but can't find any that are of use to me.

The resources that I am trying...

Hi,

The purpose of the formatting was for a report not a front end application.

Regards

Carl

Discovered how to do it:

select REPLACE(CONVERT(CHAR(11),[testdate],106), ' ','') AS [testdate]

from testdate

Carl

Hi,

I have tested the thoery myself by creating a test sproc and the user does not have permissions to create tables.  I beleiev the user would need ddladmin rights as...

Hi,

One of our reporting team wants to be able to rank a result set so the row with the highest amount of sales for each month is shown as number...

Thanks for the reply.

Changing the Agent account to a domain account won't cause any problems will it?

From what I know, If you change the Account via Enterprise manager you don't...

Thanks everyone for your help. Its much appreciated.

Carl

I have ran the original code and it does differ to the count I get using my own code.  I have checked and it seems to exclude NULLS.

The only thing I would say is your code brings back less rows than mine?

Does your code deal with NULLS?

Guys,

I dug out a piece of code and messed about with it and it seems to do the trick although I don't fully understand what it does?

select  client_id, 

substring(post_code_insured,1,len(post_code_insured)-(charindex(' ', right(reverse(post_code_insured),len(post_code_insured))))), 

from...

Thanks for your help.

In terms of moving forward, it looks to me like it is best to run the SQL Services as a domain account rather than local system as...

So is the NT AUTHORITY\SYSTEM account the local system account?