Chris

I think the answer is "just because".  sa has fixed permissions and therefore you can't add it to or remove it from fixed server roles, hence the error message.

John

Chris

Yes, sa can perform any task that a member of security admin can (and more).  Mind you if your thrid party product requires the sa account, then it's probably time...

Torben

Do you mean enter the credentials in the same way as a SQL login?  I don't think that's possible.

John

Torben

Right-click on your Query Analyzer icon and choose Run As.  You can then enter the security details for the account you want to connect as.

John

Thomas

You could do it in one statement using dynamic SQL, but I think it's more elegant to do it like I've done below.  Why do you prefer the single query...

Marie-Sofie

Does this get you any closer?  I've left it to you to do the manipulation of the figures.  Obviously it's not tested since there was no sample data, and performance...

Andrew

From Books Online:

ALTER INDEX cannot be used to repartition an index or move it to a different filegroup. This statement cannot be used to modify the index definition, such as...

Delete the data in the child table that references the data you want to delete from the parent table.  Then you will be able to delete the parent data.  Alternatively,...

Ben

Can you adapt this example from Books Online to work in your environment?

John

USE AdventureWorks;
GO
SELECT c.FirstName, c.LastName
    ,ROW_NUMBER() OVER
    (PARTITION BY PostalCode ORDER BY SalesYTD...

First, don't mix old-style and ANSI join syntax.  Rewrite something like this:

select Distinct (e.empID),empName,lc.CountyName

from Indicator I

inner join emp e on e.jobid...

Ben

I think the ROW_NUMBER function is exactly what you're looking for here.

John

Jeetendra

I tried once to write a script that would generate scripts for all indexes in a database, but I gave up.  I'm not saying it isn't possible - search the...

Jeetendra

You can either do them one by one in Enterprise Manager (let me know if you need me to explain how), or you can script out all your non-clustered indexes,...

Patrik

As far as I can tell, Logged Value corresponds to ml.MeasurementLogValue.  But what to Calc1 and Calc2 correspond to?

John

What happens if you run the job not at 1am (I assume that's what you mean by 1pm in the morning), but at the same time you try to run...