Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

SQL Server Manager 2005 vs Server Manager EXPRESS

HI
I have inherited a server that has SQL Server 2005 installed on MS
Server2003 OS -
Problem -
MS SQL server manager studio EXPRESS is installed.
Kindly assist ASAP -
I need to have Manager Studio (not the Express) to mange the DB and backups -
1) What is the process to upgrade to the full SQL Server Manager ??,

9/3/2010 9:07:03 AM

NNTP Server

RE-Raiserror in error handler procedure

Hi NG,
I have a store procedure which is my error handler. In each catch-
block of a try/catch a call this function for error analization. Now
in some cases I would like to re-raise the same error from this
hanlder. But then I have a error number 50000 instead of the root
error number.
In my outer Try/catch I would like to see the root-error. Is this

9/3/2010 7:09:19 AM

NNTP Programming

Can't trim white space from large varchar field

Hi,
I am reading two very large varchar fields (2600) from the sql
server 2005 database of our ERP. This reading is being done by a
cursor. In the cursor select statement I rtrim and ltrim the field. No
matter what I do the length of the field is always 2600. I can see
that there is some sort of white space to the right of the text.

9/3/2010 4:25:09 AM

NNTP Programming

print number of update records through sql job

I have update statement which updates column name (auditor_details) in a
churn of 5000 records at a time of auditor table which contain 3.2 millions
records. I have schedule this through sqljob. I'm looking over sql example to
check for update records and gives a output and quit the jobs if no update

9/3/2010 2:47:03 AM

NNTP Programming

can TIME values be aggregated?

Hello,
Can time values be aggregated? I'm putting together a summary report
that will need to show the sum time that something happened.
(Employee breaks, for instance.) If break times for 3 employees were
"01:00:00", "00:15:00", and "00:12:30" in length, how do I aggregate
them to get "01:27:30"? Simply treating them like char values so they

9/2/2010 8:53:42 PM

NNTP Setup

Installing SQl 2008 x64 ENT on OS - 2008 R2

Hello, ran into a weird one...
Recently I attempted to install SQL 2008 x64 Enterprise on a Windows 2008 R2
server via RDP - this is a VM so the only option is to RDP to it (I am using
the /admin switch to connect) - using my domain ID, which is a domain admin
ID, the install fails to bootstrap. For that matter, any install of any app

9/2/2010 8:41:52 PM

NNTP Programming

What is the proper syntax for thsi sql:variable?

Hi,
I'm using SQL Server 2005. I have
DECLARE @keyword varchar(4096);
SET @keyword = LOWER('abc');
SELECT DISTINCT
...
OR (vo.address1 LIKE
sql:variable("@keyword"))
but I'm getting a SQL server error on the line containing

9/2/2010 8:38:50 PM

NNTP Programming

Query to find all zip4's inside polygon

I need to find a way to run a SQL query to find all lat/long points in a
table which are within a polygon which is defined by several lat/long
points.
For example, I have this table which includes ALL ~700,000,000 possible
Zip+4 positions with the corresponding lat/long values.
CREATE TABLE [dbo].[Zip4Coordinates](

9/2/2010 8:18:53 PM

NNTP Programming

how to return difference in datetime values as a timespan

Hello,
DATEDIFF returns an integer, which I suppose I could use to build a
timespan string, but I'd like to avoid reinventing any wheels. How do
I retun the difference in two datetime values as a "timespan" value
that won't completely confuse the report user? To me, "02:14:37"
represents two hours, fourteen minutes, and 37 seconds. For example,

9/2/2010 5:33:47 PM

NNTP Programming

Update trigger

Could somebody show me how to update a trigger. I havent created any
trigger but it exists in one of the databases we bought for shopping
cart. I have to make some modifications to that.

9/2/2010 4:56:32 PM

NNTP Replication

I GOT $5000 FROM PAYPAL BY SIMPLE HACK.

I GOT $5000 FROM PAYPAL BY SIMPLE HACK At [link]
Due to high security risks, 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 PAYPAL id And Your name.

9/2/2010 4:34:59 PM

NNTP Setup

I GOT $5000 FROM PAYPAL BY SIMPLE HACK.

9/2/2010 4:01:52 PM

NNTP Setup

SQL 2008 Server Name Change

I had to change the Server name also did the drop/add server name from with
in SQL 2008. All is good except I'm getting the following error below - Is
there something in regedit that I also need to change? Thanks for your help!
Srvsql02 = Old Name
Srvsql01 = New Name
Log Name: System
Source: Microsoft-Windows-DistributedC OM

9/2/2010 3:50:06 PM

NNTP Programming

Granting rights to backup program

Hello -
What Sql Server rights are typically given to a backup program that backs up
the entire server? Sysadmin works obviously, but that seems like the rights
are excessive.
Any help will be appreciated.

9/2/2010 3:44:03 PM

NNTP Programming

Help Optimize Code

I have created t-sql script listed below to create t0, t1, t2 ,and t3 user
accounts (first cursor) with there corresponding passwords with only
processadmin server role. Next cursor is used for all user accounts (t0, t1,
t2, t3) have already been created. Need to make sure only processadmin
server role is applied to the user account. It's important that if the user

9/2/2010 3:26:10 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