i tried going down the CLR route to resolve this in SQL 2005...but guess what... a SQL project is not allowed to have access to an rtf richtextbox control....I guess...

i looked at the 4 special RESTORE commands that I know of in BOL:

RESTORE HEADERONLY

RESTORE FILELISTONLY

RESTORE LABELONLY

RESTORE VERIFYONLY

looks like you can find the name of the user that rant...

kewl to get a wierd error....can you paste lines 13,14,15 from your script so we can see what line 14 might be doing to cause the error?

looks like you are trying to do a sum on the web page, which is NOT the same a s a sql statement running on the server.

on the server, the...

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...