Hi Antares686,

quote:

---

Actually the part about wrapping in a dynamic string is not correct. I just tried your example code from the beginning...

Hi amelvin,

quote:

---

Perhaps the site owners could make a feature of favourite books, when I'm buying from Amazon (or almost anywhere online) I...

Hi winash,

only thing I can think of is SET ANSI_WARNINGS ON/OFF, but that's something different.

I'm pretty sure, I haven't changed settings since I have installed QA.

Cheers,

Frank

Hi winash,

quote:

---

Hi Frank,

The table will be created without any problem...

if created using QA then a message saying "The total row size (14061)...

Hi David,

quote:

---

We Brits have this thing called Snakebite (Lager and Cider mixed). Its magic, it makes all members of the opposite...

Hi winash,

quote:

---

CREATE TABLE [KeyResultAreas] (

[UserID] [int] NOT NULL ,

[AppraisalID] [varchar] (15) NOT NULL ,

[KRAType] [int] NOT NULL ,

[Weightage] [smallint] NULL ,

[KRADesc] [varchar]...

Hi richiey,

maybe this thread will help you

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12271&FORUM_ID=23&CAT_ID=2&Topic_Title=date+problem+with+SQL+2000&Forum_Title=General

Might be the link is splitted

Cheers,

Frank

Hi Brian,

thanks for correcting me!

With out of the box installation the normal user has at least enough rights to crash his box ultimately

What I take from...

Sorry,

if you are about to retrieve image (binary) data you should replace varchar(8000) with varbinary(8000). This should work.

Cheers,

Frank

Hi matt1,

quote:

---

is some of that german?

---

err, yes. The field names are a mixture of german...

Hi Greg,

quote:

---

Every now and then a developer will give me a script to create a table that produces the following error:

Warning: The...

Hi Patrick,

quote:

---

Yes, if the drink is green that's probably not good for me. Good advice.

I drink a single malt, but in France...

Hi Guarddata,

quote:

---

Finding the tables is easy

select sc.name 'Column', so.name 'table'

from syscolumns sc

inner join sysobjects so on so.id = sc.id

...

Hi mimorr,

what a great work, and how simple. Finally this has been solved. I've also asked this question on a list where a couple of SQL Server MVP hang around...

Hi global,

first, the SQL Server equivalent to Access OLE datatype is the image datatype. All you need is some knowledge with the ADO StreamObject. there are plenty of threads about...