Database

saanj12-Jun-09 3:16

saanj

12-Jun-09 3:16

You have to create a linked server first.

There is no foolish question, there is no final answer...

enipla12-Jun-09 3:41

12-Jun-09 3:41

Thanks. I guess there is a utility in Server Management Studio to do this?

Microsoft help (for what it's worth) mentioned that I should run sp_addlinked server. I suppose a System SP. It does not exist in this DB though.

enipla12-Jun-09 3:47

12-Jun-09 3:47

ohhh.

sp_addlinkedsever is an SQL command that is included in the stored procedure

Abhijit Jana12-Jun-09 3:53

Abhijit Jana

12-Jun-09 3:53

Here you go for Linked Server.
And
Walkthrough: Creating a Stored Procedure in Managed Code

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

enipla12-Jun-09 4:00

12-Jun-09 4:00

I'm going to need some time to digest this. Not sure if I'll do it in managed code or not.

Basically. I have 10 fields in a view that need to update multiple tables on another server. I'll probably schedule this to run nightly.

First things first. I'm going to see if I can link the servers, and list the tables.

Thanks to both of you. I suspect I will return with more questions.

Abhijit Jana12-Jun-09 4:15

Abhijit Jana

12-Jun-09 4:15

Ya go ahead and let us know if any issue. All The Best Thumbs Up | :thumbsup:

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

enipla12-Jun-09 5:11

12-Jun-09 5:11

Hmmmmm.....

Just for a test, I tried the code below. It does not through any errors, but it does not perform the update either.

Any ideas?

GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [test\me].[GIStoCRW]

AS
BEGIN

	SET NOCOUNT ON;

EXEC sp_addlinkedserver 
   @server = 'CRW',
   @provider_name = 'SQLNCLI',
   @datasrrc = 'TheServerName',
   @catalog = 'TheTablename'

EXEC sp_addlinkedsrvlogin CRW, FALSE, 'My Login’, NULL

update CRW.GEO_UDF set WATERDISTRICT = 'TEST' where SITE_APN = '123'

END
GO

Thanks

Jerry Hammond12-Jun-09 4:42

Jerry Hammond

12-Jun-09 4:42

Be sure to set delegation too. If you fail to do so you will run into problems.

From BOL:

SQL Server and Windows can be configured to enable a client connected to an instance of SQL Server to connect to another instance of SQL Server by forwarding the credentials of an authenticated Windows user. This arrangement is known as delegation. Under delegation, the instance of SQL Server to which a Windows user has connected by using Windows Authentication impersonates that user when communicating with another instance. Security account delegation is required for distributed queries when a self-mapping is used for a specific login against a specific linked server.

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

enipla12-Jun-09 6:38

Encryption of SQL Server Database 2005

12-Jun-09 6:38

Looks like I need to take a few steps backwards. I can’t even get a table in the local DB to update.
As I said, this is my first SP.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [domain\me].[TestUpdate]

AS
BEGIN

update gis.crw_gis_data set block = 'test' where id = '123'

END

GO

Shouldn’t the above code update the table? I’m connected as the DB owner.

Isaac Gordon11-Jun-09 23:45

11-Jun-09 23:45

Hi Experts
I want To Encrypt my whole Database With Single Command or Any Query in SQL Server 2005
is Their Any Way To Encrypt The Database
Thanku
Dinesh Sharma

Blue_Boy12-Jun-09 0:34

Blue_Boy

12-Jun-09 0:34

How do you mean "Encrypt my whole Database"?! Do you want to encrypt data inside tables?

By the way please type normal words, don't use CapsLock for every first letter of the word.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Isaac Gordon12-Jun-09 1:02

12-Jun-09 1:02

i want encrypt data inside the table of database .
actually i am create my database and software using C#.Net now i face the problem when my customer tell me that i want that the data inside the table of my database is encrypted no one can see it
thank u
Dinesh Sharma

Blue_Boy12-Jun-09 1:08

Blue_Boy

12-Jun-09 1:08

Take a look this google result,there are some good examples.[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Jerry Hammond12-Jun-09 4:32

Jerry Hammond

12-Jun-09 4:32

Sharma Dinesh Kumar wrote:
i want encrypt data inside the table of database .

This is very different from your original stated problem. Are you sure this is now correct, or do you want to encrypt only a column, or Store Proc?

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Isaac Gordon14-Jun-09 21:38

14-Jun-09 21:38

Yes

Storge Of Data in Database

Luc Pattyn12-Jun-09 3:07

Luc Pattyn

12-Jun-09 3:07

Hi,

encrypting the data will slow down all operations, especially search operations.

anyway, isn't username-and-password protection enough?

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

Isaac Gordon11-Jun-09 23:40

11-Jun-09 23:40

hi Experts
I am Creating A Application using C#.NET and SQL Server 2005.
In my Database their is a Table Having 9 Fields But in Out of 9 fields Their
is one Field where We Have To Store Large Text File Data like 2,3 or more page data
then Suggest Me Which Data type i am using To Store this Fields i have Also Search Record in this Large Field if i am Taking Text Then It Does Not Provide Me Search in text Data Type in SQL Server Express Version. I am also Find The Result with Fast Speed. and Record in My Table is 1 Lakes or more then Suggest Me How I can Handle This Suit ions.

Mycroft Holmes12-Jun-09 0:24

Mycroft Holmes

12-Jun-09 0:24

Kumar
I know that English is not your first language, it is so obvious it hurts, but you need to address the problem of communication, your post is VERY difficult to understand and painful to read.

I suggest you get someone more skilled in English to help you with your message construction because your current efforts are BLOODY IMPOSSIBLE TO UNDERSTAND.

Never underestimate the power of human stupidity
RAH

Niladri_Biswas24-Jun-09 21:11

Niladri_Biswas

24-Jun-09 21:11

Hi,

May be your mother tongue is English or you know English better than the

original poster.

Instead of conveying your pain to him in a different fashion, do you think you made a justification by abusing him when you are here to answer a technical question?
Smile | :)

Niladri Biswas

Mycroft Holmes24-Jun-09 23:16

Mycroft Holmes

24-Jun-09 23:16

Hmm I thought I was reasonably polite, I pointed out there was a communication issue and tried to convey the difficulty in reading his post. If the last statement was offensive, put it down to MY communication problem, there is nothing offensive about it where I come from (Oz);

Was I just supposed to ignore the poor bugger because I could not understand him.

Never underestimate the power of human stupidity
RAH

Aman Bhullar12-Jun-09 0:29

Aman Bhullar

12-Jun-09 0:29

try using nText data type.... Smile | :)

Regards
Aman Bhullar
www.arlivesupport.com[^]

Isaac Gordon14-Jun-09 21:41

14-Jun-09 21:41

is nText Provide Search in Database..