When using SQL 2000 personal desktop (i.e MSDE) on win 98 Machine with our VB6 application we sometimes get this error [Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: Provider DLL failed to initialize correctly. On Win2000/20...more >>

Hi, after I tried it a few times without success, I'm searching for a step by step guide how I can realize a odbc-connection to a sql-server through the internet. In the local Network where the Server is installed the port 1433 is opened, directed to the server and I know the WAN-IP-Adress ...more >>

HI i have installed VisualStudio Sp6 after this installation when open my Sql 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows don't work. I reinstalled Sql Sp3 but don't work. Can help me? Tia Pupo ...more >>

There is one user 'Noor' in the database, he has created alot of objects and now I wanna delete that user throught the following command.. sp_droplogin 'Noor' -- obviously this command will not work b/c so many objects are mapped to that login.. Now I wanna drop that login 'Noor' with single...more >>

If I have 3 programs on my desktop that connect to two different SQL Server databases (two to 1 and 1 to the other) , yeah! looks funny, I know. How many SQL Server CAL's do I need? Are these server CALs or Device CALs or does it matter? If I am using all three programs at the same time does...more >>

I don't know where to ask this question, I am hoping someone will clarify this for me. We are evaluating several ERP systems, but when it comes to choosing the database. All the software vendors say that they have to pay approx. 10% Royalty to Microsoft to develop their applications on SQL...more >>

Our vendor is running SQL 2000 on a Win2000 server and is planning on installing the SQL 2000 clients on Celeron PC's (400-700mhz). It would seem that the performance would be too slow on these processors. Has anyone had experience with running SQL 2000 clients on older celeron processors? ...more >>

I am using the following command but it gave me an error that the log file is in Use alter database Aspstate set RESTRICTED_USER with ROLLBACK IMMEDIATE Go DBCC SHRINKFILE(Aspstate_Log, EMPTYFILE) Go any idea what I have to do? Thanks Noor ...more >>

here is the data in One table. Pak Sind karachi Pak Sind Hyderabad Pak Sind Other I want the result like this. Pak Sind karachi null Sind Hyderabad null Sind Other any query thanks ...more >>

How Can I make any specific server as a Master server and how can I create any specific machine as a target server thanks Noor ...more >>

Dear Professional I want to restart the msSqlServer and msSqlAgent Services once a day through JOB, how can I perform this Thanks NOOR ...more >>

I have used the DBCC showcontig ('product') Which point should we consider if the Logical Scan Fragmentation is in between 1% - 50% and Which point should we consider if the Extent Scan Fragmentation is in between 1% - 50% Thanks NOOR ...more >>

How can I identify the database which I execute an TSQL statement. The counterpart to @@ServerName... Something like @@database? thanks in advance. /Tob...more >>

Dear Sir/Mam, Kindly let me know that whether it is possible to set authentication locking mechanism that will provide the feature for disabling user accounts after 2 unsuccessful login attempts and automatic password expiry on SQL 2000 clients. Regards Vetrivel.S...more >>

Several people have suggested to me that I should abandon MS Access and MSDE2000A in favor of the Developer edition of SQL Server. If I do this, what cleints should we be using to develop GUI screems for our customers and to deploy to our customer's users? Both our developers and the users are...more >>

I've written some software that listens to meters on a specified port and writes XML files when any of those meters "speak." There are some 200 of them, and each is programmed to "speak" at 10 second intervals, so there's a fair amount of traffic. Now what I've been asked to do is write a reco...more >>

Hello, I need help with a semi-complicated(not sure) query. Here is a snip-it from the table I'm querying: RATE_CENTER OCN NXX BLOCK_ID Block Count Per OCN __________________________________________ _________________ ABERNATHY ...more >>

Could any one confirm me that can I restore only the Primary File Group from the Full Back file. Thanks NOOR ...more >>

Hello, I have an Access 97 application that links to mulitple SQL Server 2000 databases. I migrated one of the database to a new box running Windows 2003. All my users are fine except one. When this user tries to link to the database on the new server if keeps prompting him with a connection ...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

I tried to transfer the data from one application to another. Under the SQL Profile it stated Error 242, Severity : 16, State : 3. Any idea? SQL provide an logging "sa" error. I have checked the password for the application setup, odbc and SQL, they are all identical. The applications have no proble...more >>

Let's assume there is a OLTP database so I just wanna know which one would be better performance * for Place the transaction log on physical disk 0 and and the data file on the RAID-5 disk array Or * for Place the transaction log and the data file on the RAID-5 disk array Thanks Noo...more >>

I am trying to split an address field which contains carriage controls. The address field can have 2 carriage controls in it, ie 3 address lines. I want to split the address into 3 seperate colomns based on the control carriage. I know how to combine 3 columns into 1 but not how to split it out agai...more >>

Hi, I'm getting the runtime error 2046 (The command or action '|' isn't available now.@* ...) when I try do delete a record from an SQL SERVER 2000 table in an Access 2000 form. The strange is that if I try to delete the record again it works, and this error message just appears sometimes... ...more >>

I get the follwing error: "Setup Initialzation Error. Error performing inpage operation Source: d:\x86\setup\..\upgrade\res\1033\cldtcstp.rll Target: c:\winnt\temp\sqlsetup\bin\cldtcstp.rll" This is happening when I try to install the SQL 2000 client on a machine that either had or has ...more >>

I have an Active Directory network with an Exchange 5.5 server running on a Windows NT box. I am hosting 3 email domains on that box. For example lets call them mydomain1.com, mydomain2.com and mydomain3.com. All external emails come in and work just fine except for the mydomain3.com emails...more >>

I've been having this problem for a couple of months now. When I try to connect to an SQL Server on a remote network I get an error message saying "SQL Server does not exist or access denied". I think - but I'm not sure - that this problem appeared after my hosting provider moved the database ...more >>

In Our application there is a method which contain a series ( around 7 ) of functions ( we can think it as sql queries). Earlier we use to create one table for each fuction out put and use it as the input to next function. ( we use simple recovery model) Things were working at that time , but to...more >>

Hello. I have a solution written in Access. In order to filter a report a date is passed the the serverfilter property. e.g. MyFilterDate='01/28/2004' This works fine on one machine but on another machine I get an overflow error due to the fact that date is passed in American Format. Bo...more >>

osql :r doesn't seem to like file names with spaces. Don't want to have to use shortnames if I don't have to. What's the fix? Thanks Martin ...more >>

I have two instances running one is on SqlServer 7 and second one is on SqlServer 2000 (default). I want to make the default instance to SqlServer 7 , how can I ? Thanks Noor ...more >>

Can any body tell me one thing like when I run the following query it will run perfactly but also return null values Update Personnel Set PA_IsFirstLogin = 1 GO OutPut : Null Null Null Null Null Null Null Null Null Null Null Null Null...more >>

I can execute the following in SQL Query Analyzer: Select productID, productName from Products where productName LIKE '%Spider%' and get the results I was expecting. I must be using the wrong syntax when I try to use a variable instead of a hard-coded search string in my ASP.NET code. I ...more >>

Dear All I have created one stored procedure for parsing the XML and insert that data into specific table but the problem is the XML Character length is around 10000 and for this I have to take text datatype as a input Critaria but stored procedure can't support text datatype as a input crita...more >>

Hi, we are running SQL 2000, on a win2000 server. it seems that the clients are dropping the connections to the server since I changed the connection from ISDN to DSL. The tunnels are up and functioning, I have set the time-out to infinite, but I still will loose connection. The VPN tunnels ...more >>

We sometimes get very large databases that we want to cut down to use for testing. The information is all related to a central accounts table. The way I thought of doing this is to grab all the foreign constraints and turn them into cascade delete constraints, then delete as many accounts as...more >>

Hello, We have a sql server 2000 data warehouse at my company. What sort of licence would I need to install the client software on my computer for the purpose of writing queries which I would use for crystal reports? Could I use the developer licence? Is it enough? I mean, my thinking is tha...more >>

Hy anyone use 'Database Maintenance Plan' for setting database backup? I try many times but the backup's log mangement don't work. Giuseppe ...more >>

Hi, I want to restrict the access to enterprise manager from the developer computer. They need the access the develpment machine so they require enterprise manager on their machines. But i do not want them to access the production database from their workstation enterprise manager. Also because...more >>

Dear Guys... Let's assume I have a Database Name "Production" and I have two Harddisk C and D. In C drive I have production.mdf file and in D Drive I have production.ldf. After a month C drive has been corrupted but D drive is still live so now I am in a position to recover whole data or not t...more >>

What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I = created, attach and detach database manytimes. SOme time its shows the = database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it = only shows file name as "xxx.mdf and xxx.ldf", why? However in = Enterprise man...more >>

can anybody help me with sql problem if have this table `link_item_cato`: +-----+---------+---------+ | id | item_id | c ato_id | +-----+---------+---------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 1...more >>

I have created one database named test on DServ Server and in that database I have created three fileGroup named Primary, BaseFileGroup, TransactionFilegroup and after that I took the backup of that all filegroup and restore it into another server. (OServ). After a week I took only the backup of...more >>

Hi, I cannot execute ISQL query from dos prompt to one specific MS SQL Server 2000 production machine, but works fine with other server any reason Please let me know ASAP Thanks & Regards, Mustaq ...more >>

Hi all, This is a question related to licensing... Environment : Server 1 - Windows 2000/2003 with SQL Server 2000 Server 2 - webserver (IIS/Apache/etc) Server 2 is connecting to the SQL Server database (Server 1) using SQL Server authentication (i.e. SQLServerAccount/Password...more >>

Hello, we host some MS SQL Server databases. Our SQL server is accessible via port 1433 from outside. And i was wondering how our clients can connect to our SQL Server withouth having their own license of MS SQL 2000 server. Is there a free downloadable client tool so they can log in with t...more >>

Hello, we host some MS SQL Server databases. Our SQL server is accessible via port 1433 from outside. And i was wondering how our clients can connect to our SQL Server withouth having their own license of MS SQL 2000 server. Is there a free downloadable client tool so they can log in with t...more >>

SELECT TOP 10 * FROM ( SELECT TOP 60 * FROM Patient ORDER BY PA_VPatientID DESC ) ORDER BY PA_VPatientID DESC E...more >>

Hello, Has anyone figured out a way to install SQLXML on Web Server Edition? I tried and it says I have to have the SQL 2K client tools.. well I can't install them because that setup has been disabeled because it is the web server edition (which I understand). But shouldn't a stand alon...more >>