Hello, I am pulling back data from sqlserver 2003 with an application that cannot cope with the french e acute for example. I have taken this up...

syd_p

08-04-2009 04:15 PM
Erland Sommarskog

Hi, We supply an application which runs on a SQL Server backend (SQL 2000 and 2005 currently). I am aware that the Full Recovery Model provides for...

bernie sprouster

08-03-2009 04:48 PM
Erland Sommarskog

Here are available all details about naz computers and laptops http://naz-computersandlaptops.blogspot.com/

naz mona93

08-02-2009 09:25 AM
naz mona93

Hi Folks, I've worked this in a different manner now, which actually worked out better, but I was wondering if something like the extract below...

Tim

08-01-2009 06:04 PM
João Loureiro

I tried this and it worked to an extent. The issue is that my raw data as a lot of free form text fields and the only way to make this work is to...

PCRIDE

08-01-2009 04:34 PM
PCRIDE

SQL 2005 SP2. When I try to import a table from one server to another using SSIS, the table imported on the new server does not have the primary key...

Raziq Shekha

07-31-2009 03:45 PM
--CELKO--

--CELKO-- wrote: What context do you have in mind for the "triggers or stored procedures" bit? Stored procedures, in particular, I routinely use...

bill

07-31-2009 03:37 PM
Ed Murphy

Yellowfin, leading web-based Business Intelligence software providers, today announced the release of Yellowfin 4.1, the next generation of the...

JTP PR

07-31-2009 05:49 AM
JTP PR

Hi Can someone confirm this is a feature of SQL 2000 which was fixed/ changed in 2005 Get 2 query analyser windows, do setup in one of them as...

codefragment@googlemail.com

07-31-2009 02:26 AM
Erland Sommarskog

Hi, If I have 2 tables: Table testamount orderID | amount 1 | 20 2 | 10 3 | 4

wibni

07-30-2009 10:11 PM
Plamen Ratchev

I need to Create a table called ‘Tracker’ with two columns. The first column will be CustomerID, an nchar(15) field, while the second will be...

sandiec

07-30-2009 02:22 AM
Erland Sommarskog

Hello everyone, Against my better judgement I have been thrust into the duty of creating Crystal reports for my company. I have discovered...

eighthman11

07-29-2009 09:12 PM
--CELKO--

I am trying to install sql server 2008 with "best practices". One of the recommendation from Micorsoft is to use domain user account with the minimum...

akkha1234@gmail.com

07-29-2009 04:25 PM
Mike McNeer

Hi, I need a way to intercept and modify SQL statement with parameters sent by .NET application. It should be transparently, I mean I don't want...

Zabuti Maxim

07-29-2009 04:23 PM
Erland Sommarskog

Hi I use Sql Server 2008. 1. After I truncate a table, is it necessary to recreate it's keys and indexes ? 1. Is it necessary to run "DBCC...

David Greenberg

07-29-2009 04:20 PM
Mike McNeer

We were just informed that we have to use SQL Server (Enterprise Edition) for our projectinstead of Oracle .. Which version 2005 or 2008 do you...

George Lewycky

07-29-2009 04:07 PM
Mike McNeer

Hi I've got databases (both SQL Server 2000 and 2005) wherein an ID column is used in many tables. I now need to extend this field from nvarchar(20)...

Smith

07-29-2009 04:05 PM
Mike McNeer

Hi, I'm new at SQL Server 2005, and am having quite a number of problems with blocked deadlocks at the...

cwho80

07-29-2009 04:01 PM
Mike McNeer

Hello The With statement below , Im new To this..and need a little help understanding what is going on here.. the below does show all the rows in a...

DaveP

07-29-2009 01:21 PM
DaveP

I am trying to count averages for a date range. The amount of data and data nature is highly dependant on the day of the week, so just averaging all...

migurus

07-29-2009 12:40 PM
migurus

Hi, I have a table that contains order information, each row contains information about a detail item that's been order but the key is OrderID and...

Guy Dreger

07-29-2009 06:33 AM
Iain Sharp

1) Are there competing UML Data Modeling profiles (for relational databases) or is only one being considered? One of Scott Ambler's articles...

dana

07-29-2009 03:52 AM
dana

If you can spare about 10 minutes to take a survey I would love to hear about how the global recession is (or is not) changing your personal or...

Mikhail

07-29-2009 12:42 AM
Mikhail

Hello When executing an ALTER COLUMN query within SQL Server Management Studio, the number of rows affected is returned. As I've understood, an...

Smith

07-26-2009 09:30 AM
Erland Sommarskog

Hello, We at ZIN Technologies (Pvt.) Ltd. require a SQL Programmer with the following skill sets: • At least 4 years of Experience with designing...

darravian

07-24-2009 07:45 AM
SQLMan_25

Hi, I have two databases with the same structure. They were filled by different users. Now I want to merge the two databases. I tried the Import...

sheperson@googlemail.com

07-23-2009 07:04 PM
bill

Hi I have 2 databases:PRD and DEV.data files are about 6GB ( Simple recovery mode).Once a week i am backing up PRD,then restoring in DEV.After...

hayko98

07-23-2009 04:42 PM
Erland Sommarskog

On Jul 17, 11:18*am, Plamen Ratchev <Pla... (AT) SQLStudio (DOT) com> wrote: THanks Plamen, What I am having problems with is the final...

pbd22

07-22-2009 01:03 PM
Plamen Ratchev

Is there a collation page that will make SQL 2008 act the same way as Oracle: e.g the dictionary object names are case INsensitive, but the column...

bill

07-21-2009 01:47 AM
Erland Sommarskog

Anyone can give me SQL statement for auditing system function master.sys.fn_get_audit_file ? I tryed googling but i couldn't find procedure...

Damir R.

07-20-2009 02:59 PM
Damir R.

Hi We use SqlServer 2008. In an SSIS package I wanted to bring over a large table , a little more than 600mb or in records ovrer 10 million. The...

David Greenberg

07-19-2009 01:47 AM
David Greenberg

Hey There. I need help figuring out how to span a category tree. I am using WIN SERVER 2003/ MS SQL 2005 / ASP.NET 3.5 / C#. I have provided...

pbd22

07-17-2009 09:41 AM
pbd22

Greetings! I have a problem that I have been working on most of the afternoon and I was hoping someone here could point me in the right direction....

sauly

07-16-2009 06:21 PM
sauly

Hi, I need a database project for my database course. I will prepare it by sql server 2005. The project should not be less than 10 tables and...

LFOBO

07-15-2009 03:03 AM
LFOBO

Hi, I have a table that contains a datetime column and a numeric output column. I want to write a query that will give me the average of all...

Billy

07-15-2009 02:25 AM
Billy

This tool re-indents the code to make codeblocks easier to follow. It also comments codeblock ends where possible and where not already commented. ...

DTecMeister

07-14-2009 10:06 PM
DTecMeister

Is anyone on this group aware of a new "feature" with SQL 2005 that would disallow adding a user to the sysadmin server role? I have tried...

TechWitch

07-14-2009 04:57 PM
Erland Sommarskog

SQL Server 2005 SP2 9.0.3054 A few times now I have had a misbehaving process that ate up way too much database temp space. I identify the process...

aj

07-13-2009 08:25 AM
aj

Greets yalls, Has anyone made SQL Server work with unicode in java? I'm working on a system which wants to put unicode in a database. It does this...

Tom Anderson

07-12-2009 01:12 PM
Arved Sandstrom

Hi We've just upgraded from Sql 2000 to 2008. I designed backups in maintenance plans for our databases and run the various subplans as different...

David Greenberg

07-12-2009 12:46 AM
David Greenberg

Here are available all details about naz computers and laptops http://naz-computersandlaptops.blogspot.com/

naz mona93

07-10-2009 02:42 PM
naz mona93

Business intelligence (BI) firm Yellowfin has launched a new version of its flagship Yellowfin product with enhanced capability for...

JTP PR

07-09-2009 06:40 AM
JTP PR

Hi. Could somebody outline what the best steps are for password reset on a site? I notice often that when I request a password reset from another...

pbd22

07-09-2009 12:20 AM
Jamal

I have a function that takes a bit parameter and returns a text substitute. I use it in this kind of operation: SELECT...

Rotwatcher

07-08-2009 05:33 AM
Rotwatcher

Hi. I need some help here with a multi-table join. I am writing a stored procedure with a code block that needs to join my service table, my product...

pbd22

07-08-2009 03:28 AM
Erland Sommarskog

I've been tasked with assessing the benefits of changing our DB platform in some areas. We currently use SQL 2000 and 2005 and I'm pushing for SQL...

Ryan

07-01-2009 08:18 PM
Greg D. Moore \(Strider\)

I was building a table-valued function that included this in the WHERE clause: AND tab.SOME_COLUMN = '0148' I wanted to drive the query with a...

bill

07-01-2009 05:01 PM
Erland Sommarskog

Hi! Beeing new to sql-server I look for some pointers. I have a system, written for Oracle that uses sequences in order to get a primary key value. I...

björn lundin

06-29-2009 04:05 PM
Erland Sommarskog

Sorry for the newbie question, but I would like to simply populate a tracking table with 'I', 'U' or 'D' (and the PK id) based on the type of change...

seanD

06-29-2009 04:04 PM
Erland Sommarskog

All, I posted under another thread titled "Trigger, Identify Insert, Update AND delete in one " because I was thinking a trigger was the way to go,...

seanD

06-28-2009 04:44 PM
Hugo Kornelis