Microsoft SQL Server Forum

Okay, I've been working on this one goal for about 4 days and cannot get it. 1) I have created a combobox1 on form2. Combobox1 values are received from a table1. Now, when I click on a value in combobox1, I'd like for it to link to combobox2. And for combobox2, I'd like for it to only display the records that is relevant to the value of...

Do you know where the system tables for a database are stored ? On which file ?

I have a stored procedure that is used to call on other stored procedures and I want to post a record to a "logging" table that I have created after each called stored procedure is finished running. I thought I had the coding correct, but I keep getting the following error message: Server: Msg 128, Level 15, State 1, Line 1 The name...

i have a dts package that is going to run at night and pull data from 2 tables in an Oracle db and load it to 2 staging tables that my package creates in sql server 2000. i then execute a few sprocs to and columns, indexes, etc. after that all happens successfully i want to delete the two production tables and rename the staging tables to...

Hallo ! I have a Table with a column "ordernumber" ordernumber A12 A45 A77 A88

I have to setup some scheduled tasks to copy 3-4 tables from an SQL2000 database to DB2 v. 8.1. The job must run every night replacing all data. How can this be done - with standard utilities?? Please be exact - I'm new to this. Thank for any help.

Hi, I am currently working on migrating stored procedures from Oracle RDB to SQL Server. Oracle RDB provides options to use C Code in procedures. Hence CRC 16 implementation is directly used in RDB. But I believe this cannot be used in SQL Server. Should we implement CRC 16 in SQL Server or are there any known

Hello, I would like to know is it possible to disable drop database for sa or sysadmin. If saor sysadmin needs to drop the database , he/she may have to change status in one of the system tables (sysdatabases ?) and then only database can be dropped . This is to avoid dropping the database by mistake by sa. In books online under drop...

If I created a stored procedure such as aa_procedure, how the other user refer to this procedure ?

Hi, I am new to SQL. Please bear with me and allow me to ask a dumb question. I am debugging a stored procedure (written in Trans-SQL), and I found that the SQL analyzer that I use doesn't have a debugger. All I can do it is execute a block of code and see what is going on in an interaction seesion of the SQL analyzer. I would need to...

Is it possible to ALTER a temporary table in TSQL (SQL2000)? The following TSQL reports a syntax error at the ALTER TABLE line: DECLARE @Test TABLE( NOT NULL , NOT NULL ) ALTER TABLE @Test DROP COLUMN Col2

Hi, This is a generic question, but for arguement's sake, let's say, my environment is SQL Server 2000. It seems that setting quoted_identifier off is the best way to accomodate all sort of data input/update especially for data set that contains special characters like single quote as in O'Brien, other funky stuff like %^$*@#(!)....

I've posted this in the microsoft news group but just noticed the comp newsgroups. What's the difference anyways? This one is a tricky one so I'm interested in seeing what all you gurus have to say. I'm trying to put a resume into a database. There are only three reports (see below). I suspect that the best structure for a resume...

I'm looking for configuration advice for a SQL Server. I have the following hardware to work with: 1 Dell P4 2.66 GHz PC with 512 MB RAM and a 40GB IDE drive 2 Seagtate Barracuda 4.55GB SCSI drives (ST34572W) in an external bay 1 Adaptec 2940UW SCSI Controller Windows 2000 Advanced Server MSSQL 2000 Enterprise

Hi, Situation: Need a query to return number of ticket records by month of open in a log table where the ticket open record is older than 24 hours then the ticket pending or ticket closed record. Tickets can also only have a closed record with no open record. Sample data table: ticket_id date_log status_name status_id

Has anybody had any experience of this?? We have over 2000 stored procs to convert from Watcom SQL to SQL Server 2000. Any automated tools would be much appreciated!! Also any known issues.

Compaq P4, 512mb Ram, XPPro, Office 2002 Pro. 1. Before MS SQL 2000 Client install MS Access 2002 properly created a new database in MYDOCUMENTS which is redirected to h:\users\%username% via Active Directory. 2. Upon installing SQl client, MS Access becomes non-responsive for about 3 minutes when clicking "Create New databse" and trying...

I have a SQL server that is running out of log space. I have several NAS box availabe to with lots of space, is there any I can use maped drive to store the logs in. I am not too concrned with speed

Is it possible to install SQL 2000 desktop without installing a database server? I need to have the interface to access my database servers, but don't want the overhead of a server and the service on my laptop. Possible? Thanks Doug

Hello: I have an Access 2K form I built from a SQL Server 7.0 view. I want to lock certain fields in the database from users so they can see them on the views and forms, but NOT be able to edit them. I've looked in BOL, MS SQL Server web page and SQL Server 7.0 books and could not find how to do this. Any advise will be greatly...

I have two questions: (1)After I stopped SQLAgent, I couldn't start it up, even restart the server.Why? (2) I may need to reinstall the server, if I do, do I need to uninstall? or just override the current one? Thanks! Saiyou

I'm looking for a string function that is similar to the INSTR function in VB. I haven't seen anything in the help files that I can use. Does anyone have any suggestions? Here's what I'm trying to do: There is a field in a table that will look something like this - "XXXXXX - YY". I want to separate it on the dash and get two strings...

Bit of an obscure one here, so please bear with me. I have two copies of a database which should be identical. Both have a complex view which is identical. I can open the views and the data is as expected and match. I can query it in several ways as detailed below. The 5th version of the simple query below based on the second copy of the view...

Hi, Is there anyway with SQL to return just the portion to the left (or right) of the decimal place like FIX or INT in VB? Specifically, I am trying to return just the hh:mm of a datetime field. Thanks,

I have some columns of data in SQL server that are of NVARCHAR(420) format but they are dates. The dates are in DD/MM/YY format. I want to be able to convert them to our accounting system format which is YYYYMMDD. I know the format is strange but it will make things easier in the long run if all of the dates are the same when working between...