http://www.microsoft.com/sql/solutions/migration/sybase/default.mspx

one of the raw methods that goes back to SQL 2000 is to use sysprocesses. You have the CPU and Dbid column, that you can track with hostname and loginame...

http://www.sqlservercentral.com/scripts/Miscellaneous/30830/

Excellent.. and adding to above:

Check Index Fragmentation:

REINDEX if Index Fragmentation are HIGH. based on the Values of Logical Scan Fragmentation in DBCC SHOWCONTIG OR

select db_name(database_id) as DatabaseName,object_name (object_id,database_id) as...

It Depends, and falls back to how flexiable your organization is in spending $$ and also depends if there are any unsed bays.

Adding to it: It shouldnt be RUN Frequently, I would recommend once a Week.

SQLNCLI.msi is available in the SQL Server\Setup BootStrap\ Folder. Try to Run that and see if this installs the required Providers.

Hurray.. to John and Michael.. Great Explanation.

I am Just curious to know.. how long does it take you to REBUILD your indexes on these BIG Tables.. and How often do...

use EncryptSensitiveWithUserKey as you Protectionlevel in your SSIS PAckage and also check the username pass in the provider in Dataset.

Also as andrew suggested use configuration file. this will ease things...

What do you mean by your first question. Pl clarify and regarding second Question, yes you can design Reports on ORACLE Database same way you do it for SQL Server.

you...

Can you go into the SQL Server folder (installation path) and check to see if you have the sqlwb.exe installed.

Do you want some like this:

exec master..xp_logininfo 'DomainGroupAccount','members'

This will list all the users in the domain Group, which is applied in the SQl Server.

After upgrading the Databases:

1. Change the Compatiility Level to 90

2. DBCC UPDATEUSAGE

3. DBCC CHECKDB (DatabaseName)

4. Copy all the logins associated with the Database OR ALL using this Scripts from...

Try this:

ALTER DATABASE DatabaseName SET DISABLE_BROKER;

select

*

from master..sysprocesses

Where loginame like 'MIKE%'

and HOSTNAME like 'your hostname'

only the columns that you can dig down for a Login are:

NT_USERNAME,LOGINAME AND HOSTNAME for yourHostName