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