(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

Hello All, We got a new product we've recently launched, it's a query tool and its still in beta, and we're giving it for free to...

Itamar

05-08-2009 01:28 PM
Itamar

Dear Professional, Quick question, let’s say Log Shipping is already in place from Primary to Secondary, what if I shrink the .ldf file on Primary...

Rogers

05-01-2009 07:31 AM
Balmukund

Currently. Log Shipping is in place and every hald an hour I take log backup and that has 100 MB in Size but the only problem is MyDB.ldf file size...

Noor

04-24-2009 08:47 PM
Ekrem Önsoy

Hello Professional, I would like to ask one quick question regarding Maintainance Plan -> Rebuild Index Task. I have created Maintainance Plan and...

Noor

04-22-2009 07:11 PM
Noor

Hi, We have a database in SQL 2005 Server. We would like our Excel 2007 users to be able to create queries and receive the data in Excel. The users...

Gerry Hickman

04-20-2009 11:53 PM
Mark Han[MSFT]

Thank you for your reply. I can get everything except Business Intelligence Studio working by installing VS 2008 first patching it up to SP1 and...

Derek

04-20-2009 10:37 AM
Gerry Hickman

Quick Question, I am running following query from my two different Server. Both have linked server to one of production server. Server1. Select...

Rogers

04-06-2009 07:17 PM
Noor

Guys, I would appreciate if anyone help me out. Let’s say we have DBServer1 & DBServer2 on Montreal and DBServer3 on Toronto. DBServer1 &...

Rogers

04-03-2009 05:48 AM
Ekrem Önsoy

I am trying to install SP3 on an XP client. Getting the error A recently applied update, KB955706, failed to install. Summary log says Product ...

PM in Texas

04-02-2009 04:55 PM
SQL Squirrel