Also - More specific Certs like Cisco has are great for identifying specialties but it will also create a perceived need to have multiple certs. Plus the people doing the...

One aspect of the problem with certifications is the perception of these certs by CFO's and others that do the hiring of IT people. I personally beleive that the...

Thanks John that helps.

So sp_prepexec takes a command string as input, and generates an execution plan so that it can be quickly executed later??

I think for some reason SQL requires a different thought pattern than standard programming. Much of the reading I have done instructs you to think of SQL as just another...

Thanks,

I knew I was overlooking something simple.

Could you use a cursor to count rows?

From the MS Access find duplicates query wizard...

SELECT First(dbo.tablename.key_column) AS [DUPE_ID], Count(dbo.tablename.key_column) AS NumberOfDups

FROM dbo.table

GROUP BY dbo.tablename.key_column

HAVING (((Count(dbo.tablename.key_column))>1));

Found the problem:

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;296769

I added

SET ANSI_NULLS ON

GO

To the top of the CREATE PROCEDURE statement and all is well.

Thanks for your reply.

In QA I Ran This Successfully:

SELECT [DESCRIPTION]

FROM LINK_SERVER.VMFG.dbo.PART

WHERE ([ID] = 'CFR26141585')

However, when I try to put...

Not a solution but some input.

I have a low use SQL 2K install on 2003 Server std edition. have not seen your problem but have seen the SQL Service...

Should I run an update query on the sysindexes table to set the OrigFillFactor to 0? As I said above for some reason this is set as 25 in the...

The log file is only showing as 50MB. What is your take on the results of sp_spaceused null, true showing 1,963,280 KB as index space?

ran sp_spaceused null, true:

~ Old Normal Sized DB Results ~

database_name ...

I ran this:

sp_msforeachtable 'dbcc dbreindex(''?'')'

then:

DBCC SHRINKFILE (1)

Then:

DBCC SHRINKDATABASE (PLAY2,1)

The SHRINKDATABASE command only took 1 second to complete.(?)

In Enterprise Manager I see:

Data Fles Tab shows 4603MB Space allocated

Transaction log 50MB Space...

SQL SERVER 2000 SP3a on Win2000 Server SP4

The DB has 1 datafile and I ran DBCC SHRINKFILE (1)

This only brings the datfile down to 4.8GB. It was at ~ 2GB...