Microsoft SQL Server Forum

I have a java program that accesses an ms access database through odbc:jdbc. When deploying my program will the users need a full version of microsoft access to be able to use it? If not, what do they need and where can i get it from. Thanks

If I copy a Database backup to a CD; can I resotre to a different server? Thank you

My Name is Nick Soutter, I am the owner of a small game company, Aepox Games (We're in the middle of a name change from "Lamar Games"), www.lamargames.net. Our first commercial game, Andromeda Online (www.andromedaonline.net) is going into beta soon. It runs on an evaluation edition of SQL Server 2000 (our intention is, when it...

Dear all, I want to use C program to connect MS SQL server. I copied some sample file to install on my computer. When I run the program, an error occurred, which is about ntwdblib.dll not find in some paths. But when I check the paths again, they have ntwdblib.dll. When I run my C program in another computer, it works... so , I feel...

I have a table that has numerical ID. I want a query that will get the 20 highest IDs. So in other words the query would return the last 20 results entered. What would even be better is if they were distinct entries by another column, but it still returned 20 results. Can you specify in SQL how many results you want?

Hi All, I need this urgently. Unknowingly i made something in my IIS. In my Javascript app i am using window.open to open child windows. All of a sudden when i try to open a child window the explorer is getting hanged. Do i need to make any setting in IIS to make my window.open function again. Help Please.

Would like to implement Blat on SQL Server 2000. I'm looking for example syntax for setting up BLAT with xp_cmdshell. TIA

Hi, is it possible to create an "INSERT INTO ..... "Select from stored procedure" Query? I want to create an temporary table. In this table I want to enter the data, which I can get from an stored procedure. But in the FROM-clause a stored procedure is not allowed?

select *From titles (18 row(s) affected) Totally 18 records are there in Titles table. When I query select title,title_id From titles where title like 'T%' and title_id like 'M%'

I want to backup selected tables from a database and restore it . How can i do it -- Posted via http://dbforums.com

Hi all, I'd like to know if it's possible to sort twice in a same SQL query. I use SQL for retrieving Data into an Excel Spreadsheet. (Excel 2000 or XP) and to paste the queries results into an Excel spreadsheet. 1. I tried to sort by date and the only way was to use the serail number instead of the litteral name

Hi Team, Is anyone else out there struggling with SQL Server on XP? Specifically, is there anyone struggling with starting the Agent Service using the NT_AUTHORITY "security" role? I am having no end of grief. I started with a perfectly clean XP install. I performed an absolutely clean, default install, and the installation hung. It...

I am in need of some advice. I need to build a SQL machine that will be adequate for my company. Budget is a very big factor but I need the machine to be reliable and as redundant as possible. This box will be 'vanilla' since I will be building it myself. I looked at some larger companies websites and the prices are way out of control. ...

Hello, I have a SQL server being the recipient of a message. The message comes in via TCP/IP and is sent to MSMQ. From there it is picked up by a COM+ object which puts the message into SQL server. This is all down via MSMQ triggers. The question I have is: How do I get the message to be REMOVED from the MSMQ queue after the message is...

Hello, Does anyone know of a way to loop thru a SQL table using code in a stored procedure? I need to go thru each record in a small table and build a string using values from the fields associated with a part number, and I can't find any way to process each record individually. The string needs to be initialized with the data associated...

When I run the attached query, I get duplicates when there is one to many relationship between tableA and tableB. The query, tested schema and the result is attached. Sorry for the long post. Here is tested Schema and Data inserts. ---------------------- create table TestTblA (ShipDate datetime, CPEID varchar(30), phonenum char(14))

I've added two more articles to my web site. Both are about error handling in SQL Server. I also cover ADO to some extent. The articles are "Error Handling in SQL Server - a Background", http://www.algonet.se/~sommar/error-handling-I.html and "Implementing Error Handling with Stored Procedures",...

Hi, I have copied a table structure with 13 rows from one db to other db after executing .. sp_dboption nowdb,'select * into/bcp',true .. select * into newtab from d1.dbo.oldtab The table is copied but the primary key is not unlike the oldtab has the pk.

Hello , this is my first posting in this group. I am running SQL server 2000 on my windows 2000 server box. I use it for my Siebel database. When ever I launch Query Analyzer and chose SQL Server Authentication I get the error message below: Login failure "SA" Not associated with a trusted SQL server connection.

I have an Excel worksheet with 4 columns: F1 F2 F3 AutoNo A Y C 1 G C D 2 S W A 3 I have a table in SQL Server 2000 which corresponds to the above worksheet. What's the best way to update columns F1, F2, F3 in the table using the AutoNo from both the table and worksheet?

I am trying to write updatable cursors in a stored procedure? Can I get any help to write updatable cursors? Any help would be appreciated very much. Thanks for your help in advance. Rajah V.

I have an ASP page that will take form info that a user has entered, then save it into SQL server, and retrive and display the info on another page. My problem is with long text data (10,000 bytes or more). It appears to save the long text data, as in it gives no errors... but it does not save it. In the SQL table, the field is defined as...

Are there any limitations or gotchas to updating the same table which fired a trigger from within the trigger? Some example code below. Hmmm.... This example seems to be working fine so it must be something with my specific schema/code. We're working on running a SQL trace but if anybody has any input, fire away. Thanks!

I would like to know how to write a function that will go through data in a column and change it. For example, I have a column of ISBN's for books, and the ISBN's have a period in them randomly distributed. I'd like to pull the period out. Any help I can get will be appriciated. Thanks, Bill

I have a column of digits I'd like to copy into another column in the same table. How would I do this? Thanks, Bill