The dbid Column in sysdatabases should help you.

The DBID's 1 - 4 are always used by the System DB's and the DBID for the 5th System Database

SystemResorce DB is always...

**********************************************************************************

Products Disqualified & Reason

Product ...

Well, I have not tried the same that you are looking at but, I suggest give it a try concatenating recursively to the same Text Column from by retrieving the...

Have you made enough search online for the steps?

I guess you should be getting plenty of them.

So you get multiple records from Oracle and you try to concatenate them into 1 single Value. 1st that right?

I don't know if you have done this or not,...

The value that you fetch from Oracle to Server2, is it a single record? or a record set?

You can Install 16 Instances of Express Edition on a Machine

As suggested by Steve, if preparing for exam / Intvw use a search engine you like.

Hi,

I tried to understand what you wanted to achieve, I guess you need to do this..

Create a Linked Server on Server1 with the security permissions that can execute SP's on...

Why are you thinking about writing code to create a Job?

You can actually use the SSMS to create a SQL Job.

Follow the link in Books OnLine about the steps...

How are you loging to SQL Server now? I guess you must be using SQL Login.

You cannot disable Windows Authentication completely but rather the workaround way is you Deny Login...

Break your Update into smaller slices by including some kind of condition that you are aware (may be by using a Date Column and putting between Clause)

And also use

BEGIN...

I ran the command to 10% limitation, do I need to re start sql server? I already see that file now is 32,000,000 MB.

I need to update 48 mil records,...

Before setting up Replication, you need to have the understanding of what you want to achieve by implementing replication, and it does not end there, there are different types...

Have you deployed the package in SQL Server or it is in File System?

Whatever it is currently, try changing to the other one.

It is possible if you could help us understand it !!!

Be clear in your question post with some sample script and also...