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 09:43 AM
Roger Wolter[MSFT]

Como puedo transportar de mysql a sql? Un saludo

Oficina

04-30-2007 09: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 11: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 07: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 03: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 07: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 06: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 05: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 10: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 08: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 01:09 AM
Warren Brunk

I want to import and export data in SQL Server 2005, how can I do through in Microsoft Sql Server Management Studio.. Thanks

Rogers

04-20-2007 02:48 PM
Russell Fields

Is it possible to connect to a Sql Server 2005 with Sql Client 2000? We have a piece of software that only communicates with the 2000 client but...

Geoff

04-19-2007 11:28 PM
Hari Prasad

Log Shipping.... In my organization we had implemented Disaster Recovery (Log Shipping) but Log File size is increasing gradually (140 GB) and Data...

Rogers

04-19-2007 10:09 AM
Andrew J. Kelly

Hello everyone, We hit a snag after installing SP2 for SQL Server 2005 Standard. Basically, when we want to script the database the server takes...

GAZ

04-19-2007 09:45 AM
GAZ

I would appreciate if any one can guide me or send me any stored procedure through which I can accept the Excel file from User Interface, save it...

Roger

04-18-2007 03:40 PM
Steve Thompson

Hi, I have the value 1234.1234 in a decimal field, converted to binary (cast(myField as binary(13)), it gives 0x000000000013060001883a8f49. When...

ThunderMusic

04-16-2007 01:43 PM
ThunderMusic

Hi, I want to use bulk insert and would really like to use character file because it would mean less work from our application, but we cannot...

ThunderMusic

04-16-2007 08:46 AM
ThunderMusic

i have just installed sql clinet (Microsoft SQL Enterprise Manager Microsoft Corporation Version: 8.0) on windows XP sp2 . whenever i try to reg new...

moharil

04-14-2007 02:31 PM
Anthony Thomas

Hola !!! Deseo que me ayuden en una aplicación en VISUAL BASIC ASP.NET, tengo una tabla con 2 campos nombre de la persona y un campo memo donde...

yjaramillo

04-13-2007 07:19 PM
yjaramillo

I would appreciate if any one send me the step by step link like how to create SSIS package and implement this in SQL Server 2005. Thanks

Rogers

04-12-2007 02:18 PM
Andrew J. Kelly

Hi. I'm having some problems getting a Null value into an SQL DateTime field. I'm all googled out, but I did find a bit of code using...

tclancey

04-10-2007 07:37 AM
tclancey

Hi All. First time working on an SQL database. I'm able to create all my tables and fields without errors. I can work eith the back end pretty...

tclancey

04-06-2007 03:32 PM
Hugo Kornelis

I can't see any SQL Management tools after installed SQL 2005. How can I see the database by tools just like what we had in SQL 2000?

Kit Wong

04-06-2007 08:10 AM
Hari Prasad

Can anybody let me know how I can do Encryption and Decryption of data in SQL Server 2000 Database Thanks

Rogers

04-04-2007 10:16 PM
Mike C#

Hi, SQL 2005 EE is installed on W2k3 box and firewall is off in this server. From my client machine, my window account and that developer window...

Lynn

04-02-2007 01:16 PM
Lynn

Hi I wanted to know the steps to install the report designer... I have the foll. installed on my machine ASP.NET 1.1 Version > SQL Server 2000...

joju

03-31-2007 07:05 AM
Jens K. Suessmeyer

Scenario: We have 35 Citrix client machines needing to connect to SQL Server 2005 Std. Question: Do I need to purchase 35 User CALS. I think I know...

Paul Simpson

03-31-2007 07:01 AM
Jens K. Suessmeyer

Hi, What I want to do is a Select on a table that adds a dynamic column like let's say Select T.*, GetDate() From MyTable T; My example is not...

ThunderMusic

03-29-2007 01:00 PM
Andrew J. Kelly

Just wondering, If I take the SQL Server 2005 backup and can it be restoreable in SQL Server 2000?

Rogers

03-27-2007 10:34 PM
Hari Prasad

Dear MSFT I have TSQL scripts from SQL 2000. In the past, I used the ISQL utility to execute and the scripts worked. I changed the host from ISQL to...

Robert Livermore

03-27-2007 07:17 PM
Robert Livermore

I have a text column table and that contains 3000 records but when I try to use top 10 query and include text column it take 10 minutes and when...

Rogers

03-26-2007 02:49 PM
Russell Fields

Say you have an SQL2005 Workgroup Edition server with per user licensing, and lets say you have 5 user cals. What happens when a 6th user tries to...

Rich

03-26-2007 06:15 AM
Rich

Per a previous suggestion that may be acceptable to the group. If anyone is interested in any of the below-mentioned courses at a Microsoft CTC...

VCM Network

03-23-2007 11:19 AM
VCM Network

I located the following titles and dates of courses being held in Chicago: 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 04-05-07 2071...

VCM Network

03-23-2007 07:57 AM
Jens K. Suessmeyer

Hi, I'm about to start an evaluation of SQL Server 2005. The development platform we use is Visual Studio 2003 - ie .NET 1.1. I understand that...

delard

03-23-2007 07:56 AM
Jens K. Suessmeyer

Hello, I am trying to use the SqlDependency object to maintain a current dataset on my client code. However, whenever I try to implement it, the...

Netanel Livni

03-23-2007 07:55 AM
Jens K. Suessmeyer

Hi, How to activate the Agent on SQLExpress05? TIA Ana -------------------------------------------------------------------------------- Estoy...

Ana

03-21-2007 10:02 PM
Hari Prasad

Hi everyone, I'm quite new to SQL Server so maybe this is an easy question but I haven't found the answer after 3+ hours of Googling and...

Robin Bowning

03-19-2007 06:40 PM
Robin Bowning

Dear Professional, Is there any security tool available which validate all the database stored procedures Thanks

Rogers

03-18-2007 11:27 PM
Sue Hoegemeier

OK, something weird is happening. I have a standard Windows XP client and I am trying to set up a simple ODBC entry. So I go to Control...

Richard K

03-18-2007 11:24 PM
Sue Hoegemeier

I recently deployed an app with SQLExpress2005 as the backend. Despite testing it here on my dev network, this was my first opportunity to use it in...

Earl

03-17-2007 01:44 PM
Earl

I have developed one database and its on production but data is not encrypted, now the client wants the data should be encrypted, is there...

Rogers

03-16-2007 03:58 PM
Rogers

I have an app that is on a small network. The backend is SQL Express 2005. The network is connected through a router without a server. Each of...

Earl

03-15-2007 10:47 AM
Earl

I'm currently playing with SQL Server 2005. I deployed the server on a W2K-Server. It works fine. I have deployed two clients on computers running...

Francois PIETTE

03-14-2007 04:26 AM
Francois PIETTE

When SQL Native Client has been installed on a client computer using SQLNCLI.MSI, the Configuration Manager is not installed. Hence the question: How...

Francois PIETTE

03-14-2007 03:12 AM
Francois PIETTE

Is the option OLE DB Services = -4 still valid in the connection string with the SQL Native Client ?

Michael Tissington

03-13-2007 10:48 PM
Wei Lu [MSFT]

Dear Professional, One quick and tricky question, I have a excel sheet and it contains five worksheets and each sheet has a survey questions and the...

Rogers

03-13-2007 11:15 AM
Rogers

SQL Server does not exist or access denied I have two NIC cards on my client machine. NIC #1 is the corporate network where my SQLServer...

RedBear

03-13-2007 09:59 AM
Sue Hoegemeier

I have recently changed my application from using SQLOLEDB to SQLNCLI. Occasionally I'm seeing an error "SMux Provider: Physical Connection is...

Michael Tissington

03-12-2007 11:01 PM
Charles Wang[MSFT]