Try something like this:

select t1.f1, t1.f2, t1.f3, t2.sum1, t2.sum2, t2.sum3 from t1 inner join (select sum(field1) sum1, sum(field2) sum2, sum(field3) sum3, joinFIeld from aggTable group by joinField) t2 on t1.joinField =...

Maybe no one can give you the answers to this question because they don't know your software.  What I would do is use SQL Profiler to record the commands coming...

OK, now I understand.  Here is a stored proc that you can use to watch for sa or any other account.  I created a new database for the two tables...

If you are talking about the sa or System Admin role, then run this proc in query analyzer: sp_helpsrvrolemember

Hope this helps,

Kathi

I'm not sure how SQL is coming up with the generated code, but it is possible that SQL is using this method to uniquely identify the table.  For example, if...

you could try something like this that generates a random number between 65 and 122.  It then converts that to a character to build the password:

create proc usp_NewPassword as

declare @number...

Yes to both.

Try running this command to shrink the log:

DBCC SHRINKFILE (<log_file_name>, 1000) 

Please note that the log_file_name is the logical name, not the physical location of the file.

To keep the log file from...

I would tend to agree with the Sybase DBA.  The Agent is basically a scheduler, so it will probably just run the job again.  This is definately worth doing some...

I agree with Steve.  I am doing the same thing for our accounting department and have scripts adding/removing accounts after the restore.

If they are on the same box it should work, but if they are on different boxes you will have to use sp_change_users_login to sync the accounts.

There is a good example, I was trying to type a colon and a close paren and ended up with a yellow icon.  I meant to say I don't like...

I agree with you!  I'm not a fan of icons in text nor the stuff, but it is really annoying when you are trying to...

How are you deleting them now?  I think you are probably doing something like:

delete from myTable where myColumn = 'somevalue'

If there is an index on myColumn and SQL is...

To see data in databases besides the default run this in Query Analyzer:

Select * from linkedservername.databasename.dbo.tablename

I was just able to run it in debug with 2002-01-01 with no tick marks.