Hi

Hi,

I have setup a linked server to a DB2 database using "Microsoft OLE DB Provider for ODBC Drivers",

the connections works fine i am able to run select queries.

but the number of rows returned from the two following statements are different.

select * from linkedserver...tablename

select count(*) from linkedserver...tablename

e.g. The First statement returns 116 rows, whereas the second query returns count as 144....

I am a bit confused ?

could anybody think of any possible reasons..

Cheers

ARAW012

Hi,

which SQL Server version are you using ? There was an issue with SQL Server 2000. Are you able to trace the queries that are actually executed at the DB2 database ? Did you already try to use the OPENQUERY method to pass the query (without any refactoring through the driver stack) through to the DB2 instance ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

i am using SQL server 2005 , and i am using the OPENQUERY method.

I only have read access to the DB2 database.

Thanks

|||The openquery and the "normal" Select behave different, because the OPENQUERY will issue a pass-through to the server instead of doing the interpreted Select query through the driver. So the results can differ according to the changes the driver will do in the middle. Perhaps someone with additional DB2 knowledge can help you here.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

help-for copying database

hi,
i m new 4 sql server.
i create one app. in asp.net.

i create one database in sql server.
now,
i want to make setup for my app.
so,
i want copy database and put on c:/.../wwwroot/app folder.

how can i do this?

one more things,
i create database using enterprise manager.
i want to see my database file.
where it is stored?

somebody help me.

it's urgent.
thanks in advance.Not a wise move but if you insist, right-click on the database from Ent Mgr and then click on the Data Files tab, you will find the path to your datbase file there. Next, click on the Transaction Log tab on you will find the path to your transaction log there; these are the two files that make an SQL database.

Help:I cannot subscription report

Dear all

I cannot subscription report when I finished setup that the following is the error message

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The specified @.category_id ('101') does not exist.

The SQL agent have already start. I don't know what happen.

Can you look in the SSRS Logs and Event logs and grab some relevant information for us to digest?|||

I have already checked the log but it have any log for it.

How can I do?

Help:DTC-Firewall-SQL server clustering

Hello All
I am having trouble of DTC to get working thru firewall
The setup we have is
Two web servers load balanced. Componets run off the web servers. (OS:2000 Server
Two SQL server clusered.(OS: 2000 advanced server)
Web servers and SQL Servers are in different domain separated by firewall
Components do not work if I set "transaction required". If I changed it to "Transaction suported" or "not supported" some componets do work
I tried suggestions from kb article
DTCPing: http://support.microsoft.com/?id=30684
Initially DTCping had some problem but for testing purpose we opened all ports on firewall. It worked
I tried another config suggestion
http://support.microsoft.com/?id=25036
When I apply the registry entries for ports mentioned in this article, it disabled Clustering service. I was not able to get it back until I revert back registry settings
I tried DTCtester utility, it doesn't work
Does any one know why it must be disabling the clustering service? or Have any other suggestions on configuration for DTC thru Firewall
Thank
MilsThanks Jeff
I tried the procedure you mentioned. but it did not help
I have already tried the DTCping utility. At first it did not work but then I opened all the ports on firewall. now DTCping works.
DTCtester.exe utility still does not run, it gives error
Output of utility
****************
E:\netins>dtctester vssql01 uname Pw
Executed: dtcteste
DSN: vssql0
User Name: unam
Password: pw
tablename= #dtc1236
Creating Temp Table for Testing: #dtc1236
Warning: No Columns in Result Set From Executing: 'create table #dtc12365 (iva
int)
Initializing DT
Beginning DTC Transactio
Enlisting Connection in Transactio
Error
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server Driver
Distributed transaction error
Error
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cu
sor stat
Typical Errors in DTC Output Whe
a. Firewall Has Ports Close
-OR
b. Bad WINS/DNS entrie
-OR
c. Misconfigured networ
-OR
d. Misconfigured SQL Server machine that has multiple netcards
Aborting DTC Transactio
Releasing DTC Interface Pointer
Successfully Released pTransaction Pointer.
*********************************
One of the error description refers to multiple netcards. Our SQL server has multiple netcards.
Any idea if there's any specific configuration for SQL Server using multiple netcards
Thanks
Milin|||1. Are the ports still open. If not then you need to open ports 445, 135,137-9, plus the ones you set in DCOMCNFG
2. Do you have an entry in each server of the cluster's host file with an entry to the destination server. and likewise on the destination for each of the Clustered servers
3. Does DTCPing work both ways now also
Jef
MCDBA, MCSE+I|||Yes. All ports are still open in both directions
I have entries in hosts files of both servers. I can access these servers using network names from each other
DTCping work in both directions
Thank
mil|||Did you actually set the ports with DCOMCNFG and reboot or did you just try the reg hack
If not then set DCOMCNFG on all servers to use the proper ports and reboot all servers
Other than that I cannot think of anything else
Good Luc
Jeff|||Mil
I am sorry then. In all my experience once I have had DTCping working I have had DTC working as well
Jeff|||"mils" wrote:
> When I apply the registry entries for ports mentioned in this article, it disabled Clustering service. I was not able to get it back until I revert back registry settings.
Hi,
I have the same problem.
when i set the port by dcomcfg (or by registry), the nodes cannot start clustering services.
WhY '
How can i do ?
thanks in advance !!
Regards, Dario

Help: Selecting from two tables: odd situation

Hi, I have two tables setup as shown below:

Table name,"config"
+------+------+
| config_name | config_value |
+------+------+
| default_style | 1 |
| *other names | *other values |
+------+------+

Table name,"styles"
+------+------+
| style_id | style_name |
+------+------+
| 1 | Purple Hue |
| *other names | *other values |
+------+------+

Now, for my question:
I need to select everything (*) from the config table
and the 'style_name' from the styles table where style_id of the styles table is equal to the value of default_style of the config table.

I got as far as this query
"SELECT config.*, styles.style_name FROM `config`, `styles` WHERE config.default_style = styles.style_id LIMIT 1"

But obviously that will not work.

I know I can do this with two queries, but I am optimizing and I would like to reduce this down to 1 query, is this even possible to do with one query?

Thanks.left outer join|||Is this the same as a left join? I have heard of left join, but never of a left outer join.

Just an alias or what?|||yeah, it's the same

some databases allow the OUTER keyword to be optional

HELP: MSmerge_past_partition_mappings is Huge !

I have a SQL 2005 Merge Replication setup with SQL Mobile Subscribers. The
merge replication performance has been incredibly slow (a couple of hours in
some cases). I looked at the size of some the Replication tables and their
sizes are huge compared with the rest of my db tables e.g.
MSmerge_past_partition_mappings637451 Rows
MSmerge_current_partition_mappings350554 Rows
MSmerge_contents252368 Rows
The most amount of rows in any of my user defined tables is under 200,000
Rows. My question is - is there any way to fix these Replication tables
either my deleting the rows, running a cleanup script, etc. without affecting
the Subscribers?
Thanks for the help
http://www.mssqlserver.com/replication/purgemetadata.asp
This article will help you understand why the meger metadata tables can get
quite big.
You can run sp_mergemetadataretentioncleanup procedure to clean up some
metadata.
http://msdn2.microsoft.com/en-us/library/ms178557.aspx
Hope this helps.
"Cube" <ciaran@.nospam.insero-technologies.com> wrote in message
news:3F420705-1567-4257-9570-393795D005D8@.microsoft.com...
>I have a SQL 2005 Merge Replication setup with SQL Mobile Subscribers. The
> merge replication performance has been incredibly slow (a couple of hours
> in
> some cases). I looked at the size of some the Replication tables and their
> sizes are huge compared with the rest of my db tables e.g.
> MSmerge_past_partition_mappings 637451 Rows
> MSmerge_current_partition_mappings 350554 Rows
> MSmerge_contents 252368 Rows
> The most amount of rows in any of my user defined tables is under 200,000
> Rows. My question is - is there any way to fix these Replication tables
> either my deleting the rows, running a cleanup script, etc. without
> affecting
> the Subscribers?
> Thanks for the help
>

HELP: How to delete a user from Reporting Services?

I have the following problem.
The system setup is as follows.
IIS and sqlserver are on the same server and I'm using windows integrated
security.
I initially created a windows login user (userA).
I then in the reporting services(RS) admin area, set the security permissions
for a directory(Dir1). The permissions were, userA is a member of the
browser role and the directory was set to the browser role.
Everything worked as it should at that point.
I then wanted to delete userA from the server. So i delete userA from the
'local users and groups' admin area in the control panel on the server.
This is when I started to have problems.
When I go back into RS to administor permissions, I tried to ammend the
'browser role' permissions for Dir1. When I try to save the changes the
following error is displayed.
'The user or group name 'userA' is not recognized. (rsUnknownUserName) '
Its seems that userA is still registered in RS.
Logically I understand why, I've only deleted userA from windows, not from RS.
My question is , How do I completely delete userA from RS.
I noticed a users table in the RS database but there are numerous other
tables which could have entries refering to userA.
Is there a way to be sure all references to userA are deleted.
The only way I could get round this was to re-generate userA as a windows
user and disable it.
This is not an ideal solution as I do not wish to have numerous disabled
windows login users.
Any suggestions would be gratefully received.
--
Message posted via http://www.sqlmonster.comSounds like you would have to delete userA from the folders on RS, then
delete the user profile. If possible, use a security group instead of
assigning individually.
"Stewart Waddell via SQLMonster.com" wrote:
> I have the following problem.
> The system setup is as follows.
> IIS and sqlserver are on the same server and I'm using windows integrated
> security.
> I initially created a windows login user (userA).
> I then in the reporting services(RS) admin area, set the security permissions
> for a directory(Dir1). The permissions were, userA is a member of the
> browser role and the directory was set to the browser role.
> Everything worked as it should at that point.
> I then wanted to delete userA from the server. So i delete userA from the
> 'local users and groups' admin area in the control panel on the server.
> This is when I started to have problems.
> When I go back into RS to administor permissions, I tried to ammend the
> 'browser role' permissions for Dir1. When I try to save the changes the
> following error is displayed.
> 'The user or group name 'userA' is not recognized. (rsUnknownUserName) '
> Its seems that userA is still registered in RS.
> Logically I understand why, I've only deleted userA from windows, not from RS.
>
> My question is , How do I completely delete userA from RS.
> I noticed a users table in the RS database but there are numerous other
> tables which could have entries refering to userA.
> Is there a way to be sure all references to userA are deleted.
> The only way I could get round this was to re-generate userA as a windows
> user and disable it.
> This is not an ideal solution as I do not wish to have numerous disabled
> windows login users.
> Any suggestions would be gratefully received.
>
> --
> Message posted via http://www.sqlmonster.com
>|||I almost never assign individual users to a role. I create a local group and
then add users (in my case domain users) to the group. I then assign a role
to that local group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stewart Waddell via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:53C43C9C93255@.SQLMonster.com...
>I have the following problem.
> The system setup is as follows.
> IIS and sqlserver are on the same server and I'm using windows integrated
> security.
> I initially created a windows login user (userA).
> I then in the reporting services(RS) admin area, set the security
> permissions
> for a directory(Dir1). The permissions were, userA is a member of the
> browser role and the directory was set to the browser role.
> Everything worked as it should at that point.
> I then wanted to delete userA from the server. So i delete userA from the
> 'local users and groups' admin area in the control panel on the server.
> This is when I started to have problems.
> When I go back into RS to administor permissions, I tried to ammend the
> 'browser role' permissions for Dir1. When I try to save the changes the
> following error is displayed.
> 'The user or group name 'userA' is not recognized. (rsUnknownUserName) '
> Its seems that userA is still registered in RS.
> Logically I understand why, I've only deleted userA from windows, not from
> RS.
>
> My question is , How do I completely delete userA from RS.
> I noticed a users table in the RS database but there are numerous other
> tables which could have entries refering to userA.
> Is there a way to be sure all references to userA are deleted.
> The only way I could get round this was to re-generate userA as a windows
> user and disable it.
> This is not an ideal solution as I do not wish to have numerous disabled
> windows login users.
> Any suggestions would be gratefully received.
>
> --
> Message posted via http://www.sqlmonster.com