New to Reporting Services

We have a license for SQL Server Enterprise.The license is per processor.We plan to use Reporting Services. I was wondering if there is going to be a limitation for the number of the users that can use this. Similar with Crystal asking for license for more than 5 concurrent users.
We'll access Reporting Services from a web site.Unfortunately the web site is plain ASP.Is there any way I can use Reporting Service(maybe the web service) from plain ASP, or should I think about a way to integrate an ASP.NET page?
The report is generated based on some data the users are entering, and is not related in any way to any database, can I push some xml from my page to the Reporting Service?
Do I need to have a SSL certificate to use Reporting Services?
Can I just download Reporting Services from Microsoft, or is it available only on a CD? We are somehow in a hurry, I don't have too much time to wait for CD's.
Thanks,
IoanaThe requirements for SQL Server Reporting Services are listed herehttp://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx you will see that the server needs the .NET framework. When that is setup ASP applications should be able to call the reports with a URL or you can use the web service that is part of it.
To my knowledge there is no limit for the number of concurrent Reporting Services users.
An SSL certificate isn't essential but is advisable.
You can download the demonstration which should get you going until you get the CD
Steve|||Thank you Steve.That answers all my questions.:o)

New to MS SQL 2000

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination.
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:58C5D3AA-D2FC-419E-B560-DD5703546B5A@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
if
> I expand the database server I could select all task, backup database and
> select the destination.
If you've got the Veritas netbackup SQL Server agent, you can configure
netback to capture all relevant databases. If not, you can use the SQL
Server backup database task wizard to backup your databases, then use
netbackup to backup these files.
Steve

New to Clustering - 2003 Server Enterprise & SQL 2000

I am new to clustering and would like to implement and active/active SQL
cluster, which would allow the functions of one of the nodes to fail over to
the other in the event of a problem.
I have two identrical servers in terms of hardware connected to a SAN and
running Windows Server 2003 Enterprise and will be using SQL 2000.
What are the steps for setting this up?
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
> to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?
1. Attend training to support your extremely expensive cluster with
extremely important databases.
2. Build your cluster
3. Install SQL on your cluster
http://support.microsoft.com/Default.aspx?kbid=243218
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||What do "you" mean by Active/Active? In a clustered configuration, you
install SQL Server to all participating nodes, but then a virtual server is
hosted by only one of them at any given time. If, however, one of the nodes
becomes unavailable, one of the other nodes can host the resources.
Active/Active on Microsoft Clustering means you have multiple cluster
resource groups (i.e., virtual servers) running at the same time with
multiple nodes all hosting different resources.
Anthony Thomas

"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?

New Server...

We are running an Enterprise CRM (SalesLogix) on SQL2K
SP3a.
The server we have is a Quad Xeon 500MHz, 4GB RAM.
We currently have 192 users that connect at any given
time, but usually no more than 70-80 at a time.
The perfomance has gradually been getting worse the last
few months and the usage has increased by about 30% since
then as well.
Would upgrading to a quad 1.5GHz Xeon with 4GB RAM
increase performance quite a bit?"Don" <donolwert@.hotmail.com> wrote in message
news:000b01c35c34$ee45c330$a401280a@.phx.gbl...
> We are running an Enterprise CRM (SalesLogix) on SQL2K
> SP3a.
> The server we have is a Quad Xeon 500MHz, 4GB RAM.
> We currently have 192 users that connect at any given
> time, but usually no more than 70-80 at a time.
> The perfomance has gradually been getting worse the last
> few months and the usage has increased by about 30% since
> then as well.
It may be time to rebuild the indices and update the statistics... In
addition, you may want to consider running the Index Tuning Wizard to
determine if performance would benefit by a few carefully placed index's.
> Would upgrading to a quad 1.5GHz Xeon with 4GB RAM
> increase performance quite a bit?
Where is the bottleneck? Is it processor? Is it disk? Some performance
monitor statistics would help answer those questions. I'd start with my
previous suggestions...
Steve|||> It is Processor performance. I haven't noticed any
> bottlenecks and there is 30GB of free space left. The DB
> is 9GB.
Free disk space doesn't indicate that processor performance is poor.
If there are no bottlenecks... then faster processors won't help.
If you are unwilling to try suggestions, and aren't willing to find
bottlenecks, try this:
1. Go out and buy the processors
2. Get fired because performance didn't improve
3. Let someone else have a go at it.
-har|||Sorry for the lack of clarification. Basically what I am
needing are suggestions on how to check for bottlenecks.
Thanks.
Don
>--Original Message--
>> It is Processor performance. I haven't noticed any
>> bottlenecks and there is 30GB of free space left. The
DB
>> is 9GB.
>Free disk space doesn't indicate that processor
performance is poor.
>If there are no bottlenecks... then faster processors
won't help.
>If you are unwilling to try suggestions, and aren't
willing to find
>bottlenecks, try this:
>1. Go out and buy the processors
>2. Get fired because performance didn't improve
>3. Let someone else have a go at it.
>-har
>
>
>.
>|||>--Original Message--
>"Don" <donolwert@.hotmail.com> wrote in message
>news:000b01c35c34$ee45c330$a401280a@.phx.gbl...
>> We are running an Enterprise CRM (SalesLogix) on SQL2K
>> SP3a.
>> The server we have is a Quad Xeon 500MHz, 4GB RAM.
>> We currently have 192 users that connect at any given
>> time, but usually no more than 70-80 at a time.
>> The perfomance has gradually been getting worse the last
>> few months and the usage has increased by about 30%
since
>> then as well.
>It may be time to rebuild the indices and update the
statistics... In
>addition, you may want to consider running the Index
Tuning Wizard to
>determine if performance would benefit by a few carefully
placed index's.
>> Would upgrading to a quad 1.5GHz Xeon with 4GB RAM
>> increase performance quite a bit?
>Where is the bottleneck? Is it processor? Is it disk?
Some performance
>monitor statistics would help answer those questions. I'd
start with my
>previous suggestions...
>Steve
It is Processor performance. I haven't noticed any
bottlenecks and there is 30GB of free space left. The DB
is 9GB.
>
>.
>sql

New server registration error

Hi, I've just installed MSDE 2000 Release A on a Windows NT Server 4.0 w/SP6. I'm on a WinXP machine and I've installed the Enterprise Manager, and am trying to register a new server registration. However, I'm getting the error: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. I've made sure that both the client and server are using TCP/IP for the protocol list, and I've tried using the physical server's name and it's IP address to register, but keep getting the same error. Thanks for the help.How are you authentacating? Try a search before posting.
http://www.dbforums.com/t525129.html
or

http://search.msn.com/pass/results.asp?RS=CHECKED&FORM=MSNH&v=1&&q=Login+failed+for+user+%27sa%27.+&cp=1252|||I was trying to authenticate via SQL Authentication. I did try searching, and nothing I found seemed to pertain to my situation. But I fixed the problem, so if anyone wants to know, I used Windows authentication to register the server, then I right-clicked on the server, chose properties, and went to the security tab. In there, it was checked to use "Windows only" under the Authentication section. I changed it to "SQL Server and Windows", restarted the SQL service, deleted my Windows SQL registration. Then I was able to successfully register my SQL server using SQL Authentication!

New Processes after upgrade

Hi There

After upgrading to Sql Server 2005 Enterprise Edition , SP1.

if i run the following query:

select * from sysprocesses where waittime <> 0 order by waittime desc

I get the following result:

spid waittime lastwaittype status

10 4480 0 0x007E 78424187 ONDEMAND_TASK_QUEUE background
4 5620 0 0x009D 78418906 KSOURCE_WAKEUP background
16 4512 0 0x00A9 78418890 BROKER_TRANSMITTER background
17 4516 0 0x00A9 78418875 BROKER_TRANSMITTER background
12 5056 0 0x00AD 78418796 BROKER_EVENTHANDLER background
11 5728 0 0x0081 179140 CHECKPOINT_QUEUE background

Basscially the waittime just keeps going up infinitely for these processes, is this normal, should i be worried ?

Thanx

Have same issue with BROKER_EVENTHANDLER and BROKER_TRANSMITTER.

Normal behavior?

|||

Hi

This link from microsoft describes the various Wait Types (of which there a lot more in SQL Server 2005):

http://msdn2.microsoft.com/en-us/library/ms179984.aspx

Here is some information from it about your specific items.

ONDEMAND_TASK_QUEUE waits for high priority requests (and high wait times simply indicates there have been none of these.)

KSOURCE_WAKEUP waits for requests from the Service Control Manager and long waits are to be expected (pause then unpause the SQL Server service to cause this to reset).

CHECKPOINT_QUEUE - This is the Checkpoint task waiting for the next checkpoint request (few checkpoints = large wait - and that's only 3 minutes).

BROKER_* - These are associated with the service broker and whilst it does not specifically say, I suspect if you do not have service broker servicing requests then these just wait and wait.

If you are interested in monitoring blocking then you might like to read this knowledge base article:

http://support.microsoft.com/kb/271509 - (LiveID required)

This describes sp_blocker_pss80 - a stored procedure to monitor blocked processes in SQL server 2000 up (it does however still produce these system processes in it's list).

New MS SQL User cannot display DBs via Enterprise Manager

I have a SQL Server 2000 instance running sp3 (in a cluster).
When I create a NEW SQL user, and give that user access to ONE database (pub
lic and DBO) I cannot list ANY databases from Enterprise Manager when I logi
n with that user. If I refresh the Enterprise Manager Databases View, eventu
ally it will display the Da
tabases - but only after about 10 minutes and I get access violation errors
in my SQL and NT logs. Even if I create a 'dummy SQL login' and give it acce
ss to Northwind, the same results - I cannot list databases in Enterprise Ma
nager. I tried changing the
users default DB to Master - but I got the same results. It does not seem t
o matter what I make the default DB for this user - I still get the errors.
I tried to recreate this problem on another Clustered SQL Server 2000 Instan
ce - this one running sp3a, and I am NOT able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does anyone have any sugg
estions?Previous post "If I refresh the Enterprise Manager Databases View,
eventually it will display the Databases - but only after about 10 minutes
and I get access violation errors in my SQL and NT logs. "
I'd recommend opening up a support case with a SQL Engineer to review teh
Access Violation errors. All bets are off until you resolve this first.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Found the following KB article
http://support.microsoft.com/defaul...15523&Product=s
ql2k
and I checked this out by doing a select * from sysusers on each of my
Databases and 'some' of them had the guest account deleted directly from
their sysusers table!!!
To test the script in the article, I took a 'healthy' DEV Instance,
turned ON the switch in the server setttings that allows modifications
to be made directly to system catalogs, then I deleted the guest account
in one of my user databases. This 'broke' it and i could no longer get
a list of DBs in EM without sysadmin priviledges. I ran the script
which checked each DB and adds the guest account make in if it find it
missing and then disables the "allow modifications to be made directly
to system catalogs" switch. AND THIS WORKED!!!!
Thought I would pass this on. Thank you everyone for your input.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

New MS SQL Server

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination. Which is the proper way to backup these databases.
You could get a Veritas agent that will be able to back up the database real
time. The problem with using the plain vanilla Backup EXEC is that it can't
back up a file that is in use. Alternatively, you can use a scheduled task
within Enterprise Manager to back up the database before you backup to tape.
We have ours set up this way and it works well...
Regards,
Hank Arnold
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:12671BDC-34F2-427E-80EF-753A96DC4818@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
> if
> I expand the database server I could select all task, backup database and
> select the destination. Which is the proper way to backup these databases.

New login cannot retrieve data from db

Hello all. I created the "student2" user account and set the password to
"student2". I then
went to Enterprise Manager and in the class_mgr database and in its
customers table, I gave this student2 user account access to the database
and set all permissions to the table. But when I log in to SQL Server using
this new userlogin, I can access the SQL Server Query Analyzer OK but when I
run the select * from customers; query I get
http://www.jimwrichards.com/images/student2_1.gif"

.. What have I done wrong or overlooked doing right? Thanks in advance for
any help, Jim.
Jim Richards wrote:

> Hello all. I created the "student2" user account and set the password to
> "student2". I then
> went to Enterprise Manager and in the class_mgr database and in its
> customers table, I gave this student2 user account access to the database
> and set all permissions to the table. But when I log in to SQL Server using
> this new userlogin, I can access the SQL Server Query Analyzer OK but when I
> run the select * from customers; query I get
> http://www.jimwrichards.com/images/student2_1.gif"
> . What have I done wrong or overlooked doing right? Thanks in advance for
> any help, Jim.

What is the default database context for the new user? If it is not
the class_mgr database, then maybe your query is trying to access a
different table of the same name, but which isn't allowed to your user?
Joe Weinstein at BEA
|||"Jim Richards" <JWRichards@.satx.rr.com> wrote in message
news:6AXCd.483$q4.168@.fe1.texas.rr.com...
> Hello all. I created the "student2" user account and set the password to
> "student2". I then
> went to Enterprise Manager and in the class_mgr database and in its
> customers table, I gave this student2 user account access to the database
> and set all permissions to the table. But when I log in to SQL Server
> using
> this new userlogin, I can access the SQL Server Query Analyzer OK but when
> I
> run the select * from customers; query I get
> http://www.jimwrichards.com/images/student2_1.gif"
> . What have I done wrong or overlooked doing right? Thanks in advance for
> any help, Jim.

No idea, but what are the current permissions on the table? You can use
sp_helprotect to find out (see Books Online for more details):

exec sp_helprotect 'dbo.customers'

Also, did you DENY permissions on that table to student2 or a role which
student2 is in; a DENY takes precedence over a GRANT.

Simon|||Thanks Joe. I set the default database to "class_mgr" which contains the
table "customers" which contains just two rows (customers). As soon as I
access the SQL Query Analyzer using this student2 login the current database
is automatically set to "class_mgr" instead of the usual "master" database.

"Joe Weinstein" <joeNOSPAM@.bea.com> wrote in message
news:41DC46D5.5040701@.bea.com...
>
> Jim Richards wrote:
>> Hello all. I created the "student2" user account and set the password to
>> "student2". I then
>> went to Enterprise Manager and in the class_mgr database and in its
>> customers table, I gave this student2 user account access to the database
>> and set all permissions to the table. But when I log in to SQL Server
>> using
>> this new userlogin, I can access the SQL Server Query Analyzer OK but
>> when I
>> run the select * from customers; query I get
>> http://www.jimwrichards.com/images/student2_1.gif"
>>
>> . What have I done wrong or overlooked doing right? Thanks in advance for
>> any help, Jim.
> What is the default database context for the new user? If it is not
> the class_mgr database, then maybe your query is trying to access a
> different table of the same name, but which isn't allowed to your user?
> Joe Weinstein at BEA
>>
>|||Thanks Simon. I have a snapshot of the current permissions:
http://www.jimwrichards.com/images/student2_2.gif.

I did NOT deny any permissions, see snapshot:
http://www.jimwrichards.com/images/student2_3.gif.

What now, Sir? Jim.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:41dc4a08$1_1@.news.bluewin.ch...
> "Jim Richards" <JWRichards@.satx.rr.com> wrote in message
> news:6AXCd.483$q4.168@.fe1.texas.rr.com...
>> Hello all. I created the "student2" user account and set the password to
>> "student2". I then
>> went to Enterprise Manager and in the class_mgr database and in its
>> customers table, I gave this student2 user account access to the database
>> and set all permissions to the table. But when I log in to SQL Server
>> using
>> this new userlogin, I can access the SQL Server Query Analyzer OK but
>> when I
>> run the select * from customers; query I get
>> http://www.jimwrichards.com/images/student2_1.gif"
>>
>> . What have I done wrong or overlooked doing right? Thanks in advance for
>> any help, Jim.
>>
>>
> No idea, but what are the current permissions on the table? You can use
> sp_helprotect to find out (see Books Online for more details):
> exec sp_helprotect 'dbo.customers'
> Also, did you DENY permissions on that table to student2 or a role which
> student2 is in; a DENY takes precedence over a GRANT.
> Simon|||"Jim Richards" <JWRichards@.satx.rr.com> wrote in message
news:QEYCd.502$q4.238@.fe1.texas.rr.com...
> Thanks Simon. I have a snapshot of the current permissions:
> http://www.jimwrichards.com/images/student2_2.gif.
> I did NOT deny any permissions, see snapshot:
> http://www.jimwrichards.com/images/student2_3.gif.
> What now, Sir? Jim.

Good question - everything seems to be correct, unless I've missed something
somewhere. Is student2 in any roles?

exec sp_helpuser 'student2'

If student2 is in the db_denydatareader role for some reason, then that
would explain what you're seeing. If not, then I'd try dropping and
recreating the user again (and running DBCC CHECKDB wouldn't hurt either,
just in case there is some database corruption).

Simon

New Install can't view data

I installed MSSQL 2000 Dev version. It appeared to work. I am now
trying to open any table in Enterprise manager and I get "Provider
cannot be found. It may not be properly installed." I don't see any
errors in Event Viewer.
I'm running it on XP Pro.
Thanks.
--
_________________________________________
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
_________________________________________Don Gollahon wrote:
> I installed MSSQL 2000 Dev version. It appeared to work. I am now
> trying to open any table in Enterprise manager and I get "Provider
> cannot be found. It may not be properly installed." I don't see any
> errors in Event Viewer.
> I'm running it on XP Pro.
> Thanks.
Have you installed SP3a or SP4 yet? The problem you describe is not one
I know of with the RTM version, but applying the service pack may
address any problems.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> Don Gollahon wrote:
> > I installed MSSQL 2000 Dev version. It appeared to work. I am now
> > trying to open any table in Enterprise manager and I get "Provider
> > cannot be found. It may not be properly installed." I don't see
> > any errors in Event Viewer.
> >
> > I'm running it on XP Pro.
> >
> > Thanks.
> Have you installed SP3a or SP4 yet? The problem you describe is not
> one I know of with the RTM version, but applying the service pack may
> address any problems.
I just installed SP3a and have the same result.
--
_________________________________________
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
_________________________________________

New Install can't view data

I installed MSSQL 2000 Dev version. It appeared to work. I am now
trying to open any table in Enterprise manager and I get "Provider
cannot be found. It may not be properly installed." I don't see any
errors in Event Viewer.
I'm running it on XP Pro.
Thanks.
_________________________________________
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
_________________________________________
Don Gollahon wrote:
> I installed MSSQL 2000 Dev version. It appeared to work. I am now
> trying to open any table in Enterprise manager and I get "Provider
> cannot be found. It may not be properly installed." I don't see any
> errors in Event Viewer.
> I'm running it on XP Pro.
> Thanks.
Have you installed SP3a or SP4 yet? The problem you describe is not one
I know of with the RTM version, but applying the service pack may
address any problems.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David Gugick wrote:

> Don Gollahon wrote:
> Have you installed SP3a or SP4 yet? The problem you describe is not
> one I know of with the RTM version, but applying the service pack may
> address any problems.
I just installed SP3a and have the same result.
_________________________________________
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
_________________________________________

New Install can't view data

I installed MSSQL 2000 Dev version. It appeared to work. I am now
trying to open any table in Enterprise manager and I get "Provider
cannot be found. It may not be properly installed." I don't see any
errors in Event Viewer.
I'm running it on XP Pro.
Thanks.
________________________________________
_
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
________________________________________
_Don Gollahon wrote:
> I installed MSSQL 2000 Dev version. It appeared to work. I am now
> trying to open any table in Enterprise manager and I get "Provider
> cannot be found. It may not be properly installed." I don't see any
> errors in Event Viewer.
> I'm running it on XP Pro.
> Thanks.
Have you installed SP3a or SP4 yet? The problem you describe is not one
I know of with the RTM version, but applying the service pack may
address any problems.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:

> Don Gollahon wrote:
> Have you installed SP3a or SP4 yet? The problem you describe is not
> one I know of with the RTM version, but applying the service pack may
> address any problems.
I just installed SP3a and have the same result.
________________________________________
_
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
________________________________________
_

New db cant be found

We have a brand new sql 2k server. Its all up to date on service packs
(both win2k and SQL).

I went in to enterprise manager and added a new db. I can run sprocs
and raw sql against the new db just fine from Query Analyzer.

When I try to make a dts package that refers to my new db I get the
following error:

Error desription: deferred prepare could not be completed.
Could not locate entry in sysdatabases for database 'mydbname'. No
entry found with that name. Make sure that the name is entered
correctly.

OK, so I look in sysdatabases and see 'mydbname'. Just in case im an
idiot... I actually copied the db name from that table and paste it in
my dts window.

My dts package is using an "execute SQL task" to call a stored proc.

To be ecxact:
USE mydbname
GO
EXEC MyProc

When I click on the parse button, is when I get that error message.

I have deleted the db, restarted the server, and recreated the db with
a slightly different name. I can replace mydbname with pubs or
northwind and all is ok. It just doesnt like new db's.

Any help would be greatly appreciated.

Thanks,
DaveHi

I am not sure why you need the USE statement if the associated connection is
already setting this as the database.

John

"Dave" <funkdm1@.yahoo.com> wrote in message
news:f5174e0f.0407130507.ac071b@.posting.google.com ...
> We have a brand new sql 2k server. Its all up to date on service packs
> (both win2k and SQL).
> I went in to enterprise manager and added a new db. I can run sprocs
> and raw sql against the new db just fine from Query Analyzer.
> When I try to make a dts package that refers to my new db I get the
> following error:
> Error desription: deferred prepare could not be completed.
> Could not locate entry in sysdatabases for database 'mydbname'. No
> entry found with that name. Make sure that the name is entered
> correctly.
> OK, so I look in sysdatabases and see 'mydbname'. Just in case im an
> idiot... I actually copied the db name from that table and paste it in
> my dts window.
> My dts package is using an "execute SQL task" to call a stored proc.
> To be ecxact:
> USE mydbname
> GO
> EXEC MyProc
> When I click on the parse button, is when I get that error message.
> I have deleted the db, restarted the server, and recreated the db with
> a slightly different name. I can replace mydbname with pubs or
> northwind and all is ok. It just doesnt like new db's.
> Any help would be greatly appreciated.
> Thanks,
> Dave