I created a new database instance, but I forgot to script out the
scheduled jobs before I wiped out the original database instance.  I
have attached the original msdb database as msdb_old onto the new
instance, but I need a script to pull out the require information

I have just built a crosstab query on Access & I am having trouble
translating it on to SQL Server 2000 or 2005. Browse thru the online help in
T-SQL Reference but no much help. Would you guys give a helping hand please?
MS-Access (2003)

I have an SSIS package which calls many other SSIS packages.  Each of
these was created with the import wizard in SSMS.  As a result, they
all have SourceConnectionOLEDB and DestinationConnectionOLEDB
connections listed under the Connection Manager in the package

I just started using SQL to create a report. I got the syntax working
but I have absolutely no idea of how to format data. Can anyone kindly
look at my code and help me? I thank you in advance.
Details:-

What ports do I need to open on the firewall in order to reach my ms-sql
server from the outside?
many thanks,
Raul Rego

In previous versions of SQL you could see the created date and time.
In SQL 2005 you only see the created date.  Is there a way to see the
created time in SQL 2005?

in SQL SERVER 2005 environmente how can I stop a restore?
Regards
Alberto

Recently our SQL Server 2005 has started showing a strange behavior.  
Whenever you do an ALTER PROCEDURE to make changes to a stored procedure it
can take 2 minutes or more to complete the operation.  Any suggestions?

I have SQL Server 2005 on a 2 node Cluster, the default port number has been
changed.  However SQL Server accepts connections thru the default port 1433
and the non-default port as well.  There are no aliases defined.  How do I
configure SQL Server to listen on the non-default ...

i have this sql strin that works fine in access and asp.net 2.0
i 'd like to pass to sql express but i get errors with the query.
the original Access query:
SELECT cAuxRk.CatB, cAuxRk.NombreCompleto, Sum(cAuxRk.PBh) AS Parc,

Hi - I have installed SQL Server Express (2005) on one PC and am
trying to access it from another using mgt studio.
I have tried to connect using windows authentication to no avail, but
that I can live with if I can get SQL Server authentication to work.

I hit problem which i can't explain so you could help me.
I try to fix existing application and run sql perf. monitor to get biggest
io offenders. So i get them into table and select them ordered by 'reads' in
desc order.

The first SELECT works but I want to filter it with a subquery.  NOw
instead  I have  a VIEW but it is really slow.  I want to try  a
subquery but I don't know how to relate the two queries. The 2nd query
I want as a subquery not a VIEW.   The relationship would be [car_mark

I have a table that looks like this:
ACCOUNT    ID    DATE
aaa        01/01/08
aaa        02/01/08

Does anybody know why searching for a string '@' with LIKE does not work
even when you use ESCAPE
Very strange......
Say the field has .....   I love my @*&!& friend