internal consistency error

I have a sql database
I run dbcc checkdb and get no errors
I go to backup the database in enterprise manager, and it won't
restore because it has internal consistency errors
I can go back to an older version of the database

I run a particular procedure in our accounting software package
Never do I get errors when running dbcc checkdb

Sometimes I get the backup and restore problem, sometimes I don't

I am doing this on a test server with about 220 megs of RAM

I am trying the dbcc checkdb ('dbname',REPAIR_REBUILD) command

Any other ideas?An update to the problem:

I ran the process on my test server on a one-gig or so database and it
runs fine but gets an internal consistency error when I backup and try
to restore (dbcc checkdb, with and without REPAIR_REBUILD, runs just
fine)

But I run the process on the real server and it backs up and restores
just fine

So .........

It points to a resource problem on the test server

But I am not sure of this

Any feedback on this from anyone?|||brucestromcpa@.aol.com (bruce strom) wrote in message news:<8a9196fd.0310300827.41041bda@.posting.google.com>...
> An update to the problem:
> I ran the process on my test server on a one-gig or so database and it
> runs fine but gets an internal consistency error when I backup and try
> to restore (dbcc checkdb, with and without REPAIR_REBUILD, runs just
> fine)
> But I run the process on the real server and it backs up and restores
> just fine
> So .........
> It points to a resource problem on the test server
> But I am not sure of this
> Any feedback on this from anyone?

A consistency error means that the backup set is corrupt, for some
reason. That could mean a hardware issue, or a bad tape, or perhaps
backing up across an unreliable network. There are also issues if the
two versions of MSSQL are not the same. Perhaps you can give some more
details - where are you backing up to (tape, local drive, network
drive)? What version of MSSQL do you have? What's the operating system
and filesystem? As a minimum test, is this reliable on your test
server:

backup database MyDB to disk = 'c:\MyDB.bak' -- or another local drive
restore database MyDB from disk = 'c:\MyDB.bak'

If that isn't reliable, do OS-level tools detect any integrity issues
with the filesystem?

Simon

Intermittent Connectivity issues though network is fine

Hi,

I am getting intermittent connectivity issues while connecting to a remote SQL Server 2000 database through the Enterprise Manager. It gives a time-out error

Initially I guessed it must be the network but then I was able to term-serv successfully into the remote server and work without any connectivity issues.

Any pointers how this is possible ?

Thanks for your help.

Regards,
-Ranjit S Hans.i think you have problem with the logging in.

to test this try to connect to this server using SQL Query analyzer and see if it gets connected instantly. If it's the case, there is something about the SQL Login you are using in app.

Hope this helps|||Thanks Wash. I had checked with my logins and they are fine. Also I dont see any issues with the server alias.

I have been thinking of increasing the timeout interval for the remote server.
Am wary to do it as it would need a restart of SQl services.

Any suggestions/workaround ?

Thanks,
-Ranjit

Intermittent connection

I am running SQL2000 on windows2003. I often connect to the database through
the SQL Server Enterprise Manager on a client machine to administer it. The
strange thing is sometimes I can connect to this database but other times c
annot. THe error message is
"SQL does not exist or not known to be running". I have checked the server s
tatus at the host terminal and it is running.
Anyone knows what's the problem for such intermitent connection? Network pro
b? SQL registration at the client side? ODBC setting?
Someone suggests that it may be because the host and the client are sitting
on different domain in the network. Is this true?Hi,
Due the problem situation, can you run a ping comand to the SQL Server
machine (Ping <ipaddress of sql server> ). If a request time out occurs
contact the "Network admin".
THis type of errors will come only if there is a slow network.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> I am running SQL2000 on windows2003. I often connect to the database
through the SQL Server Enterprise Manager on a client machine to administer
it. The strange thing is sometimes I can connect to this database but other
times cannot. THe error message is "SQL does not exist or not known to be
running". I have checked the server status at the host terminal and it is
running.
> Anyone knows what's the problem for such intermitent connection? Network
prob? SQL registration at the client side? ODBC setting?
> Someone suggests that it may be because the host and the client are
sitting on different domain in the network. Is this true?|||Hi, Hari.
I can ping the sql server machine from the client terminal. But the client a
nd host are in different domain. Is this the problem?
Thanks.
Tay
"Hari Prasad" wrote:

> Hi,
> Due the problem situation, can you run a ping comand to the SQL Server
> machine (Ping <ipaddress of sql server> ). If a request time out occurs
> contact the "Network admin".
> THis type of errors will come only if there is a slow network.
>
> --
> Thanks
> Hari
> MCDBA
>
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> through the SQL Server Enterprise Manager on a client machine to administe
r
> it. The strange thing is sometimes I can connect to this database but othe
r
> times cannot. THe error message is "SQL does not exist or not known to be
> running". I have checked the server status at the host terminal and it is
> running.
> prob? SQL registration at the client side? ODBC setting?
> sitting on different domain in the network. Is this true?
>
>|||HI,
If you have a Trust relation ship between both domains, then it should not
be a issue at all.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> Hi, Hari.
> I can ping the sql server machine from the client terminal. But the client
and host are in different domain. Is this the problem?[vbcol=seagreen]
> Thanks.
> Tay
> "Hari Prasad" wrote:
>
administer[vbcol=seagreen]
other[vbcol=seagreen]
be[vbcol=seagreen]
is[vbcol=seagreen]
Network[vbcol=seagreen]|||hi
I just found out that both the host and the client did not join any domain b
ut in the same workgroup. I can successfully search for the sqlserver after
I login to a shared folder from my client terminal. It seems like the client
need to establish the netw
ork path to the host before it can find the sqlserver.
Any way to avoid logging in yet still can locate the sqlserver?
Thanks.
"Hari Prasad" wrote:

> HI,
> If you have a Trust relation ship between both domains, then it should not
> be a issue at all.
> --
> Thanks
> Hari
> MCDBA
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> and host are in different domain. Is this the problem?
> administer
> other
> be
> is
> Network
>
>sql

Intermittent connection

I am running SQL2000 on windows2003. I often connect to the database through the SQL Server Enterprise Manager on a client machine to administer it. The strange thing is sometimes I can connect to this database but other times cannot. THe error message is
"SQL does not exist or not known to be running". I have checked the server status at the host terminal and it is running.
Anyone knows what's the problem for such intermitent connection? Network prob? SQL registration at the client side? ODBC setting?
Someone suggests that it may be because the host and the client are sitting on different domain in the network. Is this true?
Hi,
Due the problem situation, can you run a ping comand to the SQL Server
machine (Ping <ipaddress of sql server>). If a request time out occurs
contact the "Network admin".
THis type of errors will come only if there is a slow network.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> I am running SQL2000 on windows2003. I often connect to the database
through the SQL Server Enterprise Manager on a client machine to administer
it. The strange thing is sometimes I can connect to this database but other
times cannot. THe error message is "SQL does not exist or not known to be
running". I have checked the server status at the host terminal and it is
running.
> Anyone knows what's the problem for such intermitent connection? Network
prob? SQL registration at the client side? ODBC setting?
> Someone suggests that it may be because the host and the client are
sitting on different domain in the network. Is this true?
|||Hi, Hari.
I can ping the sql server machine from the client terminal. But the client and host are in different domain. Is this the problem?
Thanks.
Tay
"Hari Prasad" wrote:

> Hi,
> Due the problem situation, can you run a ping comand to the SQL Server
> machine (Ping <ipaddress of sql server>). If a request time out occurs
> contact the "Network admin".
> THis type of errors will come only if there is a slow network.
>
> --
> Thanks
> Hari
> MCDBA
>
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> through the SQL Server Enterprise Manager on a client machine to administer
> it. The strange thing is sometimes I can connect to this database but other
> times cannot. THe error message is "SQL does not exist or not known to be
> running". I have checked the server status at the host terminal and it is
> running.
> prob? SQL registration at the client side? ODBC setting?
> sitting on different domain in the network. Is this true?
>
>
|||HI,
If you have a Trust relation ship between both domains, then it should not
be a issue at all.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> Hi, Hari.
> I can ping the sql server machine from the client terminal. But the client
and host are in different domain. Is this the problem?[vbcol=seagreen]
> Thanks.
> Tay
> "Hari Prasad" wrote:
administer[vbcol=seagreen]
other[vbcol=seagreen]
be[vbcol=seagreen]
is[vbcol=seagreen]
Network[vbcol=seagreen]
|||hi
I just found out that both the host and the client did not join any domain but in the same workgroup. I can successfully search for the sqlserver after I login to a shared folder from my client terminal. It seems like the client need to establish the netw
ork path to the host before it can find the sqlserver.
Any way to avoid logging in yet still can locate the sqlserver?
Thanks.
"Hari Prasad" wrote:

> HI,
> If you have a Trust relation ship between both domains, then it should not
> be a issue at all.
> --
> Thanks
> Hari
> MCDBA
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> and host are in different domain. Is this the problem?
> administer
> other
> be
> is
> Network
>
>

Intermittent connection

I am running SQL2000 on windows2003. I often connect to the database through the SQL Server Enterprise Manager on a client machine to administer it. The strange thing is sometimes I can connect to this database but other times cannot. THe error message is "SQL does not exist or not known to be running". I have checked the server status at the host terminal and it is running.
Anyone knows what's the problem for such intermitent connection? Network prob? SQL registration at the client side? ODBC setting?
Someone suggests that it may be because the host and the client are sitting on different domain in the network. Is this true?Hi,
Due the problem situation, can you run a ping comand to the SQL Server
machine (Ping <ipaddress of sql server>). If a request time out occurs
contact the "Network admin".
THis type of errors will come only if there is a slow network.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> I am running SQL2000 on windows2003. I often connect to the database
through the SQL Server Enterprise Manager on a client machine to administer
it. The strange thing is sometimes I can connect to this database but other
times cannot. THe error message is "SQL does not exist or not known to be
running". I have checked the server status at the host terminal and it is
running.
> Anyone knows what's the problem for such intermitent connection? Network
prob? SQL registration at the client side? ODBC setting?
> Someone suggests that it may be because the host and the client are
sitting on different domain in the network. Is this true?|||Hi, Hari.
I can ping the sql server machine from the client terminal. But the client and host are in different domain. Is this the problem?
Thanks.
Tay
"Hari Prasad" wrote:
> Hi,
> Due the problem situation, can you run a ping comand to the SQL Server
> machine (Ping <ipaddress of sql server>). If a request time out occurs
> contact the "Network admin".
> THis type of errors will come only if there is a slow network.
>
> --
> Thanks
> Hari
> MCDBA
>
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> > I am running SQL2000 on windows2003. I often connect to the database
> through the SQL Server Enterprise Manager on a client machine to administer
> it. The strange thing is sometimes I can connect to this database but other
> times cannot. THe error message is "SQL does not exist or not known to be
> running". I have checked the server status at the host terminal and it is
> running.
> >
> > Anyone knows what's the problem for such intermitent connection? Network
> prob? SQL registration at the client side? ODBC setting?
> >
> > Someone suggests that it may be because the host and the client are
> sitting on different domain in the network. Is this true?
>
>|||HI,
If you have a Trust relation ship between both domains, then it should not
be a issue at all.
--
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> Hi, Hari.
> I can ping the sql server machine from the client terminal. But the client
and host are in different domain. Is this the problem?
> Thanks.
> Tay
> "Hari Prasad" wrote:
> > Hi,
> >
> > Due the problem situation, can you run a ping comand to the SQL Server
> > machine (Ping <ipaddress of sql server>). If a request time out occurs
> > contact the "Network admin".
> >
> > THis type of errors will come only if there is a slow network.
> >
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> >
> >
> > "Tay" <Tay@.discussions.microsoft.com> wrote in message
> > news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> > > I am running SQL2000 on windows2003. I often connect to the database
> > through the SQL Server Enterprise Manager on a client machine to
administer
> > it. The strange thing is sometimes I can connect to this database but
other
> > times cannot. THe error message is "SQL does not exist or not known to
be
> > running". I have checked the server status at the host terminal and it
is
> > running.
> > >
> > > Anyone knows what's the problem for such intermitent connection?
Network
> > prob? SQL registration at the client side? ODBC setting?
> > >
> > > Someone suggests that it may be because the host and the client are
> > sitting on different domain in the network. Is this true?
> >
> >
> >|||hi
I just found out that both the host and the client did not join any domain but in the same workgroup. I can successfully search for the sqlserver after I login to a shared folder from my client terminal. It seems like the client need to establish the network path to the host before it can find the sqlserver.
Any way to avoid logging in yet still can locate the sqlserver?
Thanks.
"Hari Prasad" wrote:
> HI,
> If you have a Trust relation ship between both domains, then it should not
> be a issue at all.
> --
> Thanks
> Hari
> MCDBA
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> > Hi, Hari.
> >
> > I can ping the sql server machine from the client terminal. But the client
> and host are in different domain. Is this the problem?
> >
> > Thanks.
> > Tay
> >
> > "Hari Prasad" wrote:
> >
> > > Hi,
> > >
> > > Due the problem situation, can you run a ping comand to the SQL Server
> > > machine (Ping <ipaddress of sql server>). If a request time out occurs
> > > contact the "Network admin".
> > >
> > > THis type of errors will come only if there is a slow network.
> > >
> > >
> > > --
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > > "Tay" <Tay@.discussions.microsoft.com> wrote in message
> > > news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> > > > I am running SQL2000 on windows2003. I often connect to the database
> > > through the SQL Server Enterprise Manager on a client machine to
> administer
> > > it. The strange thing is sometimes I can connect to this database but
> other
> > > times cannot. THe error message is "SQL does not exist or not known to
> be
> > > running". I have checked the server status at the host terminal and it
> is
> > > running.
> > > >
> > > > Anyone knows what's the problem for such intermitent connection?
> Network
> > > prob? SQL registration at the client side? ODBC setting?
> > > >
> > > > Someone suggests that it may be because the host and the client are
> > > sitting on different domain in the network. Is this true?
> > >
> > >
> > >
>
>

Intermittent connection

I am running SQL2000 on windows2003. I often connect to the database through
the SQL Server Enterprise Manager on a client machine to administer it. The
strange thing is sometimes I can connect to this database but other times c
annot. THe error message is
"SQL does not exist or not known to be running". I have checked the server s
tatus at the host terminal and it is running.
Anyone knows what's the problem for such intermitent connection? Network pro
b? SQL registration at the client side? ODBC setting?
Someone suggests that it may be because the host and the client are sitting
on different domain in the network. Is this true?Hi,
Due the problem situation, can you run a ping comand to the SQL Server
machine (Ping <ipaddress of sql server> ). If a request time out occurs
contact the "Network admin".
THis type of errors will come only if there is a slow network.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> I am running SQL2000 on windows2003. I often connect to the database
through the SQL Server Enterprise Manager on a client machine to administer
it. The strange thing is sometimes I can connect to this database but other
times cannot. THe error message is "SQL does not exist or not known to be
running". I have checked the server status at the host terminal and it is
running.
> Anyone knows what's the problem for such intermitent connection? Network
prob? SQL registration at the client side? ODBC setting?
> Someone suggests that it may be because the host and the client are
sitting on different domain in the network. Is this true?|||Hi, Hari.
I can ping the sql server machine from the client terminal. But the client a
nd host are in different domain. Is this the problem?
Thanks.
Tay
"Hari Prasad" wrote:

> Hi,
> Due the problem situation, can you run a ping comand to the SQL Server
> machine (Ping <ipaddress of sql server> ). If a request time out occurs
> contact the "Network admin".
> THis type of errors will come only if there is a slow network.
>
> --
> Thanks
> Hari
> MCDBA
>
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:FD12B805-602B-447F-BB0F-181E032CA39E@.microsoft.com...
> through the SQL Server Enterprise Manager on a client machine to administe
r
> it. The strange thing is sometimes I can connect to this database but othe
r
> times cannot. THe error message is "SQL does not exist or not known to be
> running". I have checked the server status at the host terminal and it is
> running.
> prob? SQL registration at the client side? ODBC setting?
> sitting on different domain in the network. Is this true?
>
>|||HI,
If you have a Trust relation ship between both domains, then it should not
be a issue at all.
Thanks
Hari
MCDBA
"Tay" <Tay@.discussions.microsoft.com> wrote in message
news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> Hi, Hari.
> I can ping the sql server machine from the client terminal. But the client
and host are in different domain. Is this the problem?[vbcol=seagreen]
> Thanks.
> Tay
> "Hari Prasad" wrote:
>
administer[vbcol=seagreen]
other[vbcol=seagreen]
be[vbcol=seagreen]
is[vbcol=seagreen]
Network[vbcol=seagreen]|||hi
I just found out that both the host and the client did not join any domain b
ut in the same workgroup. I can successfully search for the sqlserver after
I login to a shared folder from my client terminal. It seems like the client
need to establish the netw
ork path to the host before it can find the sqlserver.
Any way to avoid logging in yet still can locate the sqlserver?
Thanks.
"Hari Prasad" wrote:

> HI,
> If you have a Trust relation ship between both domains, then it should not
> be a issue at all.
> --
> Thanks
> Hari
> MCDBA
> "Tay" <Tay@.discussions.microsoft.com> wrote in message
> news:90E8545E-343F-4061-8DA6-E5AACB0F385F@.microsoft.com...
> and host are in different domain. Is this the problem?
> administer
> other
> be
> is
> Network
>
>sql

Interface for the MSDE

Hi All,
I just installed MSDE Release A. Haven't used it before.
Is there no interface to the database like the Enterprise Manager or isql utility?
How can I execute a query and view the databases?
Thanks
> I just installed MSDE Release A. Haven't used it before.
> Is there no interface to the database like the Enterprise Manager or isql
utility?
> How can I execute a query and view the databases?
There are no tools like EM, or QA.
But there should be a program called "osql". i've never used it before
(command line and all *shudder*). But supposedly it does come with MSDE.
The real answer to the question, "How can I execute a query and view the
databases?" is:
You write a front-end application in VB, C++, or Delphi (yeah Delphi). And
probably using ADO as the database connectivity technology.
Other than that, there are some free and (and some not free) grahical MSDE
management programs.
Google for them "free enterprise manager", or "msde management tool", etc..
|||There are GUI Utils for MSDE 2000 as Ian stated, you can Install Enterprise
manager ie the client tools if you have a full SQL server 2000 Server
version and a SQL License or use OSQL , see below article:
How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
Utility
http://support.microsoft.com/default...b;en-us;325003
HTH
Dylan
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:Ogm4v1ZaEHA.2388@.TK2MSFTNGP11.phx.gbl...
> utility?
> There are no tools like EM, or QA.
> But there should be a program called "osql". i've never used it before
> (command line and all *shudder*). But supposedly it does come with MSDE.
> The real answer to the question, "How can I execute a query and view the
> databases?" is:
> You write a front-end application in VB, C++, or Delphi (yeah Delphi). And
> probably using ADO as the database connectivity technology.
>
> Other than that, there are some free and (and some not free) grahical MSDE
> management programs.
> Google for them "free enterprise manager", or "msde management tool",
> etc..
>
|||Sorry i Meant NO GUI tools!
"Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
news:%23bJVcnaaEHA.3752@.TK2MSFTNGP12.phx.gbl...
> There are GUI Utils for MSDE 2000 as Ian stated, you can Install
> Enterprise manager ie the client tools if you have a full SQL server 2000
> Server version and a SQL License or use OSQL , see below article:
> How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
> Utility
> http://support.microsoft.com/default...b;en-us;325003
> HTH
> Dylan
>
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:Ogm4v1ZaEHA.2388@.TK2MSFTNGP11.phx.gbl...
>
|||You can even install some free GUI tools for MSDE from web. I use a great tool by Andrea, you can grab it from http://www.asql.biz/DbaMgr/DownLoad2k.shtm
Let us know if you have any more questions.
dev_kh
"Dylan kruger" wrote:

> Sorry i Meant NO GUI tools!
> "Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
> news:%23bJVcnaaEHA.3752@.TK2MSFTNGP12.phx.gbl...
>
>
|||Thank you Dylan and Dev for the links
"dev_kh" wrote:
[vbcol=seagreen]
> You can even install some free GUI tools for MSDE from web. I use a great tool by Andrea, you can grab it from http://www.asql.biz/DbaMgr/DownLoad2k.shtm
> Let us know if you have any more questions.
> dev_kh
> "Dylan kruger" wrote:
|||MSDE does not come with a front-end. Try WinSQL at
http://www.synametrics.com/winsql
sm wrote:

> Hi All,
> I just installed MSDE Release A. Haven't used it before.
> Is there no interface to the database like the Enterprise Manager or isql utility?
> How can I execute a query and view the databases?
> Thanks

interesting question

Hi All,
When I open Enterprise manager on a few of my servers,
everything is doubled.
When I open the server in EM I see 2 folders for
databases,data transformation services,management,...
Does anyone have any idea why this would be?
I have 25 different servers that I check thru my EM and
only a few of them do this.
Thanks,
JoeDid you check if there's any version or build number difference between the
servers that do this and those who
do not?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Joe" <anonymous@.discussions.microsoft.com> wrote in message news:13cf501c4132a$94a67e70$a5
01280a@.phx.gbl...
> Hi All,
> When I open Enterprise manager on a few of my servers,
> everything is doubled.
> When I open the server in EM I see 2 folders for
> databases,data transformation services,management,...
> Does anyone have any idea why this would be?
> I have 25 different servers that I check thru my EM and
> only a few of them do this.
> Thanks,
> Joe
>

Integration Services and VS 2005 Pro

My client machine has VS Studio 2005 Professional installed. My server has SQL Server 2005 Enterprise with BIDS installed. I would prefer to do my task development on my client instead of the server. How do I get the Integration Services projects on my installation of VS 2005? I went so far as installing SQL Express and BIDS on my local machine, but the only Business Development projects I get are Report Server. Any assistance would be greatly appreciated.

Thanks,

Lee

You need to get SQL Server 2005 Developer Edition on your local machine. SSIS isn't included in Express edition.

|||

Why do I even need a version of SQL Server locally? Can't I utilize the installation of SQL Server Enterprise on my server?

|||You don't have to have the database installed, just the tools.