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 04: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 01: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 04: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 10: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 04: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 07: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 07: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 12: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 09: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 11:16 AM
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 12: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 04: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 12: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 06: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 08: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 07: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 04: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 07: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 01: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 06: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 02: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 06: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 01: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-28-2009 11:21 PM
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 02:44 PM
Scott Morris

its gonna be a bright sunshiny day

Mark Trubiani

07-27-2009 01: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 05: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 05: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 02: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 05: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 09: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 04: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 04: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 04: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 12: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 06: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 08: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 09: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 08:28 PM
DJ

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 07: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 03: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 05: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 01: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 10: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 09: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 05: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 10: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 12: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 07: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 01:36 PM
Gerry Hickman