hi guys,
I was wondering about a silly thing but, anyway, which is the maximum number of grouping for a container? I mean, when you group from, i.e, a sql task and then over that group do again another one and so on...
Thanks in advance for your time,
Has anyone ever seen this issue?
If i place a loop container inside a sequence container the connectors within the loop container disappear.... is this a bug - will the loop tasks still run in the correct order?? or will they fire off willy nilly??
If I install SQL 2005 Standard on Windows 2003 Standard, is SQL limited to 4 gigs of physical RAM?
I'm planning a new system that will run SQL 2005 Standard edition on a Windows 2003 Standard platform. The spec calls for 8 GB of RAM. My experience would lead me to suspect I need to install Windows 2003 Enterprise to take advantage of all the installed memory.
I'm really stumped on this one. I'm a self taught SQL guy, so there is probobly something I'm overlooking.
I'm trying to get information like this in to a report:
WO#
-WO Line #
--(Details)
--Work Order Line Detail #1
--Work Order Line Detail #2
--Work Order Line Detail #3
--Work Order Line Detail #etc
--(Parts)
--Work Order Line Parts #1
--Work Order Line Parts #2
--Work Order Line Detail #etc
WO#
-WO Line #
--(Details)
--Work Order Line Detail #1
--Work Order Line Detail #2
--Work Order Line Detail #3
--Work Order Line Detail #etc
--(Parts)
--Work Order Line Parts #1
--Work Order Line Parts #2
--Work Order Line Parts #etc
I'm unable to get the grouping right on this. Since the line details and line parts both are children of the line #, how do you do "parallel groups"?
There are 4 tables:
Work Order Header
Work Order Line
Work Order Line Details
Work Order Line Requisitions
The Header has a unique PK.
The Line uses the Header and a Line # as foreign keys that together are unique.
The Detail and requisition tables use the header and line #'s in addition to their own line number foreign keys. My queries ends up looking like this:
WO WOL WOLR WOLD
226952 10000 10000 10000
226952 10000 10000 20000
226952 10000 10000 30000
226952 10000 10000 40000
226952 10000 20000 10000
226952 10000 20000 20000
226952 10000 20000 30000
226952 10000 20000 40000
399999 10000 NULL 10000
375654 10000 10000 NULL
etc
Hierarchy:
WO > WOL > WOLD
WO > WOL > WOLR
It probobly isn't best practice, but I'm kinda new so I need some guidance. I'd really appreciate any help! Here's my query:
SELECT [Work Order Header].No_ AS WO_No, [Work Order Line].[Line No_] AS WOL_No,
[Work Order Requisition].[Line No_] AS WOLR_No, [Work Order Line Detail].[Line No_] AS WOLD_No
FROM [Work Order Header] LEFT OUTER JOIN
[Work Order Line] ON [Work Order Header].No_ = [Work Order Line].[Work Order No_] LEFT OUTER JOIN
[Work Order Line Detail] ON [Work Order Line].[Work Order No_] = [Work Order Line Detail].[Work Order No_] AND
[Work Order Line].[Line No_] = [Work Order Line Detail].[Work Order Line No_] LEFT OUTER JOIN
[Work Order Requisition] ON [Work Order Line].[Work Order No_] = [Work Order Requisition].[Work Order No_] AND
[Work Order Line].[Line No_] = [Work Order Requisition].[Work Order Line No_]
Hello:
Does anyone know if there is a way to get SQL 7.0 to recognize 8 GB of RAM? The MS knowledgebase does not list anything usefull. On a test machine we upgraded the os from NT4 to Win2000 Advanced Server and SQL 7 will only recognize 4GB. We could goto SQL2000 but that is not supported with our current apps.
Thanks,
If there is a need to add a new column to the table, how would you do it to add it to an EXISTING report using RB? I don't want to create a new RB report. I want to add the new column to an existing RB report.
p.s. Anybody knows how to replace a Report Model on the report server when re-deploying it? Currently I manually delete the Report Model and re-deploy it onto the server. Otherwise, it gives me an error for duplicate IDs. Is there a switch that can be turned on? Thanks.
** For those 20 users (or fewer) who've read http://forums.asp.net/thread/1692306.aspx, I'm sorry that I ask the same question.Like I said above, what is the limitation of SQLEXPRESS, in terms of performance and scability?I'm creating a new webboard application that will replace the old one. I intend it to handle 200 concurrent users + 70000 records (9 years of data)The current system use Microsoft Access, which is reaching it's limit in performance and size. I took a look in the SQL Server product information page : http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx.It didn't tell me what I want, like how many connections it can handle, for example.If there are limitations that might cause my application to not reach the required specification (above), I may need to switch to MySQL. I've no intention buying a licensed SQL Server 2005.Thanks in advance.PS: Why there're so few users viewing my posts? Anyone know a more active forum that may help me?
View 9 Replies View RelatedJust wondering how many transaction replication subscriber can a publication
have? thanks!
Xiao
I have a column called codeabbreviation and currently the Max character limit is 72. Now I want to decrease it to 35character max but before I do that I want to find all rows in that column that already exceeds the 35character max so that I can clean it up down to 35characters.
What is the proper statement to use so that I can query for rows that exceeds 35characters?
Does anybody know what is the limit for the number of values one canhave in a list of expressions (to test for a match) for the IN clause?For example,SELECT au_lname, stateFROM authorsWHERE state IN ('CA', 'IN', 'MD')Is there a limit in the number of expressions that can be included inthe list to check for a match to STATE? I know this is a bad example asthere are only 50 states, but my actual query is similar to this, theonly difference being I may have about 1000 values in the 'IN' clauseto test for a match.TIA!
View 3 Replies View RelatedHi,
Can somebody tell me if the 4 GB database size limit is per database or for all the databases
Regards
Harish
Can I get a documentation about full text capacity and limitation like memory utilization, number of catalogs per server, no of rows in each catlaog for SQL Server 2000.
Thanks
Tanweer
ok i am using Microsoft sql sever 2005 express edition built in VS 2005....just wanna know that is there any limitations of the no of tables that can be created in the database.......my webpage creates a new table in the database for each user who registers....so if there are more than thousand, millions. users...will the database work properly ????
View 2 Replies View RelatedHi Guys,
Can you please advice me on if there is a limitation on SQL agent Jobs. If then how many jobs can SQL server accomedate.
If there is a limit, then is there are any ways to increase it?
I appreciate your quick response.
Thanks
I found an article that stated that there was a limit of 1GB of total user databases for SQL on Small Business Server. I could not tell if that was SBS 2003 or an earlier version. Does anyone know if there is any limitation?
View 1 Replies View RelatedI have created a backup device. THe file it wrote (.dat) is 1.2 gig when I tried to run another backup to it it failed (3sec) Is there a size limitation on the Device or .dat file size?
Just testing things out I tried to directly open this file and it gave me a memory problem(Try closing other applications not enough memory to open "filename").
I would appreciate your help, thanks
Jerry
Hi,
I am porting data between sql65 servers. I am transfering data using bcp , while doing bcp i am getting following error.
DB-Library error: Attempt to bulk-copy an oversized row to the sql server.
DB-Library error: Attempt to convert data stopped by syntax error in source field.
My row size in the particular table is : 170 bytes length.
Can anyone have idea, what is row size limitation in 65.
i am having service pack 5a.
--RK
Code is:
select
case when ItemCode is null then '-'
else ItemCode
End,
case when sum(RecdQty) is null then '-'
else sum(RecdQty)
End
from ItemMaster where ItemCode='V001' group by ItemCode
Problem Statement:
If query is not getting any records for above mentioned condition, then I want zero to be displayed if datatype is int (i.e. for sum(RecdQty) field) and '-' to be diplayed if datatype is varchar (i.e. for ItemCode field).
In this situation, "ItemCode is null" and "sum(RecdQty) is null" conditions are not been utilised.
Is this a limitation of case or group by clause?
Hi all,I am new to the ADODB.StreamI am using following codelRecordset.Open "Select * from <some table-name>"'this query return more than 1000 recordsdim lstream as new ADODB.stream'assigning the recordset data to the streamlrecordset.save lstreamlStream.Position = 0Dim lRecordset2 As New ADODB.RecordsetlRecordset2.Open lstreamMsgBox lRecordset2.RecordCountmy problem is that query is returning say 1500 records but when i amagain assigning the same stream to another recordset it is copyingonly 485 recordsthat is lstream is saving only 485 records...is there any size limiton stream...?how i can do this using stream only....If u have any solution plz reply back..Thanks in advance...
View 1 Replies View Related
Hi,
I'm using ADO 2.8 in a vb.net code. The .Net framework version is 1.1 and windows server 2003.
I'm firing a query that result in 256 columns and few hundred rows. Here is the snapshot of the code
adoRs = New ADODB.Recordset
With adoRs
.CursorLocation = CursorLocationEnum.adUseClient ' adUseClient
.ActiveConnection = adoCn
.CursorType = CursorTypeEnum.adOpenStatic ' adOpenStatic
.LockType = LockTypeEnum.adLockBatchOptimistic ' adLockBatchOptimistic
.Open(strSQL)
End With
The returned record set is empty with all the the 256 columns name. Could anyone shed light why it is returning empty recordset. Is there any limitation on number of columns that a recordset can hold.
Thanks in advance.
With regards
Ganesh
I am using FileSystemTask to copy around 4 gb file(ASCII). Is there any limitation on the file size.
SQL Server 2005 SP2, Windows 2003 server. Copying from one Windows 2K server to other Windows 2K server.
Thank you,
Hi,
I came accross this and spend a significant amount of time on it. Thought I'd posit it for all. I looks like 2005 SSIS has a limitation on the number of simultaneous transformations it can pull from an XML file using "XML source" as a dataflow. I've got an XML / XSD that will load 20 tables. I cannot put more than 13 into my data flow task. If I do I get the error message below. I've tried adding multiple OLE DB transformations to the same server/db and spreading my feeds accross the OLEDB destination connections and it still fails with the same error. Despite the error pointing to the network I see no evidence of that. I've tried everything and it consistently goes away when I have only 13 transformations and comes back as soon as I go up to 14. I've not seen this documented as a limitation so I can only assume it's a bug.
BTW -- to get around the problem you can just add multiple data transfer tasks to the same SSIS project and that works fine.
Error: 0xC0202009 at Package, Connection manager "server1.conn1": An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.".
Error: 0xC020801C at Data Flow Task, OLE DB Destination 13 [12709]: The AcquireConnection method call to the connection manager "server1.conn1" failed with error code 0xC0202009.
In the latest issue of MSDN Journal , article "IIS 7.0: Enhance Your Apps Wioth Integrated ASP.NET Pipeline", Mike Volodarsky says:
"...Be sure to close the tool after you are finished as SQL Server Express Edition allows only one user identity to access the database at a time."
Can someone elaborate on this?
Hello everybody,
Can someone tell me if there are any limitation in SQL Server Agent of SQL Server 2005?
I have a Windows 2003 Enterprise R2 with 16GB RAM and SQL Server 2005. However my SQL Agent log say:
"Message
[310] 4 processor(s) and 4096 MB RAM detected"
Any KB related?
thanks a lot
Hello,
I have a field in my SQL Server 2000 with type "varbinary(8000)" which I merge onto my SQL CE 2.0 database. On my SQL CE 2.0, this field becomes "image".
Based on Microsoft's site: http://msdn2.microsoft.com/en-us/library/aa257477(SQL.80).aspx, "image" is used if the size is not over 510; however, when I populate this field in SQL CE, the maximum size that is stored is 510 bytes. I have verified my source data was complete (2622 butes) when again when I check the size of the field after an insert, it had only 510 bytes.
What's the work-around?
Thank you.
Hi all,
I create one report with one report parameter call €śReport_Parameter_0€?. I access this report though HTML Form. Ex
<FORM action=http://hodb04/reportserver?/report/Report12 method="post">
<INPUT type="hidden" value="Render" name="rs:Command" ID="Hidden1">
<INPUT type="hidden" value="HTML4.0" name="rs:Format" ID="Hidden2">
<INPUT type="hidden" value="true" name="rc:Toolbar" ID="Hidden3">
<INPUT type="hidden" value="true" name="rcarameters" ID="Hidden4">
<INPUT type="hidden" value="request " name="Report_Parameter_0" ID="Hidden5"> <input type="Submit>
</FORM>
If I update the Report_Parameter_0 value from €śrequest€? to the string with more then 2000 characters, then I will receive the follow error message from the Internet Explorer
€śres://C:WINDOWSsystem32shdoclc.dll/dnserror.htm#http://hodb04/reportserver?/DmReport/Report12€?
My question is what it the limitation on the parameter passing thought HTML. What are the max characters I call pass to the report parameter?
Thanks,
tomas
Hi everyone,
Is there any limitation in number of accesses for a sql login account?
For example, I use one sql login account to connect between the website and db. Since I changed web server to window 2003. I got error message saying SQL Server does not exist or access denied.
I then created another sql account instead of only one login account. now the website is running fine and faster than before.
I really don't understand it. Can anyone please explain it?
Thanks in advance!
Hi,
I would like to know what problems will occur when I try to create a database that exceed the size limit of 4GB ?
Thanks
Hi everyone,
I wonder about this task.. which is the limit size for attachments? Is it depending of SMTP server?
Thanks in advance,
What is the reason behind Index key length limitation upto 900 bytes?
View 10 Replies View RelatedHello,
Does anyone know of a reg hack we can use to temporarily increase the size of the sql express limitation of 4 GB?
thanks, ken
Good Morning,
Is the 1 Gb limit a limitation of 1 Gb for all instances of express, or is it a per instance limitation?
Thanks
Kay
Here's a comment (from book) that says
"...Sharepoint sees the Report Viewer Web Part as a single item and will
continually rename it sequentially as Report Viewer [x].... This is a
limitation of SharePoint..."
http://books.google.com/books?id=b0dXlx5aww8C&pg=PA314&lpg=PA314&dq=report+viewer+web+part+title&source=web&ots=U0MVGHySWU&sig=pGBgHh2gXYWcpuZMqttY7S9B65c&hl=en
If this is true then it applies also to the ReportExplorer webpart. Is
there a current fix for SharePoint? Or is there a current fix for the
webParts?
I can see customers complaining that they would like to see on their
SharePoint ReportExplorer WebParts pointing to separate environments (SSRS)
and multiple ReportViewer webparts pointing to different reports.
Which would result in ReportExplorer [1], ReportExplorer
[2],....ReportExplorer [x]
and ReportViewer [1], ReportViewer [2],....ReportViewer [x].
Instructing customer's to ignore webpart title's and look at report names is
NOT going to be acceptable. Especially since other webparts within
Sharepoint behave differently.
Thanks in advance...