dear sir/madam I have made an project in asp with sql server. All database are without any primary key. In one times many people are doing entry. So...

vinodkus@gmail.com

02-15-2008 12:39 AM
Bob Lehmann

Hi, I am using an ADP file in Access 2007 to connect to a database in SQL Server 2000. I am trying to create new custom categories and groups, but...

I. Kinal

02-14-2008 01:04 AM
Adams Qu [MSFT]

I have a Symbol mobile device with Windows CE 5.0 and I add Microsoft .NET CF 3.5 and Microsoft SQL Client 2.0 My application connects to SQL server...

Ivailo

02-13-2008 01:52 AM
Ivailo

Hi folks I was restoring a database in SQL Server 2005 express edition. Due to a malfunction, system restarted. Now when I try to access the...

Vikas Murarka

02-11-2008 12:22 PM
Russell Fields

I would hightly appreicate if anyone can guide me about Clustering enviroment. Let's say there is a clustering enviornment and there are 12...

Smith

02-09-2008 03:48 PM
Andrew J. Kelly

I have one production server which is very critical and one of our client is having problem in one of the module, is there any way I can use the...

Smith

02-07-2008 01:34 PM
Tibor Karaszi

Two quick questions. 1. I have a stored procedure call SPAccess and in that there are three columns... (now I want if User1 access that stored...

Smith

02-07-2008 12:05 PM
Smith

Dear professional. I would appreciate if anyone can reply me about this. As my understanding and microsoft also recommend that always use Windows...

Smith

02-07-2008 05:18 AM
Ekrem Önsoy

Getting the subject event in the event viewer when trying to connect to a SQL2005 database from a workstation. My other workstations are not...

Absolutely

02-02-2008 05:30 AM
Absolutely

I have created Metrics Report but I am having problem to add summarized detail of my rows and Columns. For instance. Col1 Col2 R1 1 ...

Smith

01-31-2008 05:58 PM
Smith

I cannot display Chinses at ASP page. All chinese data (whatever is Traditional or Simply Chinese) are displayed as ????. My website connect to MS...

HK newsgroup

01-29-2008 02:10 PM
Ekrem Önsoy

Hi Professionals, Following are my queries and I want to recover the table (Test2) with data and recover all the test1 data. I would appreciate if...

Smith

01-26-2008 03:10 AM
Tibor Karaszi

Hi, This is being called in a C# loop within an ado.net transaction from C# 1.1 code. It is used to write large file data to a SQL Server database...

Phil Johnson

01-24-2008 05:42 AM
Phil Johnson

Hello Everybody, my question is the following. how can sort numerically a sql query with varchar field ? thank you for your help. ELE. EG. sort a...

01-23-2008 06:26 PM
Mike C#

Hi Professional, What are difference between DTS and SSIS. Thanks

Smith

01-23-2008 01:11 PM
Ekrem Önsoy

Hi, I have a problem connecting my SQL Server 2005 from a ASP Webpage. When I trying to connect using the following connection...

HK newsgroup

01-23-2008 09:18 AM
Sean McCown

Hi If running in an Enterprise level organisation with separate servers for Development/ Testing, Business Acceptance test and Production is it...

Patrick Flynn

01-16-2008 08:14 AM
Andrew J. Kelly

How to add RESTORE permission to Sql server 2000 & 2005 users. I need to add only Restore permission to the existing user. *** Sent via...

Mohamed Kaleel

01-11-2008 07:27 AM
Russell Fields

How do you keep these CAL's 'safe'? Linchi "Ekrem Önsoy" wrote:

san

01-09-2008 09:10 AM
san

Hi we have one application that does not work in Vista OS. The application uses MDAC and I checked the Vista OS computer and the MDAC version is...

John

01-04-2008 02:47 PM
John

Thanks for the response Ekrem. I had considered that as a solution but I would like to ensure that date/time is accurate by using the date/time of...

Clay

01-02-2008 05:15 PM
Hugo Kornelis

We have recently purchased Small Business Server Premium, with SQL Server 2005 workgroup edition included. I has 3 XP PCs that I want to access...

Andy Baker

01-02-2008 02:44 AM
Ekrem Önsoy

I'm confused about the difference between an ODBC direct query and a SQL passthrough query. Can anyone please help clarify for me? Thanks, Derek.

derek

12-27-2007 03:44 AM
derek

Hi Is there a client for SQL Server 2005 that will run on NT4, or Linux? I only need to run some simple SELECT queries. If not, is the NT...

-

12-26-2007 03:43 PM
Kyle R. Hanrahan

Hi - I'm not sure if this is the correct forum for this question. If it isn't I'd be grateful if someone could direct me to the right...

derek

12-25-2007 08:21 PM
Russell Fields

The reports were moved in sp2 (client) from Summary Window to Object Explorer (right-click). The performance dashboards report is just a...

Vincent D.

12-23-2007 08:05 AM
OgnjenT

Hello people. I have a strange behaviour with a stored procedure. Using management studio procedure executes in 1 second. Using a .net application...

Robson Luiz

12-14-2007 03:31 PM
Andrew J. Kelly

All, I am looking at updating our .Net application to allow off line clients. By this, I mean clients using the .Net app while not connected to the...

Brian P. Hammer

12-09-2007 11:14 PM
Brian P. Hammer

Hi, The adapter in an dataset, via generted code in VS2005, is defined private. How can I set the commantimeout in this case. For example, this a...

Bart

12-07-2007 03:00 AM
Wei Lu [MSFT]

does anyone know how to keep QA from adding the lines setting these two options on and off along with blank lines at the beginning and end of every...

Ted Theo

12-03-2007 03:25 PM
Bill Yanaire

how to find out if a TSQL table is being updated? for example if someone does an update to a table that takes a long time, is there anyway for me to...

DR

12-01-2007 12:45 AM
Mike C#

If I execute ALTER TABLE DROP COLUMN XX but the column XX has Constraints there will be an error. I should first delete the related Constraints. Is...

Jose Nunez

11-26-2007 10:23 AM
Russell Fields

I have a problem where I am trying to isntall emc's documentum e-room. I have already posted on their forum with no help. I have two 2003 servers....

memko

11-23-2007 03:14 AM
memko

How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?

DR

11-21-2007 04:49 PM
Andrew J. Kelly

The company I work for is thinking of implementing two new Windows 2003 servers, and is also wanting to update our backoffice software. The...

MShawRMTD

11-21-2007 10:34 AM
MShawRMTD

Is there any way to add our standard System DSN or equiv, ODBC connections on XP clients via scipt or GPO? THis cannot be the first time this...

totoro

11-20-2007 09:00 PM
jason

I would like to know that I've upgraded SQL 7.0 server to 2000. some of CAL licenses are still 7.0, Does it need to upgrading to 2000 as well?...

kcid169

11-19-2007 10:49 PM
kcid169

Dear all, Urgent help~~~~~ We need install SQL 6.5 Client on Vista. Is there any method to do so? Ivan

Ivan

11-19-2007 11:47 AM
Mohit K. Gupta

Query analyzer for SQL Server 2000 has an option to set the default action when closing queries to "don't save." I can't seem to find this option...

Joe

11-14-2007 10:08 AM
Joe

Ekrem, how would the Generate Scripts wizard generate a visual reporesentation of the structure of the DB? I see how it creates samples...

toney

11-13-2007 03:16 PM
Jesse

I have an ERP system deployed which uses SQL Server, and we are currently looking to update to a new version. The new version and the old version...

Troy F.

11-12-2007 12:00 PM
Troy F.

Hi all, a customer has several SQL Servers 2000 and wants to migrate to SQL 2005. Currently used licensing model is per server and user CAL. Does an...

Mario K.

11-11-2007 05:45 PM
Mario K.

I thought it is wscript..name but I got wscript Host instead of the name of eh script being run what should it be?

GS

11-09-2007 08:24 PM
GS

hi.. i transferred my website folder from my server 2003 to my winxp and installed a sql server 2003 express on my xp pc. wheni tried to browse...

chunky

11-07-2007 05:38 PM
chunky

I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL 2000 here http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx...

Mark

11-05-2007 11:58 AM
Mark

How can I install SQL Server 2005 Business Intelligence on windows XP, is it possible or not. I want to design all my resports through BI, need...

Rogers

11-02-2007 11:03 AM
Ekrem Önsoy

Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml...

DR

11-01-2007 05:05 PM
Mike C#

How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a...

DR

10-30-2007 02:30 PM
DR

Hi All Is there any tools to fix log file my H.D.D have bad sector and that on SQL server directory on my database login file(x_db_login.idf) so I...

MOH. I.OWN

10-26-2007 01:05 PM
Russell Fields

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to...

DR

10-24-2007 09:39 PM
DR