I receive "Error 429: ActiveX Component Can't Create Object" when running a VB software that try to connect to SQL server. My PC running on Windows 2000. I have tried a few way that listed in MS knowledgeBase, but still not get it. Appreciate if anyone can answer this. Thanks....more >>

I have a client server application that needs to access a SQL database on the local server. It will work only if I use Named Pipes in SQL Client but not with TCP/IP. I checked everything possible but could not find a clue. But Query Analyzer works fine with either setting in Client Network Util...more >>

My question is pretty simple: How does one go about purchasing an extra license for SQL Server? A customer of mine has recently asked about this. I work for a small computer that usually only sells products like MS Works or Norton Antivirus, so I know very little about SQL. My usual who...more >>

Does somebody know how can I fix thir problem?? Error 28559: SqlServerCe encountered problems in opening the sql server ce database. I can sychronize data from the server to my pocket PC using a merge replication, but I can't do it from my pocket PC to the server. Thanks....more >>

A user connection which was killed went into RUNNABLE status with KILLED/ROLLBACK cmd when we monitored with SP_WHO2.It looks like the process was hung and no activity in CPU or I/O.How do we get rid of that process completely without restarting the sql server? ...more >>

I am running into a dilema with one of the reports I have to run from MSSQL. One table contains over 1 million rows (A) and 2nd table contains 20000 rows (B). row A needs to compare items from row B. This isn't that bad until I realized that this might take a few days to give any kind of re...more >>

Hi Recently I had posted a question on Enterprise manager error -> "Can not see any items under SQL Server enterprise manager" User could not see any items under Databases folder in enterprise manager(even after refresh and reconnect etc...). But when the user opened some table in ob...more >>

Can someone tell me what the Shared Memory option is used for when one runs the SQL client network utility. Start->Rin Cliconfg There's an option for shared memory protocol. I would like a good technical description of this option. When to use it and when one doesn't need to use it. Many ...more >>

i wish to put default date as current date, even if no value is entered in the column and not 1-1-1900 as comes currently alter table ticket alter column received_date smalldatetime default GETDATE() Server: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'default'. ...more >>

CREATE PROCEDURE [dbo].[CmsUpdateTrainerSchedule] ( @EducationSessionID INT, @AssignedDate DATETIME, @ProgressStatusID INT ) AS UPDATE EducationSession SET ES_AssignDate = @AssignedDate WHERE ES_EducationSessionID = @EducationSessionID Exec Cm...more >>

CREATE PROCEDURE [dbo].[CmsUpdateTrainerSchedule] ( @EducationSessionID INT, @AssignedDate DATETIME, @ProgressStatusID INT ) AS UPDATE EducationSession SET ES_AssignDate = @AssignedDate WHERE ES_EducationSessionID = @EducationSessionID Exec Cm...more >>

Hello, I have some problems with SQL2K performance on some queries passed to server from client application witch works via ODBC. I tried to catch those queries using SQLProfiler, and noticed something. When I catch a query in sqlprofiler I see RPC:Completed, TextData(sqlstateme...more >>

Can anyone tell me why SQL-Server uses a different soundex algorithm to oracle and any other soundex generator found in the uk. For example for the surname 'skipper' oracle produces S160 and SQL-server 2000 produces S216. I have tried to call microsoft to ask why but it is a fortress th...more >>

Hi All I have installed SQL Server at client place, and client is having 30 computers with 1 server network and Windows 2000 Based. every thing was working fine and every client was able to access SQL Server, but now i donno wut happend, it's not connecting with server and this error message app...more >>

I'm not an SQL expert by any means... A friend of mine is trying to install and configure SQL 2000 Std on a Win2K3 box... All the services and everything works, but he can't access the DB from remote ODBC... He is telling me that port 1433 is not open on Win2K3...so he can't connect ODBC r...more >>

Hi I just converted my access database data to SQL 2000 database. In my visual basic form, I am able to connect to the SQL database using the data environment. I can see the tables and the data. However, I can retrieve the data using the visual basic form (using the visual basic data control) a...more >>

Today a user just called me and said she got an SQL error message when she tried to run a batch. I changed the dex.ini file (found in the application root) to log error messages. Change the following statements from FALSE to TRUE. SQLLogSQLStmt=TRUE SQLLogODBCMessages=TRUE SQL...more >>

hi does anyone know where i can download a program called msdemanage?? thanks...more >>

Question I have sql 7.0 EM loaded on my desktop. Can I register a SQL2k server using the same EM or do I have to get the CD and install EM from SQL2k cd Thanks Sam Berry...more >>

I have one input critaria which comes like '125,4566,23366,452020' I wanna insert into one table which name is chapter and the above input params are it's ids so can any tell me that how can insert that above params into that table like when I fetch the record from table so I will recieve like...more >>

I have to export the servers registered in Enterprise Manager and import the servers into another 30 machines. I exported the registry of HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X but when I import it, I only see the groups. Tried install ...more >>

Hello, I try to make a connection with a SQL Database table from within Microsoft Access and when I display the data in a grid or in a form I get '#deleted' in the feelds. When I make a repport from the same table in the same Access database I get the correct data. There is only one database...more >>

Will a bit field accept a null value? I supposed that it would because when you create the field you have a null checkbox which is not dimmed when you define the datatype as bit. It appears, however, that only ones and zeros are acceptable. Is this correct? If it is correct may I suggest th...more >>

Can anyone help me with this. I don't seem to be able to install SQL2000 on Microsoft XP professional. The installer just exits everytime it tries to install. Installing on Windows 2000 is no problem on the same hardware platform (IBM Thinkpad T40). tks...more >>

Can any body tell me about the ORDBMS... and what about Sql Server 2000 Thanks in advance. Noor ...more >>

I dont know exactly what I've done, but my SQL Enterprise Manger is now faiing under Windows XP Sp1 (I've started uninstalling updates, but to no avail) The error I get is: Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience. AppN...more >>

Dear Professional Can any body tell me the major difference between Microsoft Access and Sql Server 2000, Like is Access is RDBMS and Sql Server is ORDBMS. Waiting for your reply Noor ...more >>

Hi, I have a table with multiple date fields per row: NAME PLDAT1 PLDAT2 PLDAT3 Name1 15-12-2003 11:00:00 16-12-2003 16:00:00 16- 12-2003 20:00:00 Name2 15-12-2003 10:00:00 16-12-2003 18:00:00 15- 12-2003 08:00:00 Name3 15-12-2003 18:00:00 14-12-2003 13:00:00 00:00:00 I would ...more >>