Search results for query: *

I need to replace the 'x' character with the 'y' character whenever it occurs between two 'q' characters. How can this be done using replace and regex? Thanks in advance for your help!

I am creating an aging trial balance view, but can't figure out how to find the data corresponding to the 'distribution' form (Inquiries>purchasing>transaction by vendor>distribution). The usual table hints and dex.ini sql logging haven't produced an answer. I need something that links a PM...

I have a matrix report and would like to hide or remove the document map when the report is rendered. How to do it? Thanks.

I am trying to get the output of xp_sendmail into a table. I've had limited success looping through xp_findnextmsg for the message_id, but what I really want is a full dump of xp_sendmail output inserted into a table. Tried using the info in BOL to set up the table but haven't gotten it to...

I am trying to connect to the exchange inbox of a specific user and return the date of the most recently received email there. any suggestions? thanks!

I have a production server that contains sales data for the following years: 2002 2003 2004 I want to create a second, reporting (read-only) database containing all the 2002-2004 data, and then delete all but the 2004 data from the production database so that current transactions will process...

I am upgrading a sql 7/WinNT setup to a sql2k/Windows2k with Active Directory. My NT domain was called Olddomain and my 2k called Newdomain. Am using NT authentication. Is there an easy way to modify all my sql users to change them all from olddomain/username to newdomain/username without...

I have a document with multiple section breaks. I would like the page footer to read 2.1 for the first page of section 2, etc., resetting page number to 1 at the start of each section. How??? Thanks!

I have a DTS which runs a query that concatenates some varchar fields and exports results to a text file. The query runs fine alone and returns records no matter what the length, but the text file seems to truncate each record after 255 chars. Is there a way to address this?

Does anyone know if there is a limit to the number of email addresses that can be used as a source for bulk mailmerge in Word via Outlook? I've heard that there is a limit of 200-300 but I've found no documentation to confirm this. Has anyone done a really large bulk emailing this way? How...

Does anyone know if there is a limit to the number of email addresses that can be used as a source for bulk mailmerge in Word via Outlook? I've heard that there is a limit of 200-300 but I've found no documentation to confirm this. Has anyone done a really large bulk emailing this way? How...

I have a database with about 200 user accounts. About a dozen users have the default language set to Spanish, the rest are English. I need to find out which users are set to Spanish. How do I do this without having to look through each user login account individually?

Is it possible to restore everything from a backup except the data? I have some views and stored procs buried in an old backup and don't need the data, only the SQL script for the views & sp's. If not, is there another way to recover these without a full restore? Thanks.

What is the best way to test to see if the user has not highlighted any items in a listview? Thanks! Voxi

I am creating a view from table A, and also have table B and C. If A.departmentcode=1 I want to populate the field (as alias, call it xyz) with the corresponding field B.specialcode where A.objectid=B.objectid, otherwise I want xyz to contain the value of the field C.supercode where...

What's the best way to get a list of which user groups have permission to execute which stored procs? Thanks.

I have an application that inserts an image into a BLOB field. This image is either a jpeg or a bmp. How can I tell which file type was used in a particular record?

I would like to create an audit table that would record old and new values whenever data is modified in any table. My database might look like this: table1 (table1ID, field1, field2) table2 (table2ID, field1, field2) and my audit table like this: AuditTable (AuditTableID, TableName, FieldName...

I'm trying to write a trigger so that when field1 in table1 is created or updated with a specific value (let's say the string "approved"), the value of field2 (an ObjectID) in the corresponding row from table1 will be inserted into table2. If field2 already exists in table2, I don't...