Hi, I've got a problem in that a stored procedure of mine always times out within my application. Realistically there's no need to increase...

hiddenhippo

08-07-2007 06:20 AM
hiddenhippo

Hello All, I have a table with a column called homeMDB which contains data attribute value of users homeMDB from Active directory. There are about...

Yas

08-07-2007 06:05 AM
Yas

I am a single developer, and new to SQL Server. I have Windows XP Pro, and my system has a couple gigs RAM. I would like to know what version of...

Charlie

08-06-2007 05:18 PM
Hugo Kornelis

hi...i would like to know best practice when assigning a value to a variable example below set or select declare @var1 varchar(25) set...

MikeJ

08-06-2007 03:02 PM
MikeJ

Excellent resource on installing exchange server on a cluster: http://it-techexperts.com/MCSE/ESH08.asp

robert.mofta@gmail.com

08-06-2007 03:40 AM
robert.mofta@gmail.com

Hi, I am new to the advanced concepts of SQL server 2005. We have a web application that will be installed at multiple sites across the US. The...

yashgt@gmail.com

08-05-2007 10:32 AM
yashgt@gmail.com

I would like to know if it is possible to use a variable to use with the IF UPDATE(column) statement. Only, the column should be a variable which...

ben@jammin.co.uk

08-03-2007 03:00 PM
David Portas

Hi This is a question of "what does it cost me". Lets say I have an integer value which would fit into a smallint field but the field is actually...

David Greenberg

08-03-2007 11:14 AM
Tony Rogerson

Hi Everybody, I have a probs with dynamic generation. I am writing the probs ====================================== create proc test as declare...

Arijit Chatterjee

08-02-2007 10:15 PM
Ed Murphy

Hi I have a character field (char ot varchar) that I want to force only to contain numeric characters. Can that be done by way of defining a...

David Greenberg

08-02-2007 06:47 PM
Hugo Kornelis

Friends, My Question is related to the DTS Package (Dynamic Properties Task). I have a DTS package, In this, I transfer data from a database...

Rahul

08-02-2007 04:40 AM
Rahul

Friends, My Question is related to the DTS Package (Dynamic Properties Task). I have a DTS package, In this, I transfer data from a database...

Rahul

08-02-2007 04:40 AM
Rahul

Friends, My Question is related to the DTS Package (Dynamic Properties Task). I have a DTS package, In this, I transfer data from a database...

Rahul

08-02-2007 04:40 AM
Rahul

***Hi*** Common scenarios that have solutions described in the Using ISA Server 2004 with Exchange Server 2003 document are there for you to...

patricia.parker02@gmail.com

08-02-2007 02:59 AM
patricia.parker02@gmail.com

hi all. Can i have two instalation of SQL 2000 and SQL 2005 in a single server WIN 2003 as programs seperate, without i have´nt conflict ? If el...

fhernandezve@gmail.com

08-02-2007 02:37 AM
Helmut Woess

As you can probably tell from my query I am not a guru, just trying to "gitter done". This query is for Dynamics GP. It is a select with left outer...

Joanne M.

08-01-2007 06:46 PM
Roy Harvey

Hi, I am trying to generate an XML output form the database. I am executing select * from Request_vw for xml auto The output data is being...

Mo

08-01-2007 03:13 PM
Hugo Kornelis

I am trying to select multiple values from the row with the max id, and output them within my stored procedure. How would I combine the following...

mcolson

08-01-2007 09:04 AM
mcolson

Hello. I am getting the following error: """There are no primary or candidate keys in the referenced table 'UserPrecedence' that match the...

pbd22

07-31-2007 05:48 PM
--CELKO--

An experienced Microsoft Dynamics NAV Consultant is required in our implementation team to assist with the successful implementation and maintenance...

anna

07-31-2007 05:15 AM
anna

Hello Within a DTS I'm performing an update to a table on a different server and to an Ingres database. The update is failing and I'm getting a "no...

David Greenberg

07-30-2007 06:16 AM
David Greenberg

I am trying to create a stored procedure that will add the last two entries from a column. If I had a column named box, I would want to add the two...

mcolson

07-30-2007 05:13 AM
M A Srinivas

Hi. I really need some advice on fine-tuning a stored procedure that is the meat of the search logic on my site. Customers are allowed to save...

pbd22

07-29-2007 05:19 PM
Erland Sommarskog

SQL Server 2000 SP4. I built a large DTS package that grabs a number of tables from an Oracle DB, does some scrubbing and date verification and...

davisutt

07-29-2007 11:54 AM
davisutt

I've now released a successor to my aba_lockinfo, named beta_lockinfo. The main reason there is a new name, so that you (and me!) can run both...

Erland Sommarskog

07-28-2007 06:32 PM
Erland Sommarskog

Is comp.databases.ms-sqlserver more active than microsoft.public.sqlserver.server, or is it the other way around?? Which NG is better for general...

tlyczko

07-28-2007 11:02 AM
Dan Guzman

Hello, I have Table1 with column Email, which has mail addresses in the format 'useremailid@'. Few of these Email values are NULL where no mail...

Yas

07-27-2007 05:58 PM
Erland Sommarskog

Hello, I am trying to pass a variable before run time of an integration package, that would tell that package which other packages to run, based on...

psion

07-27-2007 04:51 PM
psion

Anyone has experience setting up kerberos authentication on SQL Server 2005 on Windows 64 bit? It is working for me on windows 32-bit. I didn't...

louis.lam@guardium.com

07-27-2007 12:43 PM
louis.lam@guardium.com

Hi, I need some help to setup Kerberos Authentication for SQL Server 2000. I believe by default Window authentication in SQL Server is Kerberos. ...

louis.lam@guardium.com

07-27-2007 12:42 PM
louis.lam@guardium.com

Hi, I would much appreciate some help with a work project that is due very soon. I have used a cursor to return the required result from a db table...

Simon Barnett

07-27-2007 05:28 AM
Erland Sommarskog

Hello, We have an XP workstation containing a very important MSDE-based application. Its MSDE database isn't likely to change for quite...

tlyczko

07-26-2007 05:44 PM
Erland Sommarskog

Is there a reasonably simple way to dump an SSRS report into Excel format automatically at a scheduled time without using Report Manager/Report...

Wes Groleau

07-26-2007 05:31 PM
Wes Groleau

Hi all, I have posted a question in the Database design and theory ng, but I expect a lot of you will have suggestions to help me (and that...

Paul

07-26-2007 05:19 PM
Erland Sommarskog

Is it possible to set a variable in a stored procedure equal to a value from a column when that column's respective ID is equal to max(id)-1 ID ...

mcolson

07-26-2007 04:46 PM
Roy Harvey

I'm a long-time DBA w/ a dozen years of experience administering and developing software for first Informix and then DB2 databases on the Linux...

aj

07-26-2007 01:25 PM
aj

Hi, We have a Java application that runs against a variety of backends including Oracle and MSSql 2000 and 2005. Our application has a handful of...

bobdurie@gmail.com

07-25-2007 10:29 PM
Alex Kuznetsov

Hello I am running a DTS (Sql 2000) and transfering data from an SqlServer database to an Ingres database. I am transfering 153k rows. Execution...

David Greenberg

07-25-2007 09:35 AM
mojeza

I have one db test with one .mdf and .ldf file. ..mdf file size is 100mb and for some reson i removed all the tables from that .mdf file and transfer...

ShailendraPune@gmail.com

07-25-2007 04:51 AM
Erland Sommarskog

Hi I'm in Enterprise Manager and have made a change to a row. When I try to update I get a message that says: Transaction cannot start, Firehose...

David Greenberg

07-25-2007 04:50 AM
Erland Sommarskog

I am using SS2005 on XP and things have been good. Today I installed "Microsoft SQL Server 2000 DTS Designer Components" (I can't think of what else...

John

07-24-2007 05:36 PM
John

I don't full have details yet but was hoping somebody has seen this before. A domain group policy change was made to disable the Windows XP...

rdraider

07-24-2007 12:51 PM
rdraider

SQL Server 2005 Technical Articles visit http://free-tech-ebooks.blogspot.com/2007/07/sql-server-2005-technical-articles.html

Free Ebooks

07-24-2007 08:12 AM
Free Ebooks

Free SQL Server 2005 Books Here you can download a complete and updated set of Microsoft's Free Books Online for SQL Server 2005. visit...

Free Ebooks

07-24-2007 08:11 AM
Free Ebooks

Hi, I have an Address table which contains more than one addresses for a particular member. I want to write a query that would only display most...

Rex

07-24-2007 12:46 AM
Rex

I have a column Last_Updated (uniqueidentifier) on a table. I'd like this column to get a new guid (NEWID()) each time any column in the row is...

michael

07-23-2007 06:08 PM
Erland Sommarskog

Hey guys, I have a client that is using a SQL database driven software. SQL and the databases are housed on a separate server, and the software...

alvinstraight38@hotmail.com

07-23-2007 06:05 PM
Erland Sommarskog

Hello Folks, I encountered a problem with SQL server 2000 and UDFs. I have a scalar UDF and a table UDF where I would like the scalar UDF to...

Carsten

07-23-2007 03:35 PM
Gert-Jan Strik

create table table1 (field1 varchar (8), field2 varchar (4)) field1 and field2 together is unique. Example data: Field1 Field2 1 A

gelangov@hotmail.com

07-23-2007 01:33 PM
gelangov@hotmail.com

Anyone who uses SQL Server is familiar with the scripting capabilities that the Enterprise Manager or the SSMS offer. Being able to script an object...

xman

07-23-2007 11:22 AM
xman