The sql community has paid relatively little attention to L2S/L2E. What attention it has paid has focused on its implementation and not what it...

steve

11-28-2008 05:28 PM
steve

I have a problem trying to set up permissions for a user at my office. He wants to use Microsoft SQL Server Management Studio to view data but does...

mdorais

11-27-2008 04:49 PM
Erland Sommarskog

We are a small pharmaceutical company and we have to gather many documents and to be able to retrieve them quickly as needed. Documents are 1-...

nioski

11-27-2008 11:26 AM
--CELKO--

I am a newbie to SQL Server, I'll apolgise for that 1st. My problem is that the following sql does not seem to work. SET ANSI_NULLS ON GO SET...

Nick 'The Database Guy'

11-26-2008 10:46 AM
Nick 'The Database Guy'

SQL Server 2005 I'm running a stored procedure that uses OLE Automation procedures to make web requests and return the responses. In this case,...

Bill E.

11-26-2008 06:29 AM
Dan Guzman

Hi, is there a rule of thumb what is better/faster/more performant in SQL Server 2005? a) SELECT * FROM A INNER JOIN B ON B.ID = A.ID AND B.Cond1 =...

René

11-25-2008 04:56 AM
René

Hi Guys, Just a quick question on the availability of debugging stored procs. At the moment, if I have an issue, what I do is firstly work out...

Cralis

11-24-2008 05:21 PM
Cralis

Hello, I have an Access 2002 front end that is connected to an SQL Server 2000 back end. The ODBC links connected to the front end are DSNless and...

Rico

11-24-2008 03:53 PM
Tony Toews [MVP]

Hi, I'm working on a Windows 2000 machine which hosts a SQL 2005 Express Database. This database is backed up using the following method...

Magnus.Moraberg@gmail.com

11-24-2008 12:22 PM
patrick61z@yahoo.com

hello, i can login to our network as administrator and windows authetication works fine for sqlserver 2005 when i change to a reg user, i get the...

daveL

11-24-2008 11:21 AM
Jackie Brophy

I want to search a text field to return multiple instances of my search criteria so I can apply a count to find out how many time it appears in...

mail@fuzzygoth.co.uk

11-24-2008 09:52 AM
Plamen Ratchev

Hi all, Could you please advise whether there are documents describing impact of MS SQL server 2005 database size on its performance? I have...

aleu@vp.pl

11-23-2008 10:16 PM
Greg D. Moore \(Strider\)

Hi, Do you know enough about SQL Server locking? I read much of it on the web. But i still have no idea how to do locking with select...

Hacking Bear

11-23-2008 06:11 PM
Hacking Bear

Hi, i want to know what is order of execution in left outer join .. for example in following case A Left outer join B on a.id = b,a_id left outer...

sunil

11-22-2008 10:51 AM
--CELKO--

I need to execute a job on a SQL Express 2005 instance (no SQLAgent). The job will be executed manually by a user, so it doesn't need to be scheduled...

Carlton Kirby

11-21-2008 10:04 PM
Tom van Stiphout

Hi All, I am using a combination of LINQ to SQL and bulk insert. In the process of performing 'one unit of work' I will be doing things...

bob laughland

11-21-2008 01:14 AM
Erland Sommarskog

Is there a way to specify columns using Bulk Insert? For example, if there were 10 columns and I only wanted 8 of those columns, is there a way to...

imani_technology_spam@yahoo.com

11-20-2008 08:39 PM
Tom van Stiphout

Microsoft SQL Server 2005 - 9.00.3054.00 (X64) (Build 3790: Service Pack 2) Last Friday we had a situation where the DNS system inside our Active...

aj

11-20-2008 01:00 AM
Erland Sommarskog

Hi All, I have a system which is running SQL queries almost constantly against a database. One problem I am having is that sometimes queries...

bob laughland

11-20-2008 12:55 AM
Erland Sommarskog

We are using SQL Server 2005. The SP in question is a fairly simple select statement. When the developers run their unit tests it is timing out (15...

Thomas R. Hummel

11-19-2008 12:13 AM
dkatulic

I'm trying to make some c#. I have a sqldatareader to get the logical file names from *.BAK files. It works on the default instance but if I add a...

mastershake

11-18-2008 03:03 PM
Erland Sommarskog

Folks, Having read the posts on clustered indexes and the on-line books I am still a little unclear as to what actually happens when a...

Tim

11-18-2008 02:56 PM
Erland Sommarskog

Hi All, I am using a combination of LINQ to SQL and bulk insert. In the process of performing 'one unit of work' I will be doing things...

bob laughland

11-17-2008 04:20 PM
bob laughland

In SQL 2005 I'm writing a query that works fine as an inner select or a join but I know there's gotta be a way to do it without doing either of...

npikes@gmail.com

11-17-2008 09:43 AM
npikes@gmail.com

I'm installing sql server 2005 express distribution version on an Asus EEE PC with XP home OS, and doing installing and uninstalling several times,...

DL

11-16-2008 05:53 PM
Erland Sommarskog

Folks, Can anyone thow some clarifying light on the following? I have come across a column with the same name and same data contents defined on...

Tim

11-15-2008 04:48 PM
Hugo Kornelis

I mean, sql server version wise, 2000 and above, and computer OS primary XP (Pro or Home), and to determine it/them from DOS command line...

DL

11-14-2008 06:54 PM
DL

I sometimes begin a script like this: ------------------------------------------------------------- if exists (select * from sysobjects where name =...

Dom

11-14-2008 12:34 PM
Plamen Ratchev

Hi, I've done several database apps with PHP to SQL, or C++ to MS Access, etc. And I went to the VS2005 / SQL 2005 launch event where the presented...

HumanJHawkins

11-13-2008 04:46 PM
Erland Sommarskog

Hi, I am new to ssis, but not to ye olde dts. I just used the wizard to create a package that imports a bunch of tables. I will be using it to sync...

Pachydermitis

11-13-2008 04:38 PM
Pachydermitis

Hi all, I have 3 tables: Order Header (oh) order header info (inv_no customer, address, date, etc) Order Line (ol) order line detail (items...

Artie

11-13-2008 09:50 AM
--CELKO--

Hi : I have a stored procedure which does a crosstab query and builds a table with differing number of columns and differeing columnnames...

thetaamommy@gmail.com

11-11-2008 03:15 PM
gsemailrec@gmail.com

I am really really new to sql,please forgive my ignorence. here is my problem I have this table named mis_outtrack desc...

skywalker

11-11-2008 04:40 AM
Tony Mountifield

Hi, I have a few legacy systems to which I need to export data from SQL server 2000. The export should be done every one or two hours, so there's...

GerdBrix@gmail.com

11-11-2008 02:22 AM
Gerd Brix

Sid B (siliconpi (AT) gmail (DOT) com) writes: That sounds scary! Well, my expertise is SQL Server, so I cannot comment on that part. The hardware...

Erland Sommarskog

11-10-2008 12:51 AM
Terje Mathisen

Hi all is there a simple command where I can just copy some data from one database server to another? For example, lets say i have two servers that...

Dev guy

11-09-2008 04:47 PM
Erland Sommarskog

Sid B wrote: You'd be better off asking on comp.arch.storage, or better yet IBM support, because it definitely shouldn't be doing this. -- Nik...

nik Simpson

11-07-2008 09:26 AM
nik Simpson

Hi Is there any way of aborting a stored procedure? I'd want to do this from c# using async connections but if its possible from query analyser I'd...

codefragment@googlemail.com

11-07-2008 07:34 AM
Dan Guzman

Hi I'm trying to get the InfoMessage code below working. What I'm finding is that the print statements have to be before the select statement, which...

codefragment@googlemail.com

11-07-2008 02:19 AM
codefragment@googlemail.com

Hi, I am trying to insert a TIME value in a SQL Server 2008 database using a simple ODBC C program. I follow the steps below: 1. Connect and...

Navs

11-05-2008 04:45 PM
Erland Sommarskog

Hello I haven't found any solution neigther on MSDN Website nor Books online so decided to ask a question to real experts :-) I'm quite new to SSIS...

Pawel

11-05-2008 05:07 AM
Pawel

Hell, Did any of you ever encounter a problem where windows 2003 server sp2 was showing the wrong "free space reading" on a volume on which I...

Maciej

11-04-2008 07:27 AM
Maciej

I posted this at SqlServer-programming group, but got no responses. We have two servers, one MS SQL Server, the other Oracle. Sometimes I need to...

Dom

11-03-2008 05:17 PM
Geoff Muldoon

I need a user to have access to track all processes logged into our SQL Server. In other words, I need them to be able to...

Richard

11-03-2008 04:48 PM
Erland Sommarskog

Hi All I have a search webpage with 10 textboxes, like customerid, customername, costcenter, business, zipcode , etc. Now the user can enter any of...

thetaamommy@gmail.com

11-03-2008 11:04 AM
thetaamommy@gmail.com

Hi every one, I need to compare to datetime values , done in stored procedure.The input datetime parameter is in dd/mm/yyyy hh:mm:ss AM/PM format...

Sreenivas

11-02-2008 10:39 PM
Sreenivas

The age-old question: does size really matter? I mean code size - get your minds out of the gutter! I have a table to store customer discounts (SQL...

Artie

11-02-2008 09:29 PM
bill

I need to write a stored procedure that selects from a table and returns the result set. I don't always know the TableSchema that I need to use when...

billmaclean1@gmail.com

11-02-2008 09:25 PM
bill

I want to create some volume metrics, and I need to produce a report that shows how many rows were inserted by minute into a particular table. This...

bill

11-02-2008 02:13 AM
John Smith

Dear Experts, We need to design a database which has an audit trail for updates to a certain set of tables. The two main approaches I've seen for...

Emin

11-01-2008 02:05 PM
--CELKO--