You can, but direct calls to SQL Agent are a lot worse that direct calls to Service Broker. If you were going to go that route, you might as...

How long does it take before it shuts down...

The problem is that "CDT" in the middle. SQL Server does not have UTC data types (maybe in 2008?) and cannot do anything with a timezone. Are all...

You want to use either Service Broker or a work table that is then scanned by a polling process running in a separate context (probably a SQL Agent Job). ...

psangeetha (10/14/2008)

---

I tried below

This worked.

insert into test values (9999999999999999990) didnt work. So I guess the maximum value for numeric...

The thing is, Oracle does not really have binary integer datatypes the way that SQL does. I think that there may be something like PLS_INTEGER which is equivalent to...

Glad we could help.

Seth Delconte (10/14/2008)

---

How about using a distributed query to copy all the data after adding the 2000 server as a linked server? This is after using the Generate Scripts...

a2zwd:

Please post your actual code that is failing so that we can test it.

Thanks,

I do not think that that is right, Adam. Try executing the following:SET NOCOUNT ON

create table #temp(foo int)

Insert into #temp select 13

Declare @sql Nvarchar(max)

SET @sql = 'SELECT * FROM...

You can use TABLESAMPLE, like this:

SELECT *

FROM YourTable TABLESAMPLE (2.5 PERCENT)

However, BOL notes the following limitations of TABLESAMPLE:

You can use TABLESAMPLE to quickly return a sample from a large...

And just in...

Look at Gail's...

Not directly, no. The database storage format is definitely different, and there is no way for SQL 2000 to know how to read a SQL 2008 formatted DB.

However, assuming...

Glad it worked out for you. 🙂