You have to provide sp_trace_setstatus 2 parameters. Parameter 1 is the traceid and parameter 2 is the status. So you need:

sp_trace_setstatus @traceid = traceid, @status = 0

to stop...

I actually encountered the problem in BIDS where my process would run but the SendMail task would fail. One way to test it on the SQL Server is to...

I don't know anything about Crystal Reports so as far as needing an ODBC connection, from the SQL Server side I don't think so. On the SQL Server you...

Here is something I think will work:

[font="Courier New"]CREATE TRIGGER dbo.trptAppointmentsINSERT

   ON  dbo.ptAppointments

   AFTER INSERT, UPDATE[/b]

AS

BEGIN

    SET NOCOUNT ON;

     IF UPDATE(resource) OR UPDATE(site)

        BEGIN

                UPDATE ptAppointments

                       SET resource = I.Resource +...

That book will get you the basics. Any of the Inside SQL Server 2005 books (4 in the series) are good. It really depends on what aspect of...

Here is something that works although it can be hard to read. You could also do it in steps. My example uses the AdventureWorks database:

[font="Courier New"]SELECT

   UnitPrice,

   /*...

Usually when this happens it is because remote connections are not enabled in Express, I know you said it was on, but are BOTH tcp AND named pipes enabled? ...

I had this issue on my personal PC because McAfee has a port blocking rule that blocked SMTP except from registered programs.

I think you want something like this:

[font="Courier New"]SELECT

   I.resource + ' ' + I.site

FROM  

   inserted I

[/font]

Inside your IF block.

I'm not sure what you are trying to capture for data but if you google sp_MSforeachdb you may find out you can use this undocumented system procedure to accomplish your...

N is used before character data literals to specify that it is a unicode string (nvarchar, nchar data types). SQL Server will normally do an implicit conversion of non-unicode...

We use Backup Exec for the server backup and native SQL Backups for the databases. I have not heard good things about the SQL Agent for Backup Exec.

Just based on the number of correlated subqueries in your code I would say yes there is a better and faster way. Probably the best way for someone to...

Sure it is still an issue in my query, but by using the join and doing the conversion on 1 side in the Derived table I reduce it to 1/2...

You might be...