Viewing 15 posts - 61 through 75 (of 90 total)
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. ...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2011 at 2:25 pm
Yea, I can use that. Except I'll probably convert it to feet. Thanx!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2011 at 12:13 pm
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2011 at 7:34 am
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?
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 15, 2011 at 6:30 am
found an interesting workaround for a query here...
but I want to do updates also.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 14, 2011 at 3:11 pm
how can you tell which service packs are installed for SQL Server? I can see the version, but can't find SP info.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 14, 2011 at 3:07 pm
Yes. sa is sysadmin on 2nd server with db owner and public membership for specified database.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 14, 2011 at 3:03 pm
Goin there now. Thanx Jeffrey!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 14, 2011 at 1:03 pm
this might be a stupid question, but I truly don't know. Can it be run while the DB is being used?
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 14, 2011 at 12:57 pm
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 14, 2011 at 12:35 pm
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]...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 13, 2011 at 11:08 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
March 3, 2011 at 12:54 pm
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
March 3, 2011 at 12:35 pm
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
March 3, 2011 at 8:11 am
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...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
January 18, 2011 at 11:01 am
Viewing 15 posts - 61 through 75 (of 90 total)