Im trying to get a list of Ssis Packages from Msdb
any help is appriciated
DAveL

I'm trying to "attach" the AdventureWorks db but get this error message ...
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request.

After a long and difficult struggle installing SQL 2008 Express I thought I
was FINALLY ready to learn SQL.  But when I try to install the
AdventureWorks sample db I get a message saying that I need Full-Text
Search.  In researching that problem I find that I need "SQL Express ...

Is there a setting to make smalldatetime or any date data type field
default to NULL?
Currently it is defaulting to 1/1/1900 anytime the record is updated
or inserted.  I can set the default to the current date, but really we

In the SQL below, there are two tables. One employee can have many
jobs. Each job has a priority number assigned to it so that the jobs
can be reordered by the boss. The query in the SQL below is a report
that shows a given employee and all of their jobs, in order of

We have an SQL Server 2000 instance that keeps writing to the logfiles
that is is starting up. (So I assume is was closing/shutting down also
before starting up.)
The interval between these entries vary irregularry.

I am trying to import data from excel sheet into my SQL server.
Actually i was trying out different ways of copying data from MySQL to
SQL Server. I exported data from MySQL to a excel and then tried
importing data from the excel sheet to SQL Server. But the import/

The following stored procedure is supposed to take a '|'-delimited string of
keywords and try a query with each keyword until there are no more keywords,
or a query returns one or more rows.
I haven't worked that much with SQL and I have no apparent way to debug this

I have an INT column and I'm using SUM() to report the total value for this
column. I'm not worried about the column overflowing, but I am worried about
the sum overflowing.
I searched the Web and found:

I have a large csv file to import into a SQL Server 2005 database as
an intermediate step to processing. The file has over 900 columns and
500,000 rows. The columns have different widths however it would be
fine to make them all varchar(255).

Dear Experts,
I would like to ask for your help in diagnosing intermittent
occurrences of the "invalid connection string". I have a variety of
client machines all of which use a connection string like the

Hey all -
I've been googling around trying to find some code that will process a tsql
query string (with *=, =*, = joins) into ansi sql using the
[left/inner/etc] JOIN y ON () format.

The results of this query all show the QFUP column as the same value for
each AgentName, which is incorrect. I know there is no join here, but I am
lost, can anyone help please?
SELECT      AgentName, COUNT(UniqueKey) AS Supplied,

In my SQL Server 2005 management console when I choose Windows
Authentication the user name and password entries are grayed out. It
puts in the domain and user name that I used to log on to my
workstation. I need to be able to use a different domain and user name

For clients accessing a MSSQL-Server I need to incorporate the installation
of the client connectivity only into my setup. I am not sure what´s the best
way to do this and would be glad for beeing enlighted.
TIA Bernd