Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
Minidach: Using JDBC, you can directly access an MS-SQL database. If you visit the SYstem i Network website and forums, you will find several articles, down-loadable code, etc. You MAY be able to access an MS-SQL database using IBM i DB2 SQL, but I have not personally done that. HTH Jon Juracich.
View Answer
| September 24, 2009 2:08 PM
AS/400, Embedded SQL, Microsoft SQL Server
Minidach: Using JDBC, you can directly access an MS-SQL database. If you visit the SYstem i Network website and forums, you will find several articles, down-loadable code, etc. You MAY be able to access an MS-SQL database using IBM i DB2 SQL, but I have not personally done that. HTH Jon Juracich.
View Answer
| September 24, 2009 2:08 PM
AS/400, Embedded SQL, Microsoft SQL Server
SQL Server 32 bit, AWE/3GB/PAE
The /3GB switch increases the virtual address space from 2 Gigs to 3 Gigs. This increases the potential size of the procedure cache and application memory.
View Answer
| September 24, 2009 12:36 AM
3GB, AWE, PAE, SQL Server
The /3GB switch increases the virtual address space from 2 Gigs to 3 Gigs. This increases the potential size of the procedure cache and application memory.
View Answer
| September 24, 2009 12:36 AM
3GB, AWE, PAE, SQL Server
Nominate a member for our latest Panasonic flatscreen giveaway
Please nominate your fellow community members below in the “Discussion” section. Thanks! —————————- We solve problems as a team — this process doesn’t feel team friendly Phil ————————— Wouldn’t you like to reward your team members for their contributions/support ? Recognizing other’s value is very team friendly from my point of view. ————————– Hi Phil, [...]
View Answer
| September 23, 2009 5:36 PM
AS/400, Contests, Data Center, Exchange, Flatscreen, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Panasonic, Security, SQL Server, Storage, Virtualization, VoIP
Please nominate your fellow community members below in the “Discussion” section. Thanks! —————————- We solve problems as a team — this process doesn’t feel team friendly Phil ————————— Wouldn’t you like to reward your team members for their contributions/support ? Recognizing other’s value is very team friendly from my point of view. ————————– Hi Phil, [...]
View Answer
| September 23, 2009 5:36 PM
AS/400, Contests, Data Center, Exchange, Flatscreen, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Panasonic, Security, SQL Server, Storage, Virtualization, VoIP
Making a WAN
I would recommend a managed service provider like <a href=”http://www.virtela.com”>Virtela</a> or some other datacom provider that services the regions where your organization has sites located. It sounds like you do not have staff to manage the WAN so a managed service provider can assist with design, implementation and management. My organization uses Virtela for 20 [...]
View Answer
| September 23, 2009 11:55 AM
Exchange 2003, Network Configuration, SQL Server 2000, WAN, WAN design, WAN hardware, WAN technologies, Windows Server 2003
I would recommend a managed service provider like <a href=”http://www.virtela.com”>Virtela</a> or some other datacom provider that services the regions where your organization has sites located. It sounds like you do not have staff to manage the WAN so a managed service provider can assist with design, implementation and management. My organization uses Virtela for 20 [...]
View Answer
| September 23, 2009 11:55 AM
Exchange 2003, Network Configuration, SQL Server 2000, WAN, WAN design, WAN hardware, WAN technologies, Windows Server 2003
If running two SQL Server db in two VMs, I should purchase two db servers?
Check out this <a href=”http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx”>http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx</a> If depends. If you have SQL Server Enterprise Edition installed, then you can buy enough CPU licenses to cover the host and all VMs on that host will be covered. If you have Standard Edition you need to license each VM by it self. So if you have a 4 [...]
View Answer
| September 18, 2009 8:07 AM
Microsoft virtualization, SQL Server databases, Virtual Machines
Check out this <a href=”http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx”>http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx</a> If depends. If you have SQL Server Enterprise Edition installed, then you can buy enough CPU licenses to cover the host and all VMs on that host will be covered. If you have Standard Edition you need to license each VM by it self. So if you have a 4 [...]
View Answer
| September 18, 2009 8:07 AM
Microsoft virtualization, SQL Server databases, Virtual Machines
Complete System Backup SQL Server
You didn’t provide any information about how you are backing up the systems. If you are doing a backup within SQL via a SQL Agent Job, then you are backing up the SQL Server. If you are backing up the database, using the SQL module of a backup software package like Commvault, NetBackup, etc then [...]
View Answer
| September 18, 2009 7:59 AM
Activant Solutions, Backup, Dell servers, Prophet 21, SQL Server 2008, Terminal Server
You didn’t provide any information about how you are backing up the systems. If you are doing a backup within SQL via a SQL Agent Job, then you are backing up the SQL Server. If you are backing up the database, using the SQL module of a backup software package like Commvault, NetBackup, etc then [...]
View Answer
| September 18, 2009 7:59 AM
Activant Solutions, Backup, Dell servers, Prophet 21, SQL Server 2008, Terminal Server
dbcc checkdb error; object id 0
I’d start by running DBCC on the source database and see if there’s anything wrong with the source database. It sounds like the corrupt page isn’t associated with a table, so the engine doesn’t know what to do with it. If the source database has this same corruption you may want to call Microsoft and [...]
View Answer
| September 16, 2009 10:30 PM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
I’d start by running DBCC on the source database and see if there’s anything wrong with the source database. It sounds like the corrupt page isn’t associated with a table, so the engine doesn’t know what to do with it. If the source database has this same corruption you may want to call Microsoft and [...]
View Answer
| September 16, 2009 10:30 PM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
Trigger Use
Database triggers don’t respond to application events. You could create a trigger that will fire when an UPDATE is performed on a specific table, but you would have to make your application update that table when the combo box is modified. You can create triggers from Management Studio by expanding the desired table tree, right-clicking [...]
View Answer
| September 16, 2009 8:10 PM
Database Management Systems, SQL Server, SQL Server 2005
Database triggers don’t respond to application events. You could create a trigger that will fire when an UPDATE is performed on a specific table, but you would have to make your application update that table when the combo box is modified. You can create triggers from Management Studio by expanding the desired table tree, right-clicking [...]
View Answer
| September 16, 2009 8:10 PM
Database Management Systems, SQL Server, SQL Server 2005
SQL Database User
Sort of. You’ll create the login on one server. Then when you create the login on the other two servers you’ll want to specify the SID, so that when the databases are restored the SIDs match.
View Answer
| September 14, 2009 11:58 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security
Sort of. You’ll create the login on one server. Then when you create the login on the other two servers you’ll want to specify the SID, so that when the databases are restored the SIDs match.
View Answer
| September 14, 2009 11:58 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security
SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes
Run SQL Profiler and see if the query is actually taking longer to run, or if the wait time is all with SSRS creating the report. When SSRS runs the procedure the ANSI settings than will be different from the ones that SSMS uses which can cause a different execution plan to be generated.
View Answer
| September 14, 2009 5:52 PM
SQL, SQL performance, SQL Server Reporting Services, SSRS
Run SQL Profiler and see if the query is actually taking longer to run, or if the wait time is all with SSRS creating the report. When SSRS runs the procedure the ANSI settings than will be different from the ones that SSMS uses which can cause a different execution plan to be generated.
View Answer
| September 14, 2009 5:52 PM
SQL, SQL performance, SQL Server Reporting Services, SSRS
App-V application license requirements
That is an interesting Licensing question. I am not a licensing expert, so I would suggest talking with your LSA, but if your user has a license to access any SQL server, then if the app has a SQL server in it, then it would be treated like any other SQL Server.
View Answer
| September 14, 2009 1:55 PM
App-V, Application virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, SQL Server licensing
That is an interesting Licensing question. I am not a licensing expert, so I would suggest talking with your LSA, but if your user has a license to access any SQL server, then if the app has a SQL server in it, then it would be treated like any other SQL Server.
View Answer
| September 14, 2009 1:55 PM
App-V, Application virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, SQL Server licensing
Controlling tempdb Growth
You should move the tempdb to another drive which has enough space. You can move the tempdb database without issue. Moving the tempdb database is actually very easy. <pre>ALTER DATABASE tempdb MODIFY FILE (name=’tempdev’, filename=’D:PathToWhereItWillBetempdev.mdf’) GO ALTER DATABASE tempdb MODIFY FILE (name=’templog’, filename=’D:PathToWhereItWillBetemplog.ldf’) GO</pre> Just change the drive letters and paths to be where you [...]
View Answer
| September 11, 2009 10:18 PM
SQL Server, SQL Server 2005, TempDB
You should move the tempdb to another drive which has enough space. You can move the tempdb database without issue. Moving the tempdb database is actually very easy. <pre>ALTER DATABASE tempdb MODIFY FILE (name=’tempdev’, filename=’D:PathToWhereItWillBetempdev.mdf’) GO ALTER DATABASE tempdb MODIFY FILE (name=’templog’, filename=’D:PathToWhereItWillBetemplog.ldf’) GO</pre> Just change the drive letters and paths to be where you [...]
View Answer
| September 11, 2009 10:18 PM
SQL Server, SQL Server 2005, TempDB
What are the licensing requirements associated with App-V?
Since App-V doesn’t change the execution location or user for the applications (it still runs where it would run if installed locally), most existing license requirements are the same as local install.
View Answer
| September 11, 2009 6:22 PM
App-V, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server
Since App-V doesn’t change the execution location or user for the applications (it still runs where it would run if installed locally), most existing license requirements are the same as local install.
View Answer
| September 11, 2009 6:22 PM
App-V, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server
can one use App-V to install SQL Server as part of a virtualized application?
Yes. depending on the configuration, services like SQL can be part of an App-V package, if it’s part of the application.
View Answer
| September 11, 2009 2:00 PM
App-V, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, Virtualized Applications
Yes. depending on the configuration, services like SQL can be part of an App-V package, if it’s part of the application.
View Answer
| September 11, 2009 2:00 PM
App-V, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, Virtualized Applications
How can one ‘v-app’ an application that uses a db like SQL 2008 express?
You can use App-V to install SQL Express as part of a virtualized applications.
View Answer
| September 10, 2009 9:28 PM
Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL 2008, SQL Express, SQL Express 2008, V-App, Virtual Apps
You can use App-V to install SQL Express as part of a virtualized applications.
View Answer
| September 10, 2009 9:28 PM
Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL 2008, SQL Express, SQL Express 2008, V-App, Virtual Apps
SQL server 2000 increase database auto-grow
You should manually grow out the database so that it is as big as it will need to be. SQL 2000 writes 0s to the file when it grows so large autogrow events will take time to complete. 10 MB is definitely to small. This will cause autogrow events to kick off quite often which [...]
View Answer
| September 9, 2009 8:11 AM
Auto Grow, Database Sizing, SQL Server 2000
You should manually grow out the database so that it is as big as it will need to be. SQL 2000 writes 0s to the file when it grows so large autogrow events will take time to complete. 10 MB is definitely to small. This will cause autogrow events to kick off quite often which [...]
View Answer
| September 9, 2009 8:11 AM
Auto Grow, Database Sizing, SQL Server 2000
SQL convert numeric to date format
Dane I RPG it’s: %date(mydt80:*iso0) but I don't think that SQL has an ISO0 so it's Date(substr(char(mydt90).1.4) || '-'|| substr(char(mydt90).5.2) || '-'|| substr(char(mydt90).7.2) , ISO) Phil ————– kccrosser Cast and Convert allow converting to/from datetime and strings easily, and supports multiple different ISO and non-ISO formats. Convert(datetime, <inputvar>, 114) will convert a string of the [...]
View Answer
| April 19, 2013 8:25 PM
SQL, SQL Date Calculation, SQL datetime
Dane I RPG it’s: %date(mydt80:*iso0) but I don't think that SQL has an ISO0 so it's Date(substr(char(mydt90).1.4) || '-'|| substr(char(mydt90).5.2) || '-'|| substr(char(mydt90).7.2) , ISO) Phil ————– kccrosser Cast and Convert allow converting to/from datetime and strings easily, and supports multiple different ISO and non-ISO formats. Convert(datetime, <inputvar>, 114) will convert a string of the [...]
View Answer
| April 19, 2013 8:25 PM
SQL, SQL Date Calculation, SQL datetime
How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?
It is usually recommended that you not store graphics within the database. The database will quickly become a performance bottleneck and you will see your database grow quickly to a very large size. That said, I posted an answer to a similar question up on the SearchSQLServer.com site in the mailbag <a href=”http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1366927,00.html”>last week</a>. It’s [...]
View Answer
| September 7, 2009 9:13 PM
SQL Server 2005, VB.NET, VB.NET 2005, VB.NET 2005 programming
It is usually recommended that you not store graphics within the database. The database will quickly become a performance bottleneck and you will see your database grow quickly to a very large size. That said, I posted an answer to a similar question up on the SearchSQLServer.com site in the mailbag <a href=”http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1366927,00.html”>last week</a>. It’s [...]
View Answer
| September 7, 2009 9:13 PM
SQL Server 2005, VB.NET, VB.NET 2005, VB.NET 2005 programming
SQL dynamic date calc.
Something like this??? select * from myFile where myDt80 > substring(char (current date – 36 months ,iso),1,4) || substring(char (current date – 36 months ,iso),6,2) || substring(char (current date – 36 months ,iso),9,2 ) Phil ———————- Thanks for the feeback Phil
View Answer
| September 7, 2009 1:19 PM
IBM 9407 M15, SQL, SQL Calculations, SQL Dynamic Date Calculation
Something like this??? select * from myFile where myDt80 > substring(char (current date – 36 months ,iso),1,4) || substring(char (current date – 36 months ,iso),6,2) || substring(char (current date – 36 months ,iso),9,2 ) Phil ———————- Thanks for the feeback Phil
View Answer
| September 7, 2009 1:19 PM
IBM 9407 M15, SQL, SQL Calculations, SQL Dynamic Date Calculation
SQL 2008 mirroring – are jobs active on mirror on just on failover?
The jobs should only be run against the active database. The mirror copy cannot be read or written to, so you’ll want to have the jobs on that server disabled until you have failed over the server. That or deal with the fact that all the jobs on that server will fail until that server [...]
View Answer
| September 4, 2009 10:24 PM
SQL 2008 Mirroring
The jobs should only be run against the active database. The mirror copy cannot be read or written to, so you’ll want to have the jobs on that server disabled until you have failed over the server. That or deal with the fact that all the jobs on that server will fail until that server [...]
View Answer
| September 4, 2009 10:24 PM
SQL 2008 Mirroring
