Read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Should work with no problems. That was the setup I used at a previous employer, desktop system was 32-bit and servers were 64-bit.

In addition, please take the time to read and following the instructions in the first article I have referenced below in my signature block regarding asking for help.

We really need...

dwain.c (11/14/2012)

---

P74 (11/14/2012)

---

hi dwain.

it didn't quite do the job for some records such as 'STI850-200 ' or '25-53492-22 ' where it drops the first digit...

very close to Lynn's results...

A good place to start is Books Online, the SQL Server help system.

SequelSurfer (11/13/2012)

---

Lynn Pettis (11/13/2012)

---

Then I have Eli Manning, who is underperforming the last few weeks, having a bye week and my backup QB gets a concussion and may not be...

Permissions issue with the directory that the trace file is being written?

So more like this then, right?

CREATE TABLE #Temp (Id int IDENTITY(1,1), PartNum varchar(25))

INSERT #Temp (PartNum) VALUES

('12345'),

('00123'),

('10000'),

('A1234'),

('12A34'),

('0A123'),

('000A1'),

('00D21'),

('00E33'),

('00000000000000000004560');

select

*,

case when patindex('%[^0-9]%', PartNum) = 0

...

I'm sorry, but

So what you really...

This article should help http://www.sqlservercentral.com/articles/T-SQL/67898/.

Basically, yes. As a DBA you have the keys to the kingdom. With no experience they most likely won't give them to you. The only way I...

Sounds like you are rebuilding indexes in your maintenance plan. Index rebuilds are a fully logged operation. Even if you switched to bulk logged recovery model the t-log...

Then I have Eli Manning, who is underperforming the last few weeks, having a bye week and my backup QB gets a concussion and may not be playing on Monday...

How about something like this?

CREATE TABLE #Temp (Id int IDENTITY(1,1), PartNum varchar(25))

INSERT #Temp (PartNum) VALUES

('12345'),

('00123'),

('10000'),

('A1234'),

('12A34'),

('0A123'),

('000A1'),

('00D21'),

('00E33'),

('00000000000000000004560');

--SELECT PartNum,

-- CASE

-- WHEN PATINDEX('%[0-9][0-9][0-9][0-9][0-9]%', PartNum) = 1 THEN...

SSC Steelers fell to the GoBolts and the WayoutWest Cowboys pulled off the win against the NFL Soldiers!

SQL Bolts stay one game behind Ditka in the Paper Division but still...