I have no idea what bii is, but you can use BCP, the BULK INSERT statement or SSIS to bulk import from files to tables.

In SSMS, expand the database, expand Storage, expand Full Text Catalogs, right-click a catalog and select "script catalog as". I can't find a way to script all full-text catalogs...

Please give us more information. What is the process? How do you know it's working properly? What does, "not able to get the data at sql prompt"...

Instead of building your own, you could use package configuration files to dynamically configure packages at runtime. Package configuration is a new feature of SSIS and can be...

The point was made in another recent thread that Management Studio (and Enterprise Manager in SQL 2000) is not a user tool but an administrative tool. If you want...

I'm not sure you can even directly upgrade any version of SQL 2000 that's lower than SP4. Anyway, you should also download and run SQL Server Upgrade Advisor -...

Look at the job's history to find what happened in step 2. You also could check the SQL Server log to see if anything was logged there.

What error is returned?

You can't hide objects in Enterprise Manager. If someone has access to the database, they get to see everything.

You can restrict what someone can do in a database by granting them permissions on objects or by assigning them to fixed database roles that already have certain permissions. ...

You mean delete the transaction log backup files, right? You DON'T want to delete the transaction logs themselves. Deleting the backup files will affect how far back in...

Janet,

Try using double quotes and no braces around the package name. This is the DTSRun command I use in all job steps that execute DTS packages:

DTSRun /S "(local)" /N...

So you know you can't use DDL triggers in SQL 2000. Check this thread:

http://www.sqlservercentral.com/Forums/Topic214602-5-1.aspx#bm214606.

Another option to consider is installing SQL 2005 as a named instance on the same server and doing a side-by-side migration from SQL 2000. We've done this on our...

Hi Richard,

Developers in my shop use the client tools (SQL Server Management Studio/Enterprise Manager, Query Analyzer) on their workstations to login to the dev SQL Server using Windows authentication. ...