Re: coping data in sql server express - Database Discussion Boards

Aaron VanWieren26-Jul-07 2:31

26-Jul-07 2:31

If you are using sql2005 you could also look at creating your stored procedure as a clr stored procedure, giving you an assembly and stored procedure. The advantage is that you can wrap the c#'s string capabilities into the stored procedure as well as other coding language capabilities. Also, you are able to recieve nulls and can debug the SProc at run time in vs2005.

Should take a look if this is an option.

My 2C worth.

_____________________________________________________________________

Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.

The Enlightenment Project (paraphrased comment)

Visit Me at GISDevCafe

Re: Stored Procedure Issue

Brendan Vogt26-Jul-07 3:09

Brendan Vogt

26-Jul-07 3:09

What would I need to search for??

Please check my new post under 1 on Colin's postings.

coping data in sql server express

Amjath Rahman25-Jul-07 22:55

Amjath Rahman

25-Jul-07 22:55

Hi All,

Im using Sql server Express 2005, in the client place.
i want to copy the database with all data and put it in my sql server express 2005 in office.
so plz help me how can i do this
how can i copy entire data from sql server express and put it in another sql server express

Thanks for ur valuable help

With Regards
Amjath

Re: coping data in sql server express

Blue_Boy25-Jul-07 23:12

Blue_Boy

25-Jul-07 23:12

copy mdf and ldf file from client place then attach database in your office

I Love SQL

Re: coping data in sql server express

Amjath Rahman25-Jul-07 23:24

Amjath Rahman

25-Jul-07 23:24

thanks for ur quick and valuable reply.
can u plz explain me how to do that.

sorry for disturbing u

With Regards
Amjath

Re: coping data in sql server express

Blue_Boy25-Jul-07 23:37

Blue_Boy

25-Jul-07 23:37

Just stop MSSQL Service then locate where are files copy them and restart again MSSQL Service

In your office open SQL Server Attach Database[^] by findinf file of MDF extension.

I Love SQL

Re: coping data in sql server express

Aaron VanWieren26-Jul-07 2:27

Aaron VanWieren

26-Jul-07 2:27

Actually detaching the database would be the first step. In ServerManager just right click on the database, click on tasks and then detach. I would first get the location from the properties of the ldf and mdf before detaching. Copy those files and move them to where you want, reattach on the database detached from and on your other database. The only other issue you might have is table ownership. Occasionally the mapping gets a little off and has to be justified.

Re: coping data in sql server express

Blue_Boy26-Jul-07 3:55

Blue_Boy

26-Jul-07 3:55

Why did you replied to me?! Sniff | :^)

I Love SQL

How to reset identity(ID) field

Mubashir Javaid25-Jul-07 22:09

Mubashir Javaid

25-Jul-07 22:09

I am using SQL server 2000.
I have added some records in table.
and then deleted.
Now I would like ID field to start count from 1 and onward.
what command will be used.

God Bless you.
Always do good to others

Re: How to reset identity(ID) field

Vasudevan Deepak Kumar25-Jul-07 22:15

Vasudevan Deepak Kumar

25-Jul-07 22:15

DBCC CHECKIDENT

Check out http://www.mssqlcity.com/FAQ/Devel/reset_identity_column.htm[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: How to reset identity(ID) field

Muhammad Qasim Pasta25-Jul-07 22:37

Muhammad Qasim Pasta

25-Jul-07 22:37

I agree... but what about the relationships and constraints ...

if I have a primary key of identity column .. then that statement will generate value that already exists in my table.... m I right?

Re: How to reset identity(ID) field

Blue_Boy25-Jul-07 22:16

Blue_Boy

25-Jul-07 22:16

dbcc checkident(tablename,reseed,1)

I Love SQL

asp horizontal data

calvinjb888825-Jul-07 21:31

calvinjb8888

25-Jul-07 21:31

Do any one know how to display data from the data base by extracting it out using the unique id of the database. I wan to display the whole row of information of that unique id.

calvin

Re: asp horizontal data

Vasudevan Deepak Kumar25-Jul-07 22:17

Vasudevan Deepak Kumar

25-Jul-07 22:17

Emphasizing through Multiple Duplicate Posts? Mad | :mad:

Check out your original post at http://www.codeproject.com/script/comments/forums.asp?msg=2151132&forumid=1725#xx2151132xx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: asp horizontal data

Pete O'Hanlon25-Jul-07 23:44

Pete O'Hanlon

25-Jul-07 23:44

Please don't repost things so quickly. It's not good practice and won't get your question answered any quicker. In fact, as you are finding out, people are more likely just to respond and tell you not to do this.

Deja View - the feeling that you've seen this post before.

asp horizontal data

calvinjb888825-Jul-07 21:31

calvinjb8888

25-Jul-07 21:31

Do any one know how to display data from the data base by extracting it out using the unique id of the database. I wan to display the whole row of information of that unique id.

calvin

calvin

Identity Field

Muhammad Qasim Pasta25-Jul-07 21:17

Muhammad Qasim Pasta

25-Jul-07 21:17

If we have an identity field wit data type of BigInt ... but at certain stage it will overflow ... then what will happen and how can prevent for such scenario?

Re: Identity Field

Krish - KP25-Jul-07 21:38

Krish - KP

25-Jul-07 21:38

use decimal data type
this allows max value i.e. 38 digits

Regards
KP

Re: Identity Field

Muhammad Qasim Pasta26-Jul-07 0:56

Muhammad Qasim Pasta

26-Jul-07 0:56

But at certain stage ... it could overflow too! then? for example.. in case of Amazon or any service like that...

Re: Identity Field

Krish - KP26-Jul-07 2:17

Krish - KP

26-Jul-07 2:17

every s/w has its own limitations.

in SQL Server 2000 decimal is the one which can be used max digits
pls check whether your number is more than 38 digits
or in how many yrs it is going to reach this limit.

or use a char/varchar data type which allowes you even more.

or else take a new table.

Regards
KP

Sql server Authentication Problem

nareshss25-Jul-07 20:28

nareshss

25-Jul-07 20:28

Hi ....

Iam new to dotnet and Sql server ...
I want to install sql server in my system ..
Ive 180 days trail version ...

its installed but i cant able to login ...
My System name is NARESH ...

It asking about system name , username and passwords ..
I gave "sa" , "sa" .
But it is showling like unable to login with NARESH ...

Plz help me ...
Ive .net framework 2.0 in my system ..

Thanks in advance

Naresh

Re: Sql server Authentication Problem

Krish - KP25-Jul-07 20:37

Krish - KP

25-Jul-07 20:37

not getting where the probelm.
however check this http://www.connectionstrings.com/[^] may help you

Regards
KP

Re: Sql server Authentication Problem

nareshss25-Jul-07 20:52

nareshss

25-Jul-07 20:52

hiiiiii...

k i think u didnt get it...
k my problem is not about the database connectivity ...

iam juz starting sql server ...
i wanna practice queries ...

So i installed Sql server studio 2005 management express edition ...
i installed in my PC ...

Its successfully installed ..
but wen am going to use sql server it is asking about username and password for sql server connection enabling ...

but i dont kw how to login ..

the window options r like this ...

Server Type : Database Engine
Sql Server Compact edition
Server Name : My system name
or browse

Authe mode : Windows
Sql Server

wen i click on Sql server

Login :
Pwd

Connect cancel ----- --------

plz help me
thanks in advance

naresh

Re: Sql server Authentication Problem

okkishore25-Jul-07 21:13

okkishore

25-Jul-07 21:13

give ur systemname as username and pwd as sa

Re: Sql server Authentication Problem

nareshss25-Jul-07 21:24

nareshss

25-Jul-07 21:24

no am not getting ....

same error .......

unable to connect

wat ive to do...

is there any compatible verson of sql server ......

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.