i'm sure you've already checked , but can you run the query from your database and make sure you specify the schema name (but not the db)

ie select x,y,z from...

a couple of things here

1) remember to use the WITH statement for your...

derek.colley (6/8/2012)

---

Can you post the structure of the table and the view please.

Sounds like the view is doing an implicit conversion of the VARCHAR column to INT.

Please post structure of...

tbraithwaite (6/8/2012)

---

Hi, I wonder if anyone can explain the following:

I have a table that has a column [unique_name] defined as Varchar(64) and this contains ID numbers some of which have...

balasach82 (6/1/2012)

---

Mike,

We are using sp_OACreate, sp_OAGetErrorInfo, sp_OAMethod, sp_OAGetProperty, sp_OADestroy.

Error occurs only for some of the records which satisfies a particular condition and not for all records. Even though, we get...

i also had to count out loud the alphabet then decided ASCII('a') and ASCII('z') gave me the numbers i needed

looks like you could use a TVP (table value parameter)

it's bets not to pass delimeted strings in as parameters

try the following - (example code only)

CREATE TYPE xtype as TABLE(id int)

GO

create...

and how many connections are currently open on your server (perhaps your application is not closing connections properly - it's not unheard of!!!)

also - how much RAM on the box...

what is your max worker threads setting?

are you using SP_OA calls?

please can you post the code that generates the error...

that error is typically a COM/REGISTRY issue for an sp_oa call to a DLL

im guessing that the OP wants

Apples

bannanas

Chocolate

Coffee

turning into

A

Apples

B

Bannanas

C

Chocolate

Coffee

in SQL 6.5 you would use the command DBCC CHECKDB

something like this

with x (id,letter)

as

(

select 65 as id, CHAR(65) as letter

union all

select ID+1,CHAR(id+1) as letter from x

where ID<90

)

select letter as name from x

union all

select name from sysobjects

order...

are you doing full backups at any point in your maintenance plan - log shipping does not prevent you from running full (non-copy only) backups - it just re-starts your...

Jonathan AC Roberts (6/1/2012)

---

michael vessey (6/1/2012)

---

If you are supplying SQL Server have multiple vendors and using SPLA licenses the cost is not far off $1,000 per cpu per month for...