I'm am feeling very left out (and young) here.

Surly there are some younger people.

Cheers,

Crispin

Actually just worked out why.

I had the list of procs open and selected all, script.

Error.

Another guy could script them.

I dropped a proc and he then got the same error.

He had...

Frank, some times I work... 🙂

Brian:

What you are saying makes sense. I'll go read the KB article now.

However, why would you say move the SQL box back into the domain?

Assume...

hmmm, kids, married etc etc.

26 here and as single and carefree as they coime Hey! There's no Drunk face!

Cheers,

Crispin

Something as incredibly simple as

binary still gives...

I would use this site and google and use the money for friday night.

I bought a couple books (Because the company paid) and most are ok.

Problem...

Also have a look at Embarcadero Change Manager.

Prefer over red gate

Cheers,

Crispin

Here's a script by Chris Cubley which I have used a couple times.

http://www.sqlservercentral.com/scripts/contributions/395.asp

Cheers,

Crispin

Something as incredibly simple as

binary still gives you too many options

Not as far as I know. The easiest way would then be to declare a local variable in the proc and set it to be a newID and insert that...

Select ColName From TableName Where [IdentityColName] = @@Identity

ColName is the name of the column with the GUID and IdentityColName is your IdentityCOlumn.

Cheers,

Crispin

Something as incredibly simple as

binary still gives you...

I would be carefull storing blobs in 7.

Way back when we used 7 to store images, SQL would only run for a couple weeks then require a reboot. Not sure...

When exactly does the error occurr? On the convert?

What is the error?

Can you post the view?

Does your where clause look include the convert?

Where

Convert (Datetime, 'March...

What does your date look like? 10/10/2003?

If this is the case the SQL will fail depending on the date.

01/30/2003 might be converted and might not depending on the regional settings.

It...

Frank,

To change the loggin location Right click on the website > Properties > Enable Loggin > Properties > change the location at the bottom.

Assuming you using IIS5+ Can't remember...

quote:

---

Crispin, that's very naughty

---

What I do?

Frank, the easiest way would...

Frank,

If you don't have access to it and _really_ want to get the files, you could change the log path it be withint the site and read it via HTTP.

Cheers,

Crispin

Something...