| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | Dear ladies and gentlemen,
Upscene Productions is happy to announce the major
version of their test data generator tool:
"Advanced Data Generator 2"...
Martijn Tonies
|
01-04-2008 03:49 AM
Martijn Tonies | 0 | 605 |
|  | I had to use use ssis 2005 in a short project recently & had little
time to work it out. I was importing a whole bunch of flat files into
SQL Server...
stephen
|
01-04-2008 03:49 AM
stephen | 0 | 343 |
|  | Hi I have a requirement where in i haev to convert the SQL from Oracle
to the one which will run on the SQL server.
in the Oracle Query i am doing...
narendra vuradi
|
01-04-2008 01:31 AM
Ed Murphy | 1 | 194 |
|  | Running a SQL 7 system on a Windows 2000 server using Access 2000 on client
machines as a front end. System administrator currently reboots the...
Neil
|
01-03-2008 11:48 PM
Neil | 29 | 350 |
|  | I am stumped on the error reporting with sql server. I was told i
need to return @SQLCode(code showing if successful or not) and
@ErrMsg(and the...
barmatt80@gmail.com
|
01-03-2008 05:25 PM
Plamen Ratchev | 1 | 159 |
|  | Recently, I was in a training course about the new features of 2005.
The trainer said that 2005 dealt with active/active memory differently
during a...
M Bourgon
|
01-03-2008 09:11 AM
M Bourgon | 0 | 164 |
|  | Dear All,
I want to get more than one table columns as a single column by
alternative.
For eg,
Table name = employee
columns = empid, empname,...
Ganapathi sundaram
|
01-03-2008 08:36 AM
Madhivanan | 3 | 156 |
|  | Yikes! My database, which had been consistently 1 gig for a long time, went
from being 1 gig to 3 gigs overnight! Looking at the nightly backups,...
Neil
|
01-02-2008 10:07 PM
Neil | 38 | 388 |
|  | I would like to call this stored procedure, but I am unable to pass
parameters to the @Start and @End.
Is thier a way to pass parameters to a pass...
gumby
|
01-02-2008 05:35 PM
Erland Sommarskog | 2 | 159 |
|  | Hi,
I have one table name: art
column:
symbol_art price1 price2
----------- ------- -------
AG-0001 20 ...
info
|
01-02-2008 04:19 PM
--CELKO-- | 3 | 176 |
|  | Hi
We use Sql 2000.
When defining a database maintenance plan one of the options is to
optimize the database, reorganize data and index pages, remove...
David Greenberg
|
01-01-2008 05:02 AM
Erland Sommarskog | 3 | 164 |
|  | Hi
We usae Sql2000.
I'm setting up backups jobs and need advise.
When I run a backup of a database, does it automatically clean out the
transaction...
David Greenberg
|
01-01-2008 04:56 AM
Erland Sommarskog | 3 | 181 |
|  | If I do
SELECT TOP 25 * FROM table ORDER BY id
does it select any 25 records and then order them
or does it SELECT all the records, order them by...
metaperl
|
12-31-2007 02:42 PM
David Portas | 3 | 159 |
|  | Sono in procinto di passare da access a sql server, per ora passando
solo il db in sql server e collegando le tabelle in access per sfruttare
tutte...
TheProf
|
12-30-2007 05:21 AM
TheProf | 0 | 220 |
|  | Hello,
I'm sure this has come up for people before. I have two fields in one
table that both refer to my users table.
TakenByID
EnteredByID
Both...
Matthew Wells
|
12-29-2007 06:34 PM
Erland Sommarskog | 1 | 187 |
|  | Someone renamed a server from 2A to A.
When I do @@servername I get 2A.
The server/machine name is 2.
Should my triggers say 2A or 2? Does it...
jantaneey@gmail.com
|
12-29-2007 06:18 PM
Erland Sommarskog | 3 | 152 |
|  | Hey Guys,
Total Number of Records (Based on 5 fields): 1000
Total Unique Records (Based on 5 Fields): 990
Total number of fields: 5
I have question...
apatel85@gmail.com
|
12-28-2007 05:49 PM
Erland Sommarskog | 3 | 179 |
|  | I am absolute a novice in XML but need to shred XML into SQL Server
2005.
I studied some examples, but only with simple XML Docs.
My docs seems to be...
Theo Müller
|
12-28-2007 05:32 PM
Erland Sommarskog | 3 | 180 |
|  | i want raed and write a sql server
pnwramt80@gmail.com
|
12-28-2007 05:05 PM
Hugo Kornelis | 1 | 174 |
|  | Hi,
my query is:
SELECT a.symbol_art,b.node_key
FROM artykuly a, art_podz b
WHERE a.symbol_art=b.symbol_art
info
|
12-28-2007 03:33 AM
Erland Sommarskog | 1 | 174 |
|  | I'm having trouble running TSQL commands when SQL2005 is in single-
user mode.
I've restarted SQL with -m, -c, -T3608 set in the startup options.
I...
Mike
|
12-27-2007 05:42 PM
Erland Sommarskog | 7 | 166 |
|  | This site really was a surprise. Also check out http://www.justfordiscounts.com
that features over tons of retailers and services.I even found...
rzt8lias
|
12-27-2007 04:00 PM
rzt8lias | 0 | 180 |
|  | I have a price field that when I query it, it returns the price as
"5.0000". What function can I use to return the price as "5.00"?
THANKS
Erich93063
|
12-27-2007 08:31 AM
Madhivanan | 3 | 177 |
|  | I've been using SQL Server 2000 and am not familiar with all the new
features in 2005 but I understand it has the ability to make web
service...
Lauren Quantrell
|
12-27-2007 12:03 AM
Lauren Quantrell | 2 | 180 |
|  | hello, i cant find how to make this select :
here is what i have : 2...
noumian
|
12-26-2007 07:27 AM
harry9katz@gmail.com | 2 | 193 |
|  | Hi,
I'm working with a SQL statement to select from tables and only return
that which matches the semester AND value of 'N'. The statement...
ll
|
12-24-2007 03:48 PM
Ed Murphy | 3 | 166 |
|  | Im trying to design my time dimension and need to add a field to
handle null dates in the fact. So if at the time of ETL the date isnt
known,...
Jimbo
|
12-24-2007 03:33 PM
Ed Murphy | 3 | 178 |
|  | hi, all.
I want to verify data merged from access in sqlserver.but it has too
many records .so i need a tool
do this.
someone maybe has it.
thanks
mymoup@gmail.com
|
12-24-2007 03:30 PM
Ed Murphy | 1 | 147 |
|  | On Fri, 21 Dec 2007 03:51:41 -0800 (PST), zhuxingsheng (AT) gmail (DOT) com
wrote:
By creating a Linked Server? Look it up in Books Online.
-Tom.
Tom van Stiphout
|
12-24-2007 03:37 AM
Robert Klemme | 3 | 172 |
|  | For explanations about indexes, have a look at this:
http://www.sqldruid.com/Articles/Indexes/tabid/57/Default.aspx
Patrice
plevexier
|
12-23-2007 07:29 PM
plevexier | 0 | 167 |
|  | Hi there,
I have a strange problem with an application running on Windows 2000
connecting to a SQL Server 2000 with Greek collation.
Runnin this...
rsam2011@yahoo.com
|
12-21-2007 04:08 AM
rsam2011@yahoo.com | 2 | 180 |
|  | I was asked to look into a performance problem on a newly migrated DB
server.
The db server was moved from a local-physical-nt4-sybase to remote...
Diggla
|
12-20-2007 08:23 PM
Greg D. Moore \(Strider\) | 8 | 168 |
|  | I have 2 sql server 2000 database that participate in log shipping.
Server A is the source database, which log ships to a database on
Server B. The...
Justin
|
12-20-2007 05:29 PM
Erland Sommarskog | 2 | 170 |
|  | I am very new to all this
I have a access databse wich uses a ODBC conection to mysql server. I
can open the and run the database find but if i...
S.Dickson@shos.co.uk
|
12-20-2007 05:18 PM
Erland Sommarskog | 1 | 167 |
|  | I'm developing a library and want to display the alphabets across the
screen. When a user clicks on one of the alphabets I want all titles
beginning...
JJ297
|
12-20-2007 03:26 PM
JJ297 | 3 | 153 |
|  | In order to run SQL queries without having to fully qualify ownership,
I know it's necessary to either give ownership to the DBO or log in to
the...
javelin
|
12-20-2007 10:33 AM
javelin | 2 | 155 |
|  | I have the following query
SELECT * FROM ViewName WITH (NOEXPAND)
WHERE FREETEXT (*, 'wills') ORDER BY Column1, Column2
This returns 0 results (not...
HardBap
|
12-20-2007 10:11 AM
HardBap | 0 | 158 |
|  | On Wed, 19 Dec 2007 12:38:57 -0800 (PST), stevedtrm (AT) hotmail (DOT) com wrote:
In the long run, for a serious application, there are no...
Tom van Stiphout
|
12-20-2007 12:10 AM
Tom van Stiphout | 0 | 166 |
|  | = = = > Please forward profiles to
michael.vigie (AT) pyramidconsultinginc (DOT) com
Hi,
Please let me know if you have any suitable references for...
Mike
|
12-19-2007 01:07 PM
Mike | 0 | 153 |
|  | I need to make a primary key, which constitute two different columns
on our MS SQL server. When I wrote the following code I received an
error...
YZXIA
|
12-19-2007 06:49 AM
David Portas | 2 | 164 |
|  | Hi all,
I am trying to take the example of Expanding Hierarchies from SQL 2000 Books
Online to include quantities. I have changed the BOL example to...
Artie
|
12-18-2007 10:53 PM
zzzxtreme@gmail.com | 4 | 146 |
|  | What do others do if you need to import excel files into SQL Server?
My main problems are
1) zipcode formatting issues. If the column is a mix of...
scoots987
|
12-18-2007 02:25 PM
aj | 2 | 161 |
|  | I'm relatively new to calling stored procedures, and I have a question
about passing in a parameter.
Very simple search proc that is called to...
paparush
|
12-18-2007 11:53 AM
Tony Rogerson | 8 | 148 |
|  | Hi,
I want to update a column typed datetime. My statement is:
update 'tablename' set Datum_Ende = '2007-12-17 08:49:04.000' where
'columnID_name'...
Thomas609@gmail.com
|
12-18-2007 07:53 AM
Madhivanan | 2 | 152 |
|  | I have built a SSIS package which runs fine in BIDS. I went into Sql
Server Management Studio and created a new job and job step. When I
select the...
jasonnance77@gmail.com
|
12-17-2007 07:50 AM
Dan Guzman | 1 | 174 |
|  | The following is part of my stored procedure where I could use some help:
If I remark out the two lines regarding dates, it runs fine. The...
Charlie
|
12-17-2007 07:40 AM
Dan Guzman | 1 | 165 |
|  | Here are my two tables...
Object Table:
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
(12) NOT NULL CONSTRAINT
DEFAULT (0),
NULL,
(1) NOT NULL...
orandov
|
12-14-2007 11:15 PM
--CELKO-- | 10 | 244 |
|  | Does anyone know how to query a field in a table where it contains an
ASCII code >= 128 - without looping through every field for every
record in...
DennBen
|
12-14-2007 05:27 PM
Erland Sommarskog | 3 | 176 |
|  | Hi,
I've used SQL Enterprise Manager to Export my selected db's locally.
My main question is how do I move the export to another pc - which
files...
ll
|
12-14-2007 04:19 PM
Plamen Ratchev | 4 | 154 |
|  | Hi, with some help today I was able to get my stored procedure running
and have the results emailed to me. However, this is how its...
Mike K
|
12-14-2007 10:30 AM
Mike K | 2 | 158 |