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

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

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

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

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

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

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

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

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

Hi, I have one table name: art column: symbol_art price1 price2 ----------- ------- ------- AG-0001 20 ...

info

01-02-2008 04:19 PM
--CELKO--

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

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

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

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

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

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

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

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

i want raed and write a sql server

pnwramt80@gmail.com

12-28-2007 05:05 PM
Hugo Kornelis

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

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

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

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

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

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

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

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

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

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

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

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

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\)

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

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

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

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

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

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

= = = > 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

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

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

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

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

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

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

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

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--

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

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

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