Viewing 15 posts - 11,386 through 11,400 (of 13,469 total)
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...
March 24, 2009 at 6:53 pm
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...
March 24, 2009 at 4:03 pm
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...
March 24, 2009 at 10:11 am
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...
March 23, 2009 at 11:43 am
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...
March 23, 2009 at 8:28 am
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.
March 23, 2009 at 7:50 am
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...
March 22, 2009 at 1:58 pm
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...
March 22, 2009 at 6:14 am
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...
March 21, 2009 at 6:52 pm
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()...
March 21, 2009 at 6:27 am
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...
March 20, 2009 at 11:51 am
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...
March 20, 2009 at 10:22 am
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...
March 20, 2009 at 10:14 am
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) +...
March 20, 2009 at 10:02 am
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...
March 20, 2009 at 9:05 am
Viewing 15 posts - 11,386 through 11,400 (of 13,469 total)