Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado...

antivirus gratis

02-18-2010 07:54 AM
antivirus gratis

I am running a C++ VS20008 service application using SQLNCLI client. I have added Mars=Yes in the connection string. The server is SQLExpress...

Morris Neuman

02-15-2010 02:15 PM
William Vaughn \(MVP\)

'Visual Studio 2008, working with an Access 97 table, and an SQL Server 2008 database. I have full rights to both... 'This program runs in x86 mode,...

Mark B

02-09-2010 10:05 PM
William Vaughn \(MVP\)

Hi, I've this trouble ... - I've got this server: Windows XP SP3 with SQL Server 2008 Express installed. I've just enabled the SQL Server Browser...

Porlock

02-08-2010 05:55 AM
Porlock

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-01-2010 02:58 PM
Mia

How can I create a table where the primary key is the dateime datatype and I'd like to default it to the current dateime on SQL Server 2005?

Manish Chauhan

01-19-2010 06:00 PM
Erland Sommarskog

Hi, for install client components with SQL Server 2005 Express Edition i use this command: "setup.exe /qb ADDLOCAL=Client_Components" and with SQL...

Seritel

01-19-2010 07:01 AM
Seritel

Many computer problems are caused by viruses and malware on your computer. The best and easiest way to correct this is to use a recognized antivirus...

antivirus gratis

01-15-2010 06:46 PM
antivirus gratis

Hello! Assume I use Integrated Security. I have two windows accounts one account Tony that I use when logging in to the machine and the other is...

Tony Johansson

01-14-2010 01:21 AM
SQLSQUIRREL

"Erland Sommarskog" wrote: Hello Erland, Thank you for your reply and comments. It appears the problem was due to Windows 2008 having trouble...

Peter_April1

01-08-2010 03:41 AM
Erland Sommarskog

Hi all, I am trying to create a Card Number for clients, after inserting a new record, based on a clientID field and the year part of the...

Cypher

01-07-2010 10:43 AM
TheSQLGuru

We have a vb6 application that among other things queries sql server 2005 db over lan. On the client side, where do I control the size of network...

RG

01-06-2010 05:25 PM
Erland Sommarskog

If you want people to do something with that, your best option would be to post the design of the tables and the insert queries required to...

Arejan

12-30-2009 04:50 PM
Sylvain Lafontaine

Hello, I don't know if this group can help, becuase I don't know if the problem is with SQL Server, Windows or Access. I am hoping someone can...

Mark A. Sam

12-28-2009 05:21 PM
Mark A. Sam

I want to access a SQL Server table on a 2005 server via an Office Access project (*.adp). Only read access is wanted. It seems to be necessary to...

Softie

12-28-2009 10:26 AM
Mary Chipman [MSFT]

Hi, Is there a way to suppress the prompt askinng to save when using SSMS 2008 query editor, as there was in SQL 2000? I don't see it in the...

Alan Z. Scharf

12-25-2009 03:39 AM
Alan Z. Scharf

SQL 2008 I have a couple of questions about SSMS which I've been unable to find the answers for and I'm hoping someone can help. 1 - When I create...

Andre

12-22-2009 01:11 AM
Andre

I'm a little confused about running SQL Express with VS 2008. VS 2008 installed SQL Express as part of normal installation, but it only installed...

Fred Chateau

12-12-2009 09:38 PM
Fred Chateau

I have a GridView that uses a SqlDataSource.Select command to fill with data. The user can specify a date range for the select statement and when...

BrassicaNigra

12-10-2009 02:42 PM
BrassicaNigra

Hi All, On my web application(C#) we have a transaction and within the transaction we are calling a store procedure. And after the execution of store...

Priyadarshan V

12-03-2009 01:41 PM
Scott Morris

I have questions regarding SQL Server Native Client. Can I connect to SQL 2008 with SQL 2005 Native Client and if so are there any limitations? Can...

Frede

12-03-2009 09:45 AM
Russell Fields

Dear Friends, Im new to SQL and Windows Server 2003, I have configured the SQL server 2005 on Windows Server 2003 Starnderd version All the...

Loku John

12-02-2009 04:58 AM
kjhgf reae

Hi! We transfered our DB from SQL 2005 to SQL2008 by creating scripts in SQL Studio2008. After that we can't update correctly records in subforms(if...

Helena

12-01-2009 10:26 AM
Russell Fields

I have just had a new PC and MS SQL Server 2005 client software was installed on it. When I open our OLAP database right down to the partition level...

MervynScarlett

11-28-2009 05:43 AM
MervynScarlett

I installed and ran some of the demos of Microsoft SQL Server 2008 for Developers Training Kit -- including creation of global alias and all...

Nam

11-24-2009 06:30 PM
Nam

I've very new to SQL Server and the Enterprise Manager. Can anyone point me to how to set up the relationships between the tables, and denoting which...

Shay

11-20-2009 11:28 AM
Sylvain Lafontaine

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 08:17 AM
Mia

Hi, I had restored a production database backup to a TRAINING database using symantec.I accidently asked symantec to restore model,msdb and database...

noorhayati shamsuddin

11-18-2009 05:31 AM
Uri Dimant

Hi I am trying to access an AZMAN store that is located in ADAM from a sql query. I have written the query below but dont get any data. Is it...

Macduff

11-16-2009 08:51 AM
Macduff

Mark and Ekrem, Thank you for helping me out with this! Unfortunately, even after installing SP3 on the server and rebooting after the install, I...

LenaMsdn08

11-14-2009 05:05 PM
Erland Sommarskog

Not sure if I am in the corrct forum but here is my issue. I am evaluating Windows 7 professional for my company and so far the only bad feature I...

jaylou

11-03-2009 02:32 AM
Uri Dimant

sreedhar (sreedhar.555 (AT) ureader (DOT) com) writes: If you get Timeout Expired when you connect, the reason may not be the same as for the...

Sachin Surana

10-27-2009 06:37 PM
Erland Sommarskog

I've been unable to install SQL Server 2005 Tools because it hangs at the same point every time. In the course of trying to address this, I...

Laurel

10-24-2009 11:12 AM
Laurel

I'm tryin to install the client-side tools for SQL Server 2005 (Disk 2 of 2). It installs the required <stuff....- I forget the term> and then...

Laurel

10-21-2009 05:50 PM
Erland Sommarskog

I may have posted this question in the wrong forum .... if so, my apologies. I installed Microsoft Accounting on my desktop only to discover that it...

JohnH

10-06-2009 08:26 AM
JohnH

I'm working with a legacy database, writing some testing routines against an old SQL 7.0 database. I've boiled the code down to: for(int loop = 0;...

Eric Gurney

09-23-2009 08:40 AM
Eric Gurney

We had a trojan downloader infect our network and in the process of look at the network traffic I discovered that I was getting many syntax errors...

firebalrog

09-22-2009 01:55 AM
Sylvain Lafontaine

I have SQL Server 2008 client and Visual Studio 2008 installed on a PC I am able to connect to all of the SQL 2000 and SQL 2005 servers using...

Derek

09-20-2009 10:32 AM
thejamie

(cross-posted to microsoft.public.sqlserver.clients, microsoft.public.data.ado) I need to store and retrieve PDF files from SQL. I am able to store...

Jimmie C.

09-17-2009 12:16 PM
chaosu

I am not able to connect to SQL 2005 SSIS from SQL 2008 SSMS. I get following error. Connect to SSIS service on machine xxxxx failed "class not...

Prabhu

09-15-2009 01:46 PM
Prabhu

JC (elvis****_is_***king**at**bellsouth***dot***net) writes: Ah, that's good to know. Then I should not research any further! When did you start...

Jimmie C.

09-14-2009 05:59 PM
Jimmie C.

PRO ACCESS FLOORS http://www.computerfloorpros.com/ ] PRO ACCESS FLOORS has provided a comprehensive line of Computer Floor and Raised Access Floor...

Gary Arvay

08-20-2009 01:21 AM
Gary Arvay

Greg: Check the Package Protection Level property of the SSIS package (under the Security section). If you are in fact using one of the 4 choices...

Todd C

08-19-2009 07:46 AM
Todd C

Hello Manpreet & Linchi Shea Thanks for your help, I would like to add couple of points over here. I have implemented databse mirroring plus log...

Noor

08-17-2009 09:04 AM
Linchi Shea

Dear Professional, I would really appreciate if anyone can help me out. Currently I have database mirroring but I am using Asynchronous mode...

Noor

08-16-2009 08:53 PM
Noor

Hello All, Not sure if this is the right forum group, but the problem appears to be on the client side; I have 2 Windows 7 installs (Pro) on my...

Gary Bouchard

08-12-2009 05:23 PM
Gary Bouchard

Hi all, I'm trying to find records in an SQL table that are newer than a specified date. Vie the code. TheDueDate =...

Mark B

08-09-2009 08:57 AM
Mark B

I can't find the download for sqlncli.msi for sql 2005. Anyone one know if this is still available? I'm downloading sql 2005 sp3 as I type, but who...

Jeremy

08-06-2009 02:10 PM
Russell Fields

Hi All, I use two servers for my websites: - The first server is windows 2008 web server - The second server is windows 2008 Standard. In this...

HungTrinh

08-06-2009 07:07 AM
HungTrinh

We have a function that basically returns a column name(mapping table), I'm trying to run a query that will call that function to get the column...

Rick

08-06-2009 03:15 AM
Bernd Maierhofer