Jason does your string always have exactly two items, or is it a long string where the first five items are SSN/name/address, and comma delimited 6 thru N are items?

you...

also look into SQLRecon;

it's free and does a very thorough scan of all IP's on your network, looking for SQL in multiple ways.

i think he's asking is it a good practice to make columns NOT NULL and insert default values, vs leaving them nullable.

as usual, the answer is "It depends"; this is...

starting with the obvious, did you select * from sys.traces? maybe it's a server side trace someone has created?

select * from sys.traces

--results

id status path ...

Ken for me, what i end up doing is still creating a PK on an identity column, ie "ContractID",

and having a unique constraint on the columns that make a unique...

i think one problem is you are joining the same table 6 times, when it is not necessary:

SELECT a.ID, RTRIM(LTRIM(a.ID)) as fID,

a.demID,

b.mid AS gp,

c.mid AS op,

d.mid AS oom,

e.mid AS...

there's two concepts you'll want to use here to get the desired results:

using a CROSS JOIN can give you every possible combination.

using a LEFT OUTER JOIN can show you...

the recommended way is to use the count of the rows in the indexes to get the number of rows; it's already materialized, and much faster than querying each table...

yep, since openrowset doesn't accept variables,(?right?) you'll be stuck with a cursor to go thru the table of file names, and dynamic SQL to do the openrowset and shredding of...

it really depends on what you are doing with the filename; they came into your temp table in a set based operation...could be thousands of file names potentially;

your example did...

i think it's just your DIR command:

exec master.dbo.xp_cmdshell 'dir c:\CIC\*.jpg /b'

*.jpg for each jpg file

/b for the brief directory style...just the file name

the database schema is the whole collection of scripts for the create tables,views,procedures, functions, etc, which should include the foreign keys of course.

foreign keys and well named columns are a...

paul of all the shared hosting i help friends with or have for myself, none give me the ability to run jobs; most do not even let me run backups.

i'm...

jadonr (1/28/2010)

---

@ Lowell

Works perfectly! I appreciate you trying to look out for me by using those extra safeguards - very nice of you.

What do I need to change to get...

jadonr (1/28/2010)

---

@Lowel

Thank you for the advice, but creating a view that features the calculation, or adding a persisted calculated column to my table won't really serve its purpose in my...