Hello there After several formats of my computer as a result of viruses i've installed firewall After that my email address got 70 emails from users registered in here on this newsgroup: mails that looks like microsoft messages. But all of them had viruseses inside them and it blocked other...more >>

Getting this error when doing an xp_commandshell from a stored procedure: The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. We're also having problems with the server going into firehose mode. That seems to be happen...more >>

Hello there I'm new on Sql server For my knowladge i can send Mail by the operator of sql server Agent tool The operator sends the email from the server and not from the client 1. Is that meens that i need to declare email on my server ? 2. If i do the replay address will be of the se...more >>

Hi Everyone, I'm new to the SQL Server world. I am looking for a tool similar to SQL navigator in Oracle, that will optimize Sql queries for me. Any suggestions? - SM ...more >>

I have a field in a table called ATB that is of type Varchar. I know for certain that the field contains no other data than nulls or numbers between 10 & 99. I would like to convert this field to a smallInt. I see that I can not simply just change the field from one type to another. I thought ...more >>

Using SQL 7.0 would like to create an array of double, not sure if it allows me to. Please advice...more >>

Fellow SQL ers' I am trying to find doco on the Update in-place functionality for SQL 2000. Can anyone direct me to a site for this. I know SQL 7 and 6.5 had specific doco about when it would be used by SQL and when it would not be used by SQL. I can not find one thing in BOL and very lit...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

My DB runs at a webhost and is one of literally hundreds of other DBs on the server. When I open the 'Databases' node in enterprise manager it takes forever (30mins+) to load all the available databases. Is there a way to only open my DB without having to browse through all DBs? Pieter ...more >>

We just got SQL 2000 installed, but want to keep several installations of SQL 7 installed. I am wondering if anyone has had problems with having both clients installed. Thanks, -- Scott ...more >>

What is the best way to track these errors down. I have users that are getting disconnected throughout the day at various points. We use TCPIP for connection. It will work for hours then all of a sudden throw the error. Nothing is reported in the event logs on the server or client mach...more >>

Newbie to SQL. Can I create (not link) database on the SQL Server using MS Access's project? Example if possible. Thanks in advance....more >>

Error Message while execution. SQL Server query has been canceled because the estimated cost of this query (2) exceeds the configured threshold of 1. Thanks...more >>

Microsoft Partner this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to...more >>

Hi, All: This SQL with UNICODE characters works OK to me and give me 2 results: SQL =3D "Select * from people where name=3DN'xxx'" But when I use stored procedure, it doesn't work, give me no results: SQL =3D "exec GetName N'xxx'" Create Procedure GetName @name as nvarchar(50) as s...more >>

I am to develop an application in fox and when I execute a command select the application goes to create a virtual table with the fields of select but in the case of the dates in the virtual table is created a field of the type datetime because in sql the field is datetime. How I can make...more >>

HI I am using OLEDB in asp and frequently get the error Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB] /Practice.asp, line 8 at one site. The thing is these errors usually have additional information detailing what the problem is but I never get any more than...more >>

I have set some DTS processes going, mainly copying a table of 168m records, and my log file is now on 45GB. How can I trim the log file? Skc...more >>

I use Enterprise Manager and IP addresses to connect to several Sql Servers in another city. When I have a project on a particular DB I am given a SQL Login for that DB and away I go. I recently got a project on a new server (Windows 2003) and couldnt register it. I have EM as result of...more >>

It is bad enough that my email address got harvested for the fake Microsoft IE 4.01 product alert email that has a virus attachment as a security patch. But I think the posts should be more closely censored as you can see from some of the posts in this newsgroup. -- *************************...more >>

Hello, Need some more Inforamation on Clients Enterprise Manager takes long time or get hang when Database list show. Please give me some moreb informationm this Thanks Dinesh Bhandare...more >>

Je cherche un moyen de remplacer la méthode seek qui ne fonctionne pas en VB avec DB OLE pour SQL Server.... Existe-t-il des API qui permettraient de me régler mon problème, je dois migrer des applications lourdes de MS ACCESS vers SQL Server et les instructions set.open ou cnx.execute sont bien...more >>

I just wanna know about connecting Sql Server via Enterprise Manager like when I connect through it and then it connect after 2 to 3 mins(Password is already saved). Can any body tell me about the reason that why it takes long time although in my different server Sql Server connect quickly. ...more >>

I am a school teacher with problems on my school networked computer. Last Friday my computer was updated with Novell Client 32 and SQL. Since that time, I am getting errors on shutdown causing my system to come up with diagnostics running. Historically, this repeated diagnostic process has...more >>

I am running SQL Server Evaluation on a P4, 235MB machine with a 80GB HDD. I have noticed today that the machine is running extremely slowly! Furthermore, I put another machine in the workgroup on a hub and tried to access the SQL engine from the 2nd machine...I kept getting the follow...more >>

Hi experts. I need to edit DSN Settings on about 200 machines. I am desperately in need of a script to accomplish this. Basically all I was asked to do is to change the hostname of a db server. Example: host=db.company.com I can`t seem to find any info on ODBC scripts Than...more >>

I have a client using my application written in Delphi with SQL Server. My log indicates Maximum number of DBPROCESSes already allocated and I can see that I have 250 sleeping processes in their SQL Server process information screen. My application is set to connect 1 times to the database and m...more >>

Is it possible to use a variable of some sort as part of a query in a Stored Procedure? Kind of like this (this obviously doesn't work) CREATE PROCEDURE [Report_ServActSumm] (@SDate as SmallDateTime, @eDate as SmallDateTime) AS Declare @MyVar as VarChar(50) Set MyVar = 'Where ([Date...more >>

Hi There, I currently developed an Access project which connects to MS SQL Server 2000. I have developed a login screen which validate the username and password for the user against the security settings on SQL Server, however the connection properties on the Access project overwrites the...more >>

In a VB6 app using ADO binding SQLServer Columns to the form controls, when a textbox bound to a varchar column is changed to "" the RecordChangeComplete event fires with adReason=adRsnFirstChange. This is good. But If the textbox is bound to a datetime column nothing happens. Has anybody ...more >>

Hi everybody, How can I Update a field from another table by Trigger? Can someone send me the statment to do it? I have a table called Clients with fields : ID_Clients, Client And Another called Doc with fields : ID_Doc, ID_Clients, Client These tables are in different databases and I w...more >>

I have a table with 8,000,000 cars. So that I know that there are in actual 8,000,000 cars in sequential order (1, 2, 3, 4....8000000) what SQL is there to verify that there are 8,000,000 cars and to output values from 1 to 8,000,000 that do not exist. For instance, if 3 was missed out f...more >>

I use EM to open a table-return all rows. But the Sorting ascending and descending button are grayed out. I tried Northwind database tables the result are the same. But if I open a same table in an Access database, I can sort the columns. How can we explain this? Thanks ...more >>

I upgraded my local instance of SQL Server 2000 to SP3 and rebooted. Upon attempting to open the MMC (EM console), I got the following error dialog: mmc.exe - application error The instruction at "0x77abf1a2" referenced memor at "0x00000000". The memory could not be "read". In searchi...more >>

Dear Professional I just wanna know about connecting Sql Server via Enterprise Manager like when I connect through it and then it connect after 2 to 3 months(Password is already saved). Can any body tell me about the reason that why it takes long time although in my different server Sql Ser...more >>

Hi, I am a newbie...so please be gentle! I am running SQL2000 with Enterprise Manager, I have an empty table called "sales" with the following fields: - ID - sales_no - amount I want to generate records into this table to be: - ID must be between 1 and 7m - sales_no must be ...more >>

I want to append to my exisiting table of 7m records a date field that contains random dates from 01/01/1998 to 01/01/2003. Currently, my table is a test table with the following fields: 1. ID //from 1 to 7,000,000 2. Make // Ford, BMW etc... 3. CC //1998, 2098, 2998 etc... If the C...more >>

i facing below problem, but after i restart server, it will work = again... Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist = or access denied.=20...more >>

Is there a way to set a default database for a server registration? I'm with a shared host and clicking my web hosts server entry in Enterprise Manager lists all the database on the server, which takes a few minutes of waiting. Maybe there's a way to set one default database for the server regis...more >>

Hi all, I am looking for List of some simple basic question, which will be based on Windows Application Development Exam Elective Exam 70-229: (Designing and Implementing Databases with Microsoft SQL ServerT 2000 Enterprise Edition) If any one having the sample list please mail me. Than...more >>

We have an Access 97 application that resides upon a Win2K sp2 Citrix 1.8 server. The Access application uses ODBC linked tables that reside in an SQL 2K sp2 database on a Win2K sp2 server. We have been experiencing occasional (weeks apart) instances of the application freezing upon an i...more >>

We have two machines that are non-members of a Domain. The machines are in Workgroup mode and running Windows2000 Pro, patched to the latest levels using Windows Update. Machine1 -------- Has SQL2000 Evaluation Version Crystal Reports IIS5.0 (for custom ASP site) Machine2 -------- S...more >>

We have installed SQL server 6.5 service Pack post 5A on Windows 2000 Operating System. We have installed Microsoft Outlook Client 2002. Applied Security Patch for the Outlook. Configured mail profile to work with the SQLMail with SQLserver 6.5. When ever we try to send email using x...more >>

hi, can somebody help me out, can somebody tell me if a windows 2000 prof machine with the sql 7.0 client tools loaded can access a sql 2000 server without having the need to run the sql 2000 client tools on all the client machines?. i hope this is clear. many thanks in anticipation of your an...more >>

I have an application I am translating from a Sybase solution (PowerBuilder) to Microsoft solution (Visual Studio .net). The source database is Adaptive Server Anywhere version 8.0 and the targets is SQL Server 2000. My question has to do with decimal fields. In ASA I have numerous decimal f...more >>

Where on the Microsoft newsgroups can I find info and discussion on the HTTPODBC.DLL interface between SQL Server and IIS? I've looked in the SQL areas and can't hardly find mention of it, and over on the IIS newsgroups, people talk about it in the past tense. I realize ..ASP and .NET are the...more >>

Hi: We have 2 sql server(both sql2000) and using update/insert triggers to replicate between the 2 servers. the replication has been working and now We got this error when doing an update: ole/db provider returned message, new transaction cannot enlist in the specified transaction coordi...more >>

Is there a way to transfer the settings of your Enterprise Manager MMC counsel from one profile to another?...more >>

Hello I have a field (nvarchar) holding words which have special=20 characters like "=A5=D6=D6=FF=FB=DFt" Now i can see them thru Enterprise Manager but if i query=20 the table to Analyzer it doesn't show. Say I have "=F9=F9=FB=D6=C4" in Enterprise manager which i can see ...i will hav...more >>

can't edit records containing null values in any of the 'bit' (yes/no) fields from a ODBC linked table (jet). The table is from an sql 2000 server database. I get a runtime error 3197 "the ms jet database engine stopped the process because you and another user are attempting to change the same da...more >>