how can i check how many applications are connected to sqlserver at a time in a produciton environment i have some knowledge of profiler but I dont know how to use profiler for this purpose thanx ...more >>

My Question: What is the best way to monitor/collect Updates/Inserts to a table in SQL Server 7.0? We have a VB6 DB application that uses SQL 7.0, and I need to figure out what it does to the database. I would like to see the actual data and Sql query that updated a row(by Column if possib...more >>

Dear h I want to have MVP title.what should i do Any sites about SQLserver2000 certification sample exams thanx....more >>

Hi I have 3 tables in MSAccess. 1.Customers 2.PurchaseOrders 3.PurchaseOrdersItems If there is more than 1 OrdersItem on the same order then the Company name and other data comes up. ie. 1001 ,Company Name , Date , SalesPerson , OrderItem1 1001 ,Company Name , Date , SalesPerson , Order...more >>

Hi all, I've never done anything like this before and I can't get past the first step. I've written a trigger that after altering the database, needs to get the application to refresh itself. We do not have access to the application code, but I do have access to the API in the form of a fi...more >>

Hello, I have read that MS-SQL Server 2000 still supports the old syntax of doing outer joins. From everything I understand about the new join, these 2 statements below should be synonymous. Rather strangely, only the new statement SQL-92 syntax actually works. While I have read that it...more >>

I've looked at about 10 o/r mapping tools/libs for .Net, about half of those in some detail -- if you put the best of each together you'd have a real winner. Anyone taken the plunge with one or more all the way through deployment and have any comments? As these things tend to ouput dynamic SQL ...more >>

Hi I am applying the trigger below - CREATE TRIGGER [dbo].[trg_insert_export] ON [dbo].[export] FOR INSERT AS BEGIN DECLAR @NOTE VARCHAR(15) @VOIDINDICATOR VARCHAR(1 SELEC @NOTE=reference2 @VOIDINDICATOR=voidindicato FROM inserte INSERT INTO [shipment ...more >>

Hi all, Ok I got help awhile back on this but, noticed that it didn't return all the rows. I'm trying to return all rows that meet the where clause and , if there are rows that the Column "Full_name" = the same just return that one row, with the earliest date. This returns almost all of ...more >>

beside ISQLW, OSQL, and ISQL utilities, what are the other ways to execute a sql file? (in my example, I have a bunch of queries in this file) I can't use this crappy utilities because 1. ISQL sucks! too slow. 2. OSQL is better than ISQL, still a little slow. 3. ISQLW is fast, but somet...more >>

I'm having trouble understanding when to use 4nf for 1:n relations. Consider Customers(PK IDENTITY CustID, Name, Address...) and BillingProfiles(CustID INDEXED, CreditCardNum...). A customer will have one, or possibly more, billing profiles. It seems to me that having a seperate CustomerBillingP...more >>

I am doing a simple: select d1 from tbl1 where d1 not in (select d2 from tbl2) I am hoping to find all missing entrys in tbl1 that are not in tbl2 since they should be identical. It returns no records despite the fact I know there is data missing from tbl2 that is in tbl1. I have no idea ...more >>

Hi Everyone, I'd like to compare two text fields in the same table using a select statement but I'm having a hard time with the query. Here is what I need in pseudocode! Select * from Table where behavior like alternate_behavior Thank you in advance! Any help is greatly appreciated! Jo...more >>

I know i can use CURSOR VARYING as an output parametar for a stored procedure, and then store that to cursor variable, and then do a 'while' loop to fetch the data. But, is there a way I could get a whole recordset, so I can do SUM() or something like it from the returned data? Something li...more >>

Resending the Post Again as After one day of Posting It did not appear in newsgroup. Hi All, I have one doubt. If I have given my Stored Procedure name begin with the name "SP_" then when I Try to execute the Stored Procedure then Will the SQL Server will serach for that Stored Procedure fi...more >>

i am getting this error when i am trying to connect from remote machine , on the same box i dont DB-Library: Unable to connect: SQL Server is unavailable or does not exist. Un ble to connect: SQL Server does not exist or network access denied. ...more >>

I am trying to update a local database getting data from a linked server update distribution set appt_begin_date = ( Select appt_begin_date from mylinked.qdb.dbo.employee_appt qdb inner join person on qdb.employee_id = person.ucla_id collate database_default ) I get an error... T...more >>

I am trying to run the following simple query, it is returning an (please see below) select employee_id from MYLINKED.qdb.dbo.employee_appt qdb inner join person on qdb.employee_id = person.my_id Error Cannot resolve collation conflict for equal to operation. Questions: 1. What is...more >>

Given the following tables: CREATE TABLE Library ( LibraryID INTEGER, Name VARCHAR(50), Description VARCHAR(1000), DateCreated DATETIME ) CREATE TABLE Book ( LibraryID INTEGER, Title VARCHAR(50), Contents VARCHAR(1000), DateCreated DATETIME ) I want to have a query...more >>

I am using stored procedure in my Visual Basic program however, when I call it from program, it prompt me following error: Run-time error '-2147217900 (80040e14)': Syntax error or access violation Here a piece of code in my vb program '-- getConnection is a valid function that return a AD...more >>

Hello I was wondering if you guys know if there's a program that generates common SPs such as INSERT/UPDATE/SELECT from existing tables? Im trying to save time, and kinda boring to write them simple SPs all the time TIA /Lasse ...more >>

Hi, i want to build a stored procedure in t-sql with an undefiened parameter collection. The problem I have is that I get 4 parameters of type uniqueidentifier with are all nullable. (optional parameters) If I use the values of these parameters, anyway if they have values or not, I get wr...more >>

I have my test.dll file, how do you make it to external procedure? I know you have to register dll, but I don't know what are the correct steps to do it. can you show me? ...more >>

Hi Is it possible to update the SQL server password on a local machine and change it from sa, admin. Our old DBA was very lazy and we would prefer to use Strong Passwords? Is there a way you can apply this change without re-installing SQL again, perhaps through TSQL? -- Kind Regard...more >>

Hi Freinds, SQL 2000 I have this script : ---------------------------------------------------------------------------- ------------------------------------------------------ declare @tmpdoublefiledname nvarchar(50),@tmptablename nvarchar(50), @tmpPKfield nvarchar(50) declare @tmpdoubleentry...more >>

Is there a way to use SQL to install hotfixes and patches to non SQL servers. NT4.0 and W2K servers. I'm pretty new to SQ tclev at comcast.net...more >>

Hey all, I am running SQL 2k on Win 2k Server. We are migrating from an Access app to a VB app. In the mean time, we are using SQL Server as a backend for our Access app. When certain Access queries run against SQL Server, the Datasheet that comes back can not have records added to...more >>

i think i'm almost there. i'm getting an "sql server error 156: incorrect syntax near the keyword as" Any ideas as to what might be going on? Thanks!! CREATE FUNCTION fnPlansByAccountOther (@AccountNumber INT, @MonthID INT, @Year INT, @ProductGroupPlan MONEY, @BaseLineTerritory VARCHAR(30...more >>

Having difficulty ascertaining an absolute answer for the mechanics of a delete and subsequent insertion of the same data into a table. Hoping someone more experience than I can provide some insights regarding physically purging data within a table. 1.) What are the mechanics of a delete? When a ...more >>

Is .NET 2.0 Framework going to take advantage of 64-bit computing? Intel and especially AMD's Opteron are 64-bit and they are really inexpensive. Look at the prices here... http://www.anandtech.com/guides/priceguide.html By the time .NET 2.0 comes out, maybe middle to late 2005 at the ear...more >>

on win2000 prof, sql2000 standard when deleting some rows from a table variable, if I display the content (select from ....) after the delete, the rows in question do not appear in the result, but if I use the content of this table in a subquerie the previously deleted rows appears back in the r...more >>

This might be a tough problem. I experienced ISQLW hanging when called from the command line. had you = guys encountered the same problem? if I run following two sql statements on query analyzer, it took 5 or 6 = seconds, but I run ISQLW on dos mode,=20 it took 15 minutes sometimes. t...more >>

I have two tables and after joining them, I want to retain all rows in the left table with NO duplicates. Of course, to retain all the left table rows, I can use a left join, but how to I remove duplicates created by the join to the right table? For Example, the following tables are joined tog...more >>

Does anyone have an example of how to set the session settings on a SQL Server ADO.NET connection string - I need to force the values of ANSI NULLs and Quoted Identifiers. They are set at the database level, but the ADO.NET seems to be overriding them. Regards Paul ...more >>

Hello, I have about 10,000 legitimate addresses in my database. I want to use this data as sample for demo. Obviously, I dont want real addresses and phone numbers to become accessible to public when I use the data as demo, online. If I can somehow change just the city and state fields, th...more >>

silly question probably. i see how to create a table on a filegroup, it is in the bol. also to move a table to a filegroup you can recreate the CLUSTERED index on that filegroup. but i have my table in the right filegroup. how to i move it to another file that is in this filegroup? this fi...more >>

Hello all, I'm trying to create a TSQL mail reader solution that will parse out emails in the SQL mail inbox, load them to a DB table, and then remove them from the inbox. I'm still in the planning process, but I have seen several postings regarding the 8000 char limit. Infortunately, all of ...more >>

Is there a way to count total number of created orders in each month in sql? Something like this: Select OrderID,OrderCreatedDate FROM Orders Where OrderCreatedDate >= '09/01/03' AND OrderCreatedDate <= '03/31/04' I need to know how many orders created in each month since September 1st u...more >>

I am wondering: I have a database with a few disjoint sets, and I was wondering what people's thoughts and reccomendations are In general, does it make more sense to make multiple queries on a database, or use large joins (in my case, outer joins) Is there different scenarios where one approa...more >>

I have a question, If I have two servers: Server A is web server, Server B is Sql Server. but they're in different domains, I want to use Server A 's windows authenication to log in Sql Server on Server B. I know you can do this on same domain, but what about different domains? is this s...more >>

Hi. Okay, I figured that out. qryAccountTransfers is now a stored procedure. The problem now is that I had another query, qryPlansByAccountOther that was using qryAccountTransfers as a record source. When I try to create another stored procedure called qryPlansByAccountOther, it tells my t...more >>

Hello, How can I get two decimal points showed in the money field in the table? I show 12.50 as 12.5 Thanks, Jim. ...more >>

Hi This is probably a really stupid question, but I can't seem to replace a carriage return, with a space, I'm using the following syntax: SELECT 'ModifiedDescField' (REPLACE((Opportunity.[Description]),CHAR(13),' ')) FROM Opportunity Is there anything wrong with what I have wrote? ...more >>

Hi. I just upsized an Access 2003 database that has a Union All query and the equivalent works fine in SQL Server when I paste the Access SQL code, but it won't let me save the view. Any help would be great!! Thanks! Here's the code: SELECT AccountNumber, FROMTerritory AS TerritoryNe...more >>

I need to write a sql statement against an Access DB that will give me the record position in the resulting recordset, similar to Absolute position in VB, but via a sql statement. The data is being dynamically sorted but needs to display a sequentially number to the left of each record, i.e., 1...more >>

what dose this line at the beginign of an stored procedure do?? SET NOCOUNT ON Thanks in advance for your time. ...more >>

I am creating a join query with three tables A1, B1 and C1. A1 has a field called ID and B1 and C1 has a field called ParentID which they uses to link to A1. I created a SELECT query shown below. Instead of returning just one record, it returns three, record for each table in the query. Wh...more >>

I need help on passing a column as a parameter to an stored procedure. For the procedure below: SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE dbo.proc_EmpDBColNmTest @ColNm varchar(10) AS Select e.EmpSAPID, @ColNm from employee e where EmpSAPID = 2...more >>

Hi. One of our reports is written in MSSQL Stored Procedures and its using heavily with cursors. It's processing like 3 seconds per row. Is there a way to get rid of this or is there any other way that will mimic the use of cursors because this process really requires looping and iteration... Than...more >>

Next version of SQL server will allow to write stored procedurer in C#. In general,is it going to be a common practice or T-SQL still will have it place? Thanks...more >>

Hello Experts, I'm posting this in this newsgroup (I had no response in sqlserver newsgroup) Is there any option that disables displaying/catching errors? Why I'm telling that? I execute an insert into stmnt with source the sp_MSdependencies, although it reports an error (occurs when...more >>

Hey all, I am running SQL 2k on Win 2k Server. We are migrating from an Access app to a VB app. In the mean time, we are using SQL Server as a backend for our Access app. When certain Access queries run against SQL Server, the Datasheet that comes back can not have records added to...more >>

Hi folks, Does anybody know how to create table on filegroup different than default, using SELECT INTO? Thanks ...more >>

Hell I have 2 tables User_Master and Tmp_User_Maste User_Master contains one field called user_key as bigint which contains numbers like 1111,2222 etc Tmp_User_Master contains one field called URL Which is of type varchar which contains the user_key as subpart, for eg. My_Doc\1111\test , My_Doc\...more >>

I'm trying to launch a VB application from a job I created. When I execute the job, I'm informed that the job is processed successfully, but my app isn't launched. Any help will be appreciated TIA...more >>

What's wrong with this? declare @table varchar (10) set @table ='rm_80' insert into @table select * from rm_80 where tkemail='kg1' when this works? declare @table varchar (10) set @table ='rm_80' insert into rm_80 select * from rm_80 where mail='kg1' and declare @table varchar (...more >>

DateDiff returns the number of boundaries crossed between the requested component of the two dates (YEAR) resulting the possibility of an off-by-one error. This is my solution to calculating age in a query. Essentially, a year is subtracted whenever the number of boundaries crossed to calculate ...more >>

I have created batch files that gather the event logs of our servers into a flat file.Is there a way to automatically import the file into a database with the use of a script or batch file as to manually doing this...more >>

I have upgraded my database from SQL 6.5 to SQL 2000. Now one of the SQL proc is failed to execute as there is following select stmt SELECT CONVERT(INT(2),COUNT(*) FROM tablenam WHERE conditio this stmt execute fine on SQL 6.5 but not on SQL 2000. It generates foll...more >>

HI I need to convert a numeric column into a hexidecimal format in a view I cannot see a TSQL Math or String Function that will do this (or an extended stored procedure perhapse) Is there a way to make the Convert fumnction do it? I can find nothing in Books Online or MSDN Library Help pleas ...more >>

Hi There, We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database. There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based ...more >>

within a dts package I am using a single DTS.DataPumpTransformCopy for all columns. I am trying to turn of full data truncation by setting the DTS.Transformation2.Flags = 63 which should include all of the possible truncation options ( i also tried just setting this to 4 for string truncation ...more >>

This is more of a discussion than a question, and im wondering if anyone has encountered this issue, or if indeed there is a fix It revolves around using COM objects from inside a SQL 2000 procedure using sp_OACreate etc...I was attempting to use MSXML4 inside a procedure to build a complex xml do...more >>

Dear All, I would like to track ALTER TABLE, ALTER VIEW and ALTER PROCEDURE statements in my database without using a trace. How would I do this ? TIA ...more >>

Hi all, this is my first post to SQL group. well my concern is that is it possible to copy the DB diagram from SQL and paste that into any other app like Paint, Word etc? Im writing an application that will do this stuff but im not getting starting point. any help? TIA bhavtosh...more >>

I'm having a problem using OpenRowset to open a text file inside VBScript in an ActiveX task. Here is the string I'm building. strSQL = "insert into table1 " & _ "(red,yellow,purple,DateCreated) " & _ "select distinct a.custid,b.yellow,a.birthdate,now() " & _ "from openrowset('Microsoft...more >>

As I mentioned previously, on one client's server, I get an error when I = try to create a procedure that calls 'sp_add_jobstep', I get: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData = (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 General network error....more >>

Im trying to write a query for Crystal reports but im having a few problems with a datetime field. The crystal Query reports it as a string field so i can not do any formatting for the report display, therefore i need to be able to do the convert within the query Im trying to convert a datetime fi...more >>

Hi.. Is there any specific place where I can find which SQL Query is mor efficient?. Is INNER JOIN is faster or Select ... Where ID in (SELECT ...) i faster? I have two tables: 1.FLEET (The number of rows is not so much) Attributes : Company_Id (PK) Fleet_Id (PK) Fleet_Name Fle...more >>

Hi, I am having problems using bulk insert to import a text file into sql server. I can import using the wizard just fine but when I try bulk insert in query analyzer, though I get 'The command completed successfully' nothing happens. Here is my statement: bulk insert edihandoff_bv from 'd...more >>