Hello All, We got a new product we've recently launched, it's a query tool and its still in beta, and we're giving it for free to...

Itamar

05-08-2009 01:28 PM
Itamar

Dear Professional, Quick question, let’s say Log Shipping is already in place from Primary to Secondary, what if I shrink the .ldf file on Primary...

Rogers

05-01-2009 07:31 AM
Balmukund

Currently. Log Shipping is in place and every hald an hour I take log backup and that has 100 MB in Size but the only problem is MyDB.ldf file size...

Noor

04-24-2009 08:47 PM
Ekrem Önsoy

Hello Professional, I would like to ask one quick question regarding Maintainance Plan -> Rebuild Index Task. I have created Maintainance Plan and...

Noor

04-22-2009 07:11 PM
Noor

Hi, We have a database in SQL 2005 Server. We would like our Excel 2007 users to be able to create queries and receive the data in Excel. The users...

Gerry Hickman

04-20-2009 11:53 PM
Mark Han[MSFT]

Thank you for your reply. I can get everything except Business Intelligence Studio working by installing VS 2008 first patching it up to SP1 and...

Derek

04-20-2009 10:37 AM
Gerry Hickman

Quick Question, I am running following query from my two different Server. Both have linked server to one of production server. Server1. Select...

Rogers

04-06-2009 07:17 PM
Noor

Guys, I would appreciate if anyone help me out. Let’s say we have DBServer1 & DBServer2 on Montreal and DBServer3 on Toronto. DBServer1 &...

Rogers

04-03-2009 05:48 AM
Ekrem Önsoy

I am trying to install SP3 on an XP client. Getting the error A recently applied update, KB955706, failed to install. Summary log says Product ...

PM in Texas

04-02-2009 04:55 PM
SQL Squirrel

Dear Professional, Just want to ask one question. Three months a ago one of my database size was 5 GB and now it's 12 GB but I didn't see much data...

Noor

03-30-2009 01:02 AM
Tibor Karaszi

Dear Professional, I am using following query but I would like to get all the records which has address2 means NOT Null, how I can handle NULL in...

Noor

03-29-2009 05:20 PM
Noor

Dear Professional. I want to capture login activity of client . I have following events for now. Login Logout Secret password changed. Place order

Noor

03-28-2009 05:43 PM
Noor

Hi We have 2 servers the same config that uses ODBC to connect to SQL2000 server and specifically a custom database. Until last week all was...

IanNew

03-24-2009 06:08 AM
IanNew

Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error...

Marco Pais

03-23-2009 02:05 AM
Deepak Janghela

Wish to learn SQL..pls help :) hi all i am interested in learning SQL but i cant afford to buy any software since i am broke :( is there an easy...

Chris White

03-22-2009 11:37 AM
Brett

Hello Guys, I would appreciate if you can provide me step by step configuring Witness Server for Database Mirroring. Quick question, let's say we...

Rogers

03-22-2009 11:30 AM
Brett

Hello, Is there a simple answer to this simple question? How to import fixed-width text file? I know the width of the columns but there are so...

Tom

03-20-2009 11:01 AM
Ilya Margolin

I keep getting the message to update SQL Server 2005 SP2, I check OK and it goes through process. But a few hours later the same thing. How do I...

pestocat

03-19-2009 10:32 PM
pestocat

Hi, i have a VB6 app which connects via SQL native client 2005 to a SQL Server 2005 Express Edition SP3 Instance. OS: XP Prof SP3 On 1 XP machine,...

Christopher Schlueter

03-16-2009 03:55 AM
Christopher Schlueter

Hi I am a SQL new bie. I searched the forum but couldn't find an exact match of my requirements. Apologies if I had created a new thread for an...

lann

03-13-2009 06:32 AM
Russell Fields

Hi to All, i'm working on SQL 2005 and C# and in my app ( multithread and multiprocess ) sometime i have the following...

Massimo

03-12-2009 09:52 AM
Ekrem Önsoy

Does anyone know how an application running on HP-UX can access a SQL Server database? I have an application running running on HP-UX that needs to...

Scott McKevitt

03-06-2009 07:47 PM
Bunny

I'm trying to install the SQL 2005 client tools on an XP SP3 box. The installation errors out at the MSXML6 installation. Some have said...

Bond

03-05-2009 08:51 AM
Bond

Hi I have a SQL 2005 server and there's an issue with connectining to SQL engine through Server Management Studio within the server. Then I found...

Santa

03-02-2009 11:57 AM
Mohit K. Gupta

How do I get a reference to SQL Server so that this code will compile? Dim sqlCnn As New SqlConnection Can you point me to a good tutorial on...

walter1234

03-02-2009 10:07 AM
Mohit K. Gupta

Hi and thanks for your reply, If I have read this MS KB ok... http://support.microsoft.com/kb/269882 "The firewall must be configured to permit...

Tristan Leask

03-02-2009 03:37 AM
Tristan Leask

Hi everyone, Ok, basically I am in the process of trying to sort my app out with unicode support. A good way of doing this would be to use ADO. ...

Tristan Leask

02-26-2009 10:52 AM
Mohit K. Gupta

Dear Professional, I am creating new stored procedure but before inserting new row in the table I am using MAX(ID) + 1 to get the maximum nunmber...

Rogers

02-24-2009 08:27 AM
Aaron Nelson

Dear all, I have the following questions: 1. How many SQL server 2008 and Express can be installed per domain? can you refer me to any MS...

thaar

02-24-2009 08:23 AM
Aaron Nelson

Yup and contrary to the ODBC and OLEDB Providers, backward and/or forward compatibility is not guaranteed between either DMO or SMO and the...

thaar

02-24-2009 02:49 AM
Sylvain Lafontaine

I have MS sqlserver 2005, and want to install a client in a PC. I expect the SQLCMD to be installed, but the installation finishes and the SQL comand...

Maria Bravo

02-21-2009 04:33 PM
William Vaughn \(MVP\)

Dear Professionals, I would appreciate if anyone can give me pros and cons of SQL Server COLLATION Settings at database or column levels. Thanks

Rogers

02-20-2009 09:45 AM
Russell Fields

Tengo una aplicacion que utiliza SQL 2005 , al generar un reporte en una maquina que tiene instalado windows xp envia un mensaje de error que es...

Armando

02-18-2009 05:57 PM
Armando

Hello Professional. I am working in Trading Firm and you can imagine how many transactions would be in place per second, I was thinking to implement...

Noor

02-18-2009 03:32 PM
Rogers

Dear All, My client is requesting to have a visual differentiation of Prod / non Prod environment in SQL Server Management Studio 2005 (SSMS) used...

Stefan[www.itsconsulting.fr]

02-18-2009 12:59 PM
Sylvain Lafontaine

WE are seeing the following problem. Share point running slow. We are seeing oneissue that may be a...

William

02-18-2009 01:44 AM
William

I'm reinstalling apps on my system and wanted to know which SQL Server version I should install. I'm debating between 2005 and 2008, but I have lots...

Shawn Ferguson

02-17-2009 11:53 AM
Russell Fields

Hi, I am not even sure if this is the right place to post, and I will admit upfront I am fairly new at SQL programming. I have written an...

jdc

02-13-2009 11:40 AM
Rick Byham, \(MSFT\)

Hi, Is there any limit on number of connection on Sql Express 2008. If yes then how many? Thanks

Piyush Trivedi

02-10-2009 03:05 PM
William Vaughn \(MVP\)

In MS Excel, one can select the header row of a worksheet and double click any one of the column separators, and all columns will expand to...

Dick Rempfer

02-03-2009 05:31 AM
Manpreet Singh

In query analyzer when I performed a results to text query, within the results pane on the status line on the bottom, the line number and...

Tom Frost

01-30-2009 03:06 AM
Charles Wang [MSFT]

I'm receiving the following messsage from a SQL 2008 Client when I attempt to open a DTS package for editing from a registered SQL 2000 Server . I...

Tom Frost

01-12-2009 08:00 AM
Russell Fields

In my organization we were thinking to use BIP IP for load balancing and in the database end we use Peer to Peer to replication so that BIG IP...

Rogers

12-29-2008 02:47 AM
Ekrem Önsoy

This question pertains to the Query Plan for views. Assume that I have a table of 10,000 widgets (widgets_table) with a primary key on the identity...

Dave

12-25-2008 12:44 AM
Mark Han[MSFT]

I am reading a list of tables from a table and wish to execute a SQL statement for each table from this list. I tried declaring...

Timothy Peer

12-10-2008 09:09 AM
Lawrence Garvin

Hi, Is there a way to change object browser fonts, size, and weight in Management Studio? I don't see the object browser listed in Fonts and Colors...

Alan Z. Scharf

12-04-2008 03:39 PM
Ashton Hobbs

I have a table called Accounts_History that has 10860150 rows right now and when I run DBCC SHOWCONTIG ('accounts_history'), I got this result DBCC...

Rogers

11-27-2008 01:45 AM
Tibor Karaszi

On a Windows XP that has SP3 I have installed SQL 2000 Client drivers. However I am unable to install any MDAC or SQL 2000 SP (3a or 4) to update the...

Robin9876

11-21-2008 11:04 AM
Robin9876

Hello, I am using Expressing Web 2 and also I have a FTP program. Can you help with a step by step article to create a new database ? I would like...

Gary LsuEduLive Adams

11-21-2008 08:55 AM
Gary LsuEduLive Adams

Are you using a beta, RC0 or RC0+CU1? What OS are you running? "Bill MacLean" wrote:

Jorge Segarra

11-20-2008 01:30 PM
Jorge Segarra