all groups > sql server clients > august 2006
SQL 2005 client tools-- 64 bit version
Posted by Prabhu at 8/30/2006 5:17:02 PM
While I am installing SQL 2005 Enterprise edition 64 bit version, if I select
client tools also, installation fails.
My question is, can't we install client tools with this 64 bit server
software CD. Don't we have SQL 2005 64 bit client tools. What's the work
around other than getting 32 bi... more >>
Verify Database backup file.
Posted by Rogers at 8/28/2006 3:44:28 PM
I forgot how to verify the database backup file. I think there is one DBCC
command through which we can verify the database backup file to make sure
its not corrupted.
Can any one recall this.
Thanks
... more >>
Why do you need the Microsoft Office Web Components for 2005
Posted by Edie Richardson at 8/22/2006 6:43:02 AM
Our security will not allow up to have the Microsoft Office Web Components.
I thought it was needed for the books on line but I uninstalled the web
components and was still able to use BOL. Does anyone have any idea if we
could install the client tools on our desktops without the Web Compone... more >>
Transaction Log shrinking problems
Posted by Jiro Hidaka at 8/21/2006 5:12:43 PM
Hello,
I was trying to restore a backup of a database file and got the error below:
"MODIFY FILE encountered operating system error 112(There is not enough
space on the disk.) while attempting to expand the physical file.
Could not adjust the space allocation for file 'SysproCompanyM_log'.... more >>
SQL Server - PDF
Posted by Rogers at 8/21/2006 11:47:33 AM
Dear Professional,
I have created one crystal report which pointing to our sql server database,
I want to automate this process. I want to convert crystal report to PDF and
send email to our customer through SQL Server, is it possible?.
Thanks
... more >>
SQL 2000 EntMgr & SQL 2005 Management Console
Posted by doug at 8/17/2006 7:22:02 AM
On my workstation I need SQL 2000 EntMgr for ongoing support. I installed
MSVS .Net 2005 and it installed SQL 2005 Express. I know I have a set of
directories under Microsft SQL Server\80 and \90. I had hoped I would be
able to run SQL 2000 EnmtMgr side by side with the newer SQL 2005 Manag... more >>
Server: Msg 8115
Posted by at 8/16/2006 3:57:56 PM
I am experiencing an error message when I run a TSQL and I don't know how to
correct it.
Server: Msg 8115, Level 16, State 8, Line 38
Arithmetic overflow error converting numeric to data type numeric.
In this code I am extracting hierarchical information. I am going 6 levels
deep. The s... more >>
Complex Query (atleast I think so)
Posted by at 8/10/2006 2:43:06 PM
We have a couple of Bill of Material tables in our SQL 2000 database and I
need to extract information.
The first table is the master table and the only relevant field is fpartno.
Table two is the child table, and it contains all of the parts that make up
the fpartno in the master table. Th... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
xp-sendmail ...does it store outbound emails in a table? if so what table?
Posted by jswayman NO[at]SPAM gmail.com at 8/4/2006 2:52:06 PM
I haven't used xp_sendmail before...new job...new problems...
We apparently have several emails that aren't being sent daily when
they are supposed to be sent. When they do finally get sent, the
recipients get blasted with a weeks worth of emails.
I was told that the outbound emails might b... more >>
Help!
Posted by tallen at 8/4/2006 9:43:02 AM
I have a client that is running sql 6.5 on 2003 server. Users are getting not
enough memory error messages when accessing SQL. What are some of the things
I should check when onsite? Thanks!!... more >>
|