mysql to crystal report

i have my db at mysql, but i need to link it to crystal report to make a report for my company.
how can i do it?
thanksYou can use ODBC or OLE DB, but you need to install ODBC or OLE DB driver of MySQL.|||how to install odbc or ole in mysql?|||how to install odbc or ole in mysql?
No, not to install ODBC in your MySQL, but in your PC.
After installation finished, then select your data source to ODBC which
using MySQL ODBC driver.|||Download MySql Connector/ODBC (http://dev.mysql.com/downloads/connector/odbc/3.51.html) and after installation.

Go to ODBC Data Source Adminiostration -> System DSN - >Add -> MySQL ODBC 3.5 Driver and set the server information.

Then you can use this connection in the Crystal Report.

MyLittleAdmin Error -2147217900 - Incorrect syntax near ''(''.

Hi,
I'm trying to create various tables on a hosted environment. Unfortunately the hosting company (lets just say 1 + 1 don't = 2) don't support remote connections so I can't access the DB using MS SQL Management Studio. So I have to use a 3rd party tool - MyLittleAdmin.

I can import scripts, and the majority of the time its ok, but I can't create certain tables that uses the generated scripts from Management Studio.

The error I received is:

Error -2147217900

Line 14: Incorrect syntax near '('.

The Script is:

Code Snippet

USE
[dbName]
GO
/****** Object: Table [dbo].[tfs_AreaManager] Script Date: 08/06/2007 14:29:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tfs_AreaManager](
[armId] [bigint] IDENTITY(1,1) NOT NULL,
[armUserId] [uniqueidentifier] NOT NULL,
[armAreaName] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[armRgmId] [bigint] NULL,
[armFName] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[armSName] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[armEmail] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[armPhone] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_tfs_AreaManagers] PRIMARY KEY CLUSTERED
(
[armId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[tfs_AreaManager] WITH CHECK ADD CONSTRAINT [FK_tfs_AreaManager_tfs_RegionManager] FOREIGN KEY([armRgmId])
REFERENCES [dbo].[tfs_RegionManager] ([rgmId])
GO
ALTER TABLE [dbo].[tfs_AreaManager] CHECK CONSTRAINT [FK_tfs_AreaManager_tfs_RegionManager]

I think line 14 refers to the 14th line counting from the 3rd GO instruction (code highlighted in RED).

Can anyone advise me as to what the problem is. I can create the table if I only use the script before the constraint operation. If I create the table, and then just script the constraints after, then they fail too. So I know it is the constraint opertaion that is the problem. Any help would be greatly appreciated!

Seems that you create the scripts with a SQL Server 2005 instance and the target one is a SQL Server 2000< one (or pretends to be in terms of compability level). So either change the compat level (if the target instance is a 2005 server) or create the scripts with compat level of your target database.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Oh that could be it! Do you know how I generate scripts for a SQL Server 2000 target?

Thanks for the help.

|||

If you are using the script generator you can use the "Script for Server Version" > SQL Server 2000

Jens K. Suessmeyer

http://www.sqlserver2005.de

my whole company and customer info/credit cards on the internet

I've been searching for a new ERP solution for my company for a while and I
think I've finally found the best one for us. But now I'm being cautioned
about some things so I need some good arguments about how I should setup the
database server.
The application is written in .net it is a N tiered application (I guess
that's what it's called) and it also has a tightly integrated commerce site.
The system was designed to work best with the app db and commerce db on the
same sql server. Desktop clients can connect by internet access if that
server isn't on the LAN and the website can even connect to the LAN but this
obviously wouldn't work because we're only using DSL here.
I've been cautioned that I shouldn't have internet access on my database
server. I somewhat understand the reasoning for this but to me it seems most
data is about as secure as the applications that access them in the first
place. So even if I had a state of the art network in place, a security flaw
in the app could screw me over regardless.
What is good business security practice for handling/storing sensitive
customer information on the internet and what is overkill/paranoia? This is
a serious questions so I'd appreciate not to be mocked.
I'm not a DBA so maybe I'm a little off on my terms, feel free to correct me
where I'm wrong. But it seems to me that if didn't use the same db server
for both the website and main system I'd have a lot of extra work like
replicating web data to web enabled sql server in our office and from the
"live server" on our LAN and then back again.
Thanks in advance for your advice/criticism/suggestions.
RobertForgot to mention. I was assuming to set it up like this
[dedicated sql server] - the only port enabled on this box is for mssql
would probably use a non default port
[dedicated web/email/application server] ports, email and web/ssl
(25/80/110/443)|||Normally what you do is expose the middle-tier (or even yet another system)
to the Internet, and then you only allow that system to connect to your
database server. Yes, if that system is compromised, there can also be
issues, but if you code correctly the only things exposed would be those tha
t
stored procedures or view expose. There are several good books on designing
secure web applications, so I suggest you check out your local bookstore for
one that fits your style.
"Rob" wrote:

> I've been searching for a new ERP solution for my company for a while and
I
> think I've finally found the best one for us. But now I'm being cautioned
> about some things so I need some good arguments about how I should setup t
he
> database server.
> The application is written in .net it is a N tiered application (I guess
> that's what it's called) and it also has a tightly integrated commerce sit
e.
> The system was designed to work best with the app db and commerce db on th
e
> same sql server. Desktop clients can connect by internet access if that
> server isn't on the LAN and the website can even connect to the LAN but th
is
> obviously wouldn't work because we're only using DSL here.
> I've been cautioned that I shouldn't have internet access on my database
> server. I somewhat understand the reasoning for this but to me it seems mo
st
> data is about as secure as the applications that access them in the first
> place. So even if I had a state of the art network in place, a security fl
aw
> in the app could screw me over regardless.
> What is good business security practice for handling/storing sensitive
> customer information on the internet and what is overkill/paranoia? This i
s
> a serious questions so I'd appreciate not to be mocked.
> I'm not a DBA so maybe I'm a little off on my terms, feel free to correct
me
> where I'm wrong. But it seems to me that if didn't use the same db server
> for both the website and main system I'd have a lot of extra work like
> replicating web data to web enabled sql server in our office and from the
> "live server" on our LAN and then back again.
> Thanks in advance for your advice/criticism/suggestions.
> Robert
>
>

My web application is not picking up all the data in the table

I'm facing a strange problems regarding an application my company is hosting.
I'm a system engineer and not a developer, so i'm a little bit lost here.
I have a cluster running W2000 SQL Server, this SQL server has some linked
servers (oracle) with one of our costumers, everyday several SQL jobs update
our SQL tables with info from that oracle servers. But for some reason,
recently the users started complaining some some of the info is not available
on the application, after some investigation, i could confirm that everything
is ok with the data on the costumers servers and that our tables keep being
updated with the info, but the application can't seem to catch any of these
info (vendor information in this case). It seems to me that at some point the
table has some corrupt data or something that is preventing the application
from getting all the data.
Do you guys thing this is something with the SQL table or within the
application?
All the help and suggestions are welcome. (my msn is below)
Best regards
Francisco Batista
Portugal
msn: f_batista69@.hotmail.com
No where near enough information to help you. I suggest you find someone
that knows the application to help you.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
news:955AF918-D80E-4B0C-B626-09733B1BE251@.microsoft.com...
> I'm facing a strange problems regarding an application my company is
> hosting.
> I'm a system engineer and not a developer, so i'm a little bit lost here.
> I have a cluster running W2000 SQL Server, this SQL server has some linked
> servers (oracle) with one of our costumers, everyday several SQL jobs
> update
> our SQL tables with info from that oracle servers. But for some reason,
> recently the users started complaining some some of the info is not
> available
> on the application, after some investigation, i could confirm that
> everything
> is ok with the data on the costumers servers and that our tables keep
> being
> updated with the info, but the application can't seem to catch any of
> these
> info (vendor information in this case). It seems to me that at some point
> the
> table has some corrupt data or something that is preventing the
> application
> from getting all the data.
> Do you guys thing this is something with the SQL table or within the
> application?
> All the help and suggestions are welcome. (my msn is below)
> Best regards
> --
> Francisco Batista
> Portugal
> msn: f_batista69@.hotmail.com
|||Thanks anyway for your time, i will try to reach a developer that was
involved in the built of the application.
Merry Christmas
Francisco Batista
Portugal
f_batista69@.hotmail.com
"Arnie Rowland" wrote:

> No where near enough information to help you. I suggest you find someone
> that knows the application to help you.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
> news:955AF918-D80E-4B0C-B626-09733B1BE251@.microsoft.com...
>
>
|||Its best to work with your developer and troubleshoot the lines of code that
calls for the data and then run the same query in your Query Analyser
window.
Alternatively you could run profiler to help troubleshoot the same. If you
think the table has all the data and the app does not return it, then it
could be capped by number of rows or possibly some rowcount option being
set,etc.
"francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
news:EE601359-B05A-4995-9253-92290C82A3A7@.microsoft.com...[vbcol=seagreen]
> Thanks anyway for your time, i will try to reach a developer that was
> involved in the built of the application.
> Merry Christmas
> --
> Francisco Batista
> Portugal
> f_batista69@.hotmail.com
>
> "Arnie Rowland" wrote:

my SQL Server updates another server in another city

I just started today at this company. They have a 2003 SQL server here in
Dallas and twice a day it updates with the main SQL server in NY. And I
don't know that much about it. When I look at the SQL Server network
connections..there is only one connection..the LAN connection..however when
I
look at Ipconfig /all there is this:
Tunnel adapter Automatic Tunneling Pseudo-Interface:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Automatic Tunneling Pseudo-Interface
Physical Address. . . . . . . . . : C0-A8-03-69
DHCP Enabled. . . . . . . . . . . : No
IP Address. . . . . . . . . . . . : fe80::5efe:192.168.3.105%2
Default Gateway . . . . . . . . . :
DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
fec0:0:0:ffff::2%1
fec0:0:0:ffff::3%1
NetBIOS over Tcpip. . . . . . . . : Disabled
This appears to be some sort of VPN tunnel but I wish I knew more about it.
Can anyone help me. Is this VPN tunnel established w/ the SQL software or
WK2003 software or is it in my T1 router or my firewall. Can anyone help me
decipher this to see the IP of the computer in NY its connecting too. We ar
e
scheduled to move buildings in 4 weeks and I am concerened this VPN thing
won't work at the new location. When we move I plan on keeping all the IP
address the same with our T1 provider. Anyone that can help me , that has
seen this before , that knows anything that I might not know about this
please post...The boss says our SQL server in Dallas replicates 2 times a da
y
to the main server in NY and I just don't get it..thanksI think you just need to read up on IPv6 - perhaps
http://www.microsoft.com/windowsser...v6/default.mspx
might help?
Zilog
Michael.Hall00 wrote:
> I just started today at this company.
> This appears to be some sort of VPN tunnel but I wish I knew more about it
.
> Can anyone help me. Is this VPN tunnel established w/ the SQL software or
> WK2003 software or is it in my T1 router or my firewall. Can anyone help
me
> decipher this to see the IP of the computer in NY its connecting too. We
are
> scheduled to move buildings in 4 weeks and I am concerened this VPN thing
> won't work at the new location. When we move I plan on keeping all the IP
> address the same with our T1 provider. Anyone that can help me , that has
> seen this before , that knows anything that I might not know about this
> please post...The boss says our SQL server in Dallas replicates 2 times a
day
> to the main server in NY and I just don't get it..thanks

My Report Manager Broke "The underlying connection was closed"

Our company recently re-located the servers and somehow in the process of
disconnecting -> reconnecting the Report Server the Report Manager now cannot
be run. All we get is the error:
"The underlying connection was closed: Unable to connect to the remote
server."
Interestingly, this affects ONLY the Report Manager, the Report Service is
running OK and all reports run fine via our web application and in Visual
Studio IDE etc...
Any clues?Hi!
We had a similar problem and resolved it by correcting the Applications
Extensions Mapping for the ReportServer virtual directory. Information about
configuring Reporting Services' virtual directories is available here:
http://support.microsoft.com/Default.aspx?kbid=867872
Good luck,
Bob
"neokortex" wrote:
> Our company recently re-located the servers and somehow in the process of
> disconnecting -> reconnecting the Report Server the Report Manager now cannot
> be run. All we get is the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> Interestingly, this affects ONLY the Report Manager, the Report Service is
> running OK and all reports run fine via our web application and in Visual
> Studio IDE etc...
> Any clues?|||thanks for the tip,
but Im not quite sure this will help me. I checked the extensions for our
ReportServer virtual directory and they are already mapped exactly as
specified in the Support article. Also, ReportServer is working fine in so
far as reports can still be run through it.
It is only the Report Manager Web UI that is flaking out.
"bobhug" wrote:
> Hi!
> We had a similar problem and resolved it by correcting the Applications
> Extensions Mapping for the ReportServer virtual directory. Information about
> configuring Reporting Services' virtual directories is available here:
> http://support.microsoft.com/Default.aspx?kbid=867872
> Good luck,
> Bob
> "neokortex" wrote:
> > Our company recently re-located the servers and somehow in the process of
> > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > be run. All we get is the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > running OK and all reports run fine via our web application and in Visual
> > Studio IDE etc...
> >
> > Any clues?|||I am having the exact same problem. ReportServer is working fine, but report
manager web interface gives The underlying connection was closed. was there a
resolution to this problem?
"neokortex" wrote:
> thanks for the tip,
> but Im not quite sure this will help me. I checked the extensions for our
> ReportServer virtual directory and they are already mapped exactly as
> specified in the Support article. Also, ReportServer is working fine in so
> far as reports can still be run through it.
> It is only the Report Manager Web UI that is flaking out.
> "bobhug" wrote:
> > Hi!
> > We had a similar problem and resolved it by correcting the Applications
> > Extensions Mapping for the ReportServer virtual directory. Information about
> > configuring Reporting Services' virtual directories is available here:
> > http://support.microsoft.com/Default.aspx?kbid=867872
> >
> > Good luck,
> > Bob
> >
> > "neokortex" wrote:
> >
> > > Our company recently re-located the servers and somehow in the process of
> > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > be run. All we get is the error:
> > >
> > > "The underlying connection was closed: Unable to connect to the remote
> > > server."
> > >
> > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > running OK and all reports run fine via our web application and in Visual
> > > Studio IDE etc...
> > >
> > > Any clues?|||No resolution yet. Since that was a test server and we were/are in the
process of migrating to a production server, it is not a emergency for us. I
do know this is a general web service error, not necessarily specfic to RS.
However if you find the answer please respond. I am curious.
"Paul" wrote:
> I am having the exact same problem. ReportServer is working fine, but report
> manager web interface gives The underlying connection was closed. was there a
> resolution to this problem?
> "neokortex" wrote:
> > thanks for the tip,
> >
> > but Im not quite sure this will help me. I checked the extensions for our
> > ReportServer virtual directory and they are already mapped exactly as
> > specified in the Support article. Also, ReportServer is working fine in so
> > far as reports can still be run through it.
> >
> > It is only the Report Manager Web UI that is flaking out.
> >
> > "bobhug" wrote:
> >
> > > Hi!
> > > We had a similar problem and resolved it by correcting the Applications
> > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > configuring Reporting Services' virtual directories is available here:
> > > http://support.microsoft.com/Default.aspx?kbid=867872
> > >
> > > Good luck,
> > > Bob
> > >
> > > "neokortex" wrote:
> > >
> > > > Our company recently re-located the servers and somehow in the process of
> > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > be run. All we get is the error:
> > > >
> > > > "The underlying connection was closed: Unable to connect to the remote
> > > > server."
> > > >
> > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > running OK and all reports run fine via our web application and in Visual
> > > > Studio IDE etc...
> > > >
> > > > Any clues?|||Hi ,
I figured out the solution to this problem. Follwoing 3 things should be
made sure of:
1. Never reinstall reporting services without first uninstalling it
completely... i.e first remove the registry entiries manually then only
reporting services uninstallation is complete.
2. In the RSWebApplication.Config file in Reports Manager , the
ReportServerURL key should have a value as https:/IP(of the report manager
virtual directory)/ReportServer . If in other Report Server and Report
manager .Config files, you find localhost... replace it with the IP of the
virtual directory where reports manager and report server are installed.
3. When you deploy the report, in the configuration properties for the
project .. in the deployment path, again specify the IP instaed of
localhost...
If all these 3 things are taken care of.. then this error will not occur...
When i fixed all these, it worked for me.
pmud
"neokortex" wrote:
> No resolution yet. Since that was a test server and we were/are in the
> process of migrating to a production server, it is not a emergency for us. I
> do know this is a general web service error, not necessarily specfic to RS.
> However if you find the answer please respond. I am curious.
> "Paul" wrote:
> > I am having the exact same problem. ReportServer is working fine, but report
> > manager web interface gives The underlying connection was closed. was there a
> > resolution to this problem?
> >
> > "neokortex" wrote:
> >
> > > thanks for the tip,
> > >
> > > but Im not quite sure this will help me. I checked the extensions for our
> > > ReportServer virtual directory and they are already mapped exactly as
> > > specified in the Support article. Also, ReportServer is working fine in so
> > > far as reports can still be run through it.
> > >
> > > It is only the Report Manager Web UI that is flaking out.
> > >
> > > "bobhug" wrote:
> > >
> > > > Hi!
> > > > We had a similar problem and resolved it by correcting the Applications
> > > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > > configuring Reporting Services' virtual directories is available here:
> > > > http://support.microsoft.com/Default.aspx?kbid=867872
> > > >
> > > > Good luck,
> > > > Bob
> > > >
> > > > "neokortex" wrote:
> > > >
> > > > > Our company recently re-located the servers and somehow in the process of
> > > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > > be run. All we get is the error:
> > > > >
> > > > > "The underlying connection was closed: Unable to connect to the remote
> > > > > server."
> > > > >
> > > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > > running OK and all reports run fine via our web application and in Visual
> > > > > Studio IDE etc...
> > > > >
> > > > > Any clues?

My Query

Hello!
Can any one help me solve this??
I am using MS SQL 2000 database for developing crystal reports for my company.
Now in this I am doing as follows:
I want to concate "dataset_" string with End_A--which is a column name in one table.(Result is like "dataset_1464")I am storing this result in a variable A.
And,now result of this query (A) is name of one table in same database.
Can I use this result ,i.e. A to get MM, which is a column in A.
Here I want to use A instead of dataset_1464.
Please help me if its possible.
thanks in advance,
chandreshselect @.var1 = 'dataset_'+convert(varchar(30),END_A) from table_A

sp_executesql ('select mm from '+@.var1)|||select @.var1 = 'dataset_'+convert(varchar(30),END_A) from table_A

sp_executesql ('select mm from '+@.var1)

HI Thanks alot for prompt reply...
I used this method but it still gives me error like:
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'select mm from '.

wht colud be the reason???
thanks (again) in advance..
chandresh

My MDF Files currupted

My company have server with loads of test databases. last saturday its
hard disk crashed all the partitions were lost . i tried to recover
data from that disk and found my database folder. I took backup on
another harddisk and tried to attache my databases but sql server says
it not avalid database file. i tried to repaire those files with
"recovery for sql server" but no use please help.
Tough thing...
If the database file is corrupt, and you cannot restore from a good backup,
reinstalling the software cannot help. also, re-attaching the database files
will not (cannot) solve the corruption.
Try =>
sp_attach_single_file_db
Attaches a database having only one data file to the current server.
if in suspect state => to reset the suspect status:
http://msdn.microsoft.com/library/de...tabse_494j.asp
once you can reaccess the db, try DBCC CHECKDB:
http://msdn.microsoft.com/library/de..._dbcc_00gy.asp
http://www.experts-exchange.com/Data..._21648997.html
Thanks,
Sree
"khandelwal.deep@.gmail.com" wrote:

> My company have server with loads of test databases. last saturday its
> hard disk crashed all the partitions were lost . i tried to recover
> data from that disk and found my database folder. I took backup on
> another harddisk and tried to attache my databases but sql server says
> it not avalid database file. i tried to repaire those files with
> "recovery for sql server" but no use please help.
>

My MDF Files currupted

My company have server with loads of test databases. last saturday its
hard disk crashed all the partitions were lost . i tried to recover
data from that disk and found my database folder. I took backup on
another harddisk and tried to attache my databases but sql server says
it not avalid database file. i tried to repaire those files with
"recovery for sql server" but no use please help.Tough thing...
If the database file is corrupt, and you cannot restore from a good backup,
reinstalling the software cannot help. also, re-attaching the database files
will not (cannot) solve the corruption.
Try =>
sp_attach_single_file_db
Attaches a database having only one data file to the current server.
if in suspect state => to reset the suspect status:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_494j.asp
once you can reaccess the db, try DBCC CHECKDB:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_00gy.asp
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21648997.html
Thanks,
Sree
"khandelwal.deep@.gmail.com" wrote:
> My company have server with loads of test databases. last saturday its
> hard disk crashed all the partitions were lost . i tried to recover
> data from that disk and found my database folder. I took backup on
> another harddisk and tried to attache my databases but sql server says
> it not avalid database file. i tried to repaire those files with
> "recovery for sql server" but no use please help.
>

My MDF Files currupted

My company have server with loads of test databases. last saturday its
hard disk crashed all the partitions were lost . i tried to recover
data from that disk and found my database folder. I took backup on
another harddisk and tried to attache my databases but sql server says
it not avalid database file. i tried to repaire those files with
"recovery for sql server" but no use please help.Tough thing...
If the database file is corrupt, and you cannot restore from a good backup,
reinstalling the software cannot help. also, re-attaching the database files
will not (cannot) solve the corruption.
Try =>
sp_attach_single_file_db
Attaches a database having only one data file to the current server.
if in suspect state => to reset the suspect status:
tabse_494j.asp" target="_blank">http://msdn.microsoft.com/library/d...
tabse_494j.asp
once you can reaccess the db, try DBCC CHECKDB:
0gy.asp" target="_blank">http://msdn.microsoft.com/library/d...
0gy.asp
[url]http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21648997.html[/ur
l]
Thanks,
Sree
"khandelwal.deep@.gmail.com" wrote:

> My company have server with loads of test databases. last saturday its
> hard disk crashed all the partitions were lost . i tried to recover
> data from that disk and found my database folder. I took backup on
> another harddisk and tried to attache my databases but sql server says
> it not avalid database file. i tried to repaire those files with
> "recovery for sql server" but no use please help.
>