Hi, Probable there is a simple solution for this, hopefully someone can direct me in the right direction. I have a table with a persons firstname,...

Fiori

09-27-2007 02:06 AM
Fiori

I remember once using a command in Query Analyser that gave me all the information about a table. It showed details about the columns, constraints,...

ben_cameron00@hotmail.com

09-26-2007 04:43 AM
Sems

Hi! I'm using SQL Server 2005. The DB has one table partitioned on 50 Filegroups (One per state) The DB is right now on my drive G: as are the...

Piero 'Giops' Giorgi

09-25-2007 08:16 PM
Piero 'Giops' Giorgi

Hello all, We have a table with about 2 million rows that is used to store log events. The table has an identity column and also a datetime column...

Tommy Hayes

09-25-2007 05:17 PM
Gert-Jan Strik

Hi I'm trying to convert an SQL Query from Access to SQL Server. The Access Query goes like this: SELECT Format(EntryDate, 'ddd mm dd') AS FROM...

rune@totalweb.no

09-25-2007 05:00 PM
Erland Sommarskog

How add column autoincrement in sql server 2005 use SQL Server Management Studio? Tom

info

09-25-2007 04:56 PM
Erland Sommarskog

Hello all, We're currently upgrading to SQL Server 2005 and we're trying to figure out if we should partition some of the tables in the...

Tommy Hayes

09-25-2007 01:41 PM
Piero 'Giops' Giorgi

Security solutions provider EXTOL MSC Berhad has developed a neural network predictive analysis engine and is now working with Australian business...

YellowFin Announcements

09-25-2007 07:35 AM
YellowFin Announcements

So, I have a query SELECT type FROM order, product WHERE order.id = product.id GROUP BY type ORDER BY sum(units) DESC but I only want the first...

Mark

09-25-2007 03:17 AM
Mark

hi all, i need to convert these simple PHP code into stored procedure : <?php $result = mssql_query( "SELECT whid, whcode FROM warehouse" ); while(...

aCe

09-24-2007 09:43 PM
Dan Guzman

Hello, I would like to make a comparison between two databases in SQL server, to find differences between tables, procedures and so on. I have...

ByB

09-24-2007 03:41 PM
dvdtknsn

Would you like to have access contents about .net totally free? Enter right now in www.mrbool.com and get to know our content on net totally for...

Jeff

09-24-2007 02:04 PM
Jeff

We have a field which is decimal (9,2) and another which is decimal (9,3). Is there anyway to subtract the two and get a precision 3 value without...

ibcarolek

09-24-2007 01:50 PM
Roy Harvey (SQL Server MVP)

Ladies, gentlemen, Upscene Productions is proud to announce the next major version of the popular database development tool: " Database Workbench...

Martijn Tonies

09-24-2007 09:38 AM
Martijn Tonies

If i create a simple table with a foreign key constraint, does it create an implicit index on that given ID? I've been told this is done in some...

bobdurie@gmail.com

09-24-2007 09:14 AM
bobdurie@gmail.com

Hello, I try to get an asp site to work on my local machine. Using ASP Studio 2005 and mssql server 2005 eval on win xp, and ms management...

Daniel Loose

09-24-2007 03:35 AM
Jack Vamvas

Dear All, I am using SQL 2005 as pub and SQL EXPRESS as sub with Merge replication. Got the following error message The schema script...

ho.horace@gmail.com

09-23-2007 09:49 PM
ho.horace@gmail.com

When tables are 'variables' you can create what I called a 'Super Function'. Pass any table of the appropriate 'type' to the function, it's that...

steve

09-23-2007 07:01 PM
--CELKO--

Hi I'm running a Windows Server 2003 Enterprise, with an IIS and SQLServer 2000. I need for the SQLServer to be able to send mail's via th...

Finn Stampe Mikkelsen

09-23-2007 05:13 PM
Finn Stampe Mikkelsen

Hello again, and thanx again - I now found something unexpected - that hopefully is the cause of my problem? : In Man. studio > security >...

Daniel Loose

09-22-2007 09:17 AM
Erland Sommarskog

hello, i use ms sql server 2005 evaluation version. i just want to get an asp project to work. not to edit, just to work, on my local machine....

Daniel Loose

09-22-2007 09:14 AM
Erland Sommarskog

I have an audit table that tracks changes to inventory items. I am trying to find the first change in avg_cost per item. The table will contain 1...

rdraider

09-21-2007 06:06 PM
Erland Sommarskog

I have a table (tableA) that lists a number of other tables on the same database. I want to search each table listed in tableA for an existence of an...

krusz10@hotmail.co.uk

09-21-2007 05:23 PM
Erland Sommarskog

Hello! I am pleased to announce that Version 2008 of Altova software, which includes Microsoft SQL Server support across the product line, is...

announce@altova.com

09-21-2007 11:08 AM
announce@altova.com

Hello all, I would like to know how to how to know through sql queries if a job that was processed is still running... I tried to use...

Andy.H.Kwok@gmail.com

09-21-2007 10:05 AM
Jack Vamvas

Everything I read about sp_resetstatus says you must restart SQL after. Is there a way around that (don't want to shut down production). The...

rdraider

09-21-2007 03:14 AM
Erland Sommarskog

I have a table in SQL Server that looks like this: Name Status --------------------------- Steve Complete Steve In...

Terry Olsen

09-20-2007 10:07 PM
Ed Murphy

Hi, I am running the following configuration: Windows Server 2003 Enterprise Edition SP2 ASP.NET 2.0 SQL Server 2005 I currently have a website in...

AMD_GAMER

09-20-2007 10:04 PM
AMD_GAMER

Hello, If I have a database of 5 GB with only 20 tables in it, how many of those can we put in how many database servers on a high end machine (Dual...

sledge

09-20-2007 05:20 PM
Erland Sommarskog

How do I give a Windows group complete rights (including create) to all stored procedures and user defined functions without giving them dbo...

Matthew Wells

09-20-2007 05:15 PM
Erland Sommarskog

I have a view that contains a complex query. A few of the columns call a function that returns a specific output. I also use a function to do a...

mcleana@sympatico.ca

09-20-2007 03:10 PM
Gert-Jan Strik

I have a win2k3 server that i am going to need to upgrade to service pack 2. It is running sql server 2000(sem reports version 8.0 - i think that is...

mmark751969@yahoo.com

09-19-2007 05:22 PM
Erland Sommarskog

Please help. I have Database A (Archived data), Database B (Transactional data). Both A and B do not have any timestamps in any tables. I need to...

rohini.srigiriraju@gmail.com

09-19-2007 05:18 PM
Erland Sommarskog

Hello Newbie here. Is there a way of creating a VIEW...using a stored procedure. I am basically trying to create a view to return some data that I...

apothecary

09-19-2007 11:41 AM
Roy Harvey (MVP)

Hi, I'm trying to create a bunch of scripts that will automatically roll the partitions of one of my database tables. The partition scheme can be...

bobdurie@gmail.com

09-19-2007 10:56 AM
bobdurie@gmail.com

Quantum Compliance System, new Business Intelligence partnership MI, Quantum Compliance System, Inc. is pleased to announce a new business...

YellowFin Announcements

09-19-2007 09:46 AM
YellowFin Announcements

Hi! On our new development environment (Team foundation server 2005) we added scrum. Scrum is using reportserver. We have a Team Project Portal with...

Brian Vind

09-19-2007 03:20 AM
Brian Vind

Hello, I need to create a column that will store hours bigger than 24. For example '25:00:00', '129:23:12', etc). That column will be used too, for...

brazil.mg.marcus.vinicius.lima

09-18-2007 11:39 PM
Roy Harvey (MVP)

Hi, I'm using stored procedures to create an online data dictionary for all of our dbs and I thought it would be very cool if there was a way that I...

vesta

09-18-2007 05:40 PM
Roy Harvey (MVP)

Hi, I'm using stored procedures to create an online data dictionary for all of our dbs and I thought it would be very cool if there was a way that I...

vesta

09-18-2007 01:48 PM
vesta

Hello, I have the following table with 4 columns.... firstname, lastname1, lastname2, EMAIL Table has user names and email, I would like to...

Yas

09-18-2007 08:03 AM
Erland Sommarskog

Hello, How to create system DSN (ODBC) on windows 2003 for SQL Server located on remote machine ? Please, guide me. Bye.

pradeep

09-18-2007 06:17 AM
vijay

I have run into a challenge that I'm not sure how to best solve. I'd appreciate any opinions or input. I am working with a third party database....

James Fraser

09-17-2007 05:27 PM
James Fraser

hello, i have this summarized stored proc. Problem is, when using 'Send', my aspx page reads (asp.net)Request.Form as empty However, when I use a...

Nick Chan

09-16-2007 10:30 PM
Nick Chan

hello, i've just started playing around with rules and udt is it possible to alter rule? are rules 'slower' compared to check constraint?

Nick Chan

09-16-2007 10:25 PM
Nick Chan

Is your website getting very less no. of visitors .If so, then post your website to http://goodtolove.com to get unlimited visitors for lifetime...No...

earn2click@gmail.com

09-16-2007 01:34 PM
earn2click@gmail.com

SQL 2000. I need a query that will search a field in the table that is 14 characters long and begins with a number. I have a client that was...

mike@mcarlson.net

09-16-2007 01:20 AM
--CELKO--

Hi, I have two tables TableA and TableB. I have a stored procedure which runs every morning and based on some logic dumps rows from TableA...

Nick

09-15-2007 05:50 PM
Erland Sommarskog

Hy, could someone help me in this: In design mode, i want to put pictures in database. I made column named pics, and its type as image. How can I...

Zeljko Bilandzija

09-15-2007 05:28 PM
Erland Sommarskog

Hi, I was wondering whether any of you is monitoring MSSQL server 2005 (whatever information could be obtained) from a remote Linux server with the...

aleu@vp.pl

09-15-2007 08:12 AM
aleu@vp.pl