| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have an application that I am working on that uses some small temp
tables. I am considering moving them to Table Variables - Would this
be a...
Rick Hein
|
07-30-2003 04:53 PM
Erland Sommarskog  | 2 | 55 |
| | | "Damian Rafferty" <damianrafferty (AT) tiscali (DOT) co.uk> wrote
Try casting the bit value to an integer, cast(fieldname as int), in a
view over...
Tony Hodgson
|
07-30-2003 04:46 PM
Erland Sommarskog | 1 | 54 |
| | | Hi
Having the PK just on datetime may cause problems with the granularity. If
this table is populated by triggers you may want to check that it is...
John Bell
|
07-30-2003 04:43 PM
Erland Sommarskog | 1 | 56 |
| | | I'm trying to test and tune two functions that retrieve records from a
property database (housing characteristics & transactions).
One returns...
Jim Geissman
|
07-30-2003 04:28 PM
Erland Sommarskog | 2 | 52 |
| | | When you set up a full-text catalog in SQL Server and you set up the
population schedule, a job gets created and scheduled under SQL Server
Agent....
Adisorn Ratanakovit
|
07-30-2003 04:27 PM
Adisorn Ratanakovit | 0 | 62 |
| | | The following SP gives an error of:
Server: Msg 245, Level 16, State 1, Procedure spSelectSEICData, Line
26
Syntax error converting the varchar value...
Bill Willyerd
|
07-30-2003 04:23 PM
Bill Willyerd | 2 | 59 |
| | | Hi,
I have a funny Error in our sql server 7 & 2000. When I compare two
string in Unicode format. I receive that it is the same when I add...
Laurent Liegeois
|
07-30-2003 04:15 PM
Erland Sommarskog | 1 | 57 |
| | | Has this happened to anyone else?
I have a large job and all the queries run fine when used
individually, but in the job, SQL says completed with...
Steve
|
07-30-2003 03:55 PM
Erland Sommarskog | 1 | 55 |
| | | Hi,
I recently had to add a new column to a table that resides off-site,
in a customer's environment. Previously, the table had around 300
columns,...
Warren Wright
|
07-30-2003 03:35 PM
Erland Sommarskog | 1 | 63 |
| | | I have a DTS job that exports into a tab-delimited file. The tab delimiting
is working great BUT it also using quotes around the fields as well. ...
gremlin
|
07-30-2003 03:35 PM
gremlin | 1 | 82 |
| | | Hi,
I am having a problem accessing SQL Server 2000 via UNIX. I am
accessing SQL Server 2000 from Solaris using Sybase Open Client
(CT-Lib). Here...
Amy Tseng
|
07-30-2003 02:34 PM
D Newton | 1 | 59 |
| | | Hi there,
I'm pretty new to SQL and am having some porblems with a linked server.
I have a table on a SQL server which stores employee...
simonfunston
|
07-30-2003 11:46 AM
simonfunston | 1 | 53 |
| | | Consider the following (questionable, to be sure, but syntactally legal) stored
procedure (using the Northwind database):
Create Procedure...
Jeff Mason
|
07-30-2003 10:35 AM
Jeff Mason | 0 | 59 |
| | | Hi!
I hope anyone can help me with this very important problem!
Since configurig one subscriber in our merge replication
scenario to a subscribing...
Gert Wurzer
|
07-30-2003 10:25 AM
Gert Wurzer | 0 | 53 |
| | | TThai (tpthai (AT) pepco (DOT) com) writes:
The inserted/deleted tables are not the fastest in town. You may win
quite a lot by doing this in your...
Erland Sommarskog
|
07-30-2003 08:27 AM
TThai | 4 | 57 |
| | | I have production SQL Server database that must be moved to a new
machine. There is a fairly complex DTS package on the original server
that is used...
Warren Wright
|
07-30-2003 07:16 AM
John Bandettini | 3 | 62 |
| | | hello
can anyone tell me if it is possible to use activeX components (com/dcom) in
MS-sql stored procedures?
tia
udo polder
|
07-30-2003 01:33 AM
udo polder | 0 | 78 |
| | | Hi,
Trying to get a grip on the "join" thing :)
Up until now, I allways used this kinda method:
"(select t1.a from t1 where t1.b in (select t2.ab...
TH
|
07-29-2003 11:55 PM
Geroge S. Z | 3 | 58 |
| | | I have a SQL Server database that is showing 2853.44 mb in size but when I
export the data into MS Access the size is less than 1 mb. Can anyone...
Rob Wahmann
|
07-29-2003 11:09 PM
Greg D. Moore \(Strider\) | 4 | 65 |
| | | I can extablish a connection to the SQL Server, but when I try to
expand the "Databases" folder to get to our DB's (any number of them),
it never...
Scott S.
|
07-29-2003 03:55 PM
Scott S. | 0 | 65 |
| | | Dear Friends,
I don't know anybody has asked this question before or not.But I need
a support urgently.How to take online backup in MS Sql server...
Arijit Chatterjee
|
07-29-2003 03:49 PM
Scott S. | 2 | 79 |
| | | How would I create a database alias name for the following database
testingdatabase.com
This database exisist on a remote server. I have tried using...
news
|
07-29-2003 01:57 PM
xAvailx | 4 | 83 |
| | | Hello,
I am having a problem with a join. Either I am just not seeing the
obvious, it isn't possible, or I need to use a different approach. ...
Rowan
|
07-29-2003 12:38 PM
Rowan | 6 | 102 |
| | | How to make a query which contains fields from two different bases ?
Thanks in advance.
ReN
TNR
|
07-29-2003 11:53 AM
Tony Hodgson | 2 | 70 |
| | | The following query works fine against SQL Server 2000 here in the US:
SELECT * from TNEWSARTICLES where CreatedOn < '2003-04-25 14:22'
But in the...
Ted Johnson
|
07-29-2003 11:47 AM
Tony Hodgson | 3 | 61 |
| | | hoganmerideth (AT) russellcorp (DOT) com had previously posted this message (ID:
58d9d350.0207170548.a8fa932 (AT) posting (DOT) google.com) on...
Ed
|
07-29-2003 10:29 AM
Ed | 0 | 77 |
| | | I have a web-based admin section for a site and I would like to be able to
query the SQL Server database size and display it within my admin area....
Rob Wahmann
|
07-29-2003 10:17 AM
Mark Etwaru | 6 | 53 |
| | | http://www.d0m1.com/autoCodeBeta/default.asp?c=706
ae ltd is pleased to announce the autoCode beta programme: autoCode is
a Windows-based integrated...
dom
|
07-29-2003 09:42 AM
dom | 0 | 55 |
| | | Does anybody know where a copy of the MS-SQLServer software is posted?
Curt
|
07-29-2003 09:26 AM
Greg D. Moore \(Strider\) | 1 | 67 |
| | | I am having difficulty writing a SQL statement and I was wondering if one of
you gurus could help me. I have a table that has three fields:...
Alex
|
07-29-2003 06:25 AM
Alex | 7 | 61 |
| | | HI,
i got a problem while using StrConv function in sql server.
My requirement is:-
suppose in a name field i have "jhon smith" Now i want to run a...
Leader
|
07-29-2003 04:39 AM
Simon Hayes | 1 | 48 |
| | | Hello,
sorry for my english.
i have to make a trigger titch will run DTs on the server.
For example
when table test and field1 get value 1 then...
MarcinS
|
07-29-2003 04:09 AM
MarcinS | 0 | 50 |
| | | I am new to MSDE and want to deploy it in my company (because it is free).
However, when I install it in a W2K professional machine, there is a...
Arthur Cheung
|
07-29-2003 03:57 AM
Atrax | 1 | 56 |
| | | Doug Baroter (qwert12345 (AT) boxfrog (DOT) com) writes:
This has nothing to do with JDBC. What is happening is that when
you run the command from...
Erland Sommarskog
|
07-29-2003 03:35 AM
Erland Sommarskog | 1 | 58 |
| | | Hi all,
Does someone have the material(PDF or PPT) of this course: Microsoft Course
2073?
Thanks,
DnVs4
|
07-29-2003 02:59 AM
Leader | 1 | 60 |
| | | Hi All,
I want to create a cube using MSSQL2000 i dont know any thing how to
create and what is parameter required so if any body help me i will...
Biswajit Barik
|
07-28-2003 09:47 PM
Ray Higdon | 3 | 64 |
| | | "T.S.Negi" <tilak.negi (AT) mind-infotech (DOT) com> wrote
Concatenation of NULL fields results in a NULL.
As @B is NULL, concatenation of @A...
Greg D. Moore \(Strider\)
|
07-28-2003 06:29 PM
CJ | 1 | 55 |
| | | Hi,
I've run into a bit of a sticky design issue. We have products in
three categories which I will call 'A', 'B' and 'C'. We have "kits"
which...
Ovid
|
07-28-2003 03:23 PM
--CELKO-- | 1 | 74 |
| | | I downloaded the latest version on JDBC from Microsoft and I got problems.
Indeed, when fetching a smallint from SQL Server i got instead an...
okai
|
07-28-2003 02:48 PM
Simon Hayes | 1 | 66 |
| | | I have a table in my database on SQL Server which holds a file name
that refers to a file that is stored on the server. I would like to
create a...
Ryan
|
07-28-2003 02:47 PM
Simon Hayes | 2 | 58 |
| | | When we insert text into field in a table, SQL SERVER apparently
replaces apostrophes with question marks -- is there a way to not have
this occur? ...
kalbee
|
07-28-2003 11:17 AM
Rob Wahmann | 1 | 48 |
| | | Hi, I just want to know to turn this:
CREATE TABLE . (
NOT NULL ,
(50) COLLATE French_CI_AS NULL ,
NOT NULL ,
(50) COLLATE French_CI_AS NOT...
Heist
|
07-28-2003 10:09 AM
Heist | 2 | 68 |
| | | How do I order a query by a date field ASC, but have any NULL values
show up last? i.e.
7/1/2003
7/5/2003
7/10/2003
<NULL>
<NULL>
Dean Mathews
|
07-28-2003 09:18 AM
Dean Mathews | 3 | 77 |
| | | Hi
The following gives a list of links for crosstab queries:
http://tinyurl.com/i9mt
John
"T.S.Negi" <tilak.negi (AT) mind-infotech (DOT) com>...
John Bell
|
07-28-2003 08:55 AM
John Bell | 0 | 52 |
| | | Hi,
We have a problem when trying to present data retrieved from SQL Server in
an e-mail. We don't use SQL mail - we use JMail (in ASP code) and... |
07-28-2003 06:27 AM | 0 | 65 |
| | | Hi,
While restoring the log we receive a message after about 30 minutes:
Processed 1152109 pages for database 'restest', file 'sales_Log' on
file...
Rene
|
07-28-2003 04:09 AM
Rene | 1 | 55 |
| | | Good morning:
At least it's morning where I am. :)
I have a rather newbie question I'm afraid. I have VisualStudio.NET, and
have installed it along...
Dagwood
|
07-27-2003 06:37 PM
Dagwood | 10 | 102 |
| | | Hello!
I am looking for a SQL server Full-Text replacement.
Does anybody know an alternative product that does full-text on db
columns?
This is my...
Lennin
|
07-27-2003 01:05 PM
Lennin | 0 | 66 |
| | | how do i specify the table destination only not the whole database
from a text.txt source?
thanks,
trint
trint smith
|
07-27-2003 12:52 PM
Dan Guzman | 2 | 71 |
| | | berthelot samuel (samuel.berthelot (AT) voila (DOT) fr) writes:
If you is logged in as nisse, and you say
exec some_sp
SQL Server first checks if...
Erland Sommarskog
|
07-27-2003 12:52 PM
Dan Guzman | 1 | 56 |
