Have a look at:

http://msdn.microsoft.com/en-us/library/ms143393.aspx

- Also keep in mind that calling a sproc without providing the correct parameters (DATATYPE !) can cause bad performing queries as well ! (caused by implicit conversions !!)

-...

I hope this little test script will provide some insight on the timestamp data type.

/****** 🙂 best regards ALZDBA ******/

set nocount on

go

/*

@@DBTS returns the last-used timestamp value of the current...

We script all objects of all user databases at least once a week (including all DDL and grant scripts) using SQLSMO.

These scrips a safeguarded in parallel with the visual source...

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...