ok i ran your command, and i have a trace up and running...it is not stopped for me.

i had to change the path from c:\MyTrace\ to a folder for me...

i think that last command is missing the variable:

exec sp_trace_setstatus TRACEID, 1 --start trace

--should be

exec sp_trace_setstatus @TraceID, 1 --start trace

ok, i think i see what you mean.

correct me if I'm misunderstanding the question please.

The default behavior is to create a user witht eh same name as a login.

so for...

the key there was emulates what you are trying to do, not necessarily...

this is where regular expressions will help out;

can you install a CLR on your server to let you do regular expressions?

converting a string is a two part process, I...

you probably need to partition by customer number + upc or invoice_number + upc instead...it completely depends on your specific data. based on what i was able to derive,...

you cannot remove the public role, it's built in and required. everyone is part of the public role.

http://www.databasejournal.com/features/mssql/article.php/1478701/SQL-Permissions-The-Public-Role.htm

what you can do is never grant any permissions to that role. so...

notice how i provided all the code you might need to test the solution? if you can do the same, by providing either CTE or CREATE TABLE...INSERT INTO statements, you'll...

sj999 (2/8/2012)

I want to find all customer IDs that have txn type AB occurring within 24 hours of txn type CD for that customer for the years 2010 and 2011....

a foreign...

linqpad is something i always carry in my portable apps flash drive;

http://www.linqpad.net/

it's got multiple query window/tabs, syntax highlighting as well as an object explorer and ability to run/test...

you skipped over the reason i stated previously. slow down and read a little deeper.

there are TWO instances of SQL on the server.

the default instance, which is already using...

you cannot. simply reset the password to a new known value.

Copy

ALTER LOGIN Mary5 WITH PASSWORD = '<enterStrongPasswordHere>';

the screenshot you posted showed port 1433, which is wrong. it cannot be 1433,

choose another port.

i personally like 14330., but that's me.

Laura as I remember it, it mostly depends on the error level that gets raised.

anything 16 or above, like foreign key violations, constraint violations, etc cannot be handled in...