Dear Professional, I would like to schedule the trace stored procedure to start at 5 AM and end at 6 AM and also would like to specify the specific...

Noor

06-04-2009 08:47 PM
Noor

Hi, I am trying to import data from excel sheet into my SQL server. Actually i was trying out different ways of copying data from MySQL to SQL...

bharath_r

05-28-2009 04:16 PM
Ekrem Önsoy

For clients accessing a MSSQL-Server I need to incorporate the installation of the client connectivity only into my setup. I am not sure what´s the...

Bernd Maierhofer

05-25-2009 06:45 AM
Bernd Maierhofer

Hi! In my SQL Server 2005 management console when I choose Windows Authentication the user name and password entries are grayed out. It puts in the...

Dave Venus

05-22-2009 02:47 PM
Tibor Karaszi

Hi, I need to create a tabular report using the SSAS 2005 cube that has multiple Dimension as Columns and Rows, but NOT Nested. i.e., Quad ...

jasonbub

05-22-2009 11:05 AM
jasonbub

Hi, I have just started using Reporting Services 2005 (I know really bad that I waited this long) and also just started using the Excel 2007...

jasonbub

05-22-2009 10:56 AM
jasonbub

Hello, I asked this in another group, but haven't gotten an answer. I have Visual studio 2008, and sql server express . Can I build an...

Scott Baxter

05-19-2009 06:28 AM
Manpreet Singh

Dear Professional, I would like to ask quick question regarding taking a backup of Log Shipping Secondary Server. I have a primary Server which is...

Noor

05-12-2009 11:54 AM
bass_player

Hello. I have a WSH script which reads in a list of servers from my database (RecordSet("serverName")) and then runs a query against that SQL Server...

Hartman_Ralph@Hotmail.com

05-11-2009 01:21 PM
Ralph Hartman

Dear Professional, I would appreicate if anyone guide me how I know my database has Torn Page problem and how to restore the specific torn page...

Noor

05-10-2009 08:16 PM
Andrew J. Kelly

I have several machines. I would like the projects and solutions i create for SQL Server (ie the nice organization of sql scripts) to be visible...

Steve Schneider

05-10-2009 02:36 PM
Gerry Hickman

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 02: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 08: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 09: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 08: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-21-2009 12:53 AM
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 11: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 08: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 06: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 05: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 02: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 06: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 06: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 07: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 03: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 12:37 PM
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 12:30 PM
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 12:01 PM
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 11: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 04: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 07: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 10: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 08: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 09: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 12:57 PM
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 11: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 04: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 11: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 09: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 09: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 03: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 05: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 10: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 06: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 04: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 01: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 02: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 12:53 PM
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 12:40 PM
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 04:05 PM
William Vaughn \(MVP\)