sql will...

simply right click...

the easiest way is to ask the other admins "hey did you create that job?"

I just created a job on purpose, and it does not appear in the default trace.

i...

click start, and when programs button is visible, right click on it;

"Open" is the first choice, click that.

a folder opens, drill down inside the Programs folder to where you want...

it's a behavior thing.

a local variable, when you assign something too big, gets truncated.

however an error will occur if you try to insert/update to a table, which has a more...

here's the code to get the first sunday of this month;

the last sunday of the previous month is the same date minus 7 days.

you could change the code to get...

i have these saved in my snippets, and the list is really incomplete:

--Oracle sp_help equivilent:

DESCRIBE tablename;

DESC tablename;

--Oracle sp_who equivilent

select osuser, machine, program, status from v$session;

--Oracle kill connection equivilent

select 'ALTER SYSTEM...

I'd start with select * from sys.server_principals

that will give you all the database users, roles, credentials and more;

you could filter it after that on the type_desc column for WHERE...

you want to use a query to generate the commands for you, based ont he metadata.

i just tested this: create user/login [Noobie];

ran the results of the script below.

logged in as...

Rob-350472 (10/26/2010)

---

When attempting to parse a job step in SQL Server Agent: Add Job Step I get an error finding a user defined data type. (Cannot Find Data Type <Type...

awesome idea,...

what a pain; too bad you can't go smack the developers for not adding relationships in the first place....that's so wrong. In some countries, that an offence punishable by cane-ing.

I...

you can also use the metadata to generate the statements you need to run...potentially 300 commands you said.

you did not provide any specific details, so here's a scenario to use...

my suggestions are still the same; show us your execution plan, and tell us how many records you are returning.

for example, if you are returning less than 10 rows, 42...

how...