Hi, What data format can MS SQL Server 2000 export?? Wing ...more >>

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...more >>

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...more >>

How do you use sqldmo object to execute system stored procedures? Any suggestions would be appreciated. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I need to just back one table and not all the data in the table. Is there a way to have SQL save the data return from a query to some text file that I can then use to build the table in another table on another server? I am SQL server 7 Thanks, S ...more >>

Hi everyone, I really appreciate if anyone could help me with this tricky problem that I'm having. I'm looking for a sample script to combine data in multiple rows into one row. I'm using sqlserver. This is how data is stored in the table. ID Color 111 Blue 111 Yellow 111 ...more >>

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 prod...more >>

Hi, What is the Log.LDF file used for? Can it be deleted? Thanks, Stef ...more >>

In my (admittedly brief) sojurn as an SQL programmer I've often admired "outer joins" in textbooks but never really understood their use. I've finally come across a problem that I think is served by an outer join. -- This table stores the answer to each test question CREATE TABLE TestResult...more >>

If I change the name of my computer/server will it change the name of my sql instance?...more >>

If I start the server in single user mode does it reset the sort order?...more >>

I developed a search stored proc that searches all or some of Procs, Views, Triggers and functions. Would anyone be interested to see it posted here? Do you have any suggestions about other places, websites forums ...., to share something I have developed? Thanks you for your response in ...more >>

Help please, Have a situation when converting from Oracle SP's to SQL SP's. The old oracle cursor was roughly as follows CURSOR cur_rsStock IS select * from (select StockRowId, CategoryId from STOCKDISPOSABLE where STOCKDEFID=numDefId ORDER BY STOCKROW...more >>

Hello: I'm a FoxPro developer setting up my first SQL Server (7.0) app. and I need to ask how to log on as SA? I guest this sounds stupid, but when I created the logons for the group, I set them up as "Windows Authentication" and now the logon happens automatically when I start Enterprise ...more >>

I recently discovered that some one (or application) updated all the rows in the database. Looks like a query was missing a where clause. It was probably one of the applications, but reviews of the code show that a where clauses is always used, or so it appears. Anyway, I set up a trigger to ...more >>

Hi guys!! I am trying to fill a cursor with the results of a Stored Procedured, but SQL give me an syntax error message , does any one can give me some help I am using SQL Server, this is the first lines of my code DECLARE FRates_Cursor CURSOR FOR exec GET_FJRs_Eng 'all' OPEN FRat...more >>

HAI , I 'VE BEEN IN SQL SERVER 7.0 WITH WINDOWS NT. FROM MY NODE I WENT TO ENTERPRISE MANAGER AND I WENT TO SQL-SERVER'S PROPERTY BY RIGHTCLICKING the registered server. I CHANGED THE MAX.. CONCURRENT CONNECTIONS TO 1 FROM THE DEFAULT (0).' It gave the warning msg. like " this settings may ...more >>

Hi all, I have installed MSDE on my computer but it's missing, as all you already know, a serious (well, osql IS TOO serious but not very newbie friendly) admin tool. I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with it but was wondering if there's something better ...more >>

Hi! I want to write a function or stored procedure such that it will use ADO2.6 or better so I can use the XMLhttpServer. When this function is invoked it will execute a URL and gather the html code and store it in the Db. So one thought would be how can I write a Stored Proc or function ...more >>

hello I am trying to do a procedure that : 1 - Take a table name, a field name and a value as parameter 2 - check if the fieldname=value in the tablename table 3 - returns 1 if so, 0 if not A - I tried : drop procedure checkmytable GO create procedure checkmytable @p_table nvarcha...more >>

HELLO, please help me, how to read txt file and then insert it to sql table. i have file like this name.txe <... 012301231923123902132003 23423i4u23490342342342343 ....> I have 4 column and want to fractionise this text '012301231923123902132003' and put in to table. Best reg...more >>

Hi, I have a simple SQL/Database question: If I have a table like this - {name, address} where name and address are the primary keys. What is the most efficient way to get a single row of addresses delimited by commas if I define the name in the WHERE clause? Thanks for your help...more >>

I'm requesting help for an account report. The desired result is a report that displays the total(money) for cost center's accounts based on account access of the user. Tables: FY_Orders - stores the orders for items purchasing. Column "fin" is the owner ID. CostCenters - Group of Accounts ...more >>

Hi, Just installed Norton Internet Security on an XP workstation that also has SQL Server on it. I now find that I cannot access SQL Server and multiple messages are being issued by NIS. When I switch off the Firewall & Intrusion Detection I can access SQL Server. Does anyone know how...more >>

I have two tables in my database called CartItems and OrderItems. I store all of a session's shopping cart items in the CartItems table using the sessionID as the identifier (called cartID in my DB). After an order is placed and is approved, I would like to copy all of the items in the CartItem...more >>

I have a table that has this as data aa, Aa and AA I would like to be able to sort on this row so I get aa aa Aa Aa AA AA or the reverse, how do i go about this? SELECT [Arow] FROM [aTable] ORDER BY [Arow] I get them returned in the order they were entered into...more >>

I am trying to export data from a SQLServer database into a text file using a stored procedure. I want to be able to read it and debug it easily; therefore, I want all the columns to indent nicely. This means I need to append trailing spaces to a text string (such as "Test1 ") or append leading...more >>

In relation to my last post, I have a question for the SQL-gurus. I need to update 70k records, and mark all those updated in a special column for further processing by another system. So, if the record was Key1, foo, foo, "" it needs to become Key1, fap, fap, "U" iff and only iff...more >>

I have a very strange database with a very strange problem. Consider 4 tables: Table1: ---------------- Table1ID INT PK Table2ID INT FK Table3ID INT FK OrderNo VARCHAR(50) Table2 ---------------- Table2ID INT PK Table4ID INT FK Table3 ---------------- Table3ID INT PK Table2ID...more >>

Dear All, Suppose in the program a record is added to a table whose primary key is a identity field. If I really want to get the lastest value for that field after the insertion, is it the best way to use IDENT_CURRENT() to obtain this value? Thanks for your kind attention ...more >>

Hi, I am an Oracle developer and new to SqlServer. Is there rollback segment in SqlServer? If there is, does it use only for the purpose of rollback or to maintain read consistency as well? If there is no rbs in SqlServer. How does it handle rollback and read consistency? Thanks! Sus...more >>

i want a good resourse for to learn replication in sql 2000 inoder to practical learn and implemetion replicat...more >>

how can i convert a file from kind btrieve to a sql server 2000 file and used that files in sql server 2000 thank you from your answer...more >>

How do I configure the SQL Server 2000 to keep a log of all attempts to log in regardless success or failure ? ...more >>

Hello, I'm trying to execute a file containing few SQL statements. CREATE VIEW test1 AS SELECT * FROM table1; CREATE VIEW test2 AS SELECT * FROM table2; The standard SQL way is to end a statement with semi-colon. But doing that,it doesn't work in SQL Server. After changing ";" to "GO", i...more >>

Hi, I want to take backup of database logfile periodically and automatically. What should i do then..... Thanks Hoque...more >>

Sorry about the huge post, but I think this is the amount of information necessary for someone to help me with a good answer. I'm writing a statistical analysis program in ASP.net and MSSQL7 that analyzes data that I've collected from my business's webpage and the hits it's collecting from the...more >>

Hi, This is what I want to do. For a data acquisition query, if condition A is met, set weight to 1, else if condition B is met, set weight to 2 etc. Is this possible? I thought about using CASE function but to no avail. Using the classical Northwind db as target db, and its employees ta...more >>

I want to create a database where the table names / column names / SP names are NOTcase sensitive but where the data in the tables is, so that I can build a unique index where 'test' and TEST' is accepted as different. I have tried Installing SQL with a Collation designator with the Case Sens...more >>

In this update, "courses" has the course number for each course and the number of corresponding credits; "courseenrollment" has the course number and id for students enrolled in that course; "students" has the student id and total credits for each student. UPDATE students SET credits = (SELEC...more >>

Can I change the value of a column's identity seed programmatically? If so, how? Thanks in advance. ...more >>

Hi Im a sql newbie , and have created two tables with a foreign key relationship. How do i insert into these tables. If i insert into the primary table will the foreign key field in the second table be automaticly updated by ms sql server ?...more >>