What's that??

Easy to say... but nobody will understand what you're saying .

Another solution... have you mailed you programmers to ask 'em who as using that dts (or which application)??

If they all reply :" I don't use it", then you might use...

I don't know in Sybase, but for sql server 2000, you don't have many options for a dynamic row count. You can go with a pourcentage like so :...

Thanx for the info Joe... but may I request that you delete your first post on this thread so that we regain a more conventionnal html design?

Thanx in advance.

Strike the 2nd query... this works :

Select TMain.name, dtIds.id, dtIds.Total from dbo.SysObjects TMain inner join

(Select T1.id, count(*) as Total from dbo.SysObjects T1 inner join dbo.SysObjects T2 on T2.id <=...

5000 ramdom records :

Select top 5000 from dbo.YourTable order by NewId() --any random generator that works in sybase

Every sixth record :

Select * from dbo.YourTable TMain inner join

(Select T1.id...

can you repost Joe?.. something went wrong.

Please do not cross post, we follow all the boards.

Finish the thread at this adress :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=187447

It's really rare that we have no other options than to use a loop with TSQL.

Good luck with this project.

I assume here that this is something important. I would then suggest that you run the trace, maybe to a file so that he can't access it (save it...

I agree, but here are the other options :

Create an audit table.

Create a stored procs that can enter the needed information to log.

Then in EVERY stored proc, call that...

You'll pretty have to fire up the profiler (saving the trace in a table). Then query that table as needed to find the last used object.

The login is for the server, not Query Analyser. Use the windows authentication mode. Or try the old sa login with a blank password.

Start / All programs / Sql Server / Query Analyser

You'll be prompted to login to a server.. select the server and enter login info as required. Then follow the...