Use the sys.server_role_members (that may or may not be the exact name - I can't remember) catalog view to script out the members of the sysadmin server.

John

In Object Explorer, navigate to Security -> Logins.  Open the Object Explorer Details window.  Select all logins, or just those you want to script.  Right-click, and choose Script Login as.

Your INSERT statements will fail unless you turn IDENTITY_INSERT on.

Why don't you just create LogTable as a view, and then it's always correct without your having to update...

Your SELECT statement is just selecting the dynamic SQL, not setting it.  Try changing SELECT to SET @sql =

John

Well, my guess would be yes.  But you're the one with the SQL Server 2000 computer - why not try it?  You won't break anything.

John

I think this is what you're looking for.

John

No, I agree - it would need to be the first column in the key.  But like I said before, it's not needed at all, unless the product ID PD1...

Danny

Use REPLACE to replace '-00' with '-20'.

Edit: and then change the data type to date so you don't get this happening again.

John

I'm not sure there's any more efficient way than that.  You'll probably need indexes on the columns in the GROUP BY clause and in the join predicates as the number...

Sam

Looks like you need to do a bit of normalising first - you shouldn't have ProductID and productname in a table of sales.  Assuming changing that isn't an option,...

I would guess that Profit_Percent and Commission_Percent have character data types, and there's values in one or both of them that can't be converted to decimal(10,2).

John

Might be worth trying querying the plan cache.  Have a look at the query on this page, and put total_logical_writes in the query.  Then, in the result set, look for...