Where did you buy it from? I am sure you can download it and use the license keys you received in the mail. It should work. I am just unsure...

Can you elaborate a little bit more on your problem so someone can help you?

Are you trying to take a backup of the jobs from Production live server?

It means you are not able to connect to Oracle from the SQL Server machine....

Is it really worth finding a solution for this? Seems like 4 lines of code that can be pasted in the stored proc once it has been reviewed. Sounds easy...

You are welcome.

Try this

declare @id int

set @id = 001

While @id <=100

begin

insert myTable(Activity_Codes)

select 'GL'+ Right('000' + convert(varchar, @id),3)

set @id=@id+1

end

Try this instead.

insert into table(value1,value2)

SELECT '123', id from table where section='section 1'

Like Gail has suggested, a Primary Key on Servername and AutoNumber would do the trick. I don't think a third column is needed. And you can set the Default Value...

Interesting article but the last couple of lines is the most interesting I thought.

The idea of getting better performance, just from slipping your database into RAM is intriguing, but I'm...

Please choose you comparison key carefully.

mohammed.arsalan (1/31/2010)

---

A bit puzzeled as to how SQL Data Compare compares the data in the tables does it scan through each data in revry cell...

Did you transaction replication? That will require the least amount of change.

Please read up Transaction Replication

You may want to check with the vendor to find out if this is considered...

Table name is case sensitive because of collation settings on the server or the database.

Here is a link with SQL Server 2008 Collation Settings. There are some links at...

You should select a column or a set of columns that you can use to compare the data in the two tables. Usually this column or a set of columns...

Since you are backing up to a DISK, NOUNLOAD and NOREWIND can be excluded.

Also, it looks like you have an extra comma (,) before SKIP.

Do you get the error when...

Administrator account on the windows machine may not necessarily give him all the privileges in SQL Server. Is the administrator account part of the sysadmin role?

In SMSS when you expand...