Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clustering

Migrating from single server install to active/passive cluster

I'm moving our production DB from a stand alone install to an active/passive
cluster. Current system is running Windows 2008 and SQL 2008 SP1, the
cluster will run Windows 2008 R2. The machine that is actively running the
database now will become the second node in the cluster when it's all said

11/9/2009 1:04:06 AM

Clustering

Migrating from single server install to active/passive cluster

11/9/2009 1:04:06 AM

NNTP Connect

Problem with SQLEXPRESS/MDB connection

My database is in mdb file. My development environment, on my laptop, is
Visual Studio 2008. Database is in the App_Data direcotry. Everything works
fine.
My server is NT 2003 R2. I have installed Web Developer 2008 Express and SQL
Server Express edition on the server. When I copy my code and run the app

11/4/2009 12:59:45 PM

NNTP Clients

SQL Server 2008 Opening files in Windows 7 Pro

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 have found so far is when I am in SQL server 2008 Management
studio, and I go to the folder to open an existing file on my local hard
drive. I click on the folder, wait about 20-30 seconds and it opens my

11/2/2009 6:56:01 PM

NNTP Connect

Unable to connect to SQL Server through ODBC

I have an Access database that has linked table to an SQL server
database. The database is on a remote server.
I distributed the Database to 10 users. 9 users work great. The 10th
is unable to connect. There must be something on her machine that is
blocking it. It tells her that the database doesn't exist.

10/31/2009 1:07:56 AM

NNTP Connect

server connection / what server to connect to

We have VB applications call a security DLL to make the database connection.
We put an Environment Variable on our windows and web servers to indicate
whether they are a development or production machine. This way the
applications can be run on any server and the security DLL knows whether it
should connect to our Development or Production SQL Server servers.

10/30/2009 2:19:01 PM

NNTP Connect

Amateur Videos Beta - Girl Amateur Sets

============================== ============================== =============
========= My own home videos collection !
=========
VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVV
========= ENTER HERE:
=========
========= [link]

10/27/2009 8:31:18 PM

NNTP Clients

Bypass Installer for SQL 2005 Tools?

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 learned
about the advantages of doing things in SAFE mode. But apparently you can't
run Windows Installer in SAFE mode. Can I install it by hand? Following is

10/24/2009 3:12:31 PM

NNTP Clients

SQL Server 2005 - System Configuration Check stalls

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 it
starts a System Configuration Check. "SQL Server Setup is scanning your
system's configuration." There's no CANCEL button and no X to close. And
it's just been sitting there for three hours. Is there a log file

10/20/2009 5:19:22 PM

NNTP Connect

sql server does not exist or access denied. connectionopen connect

Hai
Anybody help me
I installed sql server 2000 on a client machine in a domain. Then i access
the sql server using odbc i got an error like
'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."
please reply.

10/9/2009 4:40:22 AM

NNTP Connect

TCP connectivity after ESENT events

Hi Everybody
This is a troublesome problem. We recently started having trouble with a SQL
200 SP 4 server running on Win2k3 Server R2 Enterprise 32 bit SP 2.
SQL intermittently stops listening or responding to requests over TCP. We
can still telnet to 1433 from other sources but our application stops

10/7/2009 3:42:01 PM

NNTP Connect

Linked Server problem

Wh have a linked server defined between two SQL 2005 SP3 64bit servers.
When running a program we get the following error "OLE DB provider SQNCLI
for linked server "SSDEV" returned message "Cannot start more transactions
on this session". Is there a setting to increase the number of transactions
for this? I can not seem to find it.

10/7/2009 11:52:34 AM

NNTP Connect

trouble connecting to SQL 2005 db.

I have a program that normally uses an ACCESS db. It uses a file "conn.inc"
to connect to the access db. This is how it looked:
<%
dim conn,strcon
set conn=server.createobject("adod b.connection")
strcon = "PROVIDER=MSDASQL;"
strcon = strcon & "DRIVER={Microsoft Access Driver (*.mdb)};"
strcon = strcon & "DBQ=" & Server.mappath("alt.mdb")&";"

10/6/2009 7:50:06 PM

NNTP Clients

SqlConnection Pooling and SQL 7.0

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; loop < 4000; loop++)
{
using (SqlConnection c = new SqlConnection(cs.ToString())
{
c.Open();
c.Close();
I'm getting connection errors:
Verify that the instance name is correct and that SQL Server is configured

9/23/2009 12:40:18 PM

NNTP Clients

Many incorrect syntax after virus? HELP!

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 where the asp/web front end was making a call to a 2005
back end database and it would chop part of the next query or shorten
the current query. What is really weird is that the .net client seems

9/21/2009 4:52:54 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