Search results for query: *

Hi Can anyone come up with a neat where statement to catch overlapping date ranges. My table has a from and to date eg. ID F_FromDate F_ToDate 1 1-Mar-2008 18-Mar-2008 2 1-Jan-2000 31-Dec-2010 3 10-Mar-2008 01-Apr-2008 4 13-Mar-2008 15-Mar-2008 5 1-Jan-2008 01-Mar-2008 6...

Hello Our SQL server 2005 msdb database is growing at rate of 100 Meg per day and is currently 4844 Meg. Having looked at thread962-1142670 I can discount dts packages (none in use), and backupset (1325 records). Job history is 999. I'm struggling to find a table with a large number of...

Hi We recently started to use Database Mail to send information packs to our clients (pdf attachments). The emails + attachments are sent without a problem. I have subsequently noticed that the attachments are being saved on the C drive causing space issues - for example: C:\Documents and...

Hi Is it possible to change the default font and font size settings for emails sent using 'Database Mail' with 'Text' as the value for the @body_format parameter. Many Thanks

Just a quick question - how do you go about loading workstation components onto a Win32 PC where the SQL Server itself is x64? I can't use the x64 setup disk on my XP (Win32) workstation. Thanks in advance

For some time now we have been receiving the message: The job was scheduled to run, but the availability window closed before the job could start. There may not have been any destination devices available during the window, or the job may have been submitted to run when the window was closed...

I've been looking at some poorly performing queries. These queries contain conditional conditions of the form: Where C_PartitionCode Like Case When @intPartitionCode = 0 Then '%' Else Cast(@intPartitionCode as varchar(3)) End And ... etc When I build it up into a...

Morning I have a stored procedure that contains a user defined function that slows considerably the performance of the SP. Extract as below WHERE dbo.usf_PostCodeRules(@tinPostcodeCheckType, C_Postcode) = 0 The problem is not with the performance dive, which is expected, but the...

Hi I keep getting tripped up when comparing a column to Null because instead of saying P_FieldName Is Null I'm saying P_FieldName = Null This second condition doesn't fire if the field contains null. As a matter of interest - why?

Hello All oExcelWSheet.SaveAs "C:\abc.xls", , "pass123" This will save an excel document with a password. How can you also instruct the save to add encryption (e.g. RC4, Microsoft Enhanced Cryptographic Provider v1.0). Easy, manually through Excel itself, but through VBA, how? I was...

Hello My form based procedures are in the format: Private Sub ProcedureName() On Error GoTo ErrorSection …… Exit Sub ErrorSection: MsgBox "Error occured in Form: " & Me.Form.Name & vbCrLf & _ "Routine: ProcedureName" & vbCrLf & _ "Error Code: " &...

Hello You don't seem to be able to index a bit field in a table. I can sort of understand this as there are only 2 values to index. However if the distribution of the values in the field are, say 99% (0) and 1% (1), and you are searching for values of 1 then the index is beneficial. Is SQL...

Hello We suspect a problem with our SMDR logger (5.0.14). Over the last week it has not been logging 100% of the calls - more like 60%. Has anyone else had this problem. I can't see any configuration settings to make it work in this way - we use this file for invoicing, so it is important...

Hello everyone I'm trying to send email from a stored procedure (SQL Server 2000) using the xp_sendmail procedure call. My code is: exec xp_startmail exec xp_sendmail @recipients = 'robert@phoneticgroup.co.uk', @message = 'Test Message A', @subject = 'Test Subject A' exec xp_stopmail...

Hi Sorry the search is out of order so I can't check whether there is an existing solution to this one... Why does SQL Query Analyzer, but not Views run outside QA, truncate my columns to 256 characters for example SELECT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...

Hi I'm using TAPI API calls to make outbound calls. This works on 70% of our computers. On the others the call seems to be sent out from a different phone. Has anyone any idea how a call from one handset is transferred to another. The situation is fixed (eg. extension 222 always works, 224...

Hello everyone I'm trying to get more information about the TAPI API call lineOpen and specifically the second parameter dwDeviceID. Declare Function lineOpen Lib "TAPI32.DLL" _ (ByVal l_hLineApp As Long, _ ByVal l_dwDeviceID As Long, _ l_lphLine As Long, _ ByVal...

Hello All I am developing a system where I will have multiple databases on the same server which share the same structure (but contain differing data). What is the best method for handling the identical stored procedures which will live along side each database? I'm concerned that the sps are...

Hello Everyone I am making outgoing calls via TAPI. I would like to to assign an Account Code to these calls (through TAPI). Can anyone point me in the right direction. Many Thanks Robert

Hello everyone I'm new to this forum so bear with me. I'm using Outlook Express and am sucessfully sending plain text emails dynamically from Access via VBA, using code: strAddedtext = "&Subject=" & strSubject strAddedtext = strAddedtext & "&Body=" & strBody If Len(strAddedtext)...