Russ,
You did, of course, state why, but it did not click until you just reworded
it. Thank you! It makes perfect sense now.
(And yes, I had already changed to removing noise words from the search
string.)
~|
Order the Adobe
Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: 23 November 2010 22:07
To: cf-talk
Subject: Re: (ot) SQL Server Full-Text Search CONTAINS()
@ Russ-
Thanks for the reply. I've read that page so many times that it's all just
gibberish right now. My b
@ Russ-
Thanks for the reply. I've read that page so many times that it's all just
gibberish right now. My brain is mush. LOL
Suffice it to say, as you stated, when encountered in a FTS search string,
noise/stop words block any results from being delivered.
@ Ian-
I had not tried that prior
Just an off-the-wall idea.
Did you try a different order to the words? I.E. chemical NEAR romance
AND my
I was speculating what might happen of the 'noise' word came later in
the list.
~|
Order the Adobe Coldfusion Anthol
I now recall having this issue myself many years ago, and the reason it
doesn't work is because the noise words (now called stop words) are not
actually indexed, rather than being stripped from the search which is what
you assumed. On SQL 2000 you couldn't even use the stop words period or you
get
Carl,
Thanks for that link. I appreciate it. :-)
I guess I am simply totally misunderstanding noise/stop words in SQL
Server. My understanding was that they were ignored in a query. But the
behavior I am seeing indicates that the entire search string is ignored if
such a word is encountered.
Matt,
I googled on "sql server noise words" and found this link:
http://arcanecode.com/2008/05/29/creating-and-customizing-noise-words-in-sql-server-2005-full-text-search/
I followed the directions and found the noise lookup file being used by SQL
Server 2005 on my computer, and confirmed that
Thanks for the tip on using just a single NEAR keyword. In this particular
example (my chemical romance), it still results in no records being
returned. The only thing I can figure is that 'my' is a noise word, and all
searching is ignored once a noise word is hit.
For the time being, I've mere
t [mailto:mgr...@modus.bz]
Sent: Tuesday, November 23, 2010 2:07 PM
To: cf-talk
Subject: Re: (ot) SQL Server Full-Text Search CONTAINS()
I'm not overly familiar with NEAR but most of the examples I've seen where
NEAR is strung together show it without the quotes.
CONTAINS (EventName,
@ Michael-
Unfortunately, you are correct: That's no help. Same result without the
quotes. :-(
I know that "noise words" are ignored, but what appears to be happening is
that it is ignoring the entire thing, rather than just the (possible) noise
word "my".
~~~
I'm not overly familiar with NEAR but most of the examples I've seen where
NEAR is strung together show it without the quotes.
CONTAINS (EventName,'my NEAR chemical NEAR romance')
That's probably no help, but I thought I'd share.
On Tue, Nov 23, 2010 at 1:00 PM, Matt Quackenbush wrote:
>
> S
Ayep. The band name is "My Chemical Romance". I'd say that definitely
qualifies as NEAR. :-)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archi
Are there any results that actually have those 3 words near each other ?
Russ
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: 23 November 2010 18:01
To: cf-talk
Subject: (ot) SQL Server Full-Text Search CONTAINS()
SQL Server 2005
For the life of me, I ca
FYI,
a) Project deadline is days away. One should probably not to change horse
while crossing a river (of course another could argue "should you really need
to cross the river?")
b) The randomly reported error may not accurately reflect sql server 2005
express sp3 installation success or failu
Out of curiosity, after all the problems you have had with MSSQL Express
and all the alternatives that have been offered. Are you going to continue
to use MSSQL Express? Or will you try using one of the alternatives?
Best Regards.
Emmit
On Wed, Aug 12, 2009 at 6:27 PM, Don L wrote:
>
> > On We
> On Wed, Aug 12, 2009 at 5:19 AM, Don L wrote:
> >> Mysql, sql lite, h2, derby = no install
> > sql lite is eliminated for it's not a dbms but a c library for a dbm.
> of the remaining 3, which one is most compatiable with ms sql server
> 2005 syntax and feature-wise?
>
> PostgreSQL.
>
> Su
>Looks like it's still Vista SP1, Home Premium Edition.
>
>No clue what version of the Installer is in place. There are no entries
>in those keys that are specific to the installer itself, at least not on
>my OS.
Good to know, thanks. Those two registry branches are pretty standard for XP
pr
Looks like it's still Vista SP1, Home Premium Edition.
No clue what version of the Installer is in place. There are no entries
in those keys that are specific to the installer itself, at least not on
my OS.
~|
Want to reach t
> Actually, I run SQL 2005 Express on my Vista box at home for dev work,
> and it's actually been fine. SQL Express has its own problems (what
> do you mean I can't move data with it??), but that's not a Vista issue.
Could you look up Windows Installer version from registry on your Vista box f
On Wed, Aug 12, 2009 at 5:19 AM, Don L wrote:
>> Mysql, sql lite, h2, derby = no install
> sql lite is eliminated for it's not a dbms but a c library for a dbm. of the
> remaining 3, which one is most compatiable with ms sql server 2005 syntax and
> feature-wise?
PostgreSQL.
Supports silent
Actually, I run SQL 2005 Express on my Vista box at home for dev work, and it's
actually been fine. SQL Express has its own problems (what do you mean I can't
move data with it??), but that's not a Vista issue.
~|
Want to rea
sql lite is eliminated for it's not a dbms but a c library for a dbm. of the
remaining 3, which one is most compatiable with ms sql server 2005 syntax and
feature-wise? do they all support quiet installation? do h2 and derby support
dll as well? how about creating datasource connection to rail
Mysql, sql lite, h2, derby = no install
All of which have rich SQL dialects and are very capable.
Problem solved!
G!
On Tue, Aug 11, 2009 at 9:47 PM, Don L wrote:
>
> I'd like to hear people's experience on this, my users/customers reported
> tons of problem with it while generally positive
On Wed, Mar 11, 2009 at 3:01 AM, Rick Root wrote:
> The server has 4x146gb scsi drives set up in 2 RAID-1 mirrored sets.
>
> We ended up with a 20 gig C drive and a 120gb D: drive on one mirrored
> set, and 70 gig E: and F: drives on the other mirrored set. Currently
> we've got our SQL Server da
I'll give that a try and see what happens.
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 9:09 AM
To: CF-Talk
Subject: Re: OT: SQL Server Accessing Excel file.
Is there any way you can copy the file and use the copy? That was my
Is there any way you can copy the file and use the copy? That was my first
thought.
On Mon, Mar 10, 2008 at 8:29 AM, DURETTE, STEVEN J (ATTASIAIT) <
[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Sorry for the off topic, but this has been a real pain in my behind. We
> have a process were our SQL serve
Never mind, I found my solution...
take DB offline
detach database
rename transaction log file
re-attach database WITHOUT transaction log
SQL Server creates small transaction log file
Problem solved!
On 7/20/07, Rick Root <[EMAIL PROTECTED]> wrote:
> I have a problem with our database server. W
Les,
Have you tried copying the cell and doing a "Paste Special>Values"?
Sometimes, with a cell that's been worked alot Excel stores all sorts
of weird stuff in there. I've run into this before on files that
were unusually large for what they contained. Doing a Select
All>Copy>Paste Spec
Jim Wright wrote:
>
> Is this perhaps a 4 CPU machine, with Task Manager set to show one graph
> for all, and with SQL server set to only use one CPU?
It's a dual CPU machine with hyperthreading.
Yeah, I didn't consider that the single graph would really just show an
average. When viewed as 4
Robertson-Ravo, Neil (RX) wrote:
> 5GB Every morning?! All new data?
We're dumping our entire mainframe db2 database every night and FTPing
them to the SQL Server. We don't have the ability to do replication,
and writing processes on the mainframe that would only dump the data
that changed wou
Rick Root wrote:
> I have a fairly large bulk insert DTS task in SQL Serve that loads 5 gig
> or so of data into our database every morning. It drops the original
> tables, bulk inserts the data, then recreates all the indexes. No
> logging, etc.
> http://www.it.dev.duke.edu/temp/sqlcpu.gif
>
Rick Root wrote:
> I have a fairly large bulk insert DTS task in SQL Serve that loads 5 gig
> or so of data into our database every morning. It drops the original
> tables, bulk inserts the data, then recreates all the indexes. No
> logging, etc.
>
> I'm trying to figure out a way to improve
5GB Every morning?! All new data?
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It
On Wednesday 19 July 2006 23:07, Jeff D. Chastain wrote:
> in the past that by removing the log file SQL server would rebuild a new
> one and you would only loose whatever transactions were in the log file.
Well, unless it was half way through doing something, I suppose it might.
Doesn't strike m
Okay, I can't detach the database because it is being used in replication. So,
I tried to use the stored procedure sp_removedbreplication to stop the
replication and I get an error because the database is in recovery/emergency
mode. Next
Thanks.
Nick Han wrote:
>
>erver: Msg 7391, Level 16, State 1, Line 1
>The operation could not be performed because the OLE DB provider
>'MSDASQL' was unable to begin a distributed transaction.
>[OLE/DB provider returned message: Unsupported connect attribute (Set)]
>OLE DB error trace [OLE/DB Provider 'MS
rror trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 4:31 PM
To: CF-Talk
Subject: Re: OT: SQL Server- Postgres Distributed Transactions
Ni
Nick Han wrote:
> Does anyone know if there is a solution to making transactions work,
> when using remote calls from SQL Server to Postgres? We have a link
> server setup and we are able to push data over to Postgres from SQL
> Server. What we are having a problem with is when trying to wrap
> t
On 10/4/05, Bob Haroche <[EMAIL PROTECTED]> wrote:
> Are you sure your router supports loopback? I had the same issue
> where I couldn't browse to my dev sites using their external IP's
> when I'm on my LAN, though I can when I'm outside my LAN.
Nah, that's definitely not it - I can browse the dev
On Oct 4, 2005, at 12:11 AM, Kay Smoljak wrote:
>
> The machine has two network interfaces - an internal 10.0.0.n IP and
> an external 203.n.n.n IP. I can connect to the local 10.0.0.n IP using
> Enterprise Manager no problems - but not using the external IP
>
Are you sure your router supports loo
> Hmm, so how do I create a login thats the same as the table owner?
>
> I tried the login wizard and used the same name as the table owner and
> now have two users with the same name. Both seem to be the table
> owners but neither seems to be a login!
>
> I'm sure I'm close! Thanks for any help
Hmm, so how do I create a login thats the same as the table owner?
I tried the login wizard and used the same name as the table owner and
now have two users with the same name. Both seem to be the table
owners but neither seems to be a login!
I'm sure I'm close! Thanks for any help in advance.
> actually, if in the query. I give the table owners name before the
> table. I can see it. So somehow the login doesnt know enough to look
> at the tables owner. Hmm. Anybody?
If the login is different from the actual table owner, you will have to
specify the table owner within the table name
actually, if in the query. I give the table owners name before the
table. I can see it. So somehow the login doesnt know enough to look
at the tables owner. Hmm. Anybody?
On 5/25/05, DRE <[EMAIL PROTECTED]> wrote:
> Hi,
> I'm not that familiar with sql server but I've got a database that I
> ca
There's also a SQL list on House of Fusion that has some very knowledgeable
people, though it is low traffic.
>Okay... since my request for a good oracle list/forum was successful,
>here's another one.
>
>I'm looking for recommendations on a good SQL Server list or forum.
>
>We're going to be do
I enjoy SQLServerCentral.com
-Mike Chabot
> Rick Root wrote:
> > I'm looking for recommendations on a good SQL Server list or forum.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http:/
Rick Root wrote:
> I'm looking for recommendations on a good SQL Server list or forum.
http://vyaskn.tripod.com/lists.htm
lots of smart folks on SSWUG.org (though i can't seem to get to it just
now). however some of the MVP from that list are now more actve in the
ms forums.
~~
Dustin Snell [Network Automation] wrote:
>
> I know there is clustercats for ColdFusion but we want to do the database
> server first. Everything I am reading says you need at least *three*
> machines to do a simple mirror with SQL Server, is this true??
Depends on which definition of mirroring /
no - it just went to the per CPU licensing model,
john.
>We are considering migrating a number of web sites, RIAs, and a client
>server application from a variety of databases, including Oracle, MySQL,
>and Access, to SQL Server.
>
>Last time I used SQL Server (long time ago), there was an "in
Thanks Ade,
I'm actually able to create the linked server okay, but I get this
when I try to select anything from it. There's no password on the
access db, so I'm not sure why it would fail authentication with
nothing to authenticate.
Server: Msg 7399, Level 16, State 1, Line 2
OLE DB provider 'M
Wow you're good -- either that or I was really distracted and tired
yesterday... I just found the answer in the SQL Server BOL ... did a
search for msg 7399 and found it... boy is that obscure tho... in
order to connect to an insecure database, you have to create a linked
server login with username
I might be mistaken, but I think someone I work with did this a while back,
it's the evening here so I'll have to ask tomorrow. What error are you
getting?
Ade
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 15 December 2004 20:31
To: CF-Talk
Subject: OT - SQL Ser
Just for the record, things seemed to quiten down after i rebuilt all
the statistics.
AskJeeves spider was hitting the server in the particular way which
was causing the problems: there's a big cfquery with loads of
conditional stuff (and someCol=whatever), and
using particular search criteria was
> Are you sure the username is the one that is used from CF then?
Yes, it definately the CF user - when i started looking at this i
created a new new SQL login, and the only place this is used is in the
DSN set up in CFadmin.
>
>
> > How would you suggest i use a manual checkpoint? Just open up
Bert Dawson wrote:
> We're not using client variables (default storage in cfadmin=none,
> clientManagement="No", no DSNs are configured to use client variables,
> or have the tables in them).
Are you sure the username is the one that is used from CF then?
> How would you suggest i use a manual c
We're not using client variables (default storage in cfadmin=none,
clientManagement="No", no DSNs are configured to use client variables,
or have the tables in them).
How would you suggest i use a manual checkpoint? Just open up query
analyser and run CHECKPOINT? Or place it in the code somewhere?
Bert Dawson wrote:
> I've got a SQL server box that ticks along quite happily at about 15%
> CPU, but occasionally goes up to around 40% and stays there for
> anything up to a minute. During these peaks the jrpp.delayMs can start
> to climb, up to from a few seconds up to hundreds of seconds. I als
I do'n't know anything about the FTS service, and i don't knowingly
use it, so i've stopped it. But I doubt that was the cause as there
seemed to be no pattern to the "2 minutes @ 30%" periods.
Also, i suspect its something to do with CF since the loginname
reported in profiler is only used in the
Just as a guess, maybe a scheduled FTS catalog population?
Jerry
Jerry Johnson
Web Developer
Dolan Media Company
>>> [EMAIL PROTECTED] 12/03/04 12:01PM >>>
If anyone has any ideas what sort of thing could cause just a leap
then i'd appreciate any input, or ideas of where to look next.
~~~
No GUI is part of it but I couldn't connect to it and I found a work
around and didn't feel like messing with it. So I scrapped it :)
On Tue, 2 Nov 2004 08:44:00 -0800, Matt Robertson
<[EMAIL PROTECTED]> wrote:
> Why? Because there's no gui yet?
>
> I'm setting up a new server this weekend and
Why? Because there's no gui yet?
I'm setting up a new server this weekend and am planning on plugging
in and playing with MSDE, which apparently has a GUI now and does not
have the single-processor limit. I have MSDE running elsewhere but as
something plugged in by a 3rd-party app (LiveStats).
I scrapped it after about 5 minutes of use
On Sun, 31 Oct 2004 21:32:47 -0500, Michael T. Tangorre
<[EMAIL PROTECTED]> wrote:
> Anyone download the SQL 2005 Express beta from MS yet? If so, where in the
> heck do you create a new DB? The new SQL Computer Manager is a bit
> confusing.
>
> Tha
You should not experience any performance hit.
The only real downside is what Dave was talking about -- unless you
have a good reason, why clutter up the database with an extra field and
indexes -- the law of parsimony -- the simplest way is the best way.
But, if you *do* have a good reason (as
What are some of the downsides to this? Will I experience a performance hit
should I use the additional key?
> Now, the above are valid reasons for including a separate key
> -- another might be that the T3 record contains intersection
> data, and/or it is sometimes meaningful to process this ta
On Mar 18, 2004, at 7:25 AM, Nick de Voil wrote:
> Just to play devil's advocate and also enjoy the unusual experience of
> disagreeing with Dave - your proposed approach of adding a surrogate
> key is
> our standard way of doing things. Even when the table is a simple
> intersection table con
I agree, we do the same thing here.
TK
-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 10:26 AM
To: CF-Talk
Subject: Re: OT: SQL Server Table Design Question
Just to play devil's advocate and also enjoy the unusual experien
Just to play devil's advocate and also enjoy the unusual experience of
disagreeing with Dave - your proposed approach of adding a surrogate key is
our standard way of doing things. Even when the table is a simple
intersection table consisting of nothing but 2 foreign keys, we always make
the primar
I tend to agree with Dave and opt for not adding Column C
If I understand, you want to deal with C as an abstraction of the A-B
relationship. I can see how passing C (instead of A & B) would
simplify form handling.
But, you could pass AB just as easily as you can pass C.
I think introducing
Basically, I only gave you a partial story.. The rest of it is that the join
tables are used in other relationships and the where conditions and join
conditions are getting sloppy. In addition, a lot of the front end deals
with dynamic forms and passing around a handful of IDs is getting
cumbersome
yeah, the question is a bit vague
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 8:44 AM
To: CF-Talk
Subject: Re: OT: SQL Server Table Design Question
On Mar 18, 2004, at 5:04 AM, Tangorre, Michael wrote:
> What is the proper,
On Mar 18, 2004, at 5:04 AM, Tangorre, Michael wrote:
> What is the proper, or preferred way of doing the following:
>
>
> I have three tables:
>
>
> T1 - PK A
> T2 - PK B
> T3 - PK AB (compound)
>
>
> Is it acceptable to add column C to T3 and make that the PK, and then
> add a
> unique co
> -Original Message-
> From: Andres [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 9:28 AM
> To: CF-Talk
> Subject: OT - SQL server 2000 - total number of objects in a DB
>
>
> Hello Everyone,
> How can i get a count of all indexes a database has? I have a
> SQL 2000 serve
You're supposed to use system functions or stored procedures to access this,
but check out the sysobjects table. You could write a count() query to get
what you need out of that. Otherwise look in the books-online under system
functions to do it the right way, I don't know if there's already a func
the three I originally thought.
Stephen
-Original Message-
From: Rizal Firmansyah [mailto:rizal.firmansyah@;sentracommerce.com]
Sent: 28 October 2002 15:42
To: CF-Talk
Subject: Re: OT: SQL Server database problem
Just another taught...
Using varchar instead of text as a datatype for this
Just another taught...
Using varchar instead of text as a datatype for this kind of data maybe
helpful...
Rizal
At 10:21 PM 10/28/2002, you wrote:
>I think the error message is straight forward,
>that is you are trying to insert string that's longer than your datatype
>can handle.
>
>For example
Message-
From: A.Little [mailto:A.Little@;open.ac.uk]
Sent: 28 October 2002 15:23
To: CF-Talk
Subject: RE: OT: SQL Server database problem
You don;t need to trim these down to 16 chars as that isn't the max length
you can store in a SQL 'text' field - it's something like u
error.
>
>-Original Message-
>From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
>Sent: 28 October 2002 15:05
>To: CF-Talk
>Subject: Re: OT: SQL Server database problem
>
>
>Quoting "Adams, Stephen" <[EMAIL PROTECTED]>:
> >
> > T
ch you;re
trying to insert
16 chars - could this be the problem ?
Alex
> -Original Message-
> From: John Morgan [mailto:gameczar@;zbzoom.net]
> Sent: 28 October 2002 15:14
> To: CF-Talk
> Subject: Re: OT: SQL Server database problem
>
>
> You should either trim the text
I think the error message is straight forward,
that is you are trying to insert string that's longer than your datatype
can handle.
For example:
Field: MessageTitle (16): You are trying to insert: "Some text to throw
error" which has 24 characters.
Try to increase the length of the field in you
50 and 500
respectively, but still I get the 22001 error.
-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 28 October 2002 15:05
To: CF-Talk
Subject: Re: OT: SQL Server database problem
Quoting "Adams, Stephen" <[EMAIL PROTECTED]>:
>
&
You should either trim the text being inserted using the left function ...
EXAMPLE:
Left(form.MessageTeaser, 16 )
or you should expand the size of the field in the table. If this is data
input via a form you could use the size option in the input tag to enforce
the size restriction but I would
Quoting "Adams, Stephen" <[EMAIL PROTECTED]>:
>
> The problem I am having is a "ODBC Error Code = 22001 (String data
> right truncation)" error.
> My table design is like this.
> Column name DatatypeLength
> MessageID int 4
> MessageType char
Thanks Jochem,
I took a closer look at the documentation for SQL Server 2000 and it gives
2^30 -1 (1,xxx,xxx,xxx) as the maximum length for an ntext field...
So ... considering that the entire file performing the insertion of data
into this table is no more than 5k I'm suspect that there's somet
S. Isaac Dealey wrote:
> I have a db where I had been using a text field and I'm converting it to an
> ntext field so that the db can potentially support unicode at a much later
> date.
>
> The problem I'm having is this: I'm not just opening the db and changing the
> field to ntext, I created a
You can use SQL Server DTS to write the file and you can also execute
the DTS using "xp_cmdshell" extended stored procedure.
Joe
>From: S. Isaac Dealey <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT : SQL Server Bulk Copy Date: Thu, 19 Sep 2002 14:
Dave Watts wrote:
> There are a couple of options that might work for you. If this is a
> one-time thing, and you can stop the source database server, you can
> simply copy the database and log files to the new server, and use
> sp_attach_db to attach each to the new server.
Another alternative
: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 15, 2002 7:01 PM
To: CF-Talk
Subject: RE: OT SQL SERVER Backup
> Is there an easy way to back up all the SQL server DB's and
> restore them on a separate Machine?
>
> ...
>
> I have SQL server 2K
>
> and thiry +
> Is there an easy way to back up all the SQL server DB's and
> restore them on a separate Machine?
>
> ...
>
> I have SQL server 2K
>
> and thiry + databases ...
>
> I know how to backup each one, but was wondering if there is
> a bulk backup of the entire server.
There are a couple of option
gt; Subject: Re: OT SQL SERVER Backup
>
>
> Which version of SQL Server...SQL2000 has a copy database wizard that can
> create a DTS package that you can save and run later.
>
> At 08:54 PM 6/14/2002 -0400, you wrote:
> >Is there an easy way to back up all the SQL server D
Hi Jim,
Yes.Go to Enterprise Manager
Select the database-->Right Click
-->All Tasks
-->Backup
Select Database - Complete.
Add Destination ( where the back up file to be taken)
Click Ok.
The Backup is created on file selected for backup
In Options Tab See
Which version of SQL Server...SQL2000 has a copy database wizard that can
create a DTS package that you can save and run later.
At 08:54 PM 6/14/2002 -0400, you wrote:
>Is there an easy way to back up all the SQL server DB's and restore them on
>a separate Machine?
>
>- j
>
>
>
_
Nope, don't have public IP.
-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:15 PM
To: CF-Talk
Subject: RE: OT: SQL Server Connection
does the database server have a publicly acessible IP address? if so, just
crate the
does the database server have a publicly acessible IP address? if so, just crate the
ODBC source on the ISP for the site, and point it to that IP.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Messag
r" in the query
anaylyzer (F8). Right click on a table and choose - generate script as
"create". Good luck
Mark
-Original Message-
From: Andy Parry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 5:13 PM
To: CF-Talk
Subject: RE: (OT) SQL Server Schema
You ca
SP_HELPDB EXTENDED STORED PROCEDURE.
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:54 PM
To: CF-Talk
Subject: RE: (OT) SQL Server Schema
Cool. I just discovered the answer to my own question. And in case you
haven't fi
You can do a join on sysobjects and syscolumns tables in your DB and get the
data that way also.
andy
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month ·
ed perfect.
H.
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
> -Original Message-
> From: Owens, Howard [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 30, 2002 4:07 PM
> To: CF-Talk
> Subject: RE: (OT) SQL Serv
www.swynk.com
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:07 PM
To: CF-Talk
Subject: RE: (OT) SQL Server Schema
Is there a way I can get a text file or print out of all of the tables,
along with column names, datatypes and sizes
Is there a way I can get a text file or print out of all of the tables,
along with column names, datatypes and sizes, in MSSQL Server 2000?
H.
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
_
On Win98, I have a shortcut in the startup folder:
:\MSSQL7\Binn\scm.exe -Action 1 -Silent 1
Stephen
> In Windows 95, how do you change the account the Service Manager
> uses to try and start SQL Server on boot up, bearing in mind there
> is no Services option (as is the case with NT)?
>
>
>
1 - 100 of 132 matches
Mail list logo