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

    calling a VB program from SQL Server via stored proc or Job ?

    Compile it as a COM server and there are specific system stored procs that let you register and run these server from your own custom stored procs E.g: sp_OACreate <ClassID.Progid>, @object OUT IF @hr <> 0 BEGIN EXEC sp_displayoaerrorinfo @object, @hr RETURN END EXEC @hr = sp_OAMethod...
  2. apollo11

    SQL 2000 upgrade from SQL 7.0

    I am trying to install SQL 2000 on a machine that has SQL 7.0 Standard Edition on it. I have the developer edition for sql server 2000. The SQL server 2K install does not let me upgrade to 2000 but just asks for a fresh install of SQL 2K. Why is that? Shouldn't it allow me to upgrade ? Thanks
  3. apollo11

    Query to retrieve hierarchy

    I have one table (category) which stores information about category items with their direct parent i.e till one level something like: cat_id, name, pcat_id where cat_is is the primary key and Name is the description and pcat_id is the cat_id of the parent ( for top level categories value is...
  4. apollo11

    Using CONTAINS

    ...reading from an array and the CONTAINS keyword warrants the use of quotes in a special manner. The correct SQL is as follows: SELECT cpi.*, s.name as SupplierName, cpd.ShortDesc, Mfr.Name as MfrName, cp.UnitPrice as DisplayUnitPrice FROM Cat_PartDesc cpd, Cat_PartInfo cpi...
  5. apollo11

    Using CONTAINS

    ...its difficult to test this without data but can anybody make out anything wrong in the syntax off-hand. (I know it is wrong somewhere) SELECT cpi.*, s.name as SupplierName, cpd.ShortDesc, Mfr.Name as MfrName, cp.UnitPrice as DisplayUnitPrice FROM Cat_PartDesc cpd, Cat_PartInfo cpi...
  6. apollo11

    Differential Backups in SQL 7.0

    How do I specify a DB maintenance plan in SQL Server 7.0 SP2 to take differential backups? I know you can do differential backups when you backup a DB individually, but here I have a bunch of databases that I have specfified in the maintenance plan to be backed up but I don't see an option where...
  7. apollo11

    I have a stored procedure that acce

    Thanks a lot.. I have several options in case I need to redesign the app but I was looking for a quick resolution without changing the business object.
  8. apollo11

    I have a stored procedure that acce

    I have a stored procedure that accepts a list of (comma delimited) IDs as a parameter. The data type is nvarchar. I then use this parameter to fire a query that has a IN statement, something like &quot;SupplierID in (' + @SupplierID + ')&quot; where @SupplierID is teh param in question...
  9. apollo11

    Changing size of column

    Can I change the size of an already existing not null nvarchar column in SQL Server 7.0 SP2? without dropping and recreating the table?
  10. apollo11

    Quad Processor optimizations on server

    Can anybody direct me to a resource where I can get all the different kind of optimizations that I can perform on my SQL server database machine to take full advantage of its QUAD processors? Thanks
  11. apollo11

    Mailing Out from SQL Server?

    If you really do need to use CDONTS using SMTP, you can write a lightweight COM object with sendmail interfaces and register it with SQL Server. BOL has various examples on how to trigger and call COM interfaces from within T-SQL, The advantage with this is you will not need to install a MAPI...
  12. apollo11

    Export vs Import

    Which is faster? Export Data or Import Data through DTS In other words, which is faster to run? Export Data option from Enterprise manager on the source db machine or Import Data option on the destination machine?
  13. apollo11

    Lock on database during Restore

    When I try to restore a database from a .bak file, the wizard comes up with a message saying that the database is in use and the administrator should have exclusive access to it. Now I understand that there is an application that holds on to the database , but the thing is that this behavior is...
  14. apollo11

    Users lost when restoring database

    When I restore my SQL 7.0 database backup I do not see the users that I originally had in the database. What's strange is , if I create those users afresh and try to add them Enterprise manager throws an error saying that the user already exists. Is there a way to remove a user from any of the...
  15. apollo11

    SQL Server installation drive

    I want to install SQL Server Program Files on C which has lesser disk space (2.65 GB) and the Data Files on D which has 59 GB. Now I know that the database files will go to D but I have several catalogs attached to the DBs that go to /mssql7/FTDATA. Will the FTDATA files also go to D? I do not...
  16. apollo11

    SQL Server taking up too much memory

    I find it hard to believe how does SQL Server end up using 1.3 GBs of memory! Would reducing the number of databases have any effect on this? So does that mean that no matter how high the memory avail on the machine, SQL server will always end up using all except the last 4 - 10MB (from one of...
  17. apollo11

    SQL Server taking up too much memory

    My SQL Server is taking around 1 gb of memory! It is running 18 databases apart from the shipped dbs and populating the full-text search catalogs for some 5 databases. But still is it normal? When it is not running the repopulation of the full text catalogs it consumes around 700 MBs. I feel...
  18. apollo11

    Grabbing DATA from remote SQL Server to Home Based SQL Server

    Right Click Databases folder All Tasks-> Restore Database..
  19. apollo11

    Application Log File is full Error

    No the log just has 4 or 5 entries!
  20. apollo11

    Application Log File is full Error

    I am getting the error: The Application Log File is full. I have cleared the Application Log from the NT Event Viewer several times but this message still pops up!

Part and Inventory Search

Back
Top