I have run into a couple of machines that will not register the SQL DMO for
SQL 2000. When attempting to register the following error occurs...
SQLDMO.DLL failed to register. HRESULT -2147024770
Any Ideas?

I am having a problem getting SQL DMO to install on a clients machine. Not
that it matters, but MSDE 7.0 is also present on the machine. I built the
install with visual studio 2005. Using the information from the "REDIST.TXT"
file. I placed the following files on the user's ...

Having a problem SELECTing from the system views in SQLCMD interactive mode.
All other functionality appears normal, but the following query does not
work in SQLCMD:
SELECT * FROM sys.tables;

Hi, I have created a SSIS package. The connection used in the SSIS is SQL
Authenticated. This runs perfectly when executed even after it is deployed.
However, I face problems when I want to execute this package as a job. The
error I get is - "Login failed for user - <user name>".

how to find the regestry key for the following :
* sql server authentication
* sql server authentication
* find the users list

We are using BCP ulility to insert the flat file data into the table.
Can we insert more than one record in the table for a single record in the
flat file?
E.g.

Hi ,
Iam working on an application which queries out all the T-SQL command from a
*.txt file to *.csv file .
OSQL -U usename -P password -i xxx/file1.txt  -o yyy/file.csv -n -dmaster

I think we have CASE statement in SQL server which is an equivalent of  a
decode statement in Oracle. Is this correct?
Do we have any other statement in SQL server that is an equivalent of a
decode statement in Oracle?

I need few clarifications. I am using bcp 9.0 tool to load the data into the
table in SQL Server 2005.
Can we do validations in bcp format file.
The validations like

I have a big project before me on bcp and i never worked before on .cmd files.
I am basically developing an interface sql server(server B)  between two sql
server(say server a and c) .
server 'b' extracts data from 'a' using bcp and the flatfiles so extracted

Hi
I'm sure somebody else has asked this same question, it's pretty basic
I develop an app using SQLServer, now I need to install the app in my boss
laptop to make a presentation.

In Template Explorer, I modified the Create Procedure (New Menu) template,
and when I open it, I see the modifications. However, when I create a new sp,
the original template (before I modified it) is used.
What am I missing here?

is there any way to see if a table was modified ? if was using an insert,
delete or update?
thanks.

Please I need help in removing older database backups using SSIS.
I do not want to remove these backups manually every day.
I have tried to use the tools supplied with SQL 2005 and as far as I can
tell they just don't work.

Hey Folks,
As above, any ideas how to DOWNGRADE -- from SQL Server 2005 db to 2000?
I'd appreciate any cool ideas. Thanks ahead