| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 2 | 119 |
|  | 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 | 0 | 96 |
|  | 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 | 4 | 118 |
|  | 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] | 2 | 129 |
|  | 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 | 1 | 94 |
|  | 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 | 4 | 149 |
|  | 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==?= | 1 | 106 |
|  | 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 | 1 | 113 |
|  | 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 | 1 | 109 |
|  | 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 | 0 | 91 |
|  | 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 | 3 | 115 |
|  | 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 | 3 | 108 |
|  | 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 | 1 | 113 |
|  | 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] | 2 | 116 |
|  | 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 | 1 | 115 |
|  | 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=?= | 0 | 103 |
|  | 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 | 2 | 88 |
|  | 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 | 0 | 145 |
|  | 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 | 1 | 96 |
|  | "Jim W" <Jim W (AT) discussions (DOT) microsoft.com> wrote
....
Try a web...
Robert Aldwinckle
|
06-02-2007 02:42 PM
Robert Aldwinckle | 0 | 97 |
|  | 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 | 2 | 144 |
|  | 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==?= | 3 | 143 |
|  | 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 | 1 | 156 |
|  | 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 | 0 | 462 |
|  | 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 | 0 | 118 |
|  | 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 | 1 | 329 |
|  | 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 | 1 | 122 |
|  | 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 | 2 | 457 |
|  | 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 | 7 | 956 |
|  | 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 | 0 | 104 |
|  | 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 | 4 | 430 |
|  | 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 | 1 | 103 |
|  | 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 | 4 | 128 |
|  | 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 | 9 | 146 |
|  | 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 | 2 | 108 |
|  | 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 | 2 | 155 |
|  | 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 | 2 | 131 |
|  | 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 | 1 | 155 |
|  | 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 | 1 | 113 |
|  | 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] | 1 | 129 |
|  | Como puedo transportar de mysql a sql?
Un saludo
Oficina
|
04-30-2007 08:37 PM
Oficina | 0 | 432 |
|  | 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 | 0 | 124 |
|  | 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 | 13 | 463 |
|  | 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 | 3 | 133 |
|  | 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 | 1 | 154 |
|  | 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 | 3 | 130 |
|  | 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 | 2 | 134 |
|  | 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 | 1 | 159 |
|  | 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 | 5 | 107 |
|  | 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 | 1 | 452 |