in my case, i didn't see any differences:

connecting to either SQL 2000 or SQL 2005 servers, with SSMS,

when running the code, in both situations the error was found, and the...

oops: a PK error is level 14, not 16, so it CAN be managed with @@error:

using the same tablein my first example, here's another example:

--error level 14!!

insert into test(testid,othercol) select...

if @@error ...then...else

will not work, because a PK error is severity 16 or above, so the code execution stops on the error.

i believe if you redo it as a...

you can use the built in functions to get you pretty close:

select getdate(),convert(varchar,getdate(),112)

2008-10-20 22:34:41.680

gets formatted to

20081020

you could then use some string functions to get the dasheted in there

select...

the recommended way is to use the system views like this:

select * from INFORMATION_SCHEMA.COLUMNS

if you want to start doing it yourself, this will get you started:

select object_name(id) as TableName,

name as...

first thing I'fd suggest is avoiding trying to use NOLOCK;

the NOLOCK in should only be used as a last ditch attempt to improve performance...you usually don't need to allow dirty...

an OLD post for version 3.5 of Redgate implies that this error could occur if you are running out of disk space, or backing up over a network share...could that...

I've done something very similar with a tally table, where i wasinserting avbCrLf after a certain number of characters; I'm away from my hoe PC that has the code, but...

it sound's to me like you want to take Brian Kelly's suggestion one step further, and log successful logins as well...i think you are saying everyone is SUPPOSED to connect...

by "get rid of it" i assume you mean eliminate from the query, and not delete from the table...

you want to use the LIKE operator: LIKE '%-%' means a...

the built in convert functions can give you the format you want: you'd end up with a varchar containing all the inf....is that goo?

select convert(varchar,getdate(),112) ,

convert(varchar,getdate(),114),

replace(convert(varchar,getdate(),112) + convert(varchar,getdate(),114),':','')

2008101708:57:54:45320081017085754453

DBASkippack (10/17/2008)

---

Need...

it's pretty simple...you'd use a BETWEEN statemnt for 2004 AND YEAR(GETDATE())...but you need to select it from a table, right?

once again, Jeff Moden's Tally Table would be the ideal tool...

your going to be mad at yourself...you did everything except CAST/CONVERT your answer to the desired decimal:

create table test(

Price decimal(5,2),

QuotedCost decimal(5,2),

OrigCalc AS ([Price]-[QuotedCost])/[Price] *(100)...

duplicate thread;

follow the answered thread here:

http://www.sqlservercentral.com/Forums/Topic587537-359-1.aspx

you've show us just part of your stored procedure, it looks like...the line you posted wil certainly only display a single column, "Records", so there must be a line in...