I try to invoke Connection Properties dialog box that Visual Studio 2005 use. The dialog that I said is used in many places such as when developers...

=?Utf-8?B?VGVlcmF2ZWU=?=

07-16-2007 01:10 AM
=?Utf-8?B?VGVlcmF2ZWU=?=

When creating an ODBC connection to a SQL server, a handful of PC's do not show a list of drivers to create a connection. To create the connection,...

=?Utf-8?B?Q3V6emk=?=

07-13-2007 03:36 PM
=?Utf-8?B?TW9oaXQgSy4gR3VwdGE=?=

Ok..this is a weird one. When I open up SQL Server Management Studio Express my menubar has multiple instances of the File, Edit, View...menu...

=?Utf-8?B?Sm9obiBTY290dA==?=

07-12-2007 06:30 PM
=?Utf-8?B?TW9oaXQgSy4gR3VwdGE=?=

Hi, A client is having some issues with software (Progress) conflicting with Visual Studio 2005 (related to debugging). As I understand it, Visual...

koenraad@willems.com

07-12-2007 05:31 AM
JPD

Hi, We have 4 workstations that connect to remote SQL servers (2000 & 2005) using SQL Server Management Studio 2005. Whenever we first launch...

EightBall

07-11-2007 09:45 PM
EightBall

Hi, I'm looking for a way to enumerate SQL Server instances on a given server. I've seen the GetDataSources() method of the SqlDataSourceEnumerator...

Arild Bakken

07-11-2007 08:01 AM
Arild Bakken

Is there a function that I can use to multiply all of the values of a column from a result set together? Much like SUM() adds all the values...

Christoph Boget

07-09-2007 02:46 PM
Hugo Kornelis

Hello, Does anyone know how to configure a SQL 2005 Alias where SQL 2000 Clients can access it by name? I migrated a db over to a new server and...

Stewart

07-08-2007 06:25 PM
Roman Rehak

Sure...read up on the subject in books online under the help topic for DBCC SHOWCONTIG. You want to be doing some type of index maintenance on a...

Sue Hoegemeier

07-06-2007 10:46 PM
Sue Hoegemeier

Hi, I have a Access 2003 talking to SQL 2005 express DB via linked tables. I also have .NET forms application that also talks to the SQL DB. I...

Rotsey

07-05-2007 11:24 PM
Sue Hoegemeier

We have an application that requires a different version of .net framework (not 2.0). Can the SQL Server 2005 client tools be installed with a...

=?Utf-8?B?RXN0ZWJhbiBBcnR1cm8=?=

07-05-2007 08:42 PM
Roman Rehak

Hello! I have found a document that says run from command line osql -U sa -i -i instnwnd.sql This file instnwnd.sql exist from where I execute...

TonyJ

07-03-2007 05:33 PM
Joe Yong

Hello! I try to update a database. I have a datagridview that has thrree columns and two rows from beginning. When I make changes in the datagrid...

TonyJ

06-29-2007 09:02 AM
TonyJ

I don't know this is right place to submit this question or not, I have one URL i.e... www.rogers.net right when I type this URL it works perfactly...

Roger

06-26-2007 11:36 AM
Rogers

We have an application that accesses a SQL 2000 server that is running on several Citrix servers. Recently users started getting a message from...

=?Utf-8?B?TGVoclNK?=

06-26-2007 04:23 AM
Wei Lu [MSFT]

Hello there On sql server 2000 if i needed to see all the available servers can be use i was do it with client network utility and server network...

Roy Goldhammer

06-24-2007 10:48 AM
Sue Hoegemeier

i just made the switch from OLEDB to SqlClient in my .Net apps. now with SqlClient often my db calls throw the following...

=?Utf-8?B?cGI=?=

06-20-2007 04:18 PM
Andrew J. Kelly

How can I determine using C# which instances of SQL Server 2000, MSDE, 2005 or 2005 Express, if any, are installed on a client computer? For...

Stratum

06-20-2007 01:57 PM
=?Utf-8?B?T21hciBBd3dhZA==?=

When trying to install sqlncli.msi on Windows XP SP2 I get the following error "The system administrator has set policies to prevent this...

Michael Tissington

06-20-2007 12:28 AM
Sue Hoegemeier

Can I unistall Service Pack 4 or I have to re-install SQL Server again? Thanks

Rogers

06-19-2007 11:05 PM
Hari Prasad

Here's the scenario: One host application that can be connected to either Access, MsSql or MySql. This is decided at the point on installation and...

tc

06-15-2007 08:36 AM
tc

When attempting to view the properties of a database in SQL Server Management Studio we are getting an error dialog that states the...

=?Utf-8?B?bWlrZSBwYWR1bGE=?=

06-14-2007 11:44 AM
Andrew J. Kelly

Hi, I have upgraded to SQL Server2005. I have some tools that seem to only support SQL 2000, and I am wondering if I install the basic connectivity...

Aussie Rules

06-12-2007 09:33 AM
Andrew J. Kelly

Hi, In my program i need to duplicate a table in a current data base. I'm thinkin' of reading the data base columns and then rows and so i create...

Omar Abid

06-11-2007 03:46 PM
Andrew J. Kelly

I want to detach a SQL Server database in SQL Studio. Each time I try, I'm told that the database cannot be detached because it is "busy." It is...

=?Utf-8?B?QWxleCBNYWdoZW4=?=

06-11-2007 04:49 AM
Peter YangMSFT]

Hi, I'm currently developping a forum for my web site and I wanted to include a "read tag" feature to it. This forum stores it's data in a SQL Server...

ThunderMusic

06-08-2007 03:06 PM
Alexey Smirnov

To somebody it has passed that when creating a catalog in sql 2005, the first time that a SELECT carries out it takes 45 seconds, independently of...

=?Utf-8?B?Ym9iYWw=?=

06-08-2007 11:37 AM
=?Utf-8?B?Ym9iYWw=?=

Is there any way to run an optimization and integrity check against the master and msdb databases? Below are the log files. Thanks! - Gabe Microsoft...

Gabe Matteson

06-05-2007 04:02 PM
Gabe Matteson

I'm using the Query Analyzer to open a *.sql file but it returns the error "File myfile.sql contains long line over 64k limit" We are using SQL...

Christoph Boget

06-05-2007 02:34 PM
Christoph Boget

Hi All I am looking for a tool that can fire a profile trace into the database. anyone know of something out there ? Thanks

Elrond Bishop

06-05-2007 01:09 PM
Hari Prasad

"Jim W" <Jim W (AT) discussions (DOT) microsoft.com> wrote .... Try a web...

Robert Aldwinckle

06-02-2007 03:42 PM
Robert Aldwinckle

Not sure if this is the correct group - but couldn't find a specific SBS managed group - and as this relates to the SQL component of SBS it seemed...

manicguitarist

05-31-2007 05:24 AM
Andrew

I have Windows 2003 Server and installed SQL Server 2000 Sp 4 behind the firewall. I open the Portal 3389 TCP, 1433 TCP, 1434 UPD. when I try...

Rogers

05-30-2007 03:13 PM
=?Utf-8?B?bXJkZW5ueQ==?=

In the query analyzer when I run the command create database TestingDb I can see the messages The CREATE DATABASE process is allocating 0.63 MB on...

Rogers

05-26-2007 10:07 PM
Hari Prasad

Dear Professional, I am Using Openrow set command to import the data from Excel sheet, the only worry is, sheets are protected, and I know the...

Roger

05-21-2007 01:42 PM
Roger

Sorry for cross-post, not really sure which group is best.... Is there any way to debug and or see the temporary SPs generated by SQL/Server? I'm...

Philip Warner

05-21-2007 04:21 AM
Philip Warner

Hi, I'm trying to connect to AS2000 using AdoMd.Net 9.0 and I get the following error: {"Retrieving the COM class factory for component with...

Elad

05-19-2007 06:41 PM
Elad

Hi Can anyone point me in the right direction here, I would like to open a table in access 2003 by date. I have an asp web page which needs to read...

Trev

05-17-2007 09:47 AM
Andrew J. Kelly

I would really appreciate if any one let me know the Best Tool for SQL Server Performance, Data Structure Validations and which Microsoft...

Rogers

05-16-2007 11:05 AM
Rogers

I have SQL 2005 installed on a Windows 2003 server. I have installed Backup Exec 10d and get an error when trying to backup the SQL database. I...

microsoft

05-15-2007 12:04 PM
Luis Fernandes

Hi, My problem can be summarized as follows: I have a social networking web site running on asp.net 2.0 and sql 2000. The web site is pretty...

Jeeran

05-13-2007 08:49 AM
Jeeran

I have migrate SQL Server 2000 database into SQL Server 2005 and in all the stored procedures I am using SET BEGIN TRANSACTION but SQL Server...

Rogers

05-11-2007 05:39 PM
Manoj Kumar

Hi, We have a serie of objects stored in the database as xml (ex: MyClass is stored in the table MyClasses in the field XML_MyClassObj which contains...

ThunderMusic

05-11-2007 04:59 PM
Hugo Kornelis

I need to do a complete reistall of XP on my laptop, I have 2000 and 2005 Developer editions installed side by side. I'd like to backup my...

Bumble_Ogere

05-10-2007 10:05 PM
Bumble_Ogere

Hi, Is there any way how to formulate SQL query to select all columns except column D and E? So if the table has the columns A,B,C,D the result...

Lubomir

05-10-2007 12:37 PM
Lubomir

Hi, Where could I find the explanation how to use User, login role, schema objects for SQL Server 2005? The resource I found mostly explain how to...

Lubomir

05-08-2007 12:10 PM
Lubomir

Quick question, I am backing up SQL Server Database every night, I want to encrypt the database backup file? Is there any way through scheduler I...

Rogers

05-07-2007 04:07 AM
jcarlos

When I run the following query in SQL Server 2000, it works fine but when I run into SQL Server 20005, it gave me following error. Msg 8115, Level...

Rogers

05-06-2007 01:09 PM
Anthony Thomas

Kill 142, I was trying to kill one of the session and found the following error. SPID 142: transaction rollback in progress. Estimated rollback...

Rogers

05-04-2007 05:18 PM
Russell Fields

Hi, I am new to SQL Server2005. I have installed it on a computer running Windows 2003 Server as WORKGROUP. I have another computer running...

Dave_R

05-04-2007 12:11 PM
JPD