Search results for query: *

I'm a perl newbie so apologies if this is really simple. I have a perl script where I access a DSN. What I'd want to do is retrieve the Server Name and the default database where the ODBC DSN is pointing to? For example I have my $sourcedb = new Win32::ODBC("DSN=$sourcedsn;") Is there a way...

I have a query that I run that is very slow when I add a particular table to the join. I'm not sure how to troubleshoot this. The table is not very large, it has about 10000 rows. It has one primary key that is used to join with other table keys. I've done a DBCC checktable on that particular...

Hi, The following wordBasic macro does not work in Word 2003 and I need to convert the code over. Here is the code, can anyone translate the following? WordBasic.EditFind Find:="W L O Pt G FA" While WordBasic.EditFindFound() WordBasic.StartOfLine WordBasic.FormatTabs Position:="9 pi"...

Hi, This should be simple, but the macro that I recorded does not work when I try to run it. What I want to do is find the "Normal" style in a document and replace it with the "Heading 2" style. Here is the macro. It worked when I recorded the macro, but does not work when I try to run the...

I have a query that produces the following results. class, division, count, status 86 50 200 Approved 86 50 67 Not Approved Is there a way I can get it so that it displays in the following manner? class, division, Approved, Not Approved 86, 50, 200, 67 Basically I want to combine the class...

Hi, Is there a way to use the xp_cmdshell in SQL Server to count the number of files in a folder on a different server? I have a process that watches a folder on a different server and sometimes it fails and the files keep accumulating. I would like to create a job in SQL Server where I could...

I have a word module that uses some objects, I keep losing the reference from the Tools/References. Is there a way that I can set this when I load the word project so that it sets those references before the object is called? Thanks

I have a database that has a large table that contains BLOB's and I want to restore that database on another machine regularly, but I don't need that particular table, is there a way to specify that you don't want that table backed up, this way the restore will be so much faster? If so where is...

I have a number of SQL Server 2000 databases that need to be converted over to SQL Server 2005. How do you go about doing the conversion, do you do a detach and attach, a backup and restore or do you use DTS to bring over tables and stored procedures? Thanks in advance.

I have been upgrading some of my SQL Server 2000 databases to SQL Server 2005 by doing a detach and attach of the mdf file. I have noticed that sometimes, tables that have Text or image type fields become corrupt. This is confirmed by running a DBCC checktable. It does not happen on all tables...

I recently detached a SQL Server 2000 database installed on a Windows Server 2003 SP1 and brought it over to a SQL Server 2005 running on Windows Server 2003 SP1. I have a web application that uploads images. At some times the upload will hang. In the application log, I see many errors of the...

I have a table that I need to export from one database to another. My qestion is, would a DTS package be faster than individual insert statements in query analyzer to transfer over the data. The table is a rather large table. Thanks

I have a rather large sql script(277,553 KB) that I am trying to open in query analyzer and I get the error "The operation could not be completed. Not enough storage available to complete this operation". I'm pretty sure it is because the script is too large because when I seperate the file...

I want to execute an sql statetement in my program and get the results from the output variable. I'll be using ADODB, but I'm not sure how to get the output returned from the following. Can anyone help? DECLARE @data_dir varchar(500) EXECUTE master.dbo.xp_instance_regread...

I am using Installshield to install a database. I'm trying get the path for the sqldataroot. I would like this to work for SQL Server 2000 & 2005 as well as for instance names, but I know that the registry settings are different based on versions. How do you go about getting to this information...

I am converting over some code from SQL Server 2000 to SQL Server 2005 and I am having some problems with the sp_addlogin calls that I make in SQL Server 2000. The CREATE LOGIN command is the preferred call for SQL Server 2005. I was thinking of checking the sql version in my code to determine...

If I have a numbered position in a document, is there a way to get the word at that position and highlight it? Thanks

I need a piece of code that will scan through a document and remove all manual line breaks i.e.<[lb]> hidden tokens in the document. Also, when the code finds these manual line breaks in the document, does it know at what number position it found them?

Here is a snippet of code that I have. Dim w As Range For Each w In ActiveDocument.Words If InStr(1, w, "-<[lb]>") = 1 Then w = Replace(w, "-<[lb]>", "") w.Font.ColorIndex = 3 'for, say, RED End If Next What I want to do is remove the dash and the hidden line break and...

I need help with writing a macro that scans through a document and for all instances of "hyphen, line break tokens", replace those and change the color of the word. For example, if I have the word pro-<[lb]>bably, I want to be able to remove the -<[lb]> from the word and then change the color...