Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clients

Cannot Open Port 1433

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 services of sql and
Windows are starting properly .I can connect to server from client pcs and
I can ping the server from client pc But I cannot open the port 1433 from

9/21/2009 5:26:28 AM

NNTP Clients

Connecting from SQL 2008 SSMS to SQL 2005 SSIS

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 registered"
How come I am getting this error? I have 2008 server and 2005 client tools
on my machine.
Thanks,
Prabhu

9/14/2009 10:34:01 PM

NNTP Clients

ADO, VC++2k5, SQL-2k5, store pdf file into Db

(cross-posted to microsoft.public.sqlserver.cli ents, microsoft.public.data.ado)
I need to store and retrieve PDF files from SQL.
I am able to store and retrieve data from the Db already. I am not using
stored procedures yet. I had already got it working this way from web
examples when I learned that stored procedures and T-SQL should be the way to

9/14/2009 12:56:01 AM

NNTP Clients

SQL Server error on boot

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 is
not available for UK use. A Microsoft technician helped me to uninstall it
all and in the process appears to have damaged the SQL processes on my

9/13/2009 12:48:01 PM

NNTP Clients

Need to get identity after AddNew

I know this issue has been solved before for some people. I looked all over
the net and found some solutions but they do not work for me. I am fairly new
to SQL. I am not using stored procedures and due to schedule, do not have
time to go down a learning path for that. I am using MFC and ADO.
I can add the records (with AddNew) just fine. That works.

9/9/2009 3:46:01 PM

NNTP Clients

PRO ACCESS FLOORS

PRO ACCESS FLOORS
[ Url:- [link] ]
PRO ACCESS FLOORS has provided a comprehensive line of Computer Floor
and Raised Access Floor Products and Services to the Computer Industry
since 1975. Pro Access Floors reputation speaks for itself !
With 100's of computer room floor installations nationwide over the

8/20/2009 5:21:16 AM

NNTP Clients

VS 2008 BI does not retrieved password for a connection

I would like to file a BUG report with Microsoft so this can get fixed.
Will someone from Microsoft respond please; so I can mke an effective
request.
Thank you,
Greg
Ecase # 12097
The password is not retrieved in the VS2008 BI SSIS connection manager when
using the IBM.NET 9.7 driver.
In the Visual Studio SQL Server Integration Service (SSIS) Connection

8/18/2009 4:33:15 PM

NNTP Clients

Auto Failover (Primary Data Center) + DR (Secondar Data Center)

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 shipping but the problem is if my
Primary Server goes down the log shipping also stop working. So the
requirement is in database mirroring if primary server goes down the log

8/17/2009 12:54:14 AM

NNTP Clients

Applying security update 09-004 to SQL tools installation

Hello,
I have SQL 2000 MSDE installed on an application server and I have
applied SP4 and the security update, SQL2000-KB960082-v8.00.2055-
x86x64-ENU.exe. I then had to install the SQL 2000 tools on the
machine due to restrictions within the domain. I know that the
security update applies to the database engine and the tools

8/13/2009 12:42:03 PM

NNTP Clients

Help! Windows 7 Cannot connect to SQL Server 2005

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 network, and neither one of them can
connect to SQL Server 2005 (which is installed on my Win2k8 domain server).
I get a return message that says "SQL Server does not exist or Access Denied".

8/11/2009 6:25:02 PM

NNTP Clients

where is sqlncli for sql 2005?

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 knows if this will contain the file. I need to get an
update to a client.
Jeremy

8/6/2009 5:49:56 PM

NNTP Clients

SQL License Question

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 server, I
will install SQL Server 2008 standard and the license that I will buy
is Per Processor. What license should I buy for windows 2008 standard?

8/6/2009 11:07:46 AM

NNTP Clients

Query Help

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 name
and return a value from a field using that column name:
Function will return a value of 'ColumnName'
Select Field1 AS [dbo].GetDisplayName('Parm1',' Parm2')

8/5/2009 8:31:40 PM

NNTP Clients

SQL "Date greater than" query

Hi all,
I'm trying to find records in an SQL table that are newer than a specified
date. Vie the code.
TheDueDate = DateAdd("d",-1,FormatDateTime( Date))
Response.write TheDueDate & "<br><br>"
rs.Open "Select * From [StudentWorkDue] WHERE [DueDate] >= '" & TheDueDate &
"'", conn, 1,2
Do while not RS.EOF

8/4/2009 10:36:54 AM

NNTP Clients

Auto Failover & DR >>

Dear Professional,
I would really appreciate if anyone can help me out.
Currently I have database mirroring but I am using Asynchronous mode and
using manual failover strategy but going forward I have to implement
following strategy.
1. Automate failover
Question: if I go with automate failover that means I have to configure

8/2/2009 6:41:57 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56

pBlogCategories

sys.books