Hi every one, I am new to sql server2005,I have datetime column in my database ..I need to display only time part of the datetime .I need to display...

Sreenivas

10-30-2008 11:44 PM
Sreenivas

Hi All, I have another SQL question, and this one is going to be difficult to explain. I have a table like this rowid name ...

bob laughland

10-30-2008 05:02 PM
Hugo Kornelis

I'm having problems using "<>" as criteria for a varchar column in a view. The data in this column is '2008-2009' which is supposed to mean year...

emanning@kumc.edu

10-30-2008 04:48 PM
Andy M

My intial post didn't seem to come out. Let's try again, Hi All, I have another SQL question, and this one is going to be difficult to explain. I...

bob laughland

10-29-2008 04:57 PM
bob laughland

I'm running SQL Server 2008 Developer on Vista Ultimate. I've been a big fan of BitDefender for the last couple of years now, but with the release...

Dave

10-29-2008 04:47 PM
Erland Sommarskog

SQL Server 2005 64-bit 9.00.3042 SP2 When I map a database user to a login, I can specify a default schema for that user. After that, any SQL from...

aj

10-29-2008 04:44 PM
Erland Sommarskog

Hi All, I have a SQL query like this (I have tried to break the problem down to simplify it), select rowid from table where name in ('a', 'b', 'd')...

bob laughland

10-29-2008 03:03 PM
--CELKO--

SQL Server 2005 64-bit 9.00.3042 SP2 While working in SQL Server Mgmt Studio, I wish to maximize/minimize the window (or I guess the tab on the...

aj

10-29-2008 11:49 AM
aj

I'm completely new to SQL and this puzzle is over my head. Any advice would be greatly appreciated. Table: Visits Columns: RecNo VisitNo ...

Gabe

10-28-2008 03:16 PM
Gabe

Having problems adding this where clause (where week_start_date='20081003') I have two dates in the database but I want the count from only...

JJ297

10-27-2008 07:52 AM
Plamen Ratchev

I'm designing a new database from scratch. It has some columns that I currently have as datatype=int with check constraint of x>=1 and x <=32, or...

Tom van Stiphout

10-27-2008 01:06 AM
Martijn Tonies

SQL Server 2005 64-bit 9.00.3042 SP2 I am migrating a database to SQL Server that is not unicode... Assuming that I have no plan to store different...

aj

10-24-2008 04:36 PM
Erland Sommarskog

Hi. I am in a situation with an engineering application involving monitoring of press operations. This involves storage of numbers for both an X and...

jc

10-24-2008 04:20 PM
Erland Sommarskog

SQL Server SP2 9.0.3042 64-bit I recently put my first SQL Server DB in production. In the "other" database that I use (not interested in any...

aj

10-24-2008 08:14 AM
BIGsql

I am writing SQL data apps using VB.NET 2003, MSDE is being used as the server. When I create and instance of the server, it has a the...

David

10-24-2008 01:23 AM
Ravi

I have a table with an Id column as the primary key, and a number of other tables that have a foreign key pointing to the first table. I'm looking...

Tony Mountifield

10-23-2008 04:47 PM
Erland Sommarskog

I have a database backup that our vendor proformed. I dont know if they verified the backup, nor do I have the disk space to create a new backup with...

rcamarda

10-23-2008 04:43 PM
Erland Sommarskog

I am well versed in MS Access. I now want to set up a SQL database on my company's server. However there are some pretty basic questions that I...

BURL ives

10-23-2008 08:57 AM
RRR

The DataServices World conference offers a program for those interested in technology for data integration and data access, with emphasis on...

knorth

10-23-2008 03:08 AM
knorth

I have a need to make a group of records 'unique' by concatenating a foreign key value to another field, the two are float and varchar type. Now,...

Zamdrist

10-22-2008 12:04 AM
--CELKO--

Hi, I have installed free TDS ODBC driver on Linux and from there I am trying to connect to MS SQLSERVER installed on Windows machine. But it gives...

SRK

10-21-2008 04:47 AM
SRK

For some reason my Intellisense doesn't work. I have confirmed that Intellisense is enabled in the option in Tools| Options|Text...

bill

10-19-2008 02:49 PM
bill

Business Intelligence software company, Yellowfin today announced its successful foray into the Asia Pacific telecommunications sector through its...

JTP PR

10-17-2008 09:26 PM
JTP PR

Hi Plamen, Thanks for the quick response. I failed to mention that I am querying a SQL 2000 db. -ben On Oct 17, 2:09*pm, Plamen Ratchev <Pla......

benito

10-17-2008 02:35 PM
benito

Plamen Ratchev helped me at this post: http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/a57716c65bc21a2f# You...

JJ297

10-16-2008 12:31 PM
JJ297

I'm trying to run an import of some data that has unix style carriage returns throughout (ie, 0x0A, or \n). When i use osql to import the data, it...

bobdurie@gmail.com

10-15-2008 04:34 PM
Erland Sommarskog

My clients have asked me to write a service desk application using CRM 4.0. The initial spec. looks promising, and I can't see any technical reason...

teddysnips@hotmail.com

10-15-2008 09:09 AM
aj

Hi, Following is our different database infrastructure. Server1 on NetwrokDomain1 SQL Server 2000 Server2 on NetwrokDomain2 SQL Server 2000 The...

-pb-

10-14-2008 04:51 PM
Erland Sommarskog

I'm wondering if there's some t-sql code that can reset sql server 2005 express's TCP dynamic port from default {1037} or the like to blank and TCP...

DL

10-13-2008 11:11 PM
DL

How to find out what type of the data procedure in MSSQL 2005 returns? Using inquiry about sample. Example: SELECT paramtypes FROM...

mmf.stavelot@gmail.com

10-13-2008 04:38 PM
Erland Sommarskog

You may see this question posted on another usenet group as well.. Can you open a SRS report created in Visual Studio Report Builder or the tools...

Joanne M.

10-13-2008 04:38 PM
Plamen Ratchev

John Rivers (first10 (AT) btinternet (DOT) com) writes: And you ran UPDATE STATISTICS WITH FULLSCAN? Else I agree with Roy. With a new versions of...

John Rivers

10-13-2008 04:34 PM
Erland Sommarskog

How to get the Cell Size Heigh/width before show, CurrentCell is not available before the show() I need to Resize the Datagridview before its...

DaveL

10-13-2008 09:27 AM
DaveL

Hi, The DisableNetworkProtocols = 0 parameter will enable tcp/ip, named pipes and shared memory. However, in my experience, the default...

DL

10-12-2008 09:31 PM
DL

Anybody Know what the leave event is For a Custom and User Controls the WM Constants and Control Constants Thanks DaveL

daveL

10-11-2008 01:01 PM
daveL

Hi all, I had a node failure and rebuild on a sql server 2005 2 node cluster. the server has been rebuilt with new os. i evicted then re-added...

snomad

10-10-2008 05:01 PM
sqlmonkey

Hi, I have a table which has a column of type datetime,i want to write a query where i can get only year from my datetime column. 2004-11-16...

raj

10-10-2008 04:34 PM
sqlmonkey

We have a table in our SQL2005 db with a varbinary(max) column in it. In this field we store images and pdfs that the user has uploaded in our .net...

fraser.jc@gmail.com

10-10-2008 04:33 PM
Erland Sommarskog

Having trouble with inserting a record into a table. It's a list of names. But, for some reason, it won't take a particular name. When a user tries...

Neil

10-10-2008 02:21 AM
Erland Sommarskog

Hi, I use VB 2008 as front end, SQL Server 2005/2008 as back end, I want control number of cucurrent users log on to the database, I am trying to...

kai

10-09-2008 10:19 PM
Andy M

Celko-- You seem to put an awful lot of effort into being a jackass to people asking honest questions. If you put just half of that energy...

CK

10-09-2008 10:09 PM
Roy Harvey (SQL Server MVP)

Why is it important to see Obama's college records? Because the media has created fantasies around Obama on every issue. You should start dispelling...

Micky

10-09-2008 04:03 PM
Micky

I am trying to copy a database from a SQL 2000 SP3 Windows 2000 server to a 2005 SP2 Windows 2003 server. I am trying to use detach and attach method...

dpatel75@gmail.com

10-09-2008 05:33 AM
Dan Guzman

Hi, I have this problem: I use my net user to connect in sql server but when I'm doing this operation I receive a message box: Error 262 Autorization...

nickbeds

10-07-2008 04:35 PM
Erland Sommarskog

Hello. I'm slowly coming to terms with the SQL Server Management Studio 2005. I've really tried, but cannot figure out how to restrict the SSMS...

ildam@moon.sm

10-07-2008 08:18 AM
ildam@moon.sm

Under SSMS where can one find the list of indices? I can see Stored procedures under Programmability. Is there any place where I can see the list of...

Vogon Jeltz

10-03-2008 06:00 AM
Dan Guzman

Can someone help me get the right data out... I want to compare last weeks Table Diary9-22 to this weeks Table Diary9-29 to see if the same PAN...

JJ297

10-02-2008 09:10 PM
--CELKO--

Hello, I need to write a stored procedure that has two different user connections to two different databases. Both db's are on the same one server....

ventalinks@nospammers.com

10-02-2008 04:51 PM
Erland Sommarskog

Hello group, We have recently come up with a problem where SQLServer 2005 differs from 2000. We have an application role, which needs to run DDL to...

JimL

09-30-2008 04:47 PM
Erland Sommarskog

Hi I was wondering if anyone new how to access the call stack information via TSQL I'm currently in the process of migrating an application from...

michael

09-30-2008 04:40 PM
Erland Sommarskog