limiting database listings

Update: When I use Query Analyzer to connect, it seems to
work properly, so I believe this could be fixed from a
client standpoint.
Does anybody know of any options in Enterprise Manager
that would limit your database listings to only ones that
you own?
Or another option would even be, if anyone knows of any
Enterprise Manager replacements. Software/websites made
by other people which might not have this problem. Any
input would be much appreciated. thanks!
-ariel
I feel your pain. However I spend most of my time in QA, not EM. The problem is due to the SQL-DMO library that EM is based on, because it loads all information for all databases, not just the names - thus usnig up your bandwidth. This will be "fixed" in
SQL Server 2005 ("Yukon"), in that the database access API will only load the database names, and not all other information, which will speeds things up many times.
Your best bet is to use QA. You can't filter your list. You might also want to consider using the new WebAdmin tool from Microsoft - this might speed things up for you (http://tinyurl.com/3cuzt).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Is there any way to remove my email address from the old posts? spam + virii like crazy

limiting database listings

Update: When I use Query Analyzer to connect, it seems to
work properly, so I believe this could be fixed from a
client standpoint.
Does anybody know of any options in Enterprise Manager
that would limit your database listings to only ones that
you own?
Or another option would even be, if anyone knows of any
Enterprise Manager replacements. Software/websites made
by other people which might not have this problem. Any
input would be much appreciated. thanks!
-arielI feel your pain. However I spend most of my time in QA, not EM. The problem
is due to the SQL-DMO library that EM is based on, because it loads all inf
ormation for all databases, not just the names - thus usnig up your bandwidt
h. This will be "fixed" in
SQL Server 2005 ("Yukon"), in that the database access API will only load th
e database names, and not all other information, which will speeds things up
many times.
Your best bet is to use QA. You can't filter your list. You might also want to consider
using the new WebAdmin tool from Microsoft - this might speed things up for you (http://tinyurl.com/3cuzt" target="_blank">
http://tinyurl.com/3cuzt).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Is there any way to remove my email address from the old posts? spam + viri
i like crazy

Limit on row size for reading fixed-width .txt?

Hi,
I have a customer who wants to send a fixed width file with 1400 characters per row.
Before I tell the 'OK', I was wondering if there is any limit to the length of rows when using a DTS .txt source.
Anyone know?
Thanks!You have a sql row limit of 8060

Why not bcp the data in?

Does the process have to be repeated?|||My "personal best" was a smidgeon over 20 Kb per row of text. 2000 ten digit integers with a space between them per row.

-PatP|||OK, so 1400 characters is pretty puny.

This will be a weekly feed that begins with an FTP'd file and ends only after updating all of that company's organization structure, employees, employee contacts, etc. and then emailing a summary of the results and any errors to our DBA. Currently we run a bunch of these as DTS as it is easy to have some tasks be custom to the specific customer and others be based on stock scripts.

We're not looking forward to moving to Yukon. I hear that you can't upgrade DTS.

Thanks for the info guys!|||That's not true about upgrading DTS. The problem is HOW you have to upgrade. You basically take the whole VBScript it produces and plop it in there to run. It will run, but you lose all the graphical interface. I'm hoping they've changed that. I haven't really spent time looking at IS since the early notes on it. Too busy looking at all the other kewl features.|||Sounds like this will not go off without some triage and repair, particularly in our more sophisticated, looping DTS where we enable and disable tasks based on the data.|||If you mean data driven tasks, oh boy will you be excited.

There are some features that just plain won't be portable (the VBA/Active X and UDL in particular), others will require significant "triage", but most features ought to be relatively portable. I won't take any bets until I see RC, because there are so many things that aren't "final" yet.

-PatP|||I agree that we won't know until we've started to move our own stuff over.

But I'm betting it will be seriously annoying!