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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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