Recent content by PFR

there is a problem on the population of a full text catalog: the (only one) underlying table has about 100,000 records, each with one of two ntext columns filled. The text in these columns is strongly varying in size from 10 to 50,000 characters and more. The table is growing continously and...

a simple trick: Right ("000" & CStr(number), 3) PFR

in Your query that table is named zISNAVS, not "ISNAVS" is that intended? PFR

at any time in the past, when i added an identity column, i had a notion that an underlying identity had already been present. - So just add an identity column and order by that, so You will get the records in the order they were entered. PFR

Is there any way to prevent interdev from inserting width- and height properties into img tags? It's very boring to search for bugs after changing an image in size. i would prefer too, if interdev would not convert my written tags into lowercase but just keep them as they are. Any way to...

no You just cannot compare the whole string with "=" or apply any string-based function within a query but such operations seem nonsense for 30 paged documents Search the table(s) using "LIKE" or build fulltext indices on them and use "CONTAINS" etc. PFR

if You define the image column as image the data size is practically unlimited. dont know much abt VB - in C using ODBC data up to ~400kb can be bound directly to the table column, larger data must be split and put in parts. PFR

what does this "$" ? the syntax looks alike the "IN (...)" condition PFR

You can use the getdate() function as well as on datetime columns PFR

The account ASP is running in is the IUSR_<servername> == anonymous user. For that account the access is limited to the web's dictionary. Maybe You can grant access for the anonymous user, but then Your databases will be open to all internet users over the world! If You restrict the access to...

forgot last &quot;)&quot; !

LEFT ( PATINDEX ( '% %', column )

click on the options tab of the restore window there you find the physical file names for the database maybe the given path doew not exists on the new server - you may change the path in that dialog now running?

dont know the MAPI... objects, but due to the script running from command prompt expect that either the NT-rights for the SQLServer agent are not sufficient or &quot;MAPISession.LogonUI = True&quot; leads to the object using the desktop that is not present for the ssagent. for such tasks i used...

Just restore to another database and export the table into the existing one