This is a bug in Windows 2003 SP2. There's a hotfix for this.

http://support.microsoft.com/kb/932370/

After applying this hotfix you can query NumberofCores correctly.

Did you create a linked server named DEV ? you can do it in 2 ways.

1. using sp_Addlinkedserver procedure ( Look at the books online for detail )

2. from...

easiest way is to define the DEV server as a linked server. And using the four name convention

insert into PROD.DB.dbo.tablex

select * from DEV.DB.dbo.tablex

( DEV is the name of the...

I think finally DBAs will have to build a complete soulution for Archiving. nor Developers neither Analysts work on this problem..And we ( DBAs ) always force them to avoid...

just avoid using the quotes..

INSERT INTO #temp (member,medicaidID,dateOfService) VALUES ('Doe, Jane ', '012345678901', '5/21/2007 00:00:00')

this should work..