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 06: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 04: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 09: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 03: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 01: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 10: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 04: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 02: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 12:04 PM
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 09: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 02:30 PM
Jorge Segarra

Please let me know if there's a more appropriate forum to post this question. I am automating a MS Access report header to display a report caption...

adrianne

11-20-2008 04:15 AM
Charles Wang [MSFT]

I have dysfunction in SQL Server 2008 Express I'm sorry to bother you, but I have no one else to ask. I installed on my computer C# 2008 Express and...

Sergey Topychkanov

11-19-2008 09:15 AM
Sergey Topychkanov

Hi, Is there a way to prove, or not, that under the same hardware configuration with the same databases SQL Server Enterprise is faster than the...

Tecnica

10-28-2008 03:11 PM
Mohit K. Gupta

Hi all, I want a trigger to get fired when my application's connection to the database gets disconnected. Currently I am able to find out using...

Shilpa Uttarwar

10-20-2008 11:08 AM
Russell Fields

I have a client software connecting to my SQL 2000 DB (running on SQL Server 9.0.3054). When they perform some operations on the client (which...

TCorp

10-07-2008 05:35 PM
TCorp

It is because your file is missing the UTF16LE Byte order mark. Without it SSMS cannot detect its encoding. Regards, Peter

Tom Baxter

10-02-2008 10:40 AM
Tom Baxter

Group, I have a application that is distributed to a large corporation with close to 1000 users that will be connecting to a SQL Server 2005...

Mike Johnson

09-30-2008 02:10 PM
Ekrem Önsoy

Hi This is my sql query . Select * into tmp_table1 from table1 . If i the above query more than once in the sqlserver 2000 DB , it shows the...

Raghu Raman

09-26-2008 12:04 PM
Rick Byham, \(MSFT\)

Hi there, Hope someone can help me out here. I've had a long running problem with SQLserver 2005 (Standard, Developers and Express). When I try to...

Andy

09-26-2008 09:56 AM
Mohit K. Gupta

Peer to Peer replication is two way replication right not the one way? like the same we have in SQL Server 2000 for Merge...

Noor

09-23-2008 01:37 AM
Tibor Karaszi

I have production SQL Server Standard Edition and found that SQL Server is eating 95% of memory. We have 8 GB memory installed on the Server and...

Rogers

09-21-2008 01:40 PM
Noor

Do we have Business Intelligence Development(BIDS) Studio In SQL Server2005 Client. Please clarify. *** Sent via Developersdex...

Ahamed Faridh

09-11-2008 02:12 PM
Ahamed Faridh

"Pascal Deliot" wrote:

Rogers

09-11-2008 12:59 PM
Rick Byham, \(MSFT\)

Hi , I've configure a sql 2005 server DB mail. I'm not able to send email with attachment bigger than 5 MB. But I'm able to send a mail with...

Rajesh

09-07-2008 10:06 PM
Linchi Shea

I need to buy a sql server standard edition for an intranet application. From MS site I see that you can license sql standard edition "per...

Francesco

08-27-2008 06:45 PM
Sylvain Lafontaine

Hi, I am exploring sql server 2008 and installed it on my xp with management studio. I have few applications wich use databases on sql server 2000....

Sunny

08-26-2008 04:04 PM
Ekrem Önsoy

I just installed SQL Server 2005 Developer edition and a client browser is not installed. 2003 came with a brower and a sample database. Is there...

john coltrane

08-21-2008 04:15 PM
Ekrem Önsoy

Currently I am working on Authentication Database, the problem is I have to capture so many thing in terms of users authentication. 1. Date / Time...

Noor

08-21-2008 03:37 AM
Manpreet Singh

I want to copy a database to the same server but with a new name - in fact I want to make a copy for developing Can the "copy database wizard" be...

KSor

08-21-2008 02:36 AM
Manpreet Singh

Dear Professional, I am pretty much confused in capturing each event of login in to Historical databse and in one point of time we are expecting...

Noor

08-21-2008 02:17 AM
Manpreet Singh

I have a problem trying to connect to sql server 2005 remotely. I have two sql servers in my place of work in the same network. I'm trying to...

Chris

08-21-2008 01:30 AM
Manpreet Singh

Dear Professional, I am working on implementing database standards on my organization, I would appreciate if any one can send me any doc or any link...

Noor

08-21-2008 01:07 AM
Manpreet Singh

Hello, The named SQL EXPRESS instance that I have installed will not start. I opened up the list of services (in the Computer Management Console)...

Adam Porter

08-13-2008 04:22 PM
Adam Porter

I get connection failed errors trying to set up a ODBC connection (On XP ! SQL Server 2005 !) ( I have S.M. Studio Express running, so it's there) I...

barret bonden

08-08-2008 09:59 PM
Andrew J. Kelly

How can I get a list of settings on my SQL-server - 2005 version ? Best regards KSor

KSor

08-05-2008 12:18 PM
KS

I've just recvd a new laptop and am in process of re-installing the SQL 2000 client . I wanted to transfer all the server rregistrations and...

Tom Frost

08-03-2008 11:57 PM
Charles Wang [MSFT]

Hi, Pelase find the MS SQL 2005 Certification Dumps at http://itjobguru.com/forum/viewtopic.php?f=54&t=351 Regards, Naveen

Naveen

07-24-2008 02:37 PM
Naveen

Dear Professional, I have three questions First question Currently I am working on Authentication Database, the problem is I have to capture so...

Noor

07-20-2008 04:01 PM
Hugo Kornelis

not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local...

Glenn

07-19-2008 12:41 PM
Ekrem Önsoy

Dear Professional, I had serious debate in my organization and I told to my developers to use Error Handling in Stored procedure BEGIN TRY END TRY...

Rogers

07-19-2008 10:20 AM
Noor

Hi Guys... I have 2 aplications App1 and App2. App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK! App1 access Server1 (Sqlserver ent...

Fabio Martins

07-11-2008 04:42 PM
Fabio Martins

I am trying to change the SQL Service account from LocalSystem on my Win XP machine to a local account that I created. I have followed the MS...

kalvin.tuel@gmail.com

07-10-2008 03:34 PM
Ekrem Önsoy

I tried this, but was unable to see anything for SQL Server. I am "guessing" that the migration to this PC simply did not handle that correctly. I...

PatK

07-10-2008 08:15 AM
Linchi Shea

I need to obtain sql 2000 personal edition but I only have the standard and enterprise editions on cd. Do I still need to purchase this edition...

BenBreaks

07-08-2008 08:17 PM
BenBreaks

Dear Professional, I would like to ask couple of question in terms of Load Balancing, Replication, Database Mirroring. 1. Our organization has two...

Noor

07-04-2008 11:09 PM
Rogers

Hi there: I'm trying to code a page (ASP .NET) that accesses SQL Server 2005 Express installed in my own machine. When vewing it on a browser, SQL...

Rafael Soteldo

07-04-2008 10:09 PM
Rafael Soteldo

How can I update my SQL-server - not the Windows on the server it's installed but the SQL-server software itself ? Can I just turn to the usual...

KSO

07-02-2008 06:22 PM
Linchi Shea

Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I...

Travis McGee

06-29-2008 02:44 AM
Michael Coles

I have a problem that has caused whatever hairs on my head that I had left to disappear. I distributed an application in a pilot program to over...

Mike Johnson

06-27-2008 09:45 PM
Mike Johnson