I would highly recommend NOT changing data directly in system tables (you would need to set configuration settings to do so anyway). Write a script that does ALTER TABLE...

This is an excellent whitepaper from Spy Dynamics regarding SQL Injection attacks...

Hope this helps:

http://www.spydynamics.com/whitepapers.html

You're not the only one who is disappointed with the Diagram Tool in EM!!! Visio is great, but actually a really quick and dirty export from the Diagram (for...

Could you post the SQL?

If you do not care whether the information you are reading into the text file could be changed during the read operation, you could issue the following command at the...

Paul's script does indeed look simpler, however, I don't see any OF_SP_COUNTER call in it. Is this procedure essential, or can you add it to Paul's script...

Is there a question you are asking? Not quite sure what you're looking for...Are you asking whether there is a simpler way of determining the number of days between...

One alternative method might be building an XML document with the required records, then executing an SP using OPENXML(). Just a thought...

can you post the results of:

sp_helpconstraint 'name_of_constraint'

as well as an sp_help 'name_of_parent_table'

and sp_help 'name_of_child_table'

Thanks.

What are the key field data types. Sometimes when you have a char field, a trailing space in the parent record PK can throw someone for a loop? ...

try this:

SELECT dt1.LastDayID, rl.StoreID, rl.RegisterCount

FROM RegisterLog rl

INNER JOIN

(

SELECT RegisterLog.StoreID, MAX(DayID) AS DayID

FROM RegisterLog

GROUP BY RegisterLog.StoreID

) AS dt1

ON rl.DayID = dt1.DayID

AND rl.StoreID = dt1.StoreID

ORDER BY rl.StoreID

quote:

---

But I have 250 tables...

---

The only thing I can think of is running a query...

I am sure you will get a wide range of opinions here, but generally, if your indexes and storage structures are properly designed and maintained, you will not notice significant...

Try:

CASE

WHEN datetimecol IS NOT NULL THEN 1 ELSE 0 END

🙂

You don't need the EXEC('').

You also need to include the FROM (and possibly WHERE clauses) although, I think your second statement alludes to you just leaving them off the script..?

...