Hi Barry, must have been "last day of the week syndrome" 😉

Off course I should have posted the used DDL.

As stated in my previous post, i tried to play with...

As Gail already stated, you should implement this trigger to be able to cope with more than one row in the inserted and/or deleted internal objects !

e.g

--TEST IT -- TEST...

That's very promissing towards the near future (post exit goodwill)...

You've been there for 6months, so you know your role/part.

Ask him how is day looks like, what he does when he comes to the office,

- what are/were his main...

Jason Edward Rowland (1/12/2010)

---

There is another advantage to using this as opposed to SQL Agent. You can regulate the number of packages that execute concurrently by setting the max_queue_readers value.

The...

For sure this is a nice way of launching a package when you have no SQLAgent in your system ( express edtn )

But if you have SQLAgent in your instance,...

IMO for most of us, getting their first x64 is the upmost occasion to "finally" get a bigger server.

In many cases having 2 or 4 poc ( nowadays 4 to...

You have a circular reference !!!!

Table2 has a FK to Table3

AND

Table3 has a FK to Table2

- What's the point ??

- are the FK columns Nullable ?

Avoid circular references !

/* 1- create database d1;*/

create database d1;

/* 5- create new login login1. */

CREATE LOGIN [Login1] WITH PASSWORD=N'Login&', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

/* 2- create new user u1 */

USE [d1]

CREATE USER [u1] FOR...

Budi Hertanto (1/8/2010)

---

Hi,

I still got error using FOR LOGON TRIGGER, even I'd already using SQL SERVER 2005 SP3. Do I need configure something else?

The value of @@VERSION show:

Microsoft SQL Server...

IMO, sampling the proc cache on a daily basis is a way to long interval.

It is indeed a good way with minimal impact and no modification of existing stuff.

FWIW I...

Don't shoot me if it doesn't perform as expected.

You could add a persisted derived column and partition on the combination of the flagprocessed and the stringconverted datetime combined..

Keep min mind...

another nifty thing we've been provided with :

declare @TestD varchar(12);

set @TestD = '1e1'

declare @testINT integer

begin try

set @testINT = convert(float,@TestD)

Print '[' +...

the query will provide the same results. partitioned or not.

If you are refering to the sliding window technique, off course, you should first check it the partition only contains data...

is your app user connected to the correct database ???

(Always specify your wanted database at connect time, don't rely o "default database" behaviour)