definately use some of the log trolling tools out there...i think RedGates SQL Log Rescue for SQL 2000 is/was free, so something like that or profiler are your best bets.

i...

correct me if I'm wrong, but the character after the '-'(A,B etc) is the screen...so if you get that substring, you could check for the charindex on each user:

try joining...

i mapped this out for fun; i reversed engineered by comparing the values to all my serves(8 total in my db) for the first 10 columns, the values seem...

you want to use MAX() to get the highest values,sum() to add stuff, and group by the items that you want to...well..group by. something like this:

select

max(id),dpid,cabid,max(stlid),joid,sum(qty)

from your table

group by dpid,cabid,joid

Rad...

use the search in the upper right for "script user permissions"

there are like ten different versions of scripts in the contributions section that does exactly this;

this is the one i...

if you search for "count all rows", there are like 10 different versions of this script in the contributions.

there's two ways to do it:

use the indexes to get the counts,...

in your example above, you mentioned only specific fields, that would be grabgbed based on foreign keys:

Orders.OrderID, Orders.CustomerID, Customer.CustomerID, Customer.Name, Orders.ProductID, Products.ProductID, Products.Name

that is nothing more than a view which...

looks like someone has specifically prevented new databases from being created...most like a DDL triger at the server level. that is not an MS error message...someone returned that message as...

yes i've done this lots of times.

for me, the core was using sp_fkeys [yourtable] to get all the direct dependancies on the table...

from there, it was building all the queries...

why not use a function, instead of a stored procedure, and have the function return a @Table?

then you'd have what you are after...

yes, but you have to be able to identify what has not been changed.

it most likely will NOT be faster, but should avoid locking the entire table for the updates

something...

not built in , no; typically formatting is left for the presentation layer, like vb;

you can do something pretty close:

declare @val decimal (12,6)

set @val = 0.43365

select convert(varchar,convert(decimal(5,2),@val* 100.0)) + '%'

--43.37%

once I've connected with Object Explorer, I can expand the server name, open the Replication Folder, and see everything I've got in the two folders there, "local Publications" and "Local...

sELECT CASE WHEN first_Name

Like 'MR.%'THEN

Right(First_Name,Len(First_Name)-4)

ELSE

Right(First_Name,Len(First_Name)-3)

END nn

FROM tblCust

WHERE Len(First_Name) >= 4

the only other solution i have used was creating an .NET RTF to HTML converter that you could use in reporting services, so it does a best guess at converting...never...