Grant Fritchey (11/9/2009)

---

Jeff Moden (11/8/2009)

---

Jack Corbett (11/7/2009)

---

Grant Fritchey (11/7/2009)

---

As far as the cool kids club, I snuck in the back door and I'm trying to be quiet lest anyone notice...

Just downloaded the SQL MVP Deep Dive book. Now for some light reading over the weekend.

Woot :w00t:

Try loading the date from the header into a variable and then add a data transformation task for a derived colum. The value in the derived column that you...

Another method is to setup a scheduled job to copy them to another location (commonly a central location for log files) that is firewalled, protected and on an encrypted file...

Those aren't server roles. Those roles are Database roles within the MSDB database. You will need to grant the user access in the msdb database and then add...

I typically do it from the file system and haven't tried to do that directly from the msdb store.

Jpotucek (11/6/2009)

---

Need to be able to display Polish special characters - z l s e z etc - I'm told that Proper display of such characters...

What are the results of the following queries?

DECLARE @db_id TINYINT

SELECT @db_id = DB_ID('northwind')

SELECT page_latch_wait_count, page_latch_wait_in_ms, page_io_latch_wait_count, page_io_latch_wait_in_ms

5.

FROM sys.dm_db_index_operational_stats (@db_id, null, NULL,...

is there any chance they are running this job even though it is disabled? Maybe some other job calls this job, or some code somewhere calls and executes this...

Luke L (11/6/2009)

---

Jeff's gonna be pissed...

Though I suppose if you get it to raise the temps enough...

chill, socialize, and fly home.

If you don't have the sln, create a new project. Once the project is created and open, right click packages from solution explorer, select add existing package. This...

Open the package from within BIDS.

It is safest to try to do it when opening the .sln file instead of the .dts file that was exported from SQL Server. ...

This is a common behavior for which the only solution, I have been able to get to work or seen posted on the net as a solution, is to use...

within a single script task you could use the if exists condition and then perform an insert if records exist from that table

if exists (select tableid from tablea)

begin

...

end

else

if exists...

Otherwise you...