Recent content by apollo11

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

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

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

Thanks I figured out what was wrong with the SQL. The problem was I was building up the SQL dynamically 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...

I am trying to use the keyword CONTAINS in a query and I need to search for two seperate words in two different columns. Can I do that? The query below does not seem to work. I know its difficult to test this without data but can anybody make out anything wrong in the syntax off-hand. (I know it...

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

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.

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

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?

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

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

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?

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

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

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