You might be able to modify this to just display the items (or scrip them):

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=25&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

Steve Jones

steve@dkranch.net

Do they appear in the Object Browser in Query analyzer? Sorry, but I'm reaching here. not sure of the problem. Have you refreshed your table list in EM?

Steve Jones

steve@dkranch.net

sp_dropserver

sp_addserver "name", local

Steve Jones

steve@dkranch.net

Using EM will in fact create a temp table and copy the data.

Steve Jones

steve@dkranch.net

Yes, just add two connections to the dTS package.

Steve Jones

steve@dkranch.net

Yes, even poorly written apps will benefit from the enhancements to the storage and query engines. If you have a poorly designed app with lots of embedded sql, the server...

The probklem is your last line. This is returning a value, not removing the last ,.

Is should read:

select @r = substring( ...

Steve Jones

steve@dkranch.net

http://www.sqlservercentral.com/columnists/sjones/tamestrings6.asp

Steve Jones

steve@dkranch.net

You would do well to script the database DDL and then ensure it conforms to Oracle standards. Not sure, but I doubt the DTS tools will generate Oracle compliant statements.

For...

Not that I know of. You can do a "save as".

Steve Jones

steve@dkranch.net

I concur with Andy. You probably want to avoid this. You are assuming you know more than the program for a particular statement, which may not be true for different...

You would need some column in your table that has a datetime field. Or join to a table that has some date time field. There is no marking in SQL...

Any solution is going to through a load somewhere. I assume this is a one time thing. I wouldn't worry about the source load. Personally, I'd rather move the entire...

If you set this to true, then every minute or so, a checkpoint occurs. The transaction log is then truncated.

Example:

0800 DB full backup

0805 write transaction 1

0806 Check point, log cleared...

Also, what is the IO structure and the Index structure. You many have too many indexes. If you rebuild the clustered index, then you will be moving all the data...