Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clients

Pink Love-GHD Pink Limited Edition box set with 60% discounts and free shipping

Inspired by bold, statement bows seen on the catwalks the set comes
complete with a never-seen-
before collection of ghd accessories. The new ghd Pink Limited Edition
box set is the secret to
perfect styling that every fashionista needs.Pastel pinks and nude
shades are the colour
statement of the season which makes the new Limited Edition pink ghd

7/23/2010 12:33:48 AM

Clustering

Basic Clustering Question

I am installing a paperless order system. It writes to a SQL database and
the SQL servers are clustered. However, if the Application server is goes
down, then I don't have any failover. If I install the application to
DataCenter or Enterprise 2003 server and cluster them, is that all there is,

7/22/2010 9:46:14 PM

NNTP Clustering

Basic Clustering Question

7/22/2010 9:46:14 PM

NNTP Setup

Getting Started with SQL Express 2008

Hello:
Well, I downloaded it. I think I installed it right, but I do
not know enough to be sure. Now, what?
Can someone please point me to what I need to study to get going?
I do not want a huge list as much as I want a map. What should I
study first?
Sincerely,
Gene Wirchenko

7/22/2010 7:58:42 PM

NNTP Setup

Uninstaltion Quesiton

I was testing a custom application, in order to test that, I installed SQl
2005 Express Edition first and then SQL 2008 Full Edition on a Windows 2008
Server. Now I am trying to remove it. I have tried to uninstall from the add
remove programs, though the files are deleted, I still see the services names

7/21/2010 6:11:18 AM

NNTP Replication

Merge Replication: subscription problem

Hello all,
We have a merge replication set up and we are facing problem with a
subscriber.
Publisher: SQL SERVER 2008 Standard Edition. Instance Name: Lapi1/Comp
Subscriber: SQL SERVER Express Edition. Instance Name: Pup/Num
Note: Subscription is not on same server as publisher
We have built a pull subscription at above express edition but we do not

7/20/2010 1:00:27 PM

NNTP Setup

SQL Server Management Studio without database

i have installed Sql Server 2005 Developer edition,before i have
installed visual studio 2008.
When i launch "SQL Server Management Studio" appear a window screen
with
server type: database engine
server name:
authentication: Windows Authentication
Login: domain\mylogin
Password:
i have two fields with a blank value, so i type "MSSQLSERVER" in

7/19/2010 2:40:18 PM

NNTP Setup

install ms sql server2000 on windows 7

Dear all
I installed windows 7 instead of windows XP
then i tried to install MS SQL Server 2000 personal edition the installation
completed but the service for the sql server didnt work
so can ms sql server works with windows 7?
or which edition should i use??
best regards

7/19/2010 6:44:41 AM

NNTP Replication

Snapshot Agent not Starting

Currently trying to replicate between two servers. The publication database
on one server was recently restored from a copy of the database, but a copy
in which the database wasn't set as a publication. well, I wanted to try
starting from scratch so disabled the distributor and re-created everything

7/16/2010 10:35:56 PM

NNTP Connect

Delete Built-in Administrators From EM

I have deleted built-in Administrators from Enterprise Manager, Now I cannot
logon in Enterprise Manager. I am using SQL Server 2000 on Windows Server
2003.
How can I recover it now?

7/16/2010 10:34:31 PM

NNTP Replication

Replication between SQL Servers 2003 and 2008

I have a push merge replication running well on 2003 and we're trying to
migrate to a 'cloud' server running 2008. Before we switch all sites to
2008, I need to replicate from 2003 to 2008 and I can't register the 2008
instance in SQL Enterprise Manager and can't seem to find any way of
replicating to the new box. Any pointers, hints? TIA, Ross

7/16/2010 7:58:10 PM

NNTP Replication

Transactional replication

I have to create a replication between three SQL Server where each one is
the main server of three different stores. Each store have its own number.
This number is what identify data to each one inside the tables. Which type
of Transactional replication best fit this project? Updatable Subscriber or

7/16/2010 4:51:51 PM

NNTP Replication

merge replication: suggestion on deploying my application

Hello all,
We have an aplication in .net which we are planning to deploy on our workers
laptop so that they can work offline with their own copy of database.
We planned to do merge replication and have database replicated across
workers machine.
We have tables, procedures and triggers to be replicated. Tables are around

7/16/2010 12:54:38 PM

NNTP Connect

INSERT into statement truncating data to first three characters

I was using an INSERT into statement to insert records into an access
database which was working alright.
However, ever since I am using the same SQL statement to insert records into
SQL server database (nothing has changed except the connection string and
schema information), the INSERT into statement is inserting data of only

7/15/2010 6:02:33 PM

NNTP Replication

Merge Replication: user trigger issuu

Hello all,
We have a trigger defined on table x which gets executed when an update is
on a column. The trigger is executing properly on publisher side.
But when we do update on subscriber side to that particular column, trigger
doesnt execute.
While publishing I had user defined triggers true for the table.

7/15/2010 3:38:25 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