Database

Can we add SQL Server 2000 backup to SQL Server 2005 Database?

10-Apr-07 20:45

Mark Anthony Sabado wrote:
Is it a good idea to have my Data Access Layer on Web Service?

Yes. It is a good idea to have a DAL in a webservice.

Mark Anthony Sabado wrote:
What I mean is, All communication of different tier with the underlying database must all be done using XML web sevices.

Well, if the other tiers of the application are over an internet connection then that's the safest way to go.

If the other tiers of the application are on the same LAN as the database then you are just adding in an extra layer of slowness. Unless the webservice adds something of value over calling to the database direct then don't use that in a LAN environment.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

pubududilena10-Apr-07 3:44

pubududilena

10-Apr-07 3:44

Hi All,

I have taken a backup from ABC Database which was stored in SQL Server 2000 server.

Now I need to restore the same backup to same DB which is in SQL Server 2005.

Can I do this operation successfully?

Thanks in advance.

Re: Can we add SQL Server 2000 backup to SQL Server 2005 Database?

Krish - KP10-Apr-07 20:45

Re: Can we add SQL Server 2000 backup to SQL Server 2005 Database?

10-Apr-07 20:45

YES.

it is possible to restore, backup of SQL Server 2000, in SQL Server 2005.

Regards
KP

Marek Grzenkowicz11-Apr-07 0:38

Marek Grzenkowicz

11-Apr-07 0:38

But it's worth remembering that you cannot go back - you cannot restore a SQL Server 2005 database backup on SQL Server 2000 server.

Re: Can we add SQL Server 2000 backup to SQL Server 2005 Database?

Krish - KP11-Apr-07 1:10

11-Apr-07 1:10

YES.

backword compatibility is possible. But the other is not

Regards
KP

music play

pratima19-Apr-07 22:46

pratima1

9-Apr-07 22:46

hi,
how to play music during the processes of downloading a document in webapplication.

p.sethi

Re: music play

_mubashir9-Apr-07 23:08

_mubashir

9-Apr-07 23:08

This is not the right forum to ask such a question.

Mubashir

Every job is a self portrait of the person who did it.

Re: music play

Colin Angus Mackay9-Apr-07 23:26

how to put date from 2nd table to 1st table.

9-Apr-07 23:26

You might want to try the ASP.NET forum[^]

Re: music play

Paddy Boyd10-Apr-07 5:38

Paddy Boyd

10-Apr-07 5:38

You might also want to consider how annoying that could become and the fact that you're taking up valuable bandwidth streaming the music along with whatever you're downloading...

I for one would just quit the download and leave.

honda15i9-Apr-07 22:21

honda15i

9-Apr-07 22:21

I'm new in mssql. I was trying various ways, but no luck.
I have two tables "jobs" and "measures".

JOBS fields are:

[U]JOBID JOBNAME MEASURE[/U]
1 programming 11
2 corbel 22

MEASURES fields:
[U]ID MEASURE[/U]
11 hours
22 lb

[U]The result should be:[/U]
1 programming hours
2 corbel lb

Regards Arthur S.

Re: how to put date from 2nd table to 1st table.

_mubashir9-Apr-07 22:46

_mubashir

9-Apr-07 22:46

Hi,
try the following

Select jobs.JOBID, JOBS.JOBNAME, MEASURES.MEASURE
from JOBS, MEASURES
WHERE JOBS.MEASURE = MEASURES.ID

Mubashir

Every job is a self portrait of the person who did it.

Re: how to put date from 2nd table to 1st table.

Krish - KP10-Apr-07 2:11

10-Apr-07 2:11

SELECT j.jobid, j.jobname, m.measure
FROM Jobs j
INNER JOIN Measures m ON j.measure = m.id

Regards
KP

Error!

nclauder9-Apr-07 21:27

nclauder

9-Apr-07 21:27

Hi,
Im inserting into one column image at the same time text. but when I insert data I get this error:
Specified argument was out of the range of valid values. Parameter name: Images/laughing.gif
Why is it so?
Thanks

Re: Error!

_mubashir9-Apr-07 23:10

_mubashir

9-Apr-07 23:10

nclauder wrote:
Im inserting into one column image at the same time text

Where r u inserting the this data?

Mubashir

Every job is a self portrait of the person who did it.

Re: Error!

nclauder10-Apr-07 1:06

nclauder

10-Apr-07 1:06

In sqlserver database.
Thanks

retrieve auto number ID

playout9-Apr-07 19:56

playout

9-Apr-07 19:56

Hi,

I am inserting a new record to a SQL 2005 database table(tClients). I have a Primary Key called iClientID in that I use to bind clients, that is Auto Number.

I want to retrieve the iClientID once I inserted the record, as part of my stored procedure. Here is my insert statement.

<br />
<br />
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)<br />
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)<br />
<br />

Colin Angus Mackay9-Apr-07 20:25

9-Apr-07 20:25

DECLARE @Id INT
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)
SELECT @Id = SCOPE_IDENTITY();

playout9-Apr-07 20:58

playout

9-Apr-07 20:58

Thanks Colin,

I just have one more question... What is SCOPE_IDENTITY()?

Colin Angus Mackay9-Apr-07 21:03

9-Apr-07 21:03

playout wrote:
I just have one more question... What is SCOPE_IDENTITY()?

What you asked for. The ID of the most recently inserted row (in this scope).

Krish - KP9-Apr-07 21:14

9-Apr-07 21:14

SCOPE_IDENTITY
Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is a module -- a stored procedure, trigger, function, or batch.

Regards
KP