Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

sql Data Synching

Hi,
What the the best approch to do the data sunch between 2 sql servers.
Production db hierarchy columns value change/insert/delete(different
hierarchies are in diff tables) by user applications.
I need these change take place in a remote tables once a day by sql
scheduled job.
Add insert/delete/update triggers to these production tables which contains

8/19/2010 9:46:24 PM

NNTP Replication

New table not showing up in article list

Forgive me I'm very new to SQL Server. I just had someone transfer my entire database from Access to SQL Server and I'm trying to get up to speed.
It is a merge replicated database.
I added a new table "EmailList" to the database "CRM", then went to the "CRM" Publisher properties in SMSS and noticed that when I expand the article list, my new table is not there for me to specify as an object to publish.

8/19/2010 3:25:10 PM

NNTP Server

error while using case statement

Hi,
I have to modify an existing query as below
existing logic:
and table.location in (select city from tablename1 where col=col)
New logic:
Now if the column table.loction' is null then I have to use the below logic
select tablename1 CITY from tablename1 , tablename2
where =stn_id and tablename1 .id =tablename2.id

8/19/2010 7:49:04 AM

NNTP Replication

Simple hack to get $5000 to your Paypal account

Simple hack to get $5000 to your Paypal account At [link]
i have hidden the Paypal Form link in an image. in that website on
Right Side below search box, click on image and enter your name and
Paypal ID.

8/19/2010 4:33:54 AM

NNTP Server

Delete all fields in database...

I have a sql database on Godaddy.com. I was wondering if there is a
way of deleting all the fields in the database using a query? I want
copy and deploy a duplicate website with an empty database.
Thanks in advance,
RABMissouri2010

8/19/2010 12:35:14 AM

NNTP Server

SQL 2005 view vs table execution?

When you excute your query a table using via view, does it compilies
each time when you query or does it uses any kind of stored data in
the memory pool?
Is it querying directly the table always faster (small, medium or
huge) than directly querying the table?

8/18/2010 11:05:12 PM

NNTP Server

Union...

I have 2 tables as follows:
Table 1 - Names
Name_Id (int) primary key
First_Name (vchar)
Last_Name (vchar)
Address (vchar)
City (vchar)
State (vchar)
Table 2 - More names
MoreName_Id (int) primary key
MoreFirst_Name (vchar)
MoreLast_Name (vchar)
Is it possible to UNION these two tables by creating for Table 2 an

8/18/2010 9:41:40 PM

NNTP Server

BCP Computed Column

Hi.
I have a table with a computed column. When I try to import data into table
through BCP it generates error due to computed column. So how to handle a
computed column while importing data into table through bcp from a text file.
Regards,
Muhammad Bilal

8/18/2010 9:19:03 PM

NNTP Server

Locking in SQL 2005

I have an insert table trigger which amongst other things, massages inserted
column value. Within this trigger, I am stuck with select and then insert
statement. To prevent duplicate looking at the same data, I put the select
and insert statements into transaction. In addition, I used with(holdlock)

8/18/2010 9:01:03 PM

NNTP Server

Problem with SQL Server Import and Export Wizard in SQL Server 200

We are using SQL Server Import and Export Wizard to export from a view to a
flat file. This export worked in under 20 seconds in SQL Server 2005 SP3 but
after we upgraded to SQL Server 2008 SP1 the same export will take up to 2
hours or more. Also it appears to dominate one CPU out of 8 on that server

8/18/2010 4:35:03 PM

NNTP Server

sql 2005 & 2008 standard (32 and 64-bit) evaluation copy

Where can I download the evaluation copy (ISO or EXE) of SQL 2005 and 2008
standard (32 and 64-bit)?

8/18/2010 6:16:03 AM

NNTP Server

SQL 2005 Best Practices for backups

I have been working on the conversion from SQL 2000 to SQL 2005 for best
practices. I have come a long way. I only have 47 issues whcih I already
knew. However, I am having trouble finding the best way to go from SIMPL to
FULL mode on backups.
Rich Lawson

8/18/2010 6:09:57 AM

NNTP Setup

Simple hack to get $5000 to your Paypal account

8/17/2010 7:28:20 PM

NNTP Server

Dbase Backup File Size

Dear All,
I have just upgraded from SQL 2000 to SQL 2008 Enterprise, after migrating
our ERP DB, I have created a maintenance plan to backup the DB on a daily
basis, for the first 2 backups it was ok, after the third backup I found out
that the backup file size changed from 3.7GB to 2.8GB ?? Keeping in mind I

8/17/2010 3:31:03 PM

NNTP Server

Restoring DB - getting error message instead

Hello SQL Monsters
I used the backup code below to backup 32GB database and it was a success.
However, now I need to restore the database but instead of restoring I am
getting the following error message.
/*
Msg 3159, Level 16, State 1, Line 2
The tail of the log for the database "statDB" has not been backed up. Use

8/17/2010 2:07:36 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