isn't it an html issue, where html does not respect whitespace, carriage returns, line feeds or tabs?

so you need to replace spaces with & n b s p ; or...

since you posted the question in a SQL 2000 forum, that's what we assumed you were using.

it is not possible to do that in 2005 or 2008; it was a...

the change from your real needs to your psuedo code and fake tables makes the real requirement make no sense.

in your example, you had 6 rows, and you insert the...

here's how i would do it.

since the natural "order" of the table is important to you, you cannot use row_number() to populate the number column, so you need to...

in the end, you vb is still just using an ADODB.Recordset and applying filters, right?

vb can take a stored proc's results, or a vb6 function that returns an ADODOB.Recordset, and...

the way described above is the only way.

SQL Server does not keep track of when a table was accessed, only a trace can be used to determine that.

I've personally seen issues where SP_UPDATESTATS or UPDATE STATISTICS [specific table name] didn't fix performance issues for stored procs after an upgrade, and I had to actually call DROP STATISTICS...

glad you figured it out.

in our case, it was the same thing...the app testest for read/write of the key, and failed to connect.

we used regedt32(not regedit) to grant permissions to...

it might be like an application my shop had:

the app stored the connection information in an encrypted format in the registry HKEY\LocalMachine\software; by default users typically can't write to...

that error could occur if your database compatibility level is at 80 instead of 90;

the compatibility level determines which syntax version is applied to statements hitting the database, and rownnumber()...

My questions are the same:

what is a serial number to you? is it a random number? can it be '0000' plust the customer number?(0001,0002, etc). Why did your example...

yes, the CLR is actually saved in the database, along with it's source code...so if you were to backup a database, change the CLR and redeploy it, then restore the...

I like Florians script...added it to my snippets.

my only changes are I added the filegroup name and removed the WHERE statement...i want a script that generates all the DBCC and...

the same script that Florian gave you, simply change the file group name and change the line that says DBCC REINDEX to this:

'UPDATE STATISTICS ' + SCHEMA_NAME(st.schema_id) +...

ok i think i'm wrong about area codes between 100 and 199(starting with 1), so you might want to remove the logic i put in place to assume starting with...