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...

The thing is that it doesn't work in Word 2003/SP3. It doesn't even find that text. It will not go into the EditFindFound(). I have had to re-write some other macros to vba for it to be able to do these kind of searches. Could there be some kind of compatability switch that I am missing in...

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...

Thank you all. Works great.

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.

Hi, I did check the table in SQL Server 2000 before the detach and it was fine.

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 get a Microsoft SQL Server Management Studio dialog box that says "The operation could not be completed. Not enough storage is available to complete this operation".

I have 2 GB of Ram.

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...