What error message do you get from VB app ?

--

SQLBuddy

If you select all columns then you'll get an Index scan not seek unless you have a filter with a where clause.

--

SQLBuddy

jayoub (3/25/2014) Will leaving the databases in SQL Server 2005 (90) compatibility level really keep these database at 2005. The Management hear freeks out everytime i mention upgrading to...

Also check these too .. Pretty good ones ..

http://www.brentozar.com/best-sql-server-dba-books/

--

SQLBuddy

You are welcome, Corinne 🙂

--

SQLBuddy

kaplan71 (3/25/2014)

---

Hello --

The rescheduling of the third-party backup job resulted in the native differential backup being successful. Even though the third-party backup include any of the database bak or trn...

jayoub (3/24/2014)

---

I am working on migrating an SQL Cluster from Windows Server 2003 SQL 2005 to Windows Server 2008 SQL 2005 and I am considering doing the following:

Install Windows...

whenriksen (3/20/2014)

---

I need to stop a SQL Agent job with failure rather than cancelled. The stop request will come from an external script. I didn't see any option...

corinne_crawford (3/20/2014)

---

Hi All,

I have a 3 node cluster on which I have installed SSAS as it's own insntance. I have created this as a named instance and can connect to...

Yeah, Why would you do that ..

--

SQLBuddy

You are welcome, GrantBruce ..

--

SQLBuddy

Matthew Darwin (3/20/2014)

---

These are configured.

To be clear; the alert is not firing, not that emails aren't being sent. The alert was previously working. The only change I've made since the...

Mangesh Raut (3/19/2014)

---

I am running the job from Dev server. Previously I was running it from QA server but same issue so I have deployed the package and created the...

Matthew Darwin (3/20/2014)

---

The alert is the stock one created when configuring log shipping as follows:-

EXEC msdb.dbo.sp_add_alert @name=N'Log shipping Primary Server Alert.',

@message_id=14420,

@severity=0,

@enabled=1,

@delay_between_responses=0,

@include_event_description_in=1,

@category_name=N'[Uncategorized]',

@job_id=N'00000000-0000-0000-0000-000000000000'

The job successfully...

Understood. That normally takes 4 times the work, though. Develop the load balancing, find out it doesn't work the way you expected, try to fix the queries, develop...