this might help

http://www.sqlteam.com/item.asp?ItemID=11842

Politically and technically speaking, can you say "No, it is not possible" to the sales manager?

Thanks a lot Kelly!

Kevin,

I think everything is in the SQL Server server.

There is a user path and system path. It all depends on what user accounts are the SQL Server services (MSSQLServer and...

One of the nice things in EM  missing in the list is the diagramming feature. Within the diagram, you can design the tables and relationships. Or simply, it allows you...

I got this OK,  but the query does not make any sense at all...

Carl,

Good to know you took one of my suggestion. Maybe it has to do with memory allocation at the command prompt.  Good luck in your search. Maybe you can contact MS...

Carl,

you can also use the -p parameter to give you statistics.

If you find anything, let us know.

Thanks,

JA

More q: version of SQL Server and the OSQL parameters you use?

Not sure why there would be a big difference, but I suspect there is so much time spent in...

Can you post the script or a portion of it. I'd like to understand this as well, because I use OSQL a lot for batch processing.

Thanks..

I think the main reason is that the optimizer does not cache the execution plans for SQL  in sp_execute, where as SQL executed directly are cached.

the dtproperties table contains the diagrams. I believe you get the DT_ stored procedures once you create diagrams. The SP's are required to draw the diagrams.

I got this right. Can someone confirm that DCL stands for Data Control Language?

i logged this "feature" as a bug... Hopefully it will be fixed by SQL Server 2005.  It won't be fixed in SQLServer 2000. This went on undetected for a while...

Could it be a simple Refresh on Enterprise Manager?