This is more of a fyi than a question. After restoring a live db backup to our development server there was an identically named login Melb02 on both the db server and in the restored db backup. However if you log in as Melb02 on the server you cannot access any objects owned by Melb02 on the...more >>

Hi All, I want declare an array of int in SQL Server please help me to convert the following code from VB to TSQL ------------ Dim md_mon(12) As Integer md_mon(1) = 31 ------------- Thanks...more >>

Hi, I am using MS SQL Server 7.0 SP2 in Windows 2000 server SP4. I have one-to-many tables (TABLE_HEAD and TABLE_DETAILS)which I am going to update by using a stored procedure with UPDATE statements. But somehow ,ONCE IN A WHILE, when executing the stored procedure with about 1000 ...more >>

Hi, I want to schedule a backup of three databases on a daily basis. I've written the code to run the 3 backups in TSQL and was wondering how best to automate this procedure? Should I put the code in an sproc and then schedule running that command in the DTS or should I just add the TSQ...more >>

Tried googling, but I guess I have the wrong terminology for MS products. Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one machine to another, I'd do a "dump" with a single command, such as: mysqldump [databasename] > [path/filename] Then I'd take the file generated an...more >>

Hello, I am reverse engineering database requirements for systems at work. One of the way of identifying old or obselete data is to find out when was the last time the data was updated/inserted into the field. Would it be possible to run a query to get last time the data was altered or modi...more >>

I would like to add an Identity to an existing column in a table using a stored procedure then add records to the table and then remove the identity after the records have been added or something similar. here is a rough idea of what the stored procedure should do. (I do not know the syntax to...more >>

INSERT INTO Comments_tbl (FullName_tsf, Email_tsf, NTuser_tsf, name_tsf, type_tsf, comments_tsf) VALUES ('Test Tester' , 'tester@test.com', 'ttest', 'test', 'help', 'need better help') I am trying to use the following sql to insert from a script but there is a primary key column - 'com_no' - o...more >>

Hi, I try to connect to MSDE using software writing in C#. When I test this software in Win XP it works properly but when I try on Win 98 it crash. Situation: 1. Win XP, MSDE, connecting to local server and to server on Win 98 machine (works), this server hasn't instance name set (default),...more >>

I understand that there is much involved in figuring up I/O throughput, but I'm hoping the answer to the following question will be a simple A, B OR C. Given the configuration below, what hardware component would bottleneck first. A. Drive Spindle Throughput B. SCSI Controller C. Other Comp...more >>

Can someone please help me interpret this result set below and suggest on way I can speed up my table? What changes should I make? DBCC SHOWCONTIG scanning 'tblListing' table... Table: 'tblListing' (1092914965); index ID: 1, database ID: 13 TABLE level scan performed. - Pages Scanned............more >>

I have a feeling I'm missing something obvious here, but being new to SQL Server is my only excuse! I have a table that holds a variety of data. I am writing a user report where the user wants to be able to return all data that falls between a start and end date that they enter. The query ...more >>

I have a HUGE project (at least for me) and need some guidance. I am trying to create a database for a local university movie club that allows users to input there basic personal information (name, address, telephone number) as well as movies in there collection. The movies will be categorize...more >>

I have a query that returns multiple identical records, however it should only return one. Indeed there is only one record for the OrderActionTypecode of 'P' yet there are two orderactions so it returnd both. Oddly the second query returns only the desired single record but wihtout all the ad...more >>

Hello, This is the new DB comunity for spanish speakers. www.hispabd.com . Regards!!! ...more >>

Can anyone help! I need to create database for a university. I was looking for some kind of example from the net but haven't had much luck at finding one yet. Can anyone help, please....more >>

Hello, I am trying to construct a query across 5 tables but primarily 3 tables. Plan, Provider, ProviderLocation are the three primary tables the other tables are lookup tables for values the other tables. PlanID is the primary in Plan and Plan Provider ProviderLocation Lookups --------...more >>

Hi there, I currently manage 3 SQL Server Database ... one of which is on a web server. I need to backup these databases and am not sure the best way of doing this. Can someone please point me in the right direction of backing up and also restoring M3ckon *** Sent via Devdex http://...more >>

Hello all, I am a total newbie to SQL. I created this sp and then with C++, called it. My return value was 100 (which it was) CREATE PROCEDURE sp_StoreIPs @IPSource varchar(16), @IPTarget varchar(16), @TimeDate varchar(20), @Name varchar(250) as declare @iReturn in...more >>

Hi All, I need to write one complicated update statement and I'm looking at maybe finding a simpler way to do it. I have 2 tables: 1.Photo Table PhotoID FileName 1 111.jpg 1 111_01.jpg 2 222.jpg 2 222_01.jpg 2 222_02.jpg 3 333.jpg 2.Ph...more >>

Hello Sir/Madam, I need some help from you.I am working as an RA in a real-time project,on itegration of Emergency medical services with wireless technolgies, which involves work on databases. 1)I have a problem now, where I need to write a desktop application which will syncronise 2 databases....more >>

I am a beginer in SQL Server and if someone knows I would like to know where are stored columns description - am refering at that column description that can be write for each column when you create a table in a SQL Server Database using SQL Server Enterprise Manager. I want to get this informat...more >>

Hi We have a SQL server on Win2k. the physical size of the db is about 40G and the main table has approx 65m rows in it. At the moment the entire database is on one data file. The entire server including the OS is on a RAID 0 array with one RAID controller. My question is would I get any...more >>

Greetings All, I would be much obliged if anyone can point me to a good book on Java/JDBC and SQL Server. Regards, Louis....more >>

Howdy, I need to write an update query with multiple aggregate functions. Here is an example: UPDATE t SET t.a = ( select avg(f.q) from dbo.foo f where f.p = t.y ), t.b = ( select sum(f.q) from dbo.foo f where f.p = t.y ) FROM dbo.test t Basically I need to get some aggregate stat...more >>

HI there, I currently store the date using the getdate() function but how can I store just the time or seperate the time off from a datetime datatype? M3ckon *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi there, I'm trying to come up with a definitive list of ACcess data types that cause a problem when upsizing to SQL Server. On the last occasion that I upsizzed, SQL Server had an issue with smallDatetime and with Autonumbers. I changed the smalldatetime to be datetime in access and tha...more >>

Hi all We have some tables with a couple of layers of very simple views built on top. In the table are maybe 6 columns and about 15000 records. The first view cobines the data in the table with some other data from a lookup table. The second view does some sorting on the first view using cert...more >>

Hi, I have a stored procedure (below) which looks for records matching 4 values. The problem is that sometimes the @degreesubject, @degreegrade and @alevel values may be 0 in which case I do not want the select query to try and match them. Can anyone explain the simplest way to write t...more >>

Hello, Does anyone know of a way to schedule the archiving of analysis databases? Seems pretty lame if you can't... The only answer I've gotten is "maybe in Yukon".... Thanks. *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Why is it, Microsoft manage to write operating systems and office applications with every bell and whistle facility known to man. Yet, even after years and years of development they still cannot produce a decent version of MS SQL Server, one without a plethora of flaws and limitations? Persona...more >>

Hi I using Java and JDBC to connect to MS SQL server 2000 (using the MS drivers msbase,msutil and mssqlserver.jars). Sometimes it takes a long time for statement.executeQuery to return and start returning the resultset (full DB scan can take 30-40 minutes). Does anyone know if it's possi...more >>

Hi, I'm a web developer/dba and have an interview comming up soon For preperation I want to recap over some topics and was looking for good links on the web about them: The skillset of the job is: SQL server 2000/asp I'm specifically after: Normalization Upsizing from access to sq...more >>

Hi, The following parameter query SQL statement on a sql analyzer gives the error message given below. Select * from contact where cus_cust_no = ? [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error Thanks *** Sent via Devdex http://www.devdex.com *...more >>

Does anyone know of any shareware tools available to allow isql/bcp-like access to sql server 2000 from Sun Solaris ?...more >>

Hello Gurus, i have a very strange problem that is killing me.. I have a stored procedure that e-mails, that stored procedure is called from diffrent table triggers.. on table a the trigers fires and e-mail.. everything is ok.. on table b the triger fires and e-mail is sent however in IIS...more >>

Good Morning, I have a question. Is there a function like ISNULL but for the space value(example ISSPACE)? THANKS ...more >>

All, Can someone help me with the following SQL and help me write it in an OPENQUERY format. I am running the following code from a SQL Server 7 box, trying to update a table in an Oracle Linked Server. The code runs fine, except it takes almost an hour to complete. I know if I run via OPENQ...more >>

I have an Access 2000 DB that I've been considering upsizing to SQL Server 2K. I'm wondering if anyone can share their experiences in upsizing and let me know of any tips or pratfalls. I've been playing around with the upsize wizard however not all of my tables have properly converted. None of...more >>

Hi ng. I have a varchar field in my table, called Name. I wanna do a selection, which is ordered by whether this field is empty or not. E.g. something like: SELECT UserID ORDER BY Name <> ''; - - - How can I accomplish this? TIA. Klaus. ...more >>

Does anyone know if there are any issues with restoring Master DB onto a server running Standard Edition from a server running Enterprise Edition of SQL Server?...more >>

hello i need to write an sql which calculates # of billing cycles for an order for which ive order start and end date. the first invoice will be cut on the order start date. Also if i apply a coupon for lets say one month (30 days) to that order i need to calculate how many billing cycles tha...more >>

I have a large table, tblMessage, which stores e-mail messages in text fields. I need to remove the carriage returns the data in these fields, but I have not yet figured out how to do so. I thought that the way to do this would be with the REPLACE function; unfortunately, of course, the ...more >>

If a full backup kicks off at 6pm within SQL Server, and takes 2 hours to complete, will transactions between 6pm and 8pm be included in the backup? Tks...more >>