keep in mind SQLservers db diagram only shows the physical model !

Tools like Erwin, ... can support logical diagrams which will give your DA a good starting point on their...

As you have noticed, you need to "downgrade" your package to SSIS 2005 runtime level, if even possible (because of new features in SSIS2008).

How ?

IMO it is just better to...

That seem logical to me ...

You simply cannot kill your own sessions actual connection spid.

Questions:

- please provide @@version information

- Did you refresh your object explorer pane ?

- sp_who2 can provide...

If RowId is an incremental value it may be used.

I hope it is a column of datatype BIGint because chances are that will last for a very long time (if...

James Tech (12/8/2009)

---

Nabha - Thank you for your prompt response. Well the result is not what I want, I just need to get the last value of the columns Message...

MDAC will not be touched.

XML core components will be affected !

So you may be prompted for a reboot after you apply the service pack.

Once again, Books online covers all of this:

SQL Server 2005 Books Online (November 2008) topic "Stopping Services"

http://msdn.microsoft.com/en-us/library/ms189095%28SQL.90%29.aspx

another ref:

http://blog.sqlauthority.com/2007/09/09/sql-server-2005-start-stop-restart-sql-server-from-command-prompt/

Keep in mind there is no order in a set !

So you have to define "last" using some criteria !

Not having such criteria will cause "random" results, in many cases...

Gail provided you with the answer and good advise;

I just want to add this:

In many cases, if you have an open query panel, just highlight the keyword you are looking...

With these settings it is always interesting to see what happens

if you perform "set nocount on" before you create the udf ....

This is the sproc we are using.

It also takes care of alerts bound to a job !

This proc is always installed when we install an instance !

Basically what we...

Did you try this:

ALTER PROCEDURE [dbo].[myStoredProcedurel]

(

@StartDate AS DateTime = NULL

, @EndDate AS DateTime = NULL

)

AS

BEGIN

declare @refStartDate datetime

declare @refEndDate datetime

Set @refStartDate = isnull(@StartDate, dateadd(ms, -3, dateadd(mm, datediff(mm,...

you are using a windows domain account, right ?

- You'll have to define the alert "with log", because if a user raises the error using "with log" (s)he must be member of sysadmin :ermm:

- you may have to...

Atul DBA (11/24/2009)

---

I disagree with Stev. We can take the backup to other disk if they are accessible by SQL Server resource list.

This is highly possible in stand alone servers....