Hi; What registry setting is the "official" one to use to determine where Sql Server is installed on a user's hard drive? -- thanks - dave...more >>

Hi; Is there a .msi program Microsoft provides that will install just the sqldmo component on a system. And will do nothing if it is already installed? I'd rather not write my own installer (and possibly put a file in the wrong place). If not, how do I determine where to put these files....more >>

Hi, folks! I'm trying to change SQLServerAgent password, as described in the following link... http://support.microsoft.com/default.aspx?scid=kb;en-us;259710 .... but in client machine (withou any interface), with Win98 O.S. Do you have any ideas? (procedure, etc...)...more >>

Hi I have installed SQL2k as part of my SBS2003 installation. Where do I find the clients ( which I assume I need to install onto my local workstations many thanks Alex ...more >>

Hi, I have a foxpro database files created and used by the third party vendor application. Now I want to put some sort of replication between my SQL server and the foxpro. So that my application can use this data from the sql server. I need to update only sql server tables with the foxpro tables ...more >>

-- Thanks ! ...more >>

Dear Professional Through Sql Server Stored procedure can I fetch the userid and password which saved in Registry. Thanks NOOR ...more >>

I have attached JFDB1.mdf and JFDB1.ldf file but database shown Readonly status. I have deselect the readonly from the options tab but it gave me following error. Can idea what should I do ? --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- Erro...more >>

I receive numerous deadlocks while processing transactions with more than 2 users in SQLServer 2000 SP3. While these does not happen often, it does happen often enough where it has become an annoyance. The error that the users are getting are very similar or identical to the one below: Micro...more >>

Hi, I've a table category which is recursive on it following is the sample Category_Id Category_Name Parent_Category 1 Entertainment 0 2 Food 0 3 Edible Oils 2 4 Toys 1 5 Ch. Free Oils. 3 6 Bicycles 4 i know only 6 as category id, i need the lightweight query/sp which d...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

I have a mysterious hang that I cannot figure out: I am running Win XP Pro Sp2 on a new Dell OptiPlex GX280 with 1GB RAM. 3.9GHZ CPU. My MS/SQL 2000 Client version is: Microsoft SQL Server 2000 - 8.00.859 (Intel X86) Sep 18 2003 12:53:45 Copyright (c) 1988-2003 Microsoft Corporation St...more >>

I have three vb.net desktop applications on an application server that connect every couple of minutes with my SQL Server on my database server. They have been running fine for over a year. This morning I noticed that one of them generated an unhandled error when attempting to connect. The mes...more >>

I have three questions: Could anyone help. 1. How much does a Microsoft SQL Server client license cost? 2. If we have web interface as the front end and SQL server as the back end, do we need client licenses for those accessing their databases via the web? 3. Also if we have people access...more >>

I have three questions here:Could anyone help. 1.How much does a Microsoft SQL Server client license cost? 2.If we have web interface as the front end and SQL server as the back end,do we need client licenses for those accessing the databases via the web? 3.If we have people accessing the...more >>

Can someone point me to documentation on how to install the SQL Client install via SMS to include the developer libraries? Our SMS admin has created a package using WISE, but cannot get it to install consistently. HELP!...more >>

i have a quma seprated string & want to break in substring the string 'abc,def,egl' the result i want to is abc def egl any can give me idea how to implement i have check substring,indexof function but not successeded ...more >>

Sorry about posting twice, but I had some trouble with setting the date on this machine... :) I would like to write a stored procedure that takes a table (i.e. table variable) as its parameter. E.g.: DECLARE @mytable = TABLE(ID INT, NAME VARCHAR(50)) SP_MYPROC @mytable What should SP_MY...more >>

I recently inherited support for a C# application that communicates with SQL Server and some OPC devices. Unfortunately, I don't have access to the required version of the source code (working on this aspect), so I'm having problems troubleshooting the following problem: The application int...more >>

I understand that sp_help and sp_columns can give a description of a table for me. However, sp_help sees only the tables in the current schema, and sp_columns 'COLUMNS', 'INFORMATION_SCHEMA' returns an empty result, too. How can I query the descriptions of tables in other than the current schem...more >>

I would like to write a stored procedure that takes a table (i.e. table variable) as its parameter. E.g.: DECLARE @mytable = TABLE(ID INT, NAME VARCHAR(50)) SP_MYPROC @mytable What should SP_MYPROC's signature look like? I can't seem to be able to find anything about this in the documenati...more >>

I have a pair of .MDF and .LDF files that I attached to my SQL 2000 server from the Enterprise Manager. But when the Attach Process was complete, the icon for that new database was grayed out and it has a (Read-Only) next to it. After I gave myself every single permission on the SQL server, ...more >>

I'm trying to copy objects and data between 2 SQL Server databases using the import/export wizard in SQL Server 2000. I select the source and destination database and leave everything as default. When I try to run the DTS Package, it stalls at 22% for a few minutes, then goes up to 96% or so ver...more >>

Hi I have gone from a job using SQL Server 7/2000 to one using DB2. Now this DB2 query interface is a total waste of time. A green screen interface where you can only run one query at a time and so on. I would like to know if anyone here has successfully configured there system so that they co...more >>

Dear All I want to transfer data from one sql server (installed at Head Office containg all the company data) to another sql server (installed at one branch office). Please let me know the best way to do so, should i prepare the text file containg the branch data and then sent via email to bran...more >>

I want to use group policy, software installation to upgrade all of our clients with an msi file. Can this be done? If so what is the name of the msi file? Thank you...more >>

Is it possible to upgrade about 80 clients from SQL 7 client to SQL 2000 client automatically using group policy push and msi technology?...more >>

In MSSQL I have auto incrementing PK for the row I'm inserting into. The the code I use below is to insert into the table. What I need is as soon as I insert the record, I also need to return back what the PK was of my newly inserted row. I will need to use this value for another section of the F...more >>

Could the SQL2000 Desktop Engine be bought individually or they one have to buy the Enerprise version in order to get the Desktop Engine? All we need right now is the Desktop Engine. Thank you very much mike...more >>

Is there something in T-SQL that is the same as FOR loops in Oracle PL/SQL? if not, what is the closest equivalent? ...more >>

Hi! We have a problem with a database asignation. When we try to make an attach (sp_attach_db) the system display an error: Server: Msg 3624, Level 20, State 1, Line 1 Location: recovery.c: 2657 Expression: seenCkptEnd SPID: 10 Process ID: 560 Connection Broken We work with SQL Serve...more >>

Is it possible to passing information between SQL Agent Job Steps? Such as the following job that has 2 tsql steps. Step 1) Trans sql select * from myTable Step 2) send result from Step 1 using CDO. ...more >>

Hi all, I have got a query that returns values based on a date range and grouped by week. I need to return a value of 0 if there are no entries for that week. At the moment it just skips that week all together. Any ideas? Thanks...more >>

When I click on property of Db in EM on a sql server EM quit. I have installed the sp3 recently. Anyone has the same problem? How to fix? Thank you...more >>

Hello everyone, Can you please post links of "getting started" tutorials on DTC? Thanks!...more >>

If I run e.g. a table-creating sql statement then the changes won't show in Enterprise Manager no matter how many times I refresh. They only show if I restart Enterprise Manager. 1. Is there a way to get EM to reflect the changes made in Query Analizer? 2. I couldn't seem to find a way to ru...more >>

I get the following from a SQL Trace log on our UPS system communicatiiong with a SQL2K DB: ============================================== ShipUps 3a-e2 ENTER SQLExecDirect HSTMT 01D3DEA0 UCHAR * 0x01E9CB90 [ -3] "INSERT INTO tblShipLog (TotalFrei...more >>

are there any sql server client tools for mac os *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Can any one send me the script of SQL SERVER 7 "DATABASE BACKUP script" AUTO BACKUP THE ALL DATABASE BACKUP Thanks NOOR ...more >>

What would be the minumum hardware (and software) requirements to have SQL client on 10 of our contractors' computer with a maximum database size of 5GB? Thank you very much mike...more >>

how to store value return by a select query into a variable like var = select id from table where login='abc' ...more >>

i want to insert values into a table select one field value from other table (want to write select statement into insert statement but not knows how to do it) how can i implement it the stored procedure is as given below ALTER PROCEDURE dbo.usp_Insert ( @AccountName [NVARCHAR] (50) ...more >>

Hi All, We are during the coding of SPs in one project. Each SP is one .sql file and these files are becoming more and more. We use Query Analyzer to open .sql file and execute the script to create SPs one by one. It is obviously time cosuming and bring some mistake. Do anybody have a good wa...more >>

Hi, I'm using ADO to connect to a SQL Server. I want to execute a query which reads sensistive information and ensure that the results of the query cannot be sniffed on the network Can I enable encryption for a specific connection to the SQL Server without forcing either the client machine or...more >>

I created a Job with T-SQL to backup a database and retain it for seven days. Each night's backup has the date and time of the backup as part of its name. Unfortunately, after seven days the earlier backups are not being deleted. At first I thought it was because the backups hav...more >>

Hi, My application may execute some SQL statements using DTC. After I've installed Windows XP Service 2, those SQL statement doesn't work (it's orginially used Service Pack 1). I've found that there is a firewall is deployed with SP2 and I've disabled it at all. What's happened? P.S. Client...more >>

Hi i have a windows xp pro, i using odbc to connect to sql 2000 server. i have two connection that work fine. Now when i try to connect i receive a popup message of error. If i try to configure or recreate my odbc i receive the followin errors: impossible make connection sqlstate: '01000' sql...more >>

Hi, I'm trying to use the CHARINDEX built-in function in my user-defined function, but it doesn't seem to work. Right now I got down to only write a test-function that doesn't do anything else but call charindex: CREATE FUNCTION X(@p_str1 VARCHAR, @p_str2 VARCHAR) RETURNS INT AS BEGIN RET...more >>

Hi, I have a windows setup program (framework 1.1), this setup program calls one util.exe with parameters. util.exe opens the connection (SQL Server 2000, windows authentication only) and does some db updations. when i run thru setup exe fails throwing "Login failed for user '(null)'. Reason: ...more >>

...more >>