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 05: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

This is in an ASP script, as I try to get unique classcodes (StudentClassCode column) in the StudentData table. Doesn't matter what I try in ASP, it...

Mark B

07-29-2009 07:33 AM
Uri Dimant

hi we are moving an existing vsto app with lots of excel formulae all over the sheets what is best practice to move these calculations into sql...

phong

07-29-2009 02:50 AM
phong

I am trying to install the SQL 2008 client on my PC from the MSDN DVD but it looks like all of the options want to install the server component. Can...

Derek

07-29-2009 12:21 AM
Sean McCown

I have builtin\users on security of my server and also on my database and when a user tries to open the database it asks for a login and password...

seeker

07-28-2009 03:44 PM
Scott Morris

its gonna be a bright sunshiny day

Mark Trubiani

07-27-2009 02:45 AM
Mark Trubiani

Hello, I need a client to administer one SQL Server 2000 database from my (old) PC (WinXP Sp1, .Net 1.1) just for a short while. I would like...

arno

07-22-2009 06:37 PM
Erland Sommarskog

God Bless You Everyone, I recently upgraded from SQL Express 2008 to SP1. Now my user instances are messed up. When I go into the ASP configuration...

Anthony Smith

07-22-2009 06:26 AM
John Bell

I have a few years program experience but I still do not understand how to use "output parameter" in program. For example, in ASP.NET. Can some...

aspfun via SQLMonster.com

07-22-2009 03:00 AM
Uri Dimant

In SQL Server 2000 the following works but in 2005 it gave me an error. Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error converting...

Rogers

07-21-2009 06:02 PM
Erland Sommarskog

We have an application that connects to two 2005 servers. We have set up linked servers and they seem to be working correctly. The application runs...

jimbo345

07-21-2009 10:36 AM
jimbo345

Hi and tx for reading. We deploy our app with MSSQL2005 Express. Now I am curious, if someone has installed MSSQL2008, but no client, if our app...

Bernd Maierhofer

07-06-2009 05:53 AM
Uri Dimant

I was reinstalling SQL Server 2005. On Vista the message was about incompatibility. On XP Prof. SQL Server Setup Dialog Box shows Message "..scanning...

Ilya

07-06-2009 05:02 AM
Uri Dimant

SQL Server installed in my XP Prof with Visual Studio 2005. I do not know how to make it running. SQL Server(SQLEXPRESS) is Running. I do not see how...

Ilya

07-06-2009 05:01 AM
Uri Dimant

I've seen this before. If I have to take a guess, someone started the installation with a wrong bit (32 vs. 64) edition and left the...

Linchi Shea

07-02-2009 01:08 PM
Linchi Shea

Sql Windows/32 ActiveX error ActiveX object creation failed-please check that your installation is valid. How can i fix this error? The user can...

Matt

06-23-2009 07:40 AM
William Vaughn MVP

Dear Sir/Madam Can you tell me how to set default column in sql server using query and how to change it. I am using this query. ALTER TABLE...

Deep

06-17-2009 09:39 AM
Andrew J. Kelly

Hi Guys, I would like to ask one quick question regarding Page File Usage in Task Manager, currently we have 8 GB memory in one of our Server and I...

Rogers

06-15-2009 10:02 PM
Linchi Shea

I have setup a VPN to a new SBS-2008 Server running SQL. I can map network drives and access Exchange via Outlook. But when I try to setup the ODBC...

DJ

06-09-2009 09:28 PM
DJ