Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sonname

    How to get servername and default database from ODBC DSN?

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

    Query very slow when adding one particular table to a join

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

    Need help in converting the following WordBasic macro to vba

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

    Need help in converting the following WordBasic macro to vba

    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"...
  5. sonname

    Find Style in word and replace with another style help

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

    Need help with Query result display

    Thank you all. Works great.
  7. sonname

    Need help with Query result display

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

    Using xp_cmdshell to count files in a folder on different server

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

    How do you add a reference during run time?

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

    Is there a way to perform a backup of a database, but omit a table?

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

    How do you go about converting SQL 2000 databases to SQL 2005?

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

    Anyone have problem with Upgrade to SQL Server 2005 and Blob fields?

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

    Anyone have problem with Upgrade to SQL Server 2005 and Blob fields?

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

    Need help with SQL Server 2005 converted database and error.

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

    Would DTS be faster for transferring data or script

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

    Loading script in Query analyzer gives error not enough storage...

    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".
  17. sonname

    Loading script in Query analyzer gives error not enough storage...

    I have 2 GB of Ram.
  18. sonname

    Loading script in Query analyzer gives error not enough storage...

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

    Help with Reading SQL Output Parameter

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

    How to find the sqldataroot in the Registry for default and Instances

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

Part and Inventory Search

Back
Top