Noobie SQL question

I am getting this message when I try to open the database in the enterprise manager. In all other locations it is telling me that the database is running any thoughts on how to resolve this?

The SQL Server \\CRISPINDB1 is not known to be running. Are you sure you wish to connect?

Anything at all will be a great help to me thanks in advance.is \\CRISPINDB1 your machine or a server ?|||you've got to start SQL Server services|||\\CRISPINDB1 is the name of the machine and the services are running. The machines that need to access the database seem to not be having a problem getting to it and using it. Only when I try to access it thru Enterprise Manager.|||I am using the Enterprise manager on the machine that the database is running. Sorry about not giving all the info to know whats going on.|||maybe you need to add the instancename

\\ServerName\InstanceName|||With further investigation I have learned that patients are a virtue I was just trying to expand the tree before the application had polled he database. Thank you for your help on this operator caused problem. And with this I am a little less of a Noob about SQL.

Non-Report Hyperlinks on Report Manager Home Page?

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

It isn't...maybe you could run it inside an IFRAME, surrounded by other UI (including "your" hyperlinks)?|||

pittpanther wrote:

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

Why not just create an "index" aspx page that would have links to reports similar to report manager? You could have this index page in the same project as the associated data entry aspx pages.

It seems to me that you're thinking about it backwards.

|||

Thanks for the replies...

The end user is already fairly comfortable with the Report Manager front end, so I am kind of stuck with it as my launching point.

The only thing I have come up with is an "empty" report accessible from the main folder that only includes the hyperlinks for the "Data Entry" aspx pages. A little kludgy though.

|||Russell - I am not familiar with an IFRAME... could you elaborate a little more?sql

Non-Report Hyperlinks on Report Manager Home Page?

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

It isn't...maybe you could run it inside an IFRAME, surrounded by other UI (including "your" hyperlinks)?|||

pittpanther wrote:

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

Why not just create an "index" aspx page that would have links to reports similar to report manager? You could have this index page in the same project as the associated data entry aspx pages.

It seems to me that you're thinking about it backwards.

|||

Thanks for the replies...

The end user is already fairly comfortable with the Report Manager front end, so I am kind of stuck with it as my launching point.

The only thing I have come up with is an "empty" report accessible from the main folder that only includes the hyperlinks for the "Data Entry" aspx pages. A little kludgy though.

|||Russell - I am not familiar with an IFRAME... could you elaborate a little more?

Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor
Yes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas

"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor

Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
IgorYes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor

Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
IgorYes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor

Non replicated tables and MS Access

What happens whey you try to edit the data in these
tables - any error messages etc? How are you editing
them - using Enterprise manager? (If so you must move off
the line for the edit to be committed).
Regards,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Manage to find the problem. An index was missing from the table which
prohibited MS Access from updating a row.
Howevere I was always able to edit a row using MS Query Analyser
Thanks
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:2b2201c49ee7$e565e230$a301280a@.phx.gbl...
> What happens whey you try to edit the data in these
> tables - any error messages etc? How are you editing
> them - using Enterprise manager? (If so you must move off
> the line for the edit to be committed).
> Regards,
> Paul Ibison
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

no sync replication instructions.

Hello.
Does anyone have instructions on how to set back up replication that has
been marked for re-initilization thru the gui (enterprise manager)? We
have a subscriber that had their wan link down for the whole weekend and
now all their publications are marked for reinitialization. Some the
tables in question are 20gb in size, and that is just too big for us to
re-do snapshots and send over a WAN link. So in reading Hilary's and
Pauls post it looks like a "no-sync" will help me not have to send over
a snap shot.
1. how do i do this through enterprise manager only?
2. is there anyway for me to tell replication to go back lets say the
last 48hrs for the tables that we replicate, and "repush" that data
over?
Thanks,
-comb
Comb,
this article should help:
http://www.replicationanswers.com/No...alizations.asp
Initially I'd use Redgate's DataCompare to sync the data for any stray
changes.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||In article <eo9dqUZrFHA.1256@.TK2MSFTNGP09.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Comb,
> this article should help:
> http://www.replicationanswers.com/No...alizations.asp
> Initially I'd use Redgate's DataCompare to sync the data for any stray
> changes.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Thanks Paul. I appreciate yours and hilary's help.
looking now. I am also going to look into this Redgates.
-comb