Search results for query: *

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

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

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 "SupplierID in (' + @SupplierID + ')" 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

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

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

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!

I am trying to restore the backup of a database which has a full-text search catalog attached to it. When I restore the db and try rebuilding and re-populating the catalog it does not get populated. The same db restored on another sql server machine has the catalog populate correctly! What could...

I have observed that specifying any other extension for database backups ends up making the file significantly larger than a file with a .bak extension. Why is that?

I am trying to execute some COM objects via a stored procedure. I am using sp_OACreate to create and sp_OAGetProperty to excecute a property that returns another object Now when I try to run sp_OAMehtod against this returned object I get an error from sp_OAGetErrorInfo saying " Element not...

I am trying to run the following dynamic SQL: declare @ebodbname varchar(255), @SQL varchar(1000) Select @ebodbname = host_db_name from host_db_name set @SQL = "declare @EBOID integer" + CHAR(13) set @SQL = @SQL + "select @EBOID = EBOID from " + @ebodbname + "..EBO...

I am trying to send mail via sql server using xp_sendmail. I understand SQl server uses MAPI to do so. Is there a way to interface SQl server directly to SMTP. The reason is that I want to connect to an exchnage server behind a firewall and if I use MAPI I will have to open up way too many ports...

Can I update a column for the same table in a trigger,within the trigger, for which the trigger belongs? E.g.: CREATE TRIGGER [MainTrigger] ON [SimpleBuyStatus] FOR INSERT,UPDATE AS BEGIN Declare @POID integer, @Status varchar(10), @Action varchar(10), @DocType varchar(10), @Result...

I am trying to do something very simple... I want to add new column/s to some tables.I know I can use ALTER table but the way I am trying to do this is. The steps are as follows: 1)Create back up tables with the new columns 2)Add data by copying data from the OLD tables and adding...