[mssql] Forum Topics

Hi, all! I need to load base from ODBC-source into MSSql base using MsSql DTS at my customer's side with automatic as much as possible('Pushing 1 buton'). I have found such an example: DECLARE @object int DECLARE @hr int --create a package object EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT …

Hello there, we are converting our applications from a sybase server over to MS SQL Server 2000 and have run across a query that is acceptable in sybase but not ms sql. It is giving us a table name correlation error that we can't figuire out. In sybase the sql …

Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database software. There are 7 workstations (windows 2000 and XP) that run the parts database. 4 of those workstations run really fast, the database calls are near …

HI 1. I have a typical problem.We have a 2003 server which is a user authentication server.I have a sql server 7.0 on NT platform.I am logging in to the 2003 server from my XP workstation. 2. I am authenticated to 2003 server & simultaniously to NT server which has …

Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I …

I'm having trouble thinking how to write a query ... i have two tables customer and contact ...they share a common element of customerID ... their is a login form based on the contactID, contactPassword within the contact table, based on that i want the contactID and customerID of contact, …

Hello all, I have a MS SQL database which is meant to be quite small. For some reason it appears to have grown to 1GB in size. There are quite a few tables in the database. Is there any way to get a report (using enterprise manager) of the table …

Hi guys Lemme explain the situation in 2 lines: DB Structure: [url]http://img133.echo.cx/img133/6610/dbstructure6hs.jpg[/url] Client goes to computer shop. Shop has 1 or more NORMAL promotions (of the kind: for each u$sXX ammount you buy, you get X qtty of points to exchange them later by gifts). EACH NORMAL PROMOTION can have …

:cry: I'm new to this MS SQL and I've been trying to understand this Primary key and Foreign key. I know that I use the foreign key to reference a table but for some reason I'm not getting this down right can someone point me to the right direction. Also …

I created a database in Sql Server 2000, unless I made atleast one field in the table as "Unique", I could not insert data into table. But no-where in the documentation , books or Sql server online I could get a text saying we need atleast one Unique Key per …

Hi! i have a table with 3 fields: ParentFolder,DocumentNo and VersionNo the DocumentNo give each document a unique number. ParentFolder is a number specifying which folder a document is in. and each document(with same name) can have many VersionNo(1,2,3 etc). i am creating a house keeping function for user. this …

i have two tables table1 has the folowing fields lastprice symbol time table2 has the same fields now table1 stores only the last data of the corrosponding symbol but table2 goeson adding the data as it comes in now i want to write a query get the difference of the …

When attempting to connect to my sql server through Vale Software's MSDE Manager, I get the error [SQL-DMO]Service Control Error: The RPC server is not available. I made sure all processes involving RPC were turned on, and I also turned on the DCom service process launcher as I read to …

In developing customized software for different development sites, I copied the mySQL database from original server to my development server using mysqldump to creat a copy, then mysqladmin to creat it to the development server. The web page I am testing is the same for both development sites, but an …

Hello, How can a timestamp field (int, 4) witch displays as hhmmss be converted that it looks like hh:mm:ss? Can anyone help?

Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL versios. TABLES IN MY DATABASE: Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, …

Hi, I'm attempting to set up dotnetnuke with Microsoft's SQL MSDE as my database. After getting SQL up and running, I created a database aptly named dotnetnuke, and a login called dnnuser. I set dnnuser's role on dotnetnuke to system administrator and it's role membership to db_owner. After altering the …

Hi, We have a accounting/inventory program that uses MS SQL as the database, with VB and Access for reporting. We want to make the database available online. ie.. Our clients can search the inventory and make orders from it. We do not want to install a local web server inhouse. …

Hi, Accidentally one the member has compressed the disk drives in the SQL Server. Before we go ahead an uncompress the disk drives, we need to make sure that the database is unaffected. 1. What is the normal database compression ratio when Hard Disk is compressed? 2. Do uncompression of …

Hello, Can anyone explain to me how I can create a function that I can use in SQL. Thanks

Is there a way to get the current value in the process of a select statement? Such as [CODE] SELECT pk_ID, columnN and be able to evaluate what pk_ID is at this point WHERE This = That [/CODE]

Hi, I hope I put this into the right category On my [url=http://www.national-real-estate-directory.com/real-estate-forum/] Real Estate Forum [/url] the vBulletin options are not working. Could someone tell me where to start troubleshooting. Thanks, Mike

Hi All I am facing problem is SQL Server 2000, with OPENXML. I am having data which i receive from some other database in form of xml doc. Now I have to use this xml data as JOIN with MS SQL 2000 database table. But as everybody aware that using …

I am ready to start using MSDE. When I run the setup for MSDE it tells me I need to set the password. I have read the "help" on the MS web site but it is still not clear to me how I setup the password or anything else so …

I am very new to mysql, so I apologize for such a basic question... How do I link my dbase to a website? What are the apporpriate query strings and steps? I am trying to create a website that would allow members to search for other members by name, city, …

Running Win2kpro with mysql server 4.1. I installed the service "mysqld-max-nt.exe", but it won't run. It's set for automatic, but even if I try to activate it manually, it won't. I checked the event viewer and it shows only this: "[size=1]The mysql41 service terminated unexpectedly"[/size] [size=1][size=2]Could there be a problem …

Hey guys, I am a beginner at MS Access and I was wondering if anyone knew of any good sites that hold good examples and methodologies using MS Access. Let me know. And is it better to learn MS Access before attempting SQL? Thanks.

So... what is better, SQL, MYSQL, MSQL, POSTRESQL, and etc for a fast database that must be used in conjunction with asp and php. For now, i'm looking for the easiest database to be used in conjunction with ASP. Any suggestions? [flash]http://www.geocities.com/cyberpitstop/footer.swf[/flash]

Hi Peeps, I am new to this forum, I am trying to create a weblog to allow users who are registered in a database I create in Access to create a blog entry which will be displayed on the screen to every one. I have created the database i Access …

I need to learn SQL to access MS Access what book is the best to get :?: