tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Replication

Persisted Computed Column Logbased

Guys,
Have a question.
While adding an article that has a persisted computed column, has anyone
ever been able to replicate it as-is w/o having to worry about
functional dependencies on the subscriber similar to what can be done
with indexed views by using the "logbased" option?
Thanks,
Igor
*** Sent via Developersdex [link] ***

5/25/2010 3:47:38 PM

NNTP Replication

Latency Threshold Alert Not Working

It appears that SQL Server never raises error 14161. I configured the alert
in Replication Monitor, then verified it was created. I set the threshold at
30 seconds. While monitoring during a load test latency was reported by the
replication monitor at 22 minutes, but still the alert was never fired. I

5/25/2010 4:36:01 AM

NNTP Setup

Installing mssqlexpress fails

Hi trying to install ms2005 sql express fails with the following system error.
Title: .Net SqlClient Data Provider
Message: A netword-related or instance-specitic error occurred while
establishing a connection to SQL Server. The server was not found or was not
accessable. Verify that the instance name is correct and that SQL server is

5/24/2010 10:56:01 PM

NNTP Setup

SQL Setup using well-known SID instead of account name

I have issues installing SQL 2005 Express using an ini file on some
non-English Windows installations. I receive a 28075 error when trying to
use the "NT Authority\System" account since on certain localized Windows
versions that gets renamed.
So, is thre a best practice for handling this or can I use a well-known SID

5/24/2010 8:22:05 PM

NNTP Connect

Named Pipes Provider, error: 40 - Could not open a connection to S

We have a web service server that connects to a SQL Server 2000 database via
a firewall. It works fine, but once in a while, looking at the event logs, I
notice this entry:
Exception Type: System.Data.SqlClient.SqlExcep tion
Errors: System.Data.SqlClient.SqlError Collection
Class: 20
LineNumber: 0
Number: 53

5/24/2010 7:13:01 PM

NNTP Setup

SQL Server 2005 Standard to SQL Server 2008 Standard in-place upgr

I have run Upgrade Advisor successfully with only minor advisories.
Configurator runs successfully. When I upgrade the following error is
returned:
SQLServer has encounterd the following error:

Attributes do not match. Present attributes(Directory, Archive), included
attrbutes(0), excluded attributes(Archive, Compressed, Encrypted).

5/24/2010 6:59:01 PM

NNTP Replication

"Transaction Log Shipping Status" not updating

Hi All: I have two 2005 servers, with the primary shipping logs to the
secondary. At some point several weeks ago there were problems on the
primary server (ran out of space for the transaction log dumps) and the
secondary went out of sync. I ended up disabling all the shipping jobs on
both servers, performed a new restore of the primary dB on the secondary

5/24/2010 10:51:30 AM

NNTP Clients

Form 2555 Irs

VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVV
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

5/23/2010 5:07:09 PM

NNTP Setup

Connectivity setup issue to sql server 2008

Hi Guys,
I am new on SSMA tool. I have new cluster server that installed sql server
2008 in windows 2003 and I installed ssma tool which will migrade data form
sysbase to sql 2008. I have issue I cannot change server name in ssma because
it only display server node name\instance name instead of sql virtual

5/23/2010 3:23:01 PM

NNTP Setup

SS2008 R2 Evaluation license

Hi,
I downloaded SS2008 R2
I am with an evaluation license
2 questions:
- is it time limited ?
- in the future I can change the license type
to put a real license (without re-installation) ?
Thanks for your help

5/22/2010 6:02:51 AM

NNTP Setup

SQL Server 2008 Developer edtion installs with errors.

Hi,
I downloaded SQL Server 2008 Developer edition from microsoft Dreamspark
website and installed it and it was working fine, till some microsoft update
which happened last week i guess!
Now i am unable to connect to the Database engine and it gives me errors
like Piped Names error 40, error 2 etc...I have since then installed /

5/21/2010 7:34:01 PM

NNTP Connect

retrieving connection string w/ ConfigurationManager w/C#

I am trying to store and retrieve connection string info from config
file and I am having trouble retrieving the connection string info.
I stored the info with the following:
Configuration config = null;
config =
ConfigurationManager.OpenExeCo nfiguration(ConfigurationUserL evel.None );
config.ConnectionStrings.Conne ctionStrings.Add(

5/21/2010 1:56:26 PM

NNTP Setup

Failing to install 2008 R2

I have downloaded SQL Server 2008 R2 Enterprise from MSDN Subscription
downloads.
When I try to install, after it checked hardware & software, the
installation failes with error "incorrect file format" and then closes down.
This is before any specific installation options are selected. (Run
Setup.exe / Installation / New Installation or add features to an existing

5/21/2010 12:03:01 PM

NNTP Replication

Replication newbie

We have 2 SQL 2005 servers. One in the local office and a Second at a co-lo
in another state.
What I am needing to do, to replicate the local one, to the co-lo. I am
thinking that Transactional would be best as it would keep an almost realtime
copy.
The part I am not sure about, is if we add a table, or modify a table, will

5/20/2010 11:40:01 PM

NNTP Replication

Crf50 Performance Part

VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVV
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

5/20/2010 9:10:03 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

pBlogCategories

sys.books