Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Wed, 30 Jul 2008 18:08:45 -0700,    group: microsoft.public.sqlserver.newusers        back       


Standard Operating procedure for doing a maintenance plan (SQL 2005)   
Hi;

Can anyone point me to a template for a Standard operating procedure and 
maintenance plan to keep SQL running healthy
These are steps or common tasks done by an admin or a power user

Thanks a bunch

Rock
date: Wed, 30 Jul 2008 16:31:28 -0400   author:   Rocky5

Error   
Hello I get this error message and I don't know what to do or go to fix this 
I am a new user to sql server 2005 can someone help. I am trying to connect 
via ODBC Microsoft to AS/400.   Message says:

Executed SQL Statement:  SELECT OVDA, OVBC, ODGY  FROM
ABC.ASC  ORDER BY OVDA

Error Source:  CWBODC.DLL
Error Message:  ERROR [HY000] [IBM][iSeries Access ODBC Driver][DB2 
UDB]SQL0666 - SQL query exceeds specified time limit or storage limit.



Any website to visit or tips will be appreicated.  Thank you in advance.
date: Wed, 30 Jul 2008 18:08:45 -0700   author:   CAM

Re: Error   
CAM,

http://www-1.ibm.com/support/docview.wss?uid=nas1337ac2bf0df7e4268625697d00793eb5
http://www.itjungle.com/fhg/fhg071305-story03.html

RLF

"CAM"  wrote in message 
news:OaS59nq8IHA.2060@TK2MSFTNGP02.phx.gbl...
> Hello I get this error message and I don't know what to do or go to fix 
> this I am a new user to sql server 2005 can someone help. I am trying to 
> connect via ODBC Microsoft to AS/400.   Message says:
>
> Executed SQL Statement:  SELECT OVDA, OVBC, ODGY  FROM
> ABC.ASC  ORDER BY OVDA
>
> Error Source:  CWBODC.DLL
> Error Message:  ERROR [HY000] [IBM][iSeries Access ODBC Driver][DB2 
> UDB]SQL0666 - SQL query exceeds specified time limit or storage limit.
>
>
>
> Any website to visit or tips will be appreicated.  Thank you in advance.
>
>
date: Thu, 31 Jul 2008 11:20:39 -0400   author:   Russell Fields

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us