Lynn Pettis (7/23/2008)

---

Does anybody have some code to build a table of strings from 1 to 10 characters in length, with no trailing or leading spaces (embedded spaces are allowed)...

Yep, you are correct, Gus....

Well I don't have enough details to do anything exact, but assuming that they are only using 5 digits in that Varchar(12) field, then something like this ought to work:

Insert...

tosscrosby (7/23/2008)

---

Wasn't sure if I was clear enough...There are multiple references with the Jave code to a table that no longer exists and I'm wondering if there is a way...

Two things:

1) what is the error message

2) Please show us the whole listing of Proc

y.

keymoo (7/21/2008)

---

I am issuing a DELETE followed by an INSERT..SELECT statement within a transaction which affects over 1,000,000 rows at the publisher. I do not want to see any of...

Moving a table expression to a normal view should have no...

SSMS = SqlServer Management studio

EM = Enterprise Manager

GSquared (7/23/2008)

---

One thing that's always bothered me: I can't think of a good way to audit/block the truncate command. Won't fire an on-delete trigger, won't even record the data...

Actually, sys.dm_exec_query_stats and sys.dm_exec_cached_plans can essentially be reset by freeing the procedure cache (issue DBCC FREEPROCCACHE).

See this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1316979&SiteID=1

What account is it using? Can you logon to (1) in that account and connect to (3) yourself with SSMS or EM?

Ah, I see. My bad.

Great, glad it worked out fo ryou.

OK, great.

Did you try this query? It does exactly what you asked for: http://www.sqlservercentral.com/scripts/tables/62545/