Give this a read (using xp_cmdshell and CURL)

Getting Stuff Into SQL Server (his sample retrieved Bank of Canada exchange rate online as .csv and import into SQL)

http://www.simple-talk.com/community/blogs/philfactor/archive/2006/01/20/158.aspx

You probably have a NULL in the bname

select @booknames =coalesce(@booknames+',','')+COALESCE(b_name,'') from historical.books

I can think of 2 ways

1.Combine all 5 packages into 1 big package, with Control & Data Flow

and you do the validation between the flows

2. in SQL Agent, add a...

Could it be a security enhancement in Windows 2008? to lock everything down by default?

SQL 2008 (which intends to work with Windows 2008) has removed the Surface Area configuration

That's why...

Awesome, REVERT worked (and another new command learned)

Thanks, RBarry

EXECUTE AS USER = 'wglnapp'

EXEC Grant_Test_Proc -- fired the trigger

GO

REVERT;

DROP PROCEDURE Grant_Test_Proc -- success

GO

Thanks SSC and guys for the code, copy-and-paste worked

Did some testing code as well

No trigger

DISABLE TRIGGER Create_SP_Trigger ON DATABASE

GO

CREATE PROCEDURE Grant_Test_Proc

AS

PRINT 'should have triggered the trigger'

GO

EXECUTE AS USER = 'wglnapp'

EXEC...

Happy Halloween to everyone

Happy Birthday to myself 😀

That is what you want

Just "only" pick the client tools during the NEW stand-alone installation

great tips, thanks rbarryyoung

Freaky, I just posted this yesterday

http://sqlservernewbie.blogspot.com/2008/10/how-to-convert-date-from-seconds-to.html

Apparently Unix timestamp range only from 1970 Jan 1 to 2038-01-19 at 3:14:08 AM

I always just the run the SETUP.exe in the Root directory

Just mounted my ISO, there is a SETUP.exe in there

Then follow the on-screen wizard, go to the Installation tab, and...

Interesting, but you can get by with the JOIN

Tested on SQL 2008 AdventureWorks2008, should work on 2005 as well

USE AdventureWorks2008

SELECT * FROM Person.Person

WHERE FirstName IN ('Jean')

COLLATE Latin1_General_CS_AS -- Incorrect syntax...

My vote is SQL 2008 on Windows 2008

License costs probably around the same, but you get more from SQL2008 (not necessarily always faster though, judging from Brent's upgrade story[/url] at...

Books Online

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

Understanding Logical Scan Fragmentation and Extent Scan Fragmentation values.

Logical Scan Fragmentation and, to a lesser extent, Extent Scan Fragmentation values give the best indication of a table's fragmentation level....

depnumber=1 seems to limit the outputs

but I think the purpose was to only show UNIQUE tables (example below should only show BillOfMaterials and Product)

In AdventureWorks2008 (on SQL2008)

SELECT DISTINCT

o.id, o.name...