hopefully, this is not homework, because if you submit this as your answer, and can't explain what it does, you'll get burned.

FOR XML has a neat way of getting values...

i suspect it has something to do with being loos-goosy on your varbinary and varchar sizes:

DECLARE @prize_encrypt VARBINARY(256)

Set @prize_encrypt = EncryptByPassphrase(@pass,Cast(@prize_id as varbinary))

you try to use a varbinary(256 in one...

don't crosspost. you only need to ask once, the Newest Posts feature lets us see everything. asking the same question multiple places wastes posters time and fractures the continuity of...

don't crosspost. you only need to ask once, the Newest Posts feature lets us see everything. asking the same question multiple places wastes posters time and fractures the continuity of...

if this only happened once, i'd lean towards a minor intermittent network error:[DBNETLIB][ConnectionWrite (send()).]General network error.

if it's happening everytime or a lot, then

I found a lot of really good information...

in general, you'll see two ways to do this.

you can use a

SELECT * FROM TABLE1 WHERE [Client ID] in (SELECT [Client ID] FROM TABLE2 WHERE Trading_Code IN('ZBwhatever') )

or you...

i misread the original post;

here's a sample from my snippets where someone wanted a unique alphanumeric, in order, ie AAA001 thru ZZZ999;

the nubmer gets generated based on an identity.you could...

how about an Identity using a bigint column that starts with the first 16 digit number ?

create table #example( bigintID bigint identity(1000000000000000,1) primary key,

morestuff varchar(30) )

also why must it be...

remember SQL encryption is not all that strong, even in 2005, a simple Google search will allow anyone that can run a TSQL script see the un-encrypted text of something...

clearly any data without an arbitrary number next to it is worthless! everyone knows that! how else do you know who's number 1, or to give a goals to numbers...

two things i think, but i could't get mine to work yet either.

4 part naming conventions are the limit.

select name FIVER.AHOG.dbo.sys.procedures is wrong

its probably FIVER.AHOG.sys.procedures not what you had....i tried...

I'm not familiar with your application, but here's a best guess: if the "files" deleted are really tables in SQL, the space isn't released unless you shrink the database.

can you...

must be an incomplete example...all your code that is commented out in your case statement returns c.SerialNumber1 NO Matter what....maybe you could show us a bit more?

Case

when a.DocumentId=...

try this; it gets the current default trace file, and gives the objects/created/altered/deleted.

this might help you:

[font="Courier New"]

-- obtain file name for Default Trace

DECLARE @TraceFileName  NVARCHAR(256)

SET @TraceFileName = (SELECT path FROM sys.traces...

ok this nippet, based on using some FOR XML statements goves a SQL statement you could execute that looks like this:

SELECT * FROM MYSTAGE WHERE 1 = 2 ...