Glen, have you tried the wrapper from Marek? I wanted to ask him some questions, but my MSDN profile is crapped up and it won't let me respond. ...

Yea, I can use that. Except I'll probably convert it to feet. Thanx!

Actually I meant both, but realized right after I posted that the example (test) was commented right there in the code. Sorry for being such a rookie, but your...

OK guys, on the SQL knowledge scale, I'm about 100 degrees latitude south of all of you. Can someone give me an example of how I would use this?

found an interesting workaround for a query here...

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/7b24b699-f8b9-48e8-ba78-b037fd3b1d21/

but I want to do updates also.

how can you tell which service packs are installed for SQL Server? I can see the version, but can't find SP info.

Yes. sa is sysadmin on 2nd server with db owner and public membership for specified database.

Goin there now. Thanx Jeffrey!

this might be a stupid question, but I truly don't know. Can it be run while the DB is being used?

Jeffrey I go t your msg about the time I was going to hit Post on this ....

I realized I had the remote server hilited when I opened and ran...

We use the function below, i.e. fProper(fieldname). Works great.

USE [SfiData]

GO

/****** Object: UserDefinedFunction [dbo].[fProper] Script Date: 04/13/2011 13:05:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[fProper]...

SSCrazy, I like the head-banging avatar. I need one of those and an automatic butt-kicking machine.

I saw this post and have been banging my head trying to set up...

Since I AM the team, and am not really a DBA, I took the least-invasive measure first, which was to set up a weekly defrag. I haven't seen the...

We've been consistently seeing Error 18056, Severity 20, state 29 about the "client" was unable to reuse the session being reset for connection pooling and it says to look for...

I figured the memory issue couldn't break anything . We've checked the RAID controller and saw no errors. Checked driver updates and they are all current. I'm...