Can you restore the master database, running on windows server 2000, sql server 2000 from a backup that was taken from c:\ to another server restoring to d:\? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

SqlServer2k is on the domain server SqlServer2k is on a laptop too I want to copy a database from the domain to the laptop over the network using the copy database wizard. I have done this before with no problem but this time I get the following error: Your SQL Server Service is running ...more >>

I have a .NET program that can connect to either an Access 97 database or an SQL Server 7 database. In the database I have two tables which have a field called ID. When I run a query like "SELECT A.*, B.* FROM A, B", the query returns those fields as "A.ID" and "B.ID" when connected to Access 9...more >>

How can I export data from SQL2000 to XML? Is there any tools with SQL for that? I don't want to use "for xml explicit"... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

hi!!! would appreciate if somebody could let me know the query/algoritham to sort the following values in the column either in asc or desc the values in the column originally 1 1-1/2 1-1/4 1/2 10 12 14 16 18 2 2-1/2 20 3 3/4 4 5 6 8 the sorted result should be as follow...more >>

I am trying to run 3 dynamic selects from stored proc, really only the table name is dynamic.. Anway I'm kinda lost on how I can accomplish this.. this is what I have but it only returns the first result.. that being basic CREATE PROCEDURE email_complexity @TableName VarChar(100) AS ...more >>

Hi , I have this query paprojnumber is varchar patx500 is text palineitemseq is int select Paprojnumber,Patx500,max(palineitemseq) from pa02101,pa01601 where pa02101.pabillnoteidx=pa01601.pabillnoteidx group by paprojnumber,patx500 it throws this error Server: Msg 306, Level 16, S...more >>

I am interested in installing both SQL Server 2005 Express and SQL Server 2005 b2 on the same machine. Can they both be installed on the same machine without conflicts? As in two different instances? John Dalberg...more >>

Hi all Please help me to find out table size in MS-SQL how can I count or identify, this specific table is using some xyz kb of space of my hdd. thanks...more >>

For a SQL statement in an Alias column I am am combing several columns. But I am having problems with one column as it is a smallint. I get this error Syntax error converting the nvarchar value to a column of data type smallint My Sql statement " Select Stilngcol1 + stringcol2 + intcol...more >>

Hello, is there any quite easy solution for the problem of transposing the rows into the columns? I have the following table with some data in it: dealer date 09.00 10.00 11.00 12.00 13.00 14.00 ----------------------------------------------------------------- 1 20...more >>

Hi All, Here is my question What might you configure on a SQL Server so that a Web server running on the same machine, with limited memory, will continue to perform optimally? Thank you Raju...more >>

What is the way we could implement a business logic from a Table by storing it statemnnets in a colums and defining an execute sql to execute it.Some legal requirements make it diffcult for us to create modify stored procdures so Iwant to have a process where we create new rows in a table and ex...more >>

I am working with a proprietary database that records the date, time, location, and speed of a vehicle. It is pulling this information from GPS unit tied to a vehicle. The table is populated with values that are pulled from the GPS unit every 30 seconds. I need to find the duration of time for w...more >>

Hi all, This should be easy, but it has me pulling my hair out. I have a SQL 7 server running on NT server 4 with all the patches and updates for both. I cannot seem to get the openrowset to run against an oracle server, try as I might to install the drivers from oracle. The first error I go...more >>

Here is a protion of the the DDL that created the table I wish to referece: CREATE TABLE [dbo].[tblPerson] ( [PersonID] [int] IDENTITY (1 ,1) NOT NULL CONSTRAINT PKPersonID PRIMARY KEY, .... .... Here is the line in my DDL that returns the error: CREATE TABLE [dbo].[tblAvailability] ...more >>

I have two tables: TestA and TestB. Both tables have 3 fields: ID, Name, and RunDate. I need to create a query which will join the two tables first on Name but then I need to match up the RunDates even though the RunDates won't be the same. CREATE TABLE TestA (ID INT IDENTITY, Name VARCHAR(2...more >>

Hello, I have an sql server 2000 on the network and one installed locally in my computer. I use access as front-end. I go through odbc to connect to the sql server on the network. I was wondering if it is possible to setup the access file to link to either server. I need to do this because I...more >>

I know the default data path on a SQL7 server is defined in the registry key SQLDataPath. I want to be able to determine the default data path in a VB.NET application on the local machine and remote machines. Is using the Registry Class the best way to do that or is there a SQL command that can ...more >>

Hi there. I need to fetch ONE random row from many. How can i get it? I try to execute "SELECT field.table FROM table ORDER by RAND()" no effect. Thank you....more >>

Hello, I'm having a difficult time finding the right sql syntax to perform an update. Here is the situation: I have two tables, each with an orderid field and a removal_date field. There is a one-to-many relationship between table A and table B, with B having multiple records to each one...more >>

Hello, I have a question regarding stored procedure desing that provides the optimal performance. Let's say we have a table Products that consists of three columns: Name, Status, RegistrationTime. All columns are indexed and users should be able to lookup data by any of the columns. We have...more >>

Is possible in SQLSERVER to use a syntax like this? select x,y from table_1 where (x,y) not in (select h,k from table_2) I've tried, but it doen't work. Do you know any workaround? Thank you Fede ...more >>

I'm a beginner in using SQLServer and I 'm trying to bring a db Schema written for DB2 into SQLServer. My problem is this: using a tool to translate the script for creating the DB, I obtain the following code: ALTER TABLE PROJECT.RSURETTA ADD FOREIGN KEY(VOCE ) REFERENCES PROJECT.RSANVOCE(VO...more >>

Is there any problem with implementating some kind of replication and backing up transaction logs at the same time? SQL Server 2000 Standard Edition The server is configured to back up log files regularly, with the presence of a(New) Disaster recovery server and with an inability for standb...more >>

I have MSSQL2k SP3a on WIN2k SP4. moved a Date/log files to this server about a week ago from a SQL7 server and attached it to this new Sql2k server. everything works fine for about 24hrs and then it starts timing out !! all I have to so is restart the MSSQL service and works fine again ...more >>

I have my SQL 7.0 server set for Mixed security. I see now (finally) the advantages of having windows authentication security for windows groups. I do most of my developing in Access Projects which require a login of some type. I have been using my SQL login to develop with SQL and then when ...more >>

hi, There is facility to do backup of the database. I can use that facility to backup the database. But before i do a backup i want to check if the disk space available enough to backup that database. I have a 22gb database mdf file, when i took a backup of that its only 3gb. SO i cannot use ...more >>

How to use a dsn-less connection from DTS? Source: MySQL Destination: SQL Server 7.0 I have the ADODB.connection code but unsure where and how to use it. Pls advise. TIA! Bob ...more >>

SELECT DISTINCT product.product_id AS Expr1 FROM [SELECT product.product_id, product.item_name, product.display, product.selling_price, product.smallpicture, product.main_size, product.main_dinnerware, dbo_coupon_special.coupon_id, dbo_coupon_special.special_price, coupon.effective_date, coupon...more >>

Hi all, Have a situation that my company has never run across before. Client is running NT4 for the domain server, using terminal services 2000 and running an application with a SQL Server backend and they are experiencing locking problems. Once one person gets locked out then everyone tryi...more >>

Hi all. I have a simple vbs script I use to connect to sql server, try and read from a table, and if it fails notify me that the sql server might be down. Works fine in its very simple way, but what I am wondering is if I should try and connect to one table from every specific database on the se...more >>

In the code below I get an Internal SQL Server error in Query Analyzer. Ultimately I want to get thos code working in a function. DECLARE @WeekNumber tinyint DECLARE @Comp decimal(18,2) DECLARE @PeriodFromDate datetime DECLARE @PeriodToDate datetime SET @WeekNumber = 27 SET @PeriodFromD...more >>

I am trying to run the following query: ALTER TABLE dnb_profile ALTER COLUMN [family update date] datetime and I keep getting the following error: Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime va...more >>

I have tried to set up log shipping for one of our databases - first time. Using EM I was able to create the job and maintenance plan sucessfully. I wasn't able to find any errors in any logs. In the monitor server, when I look at job history, everything is getting copied and loaded sucessfu...more >>

Hello, We have a SQL 2000 installation (running on NT4 SP6a) with a database accessed by a client application. Currently the application logs into the database using a the SA account. I'd like to move the client access over to Window Authentication. Each user has their own NT account. What ste...more >>

I have a strange performance question hopefully someone can clarify for me. I take a production database and make a copy of it, called test, on the same instance on the same server both running at the same time. All the same things are running for each database and no one is using each database ...more >>

hi pls tell the site's where i can download free e-books, bye, s.premkumar...more >>

Hello, I am having difficulty with global variables in DTS. Specifically I would like to instantiate a global variable with a value obtained from a SQL database. I have created the global variable through the package properties section. Now i need to instantiate it with a value from the d...more >>

I have an application that lets users upload pictures. These pictures are stored in different folders depending on the user ID (of the user that it belongs to). The path can be figured out dynamically by knowing the user ID. However, the programmer that's coding my application has decided to ...more >>

I'm getting ready to start a fairly large application to be hosted on SQL-Server. In the past I have used Access 2002 (as a front end, wasn't happy with the number of bugs I ran into), PowerBuilder 6.5, Oracle Forms 7 years ago (also no happy with the number of bugs). I was curious what the st...more >>

Version: SQL Server 7.0 App: MS Access 2000 I created DTS to move records from MySQL to SQL Server (approx over 500,000+ per months dataset) for purpose of canned and adhoc reporting. The app have a simple interface using MS Access where user will input the timeframe of the dataset they wil...more >>

Hello I have to tables ar and arb, ar holds articles and a swedish description, arb holds descriptions in other languages. I want to retreive all articles that match a criteria from ar and also display their corresponding entries in arb, but if there is NO entry in arb I still want it to sh...more >>

my analysis server is hosted on a win2k server with IIS, the hosting page is on another machine. I have followed everything as per MS KB article and I could not connect through the analysis server using http. i have similar implementation on my dev machine but the main difference is my OLAP is...more >>

Hey all, I have a basic table that looks something like this. CREATE TABLE MyTable ( ID INT IDENTITY PRIMARY KEY, Company_ID INT NOT NULL, Round VARCHAR(50) NOT NULL, Details VARCHAR(250) NOT NULL ) It has a few rows of data that look like this: Identity Company_ID Round ...more >>

If you use the command UPDATE <tablename> SET <fieldname> = ' ... ' to update a CHAR or TEXT field there are some characters that can cause problems such as a single quote. Are there any other type of charaters like that? TIA ...more >>

This might not be possible, but on the chance that it can - is there a way to do the following: Given a arbitray one dimesional value list: ('AALGX','12345','XXXXX','AAINX','AMMXX') Is there a way that I could do a select statement, or similiar, in the value list, to get the following resul...more >>

What am I doing wrong in the following snippet of code? ----------------------------------- declare @FullPath varchar(255) set @FullPath = 'C:\MyDir\MyFile.txt' bulk insert Northwind.dbo.Sometable from @FullPath with (FIELDTERMINATOR = ',') ----------------------------------- This w...more >>

I have a user defined function that may be called multiple times in the same query - here's a rough example select col1, get_random_number(), col2, col3, get_random_number() from table1 The problem I am having is that I need to have both calls to the user defined function return the same va...more >>

Hello all, I just started a new job this week and they complain about the length of time it takes to load data into their data warehouse, which they do once a month. From what I can gather, they rebuild the indexes before the insert with an 80% Fillfactor, then insert the data (with the in...more >>