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 04: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 08: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 10: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 03: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 09: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 03: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 12: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-19-2007 11:28 PM
Sue Hoegemeier

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

Rogers

06-19-2007 10: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 07: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 10: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 08: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 02: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 03: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 02: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 10: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 03: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 01: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 12:09 PM
Hari Prasad

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

Robert Aldwinckle

06-02-2007 02: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 04: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 02: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 09: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 12: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 03: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 05: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 08: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 10: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 11:04 AM
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 07: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 04: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 03: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 09: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 11:37 AM
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 11:10 AM
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 03: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 12: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 04: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 11:11 AM
JPD

I have just moved a database from Access to SQL server 2005 and added three (automatically indexed) full-text indexes. This works fine through my...

jos

05-01-2007 08:43 AM
Roger Wolter[MSFT]

Como puedo transportar de mysql a sql? Un saludo

Oficina

04-30-2007 08:37 PM
Oficina

Hello, I've a lot of sql server 2005 little databases, each one has its own publication to a mobile sql ce database. I'm searching a tool to...

franck

04-30-2007 10:16 AM
franck

Hi experts! When using SQL Server Management Studio to connecto SQL Server 2005, we are given options to connect using Windows authentication or SQL...

William A. J.

04-29-2007 06:34 PM
Sue Hoegemeier

I want to know the datafile and log file for the given input parameter. I am basically creating function and the input parameter would be database...

Rogers

04-28-2007 02:31 PM
Hugo Kornelis

Hope someone here can help me out. I've worked with SqlServer for the past 10 years, unfortunately in my new job they have a mixture of databases....

mfc

04-28-2007 06:46 AM
Richard K

Hi, We have a web application developped in asp.net (I think it's not relevant, but well, it's so you know)... Yesterday, we received the following...

ThunderMusic

04-27-2007 05:08 PM
Goran Sliskovic

I have SQL Server 2005 Standard Edition Service Pack 2, I want to create Database Mirroring, how can I setup? any idea? Thanks

Rogers

04-27-2007 04:34 PM
Lucas Kartawidjaja

I would like to install the SQLNCLI on our IIS machine, and possibly other workstations that need to connect to SQL Server 2005. Where is the...

Greg Larsen

04-24-2007 09:36 AM
Chris Wood

I'm trying to aggregate values and grouping the results by defined periods (6 month, 12 month, 18 month, and lifetime). I'd like to do this with one...

Jeremy

04-23-2007 07:12 PM
Jeremy

All, i want to install a new SQL server. i have HP Proliant DL360 g4p. and i have limited number of hot swapable hard disk drives. now my question...

Kramuddin

04-23-2007 12:09 AM
Warren Brunk