Server Configuration

DST time change and SQL agent jobs
Hi All, I got a problem with our SQL agent jobs due to DST time change, and hope you can shed some light on what might have happened. We are running SQL 2005 SP2 CU9 64bit EE on Win 2k3 64bit EE. The problem: We have about 10 log backup jobs for manual log shipping purposes. Jobs are schedule to run hourly ... 15 Mar 2010 14:39

User 'public' does not have permission to run DBCC TRACEON
When it crashes you get a SQL server login box up with "Options" Application name will say Microsoft Query....change that to anything else and it will work. From http://www.developmentnow.com/g/118_2007_2_0_0_932485/User-public-does-not-have-permission-to-run-DBCC-TRACEON.htm Posted via DevelopmentNow.com Groups... 15 Mar 2010 03:32

JTDS support for shared memory access
Can anyone tell me if JTDS supports shared memory access? I would like to access the DB with TCP and Named Pipe DISABLED Appreciate your replies. Thanks! From http://www.developmentnow.com/g/118_0_0_0_0_0/microsoft-public-sqlserver-server.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/... 12 Mar 2010 15:05

SQL 2005 attemted to read or write protected memory.
When we works on the SQL server itself with the SQL Server Manager, we receive regular the following error message: attemted to read or write protected memory. this is often an indication that other memory is corrupt. Google find the following for me, http://support.microsoft.com/kb/926421/, but this upda... 11 Mar 2010 07:49

SQL service broker
It appears that the service broker newsgroup may be dead ? I apologize if some view this a cross posting... I have a process whereby I would like to accomplish the following... The setting includes many client workstations using a VB.net application to communicates with a database via ADO connections. The ... 10 Mar 2010 19:49

SQL Server 2005 Rename Instance Name
Is it possible to rename SQL Server 2005 instance name without creating a new instance within SQL Server? Please help me with this issue. Joe K. ... 10 Mar 2010 18:43

Connect SQL 2000 from SQL 2008 Powershell
Hi Daniel, I have the same problem when connecting to SQL 2000 SP4 from the SQL 2008 PowerShell. Did you have any luck finding the minimum required to be installed on SQL Server 2000 in order for this to work? I installed Microsoft SQL Server 2008 Management Components and Native Client, but I still get the same er... 10 Mar 2010 16:28

DBTYP.NET Studio 2010 - Database Comparison Suite Released
DBTYP.NET Studio 2010 - Database Comparison Suite Released Vienna, Austria - March 8, 2010 Today, BYPsoft announced the availability of DBTYP.NET Studio 2010, the newest version of the cross-database comparison tool that compares SQL Server, MySQL and Oracle databases (schema and data). DBTYP.NET Studio 2010 ... 10 Mar 2010 15:21

Log Shipping Problem -Last Backup File and Last_backup_date
The above two columns in table log_shipping_primary_database dont appear to be getting updated with the latest trans log backup information causing alerts. The trans logs are being backed up copied and restored sucessfully to the secondary database. Somethings out of sync but the information in the logshippin... 11 Mar 2010 01:19

Forums versus newsgroups - can you indulge a SBS MVP by answeringsome questions?
As an SBSer since I have SQL on my server I feel like SQL is family so if you'll indulge me in a fishing expedition on forums versus newsgroups. I need to pick your brain a bit if you don't mind? Can I ask some fishing expedition questions because I want to see if my thoughts are on track with others. Just w... 9 Mar 2010 16:58