When any records are inserted into PMR the trigger must transfer all with closed=1 to the pmr_resolved table and remove any record in pmr where closed=1? SQL 7 or 2000?

Really amazing how stuff just disappear!

http://www.pinnaclepublishing.com/sq/SQfiles.nsf/0/C6E485D46458EB5485256BAB0081BFF0/$file/Apr02eNL.txt refers to

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q298897

Maybe one should contact Bill & company!

Where is ins.@cName defined / supplied from?

BOL: Variable names must begin with an at sign (@). Local variable names must conform to the rules for identifiers. For more information, see Using Identifiers.

SQL Books Online: Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The first 4 bytes store the number of days before...

Well-done guys, interesting and worthwhile to read!

Suppose DTS to Access, text, comma delimited.

If its a small table there are some sps on web to script the data from a table, even with a if exists on...

Agree, sounds like the box maybe running out of steam. Is a SQL only installation or any other applications installed aswell (resources)?

Set based is the way to go, if possible.

Select Net_Address,NT_Username,Hostname

From master..SysProcesses

Where Spid=@@Spid

If possible can you post the actual rule(s) how it to calculated the checkdigit. I think some posters will be able to shorten the statement.

QUestion: If one is using full or bulk log with full backup once a day and multi log dumps, in theory a log shrink should not be needed? If the...

Can elaborate a more?

Agree with the previous post.

Yes, makes one think of de Morgan boolean algebra