Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

the incoming tabular data stream remote procedure call is incorrec

Hello,
I am using SQL Server 2008 Express with sql native client 10.0 as a backend
to an Access frontend.
When I try to updated one of the linked tables in Access, I receive a server
side error message stating "The incoming tabular data stream (TDS) remote
procedure call (RPC) protocol stream is incorrect. Parameter 6 (" "): Data

8/25/2010 8:54:03 PM

NNTP Server

Multiple backups with datetime stamp

I want to backup multiple Databases on Daily biases and create a file for
each Database. I would like the backups to have datetime stamp. I was going
to use either Differential or incremental but I don't know the best solution.
I would be grateful for your suggestions.
Thank you in advance.

8/25/2010 8:52:32 PM

NNTP Programming

Query Help

Dear All
i have following DDL and sample data
[sql 2000]
create table main_tab (t_id varchar(10),fname varchar(30), lname
varchar(30), gender char(1))
create table im_tab (t_id varchar(10),flag char(1))
insert into main_tab values('a0101','Ali','Hussain' ,'M')
insert into main_tab values('a0102','Noor','Inam',' F')

8/25/2010 7:27:12 PM

NNTP Server

Auto increment int field in select statement

What I am trying to figure out how to do is to have a int to start at
1, 2, 3, ect. But I want then counter to reset when the MasterID
changes.
Employees table is used to hold employee info, MasterID is the PK key
and is a Identity field on the table. Dependents are for dependents
has a FK to Employees.MasterID column. It also has a fiend called

8/25/2010 6:27:50 PM

NNTP Programming

Calling a Stored Proc from Excel or .NET Returing Very Slow

We are having a very strange problem. When I execute a specific stored
procedure from SQL Management Studio I get all 7700 rows in seconds, but
when I call the same procedure with the same parameter settings from Excel
or from a .NET 3.5 application it takes about 3.5 minutes to return. This
happens consistently and running "sp_updatestats" doesn't help.

8/25/2010 4:26:53 PM

NNTP Setup

MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services

I have been finding that I'm having trouble with the Crystal Reports Server
XI installation failing when it's dealing with SQL.
So, as a thought and in case there was something wrong with my SQL portion of
the isntall. I thought ok, I'll try installing the actual MSDE application
direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is

8/25/2010 4:02:12 PM

NNTP Server

How to use datepart in below scenario

Hi Guys,
I have the following dates:
8/23/2010 6:30:00 AM
8/24/2010 6:29:00 AM
8/25/2010 7:00:00 AM
8/26/2010 5:00:00 AM
8/23/2010 6:30:00 AM/ is Monday but i want to treat also 8/24/2010 6:29:00 AM
as Monday. Scenario: production schedule is from 6:30 am to 6:29 am the next
day.
how can i use selec case? i am using sql server 2005?

8/25/2010 2:53:34 PM

NNTP Programming

Need help with SQL

Hi,
We have a Tickets table and a Comments table in our work work horus
tracking system. Now we have a need to pull the data from Tickets and
Comments tables where ticked_id is the foreign key in the Comments
table such that the recent comments should be picked. This can be done
by doing a GROUP BY t.id on the Tickets table. This also eliminates

8/25/2010 1:38:19 PM

NNTP Programming

cleare space using shrink

Hello there
I have server which has not enough disk space.
I have removed an unessesery data from my databases which is approx 50% of
the datbase which is 20 GB
As i know i need at least 20 GB on the HDisk to run the shrink (which i
don't have, at least 10 GB). how can i free space in this case?

8/25/2010 8:59:28 AM

NNTP Programming

getting xml data

Hello there
I have some store procedures who execute XML.
I would like to run them and store the XML in table, variable.
how can i do that?

8/25/2010 8:56:27 AM

NNTP Server

Create trigger

Hii,
Can any one please let me know the process that how can we create trigger so
that it grab the job failure logs when the job fails and that error log
details will sends to mail via SMTP.
Please provide some URL's for this task is much helpfull for me.
Thanks in Advance.
Kareem.

8/25/2010 6:53:27 AM

NNTP Replication

prepress softwares bentley autodesk full download crack kM,,=,JJ.F

We can crack or emulate any protection type: Dongle,
Hardlock, Hasp, Serial, Password, Hasp4, Flexlm, Sentinel,
Wibu, Eutron Smartkey, Hasphl, Proteq, All the Protections!!
email = yshows...@gmail.com
email = yshowsoft at gmail.com
NEW UPDATES 2010
Artpro 9.5r4 with license (minimal of 2 license)
Oris Press Matcher

8/25/2010 6:39:44 AM

NNTP Programming

order by column in table structure not in result set

hi,
i have a table with 500+ records and they got jumble while inserting . now i
want to arrange them in order by column name in the table structure not in
result set..
i want somthing that works like MYSQL (Alter table order by column name)
Thanks & regards:
Aleem

8/25/2010 5:23:42 AM

NNTP Programming

SQL Server 2005 memory manager procedure cache behavior?

Can some one give me some insight on the SQL Server 2005 memory
manager procedure cache behavior if the SQL statements are issued from
Visual Studio vs having club all the SQL Statements as an SP. Do SP
plans are kept longer in the procedure cathe than individual SQL ones.
Is there a priority of one vs other? Please point me to any articles

8/24/2010 11:49:38 PM

NNTP Server

Query execution plan problem

Hi,
I have encountered a problem with a query execution plan on MS SQL Server
2008. It is a simple query on a single table. The table has a primary key
RNUM (number(10)) with a clustered index. The query is executed via ODBC
using fast forward cursors and is constructed like this:
select [field_list_here] from table_name where RNUM>@P and TYPE='A' order by

8/24/2010 8:23:01 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