Network drives not available on Database Maintenance

I am trying to establish a Database Maintenance plan for our SQL server and when I choose
Database Maintenance Plan
Complete Backup Tab
Under choose directory when I choose the (...) icon to choose a directory only the C and D drive of the server appears, I do not see the network drives.
I resolved this in the past but forgot how to.
Thanks
Jeffrey
What I used to do in 6.5 was run a scheduled task that had the ID that SQL was running under to map the network drive. I have not had a need to try this in 2k but it is worth a shot.
Jeff
MCDBA, MCSE+I
|||Not too sure if you can do this on Database Maintenance Plans
Put you can create a Backup device pointing to a Network drive and create
backup jobs to that network device(s)
Regards
J
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks
|||Type in the UNC name of the share. Make sure the SQL server service account
has permissions to that share.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks

Network drives not available on Database Maintenance

I am trying to establish a Database Maintenance plan for our SQL server and
when I choose
Database Maintenance Plan
Complete Backup Tab
Under choose directory when I choose the (...) icon to choose a directory on
ly the C and D drive of the server appears, I do not see the network drives.
I resolved this in the past but forgot how to.
ThanksJeffrey
What I used to do in 6.5 was run a scheduled task that had the ID that SQL w
as running under to map the network drive. I have not had a need to try thi
s in 2k but it is worth a shot.
Jeff
MCDBA, MCSE+I|||Not too sure if you can do this on Database Maintenance Plans
Put you can create a Backup device pointing to a Network drive and create
backup jobs to that network device(s)
Regards
J
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks|||Type in the UNC name of the share. Make sure the SQL server service account
has permissions to that share.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks

Nested Stored Procedure?

I have a stored procedure that returns a list of userIds that are available to the logged in user. I need to be able to use this list of userIds in another stored procedure whose purpose is to simply query a table for all results containing any of those userIds.

So if my first Stored Procedure returns this:
2
3
5
6

I need my select statement to do something like this:

select UserId, Column1, Column2
from Table1
where UserId = 2 or UserId = 3 or UserId = 5 or UserId = 6

I'm very new to stored procedures, can anyone help me with the syntax for doing this. I'm being pressured to get this done very quickly.

Thanks for any help!Huh? User ids like SQL Server User ids, or something application specific?

-PatP|||Eric1776,

There are 2 options to choose from:

Option 1 is to use a subselect, your select statement will look like this.

select UserId, Column1, Column2
from Table1
where UserID IN (Select UserID FROM UserID_Table)

Option 2 is to create a function instead of a stored procedure to return the valid User ID's, your script would look like this.

CREATE FUNCTION dbo.func_Return_UserID ()
RETURNS TABLE AS
RETURN SELECT UserID FROM UserID_Table
GO

select UserId, Column1, Column2
from Table1
where UserID IN (Select UserID FROM dbo.func_Return_UserID ())

Regards,
K3n|||Eric1776,

There are 2 options to choose from:

Option 1 is to use a subselect, your select statement will look like this.

select UserId, Column1, Column2
from Table1
where UserID IN (Select UserID FROM UserID_Table)

Option 2 is to create a function instead of a stored procedure to return the valid User ID's, your script would look like this.

CREATE FUNCTION dbo.func_Return_UserID ()
RETURNS TABLE AS
RETURN SELECT UserID FROM UserID_Table
GO

select UserId, Column1, Column2
from Table1
where UserID IN (Select UserID FROM dbo.func_Return_UserID ())

Regards,
K3n
Is it possible to use Option 1 with a stored procedure instead of a select statement?|||CREATE TABLE #tmp_user_list ( UserID INT)

INSERT INTO #tmp_user_list(UserID)
EXEC proc_name

SELECT * FROM #tmp_user_list -- Test only

select UserId, Column1, Column2
from Table1
where UserID IN (Select UserID FROM #tmp_user_list)

DROP TABLE #tmp_user_list

The above is how I solved this type of problem in SQL 7.0

Tim S|||CREATE TABLE #tmp_user_list ( UserID INT)

INSERT INTO #tmp_user_list(UserID)
EXEC proc_name

SELECT * FROM #tmp_user_list -- Test only

select UserId, Column1, Column2
from Table1
where UserID IN (Select UserID FROM #tmp_user_list)

DROP TABLE #tmp_user_list

The above is how I solved this type of problem in SQL 7.0

Tim S

Thanks! I should have thought of that. :) Its working great now.

Needed: Feature chart by Reporting Services Edition

I will be grateful to anyone who can tell me where to find a clear,
comprehensive explanation of what features of Reporting Services are
available in which edition(s) of Reporting Services.
I'm using Reporting Services 2005.
After much searching/experimenting, I now know 2 things:
--A "scale-out deployment" is not supported in the Standard version
(this also appears to mean that the encryption keys are useless on
any but the original machine -- so disaster recovery is problematic)
--"Click through" reports, via Report Builder type reports, are not available
in the Standard version.
It certainly is a time-drain to discover and verify these things one at a
time.
Assistance would be greatly appreciated (and anticipated from Microsoft).
--Dana Forsberg
P.S. Among other things, I have looked around quite a bit starting from:
ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/rptsrvr9/html/b8d18d3d-9db0-43e7-8286-7b46cc3a37ed.htm
That seems a comprehensive "root" to a lot of resources -- but if there's a
feature chart by Edition, it has eluded me so far.I googled: reporting services features
First hit is this:
http://www.microsoft.com/sql/technologies/reporting/default.mspx
On this page is this link:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dana Forsberg" <DanaForsberg@.discussions.microsoft.com> wrote in message
news:4CE62965-65E6-41B6-9FE4-CF77EF49A7A2@.microsoft.com...
>I will be grateful to anyone who can tell me where to find a clear,
> comprehensive explanation of what features of Reporting Services are
> available in which edition(s) of Reporting Services.
> I'm using Reporting Services 2005.
> After much searching/experimenting, I now know 2 things:
> --A "scale-out deployment" is not supported in the Standard version
> (this also appears to mean that the encryption keys are useless on
> any but the original machine -- so disaster recovery is problematic)
> --"Click through" reports, via Report Builder type reports, are not
> available
> in the Standard version.
> It certainly is a time-drain to discover and verify these things one at a
> time.
> Assistance would be greatly appreciated (and anticipated from Microsoft).
> --Dana Forsberg
> P.S. Among other things, I have looked around quite a bit starting from:
> ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/rptsrvr9/html/b8d18d3d-9db0-43e7-8286-7b46cc3a37ed.htm
> That seems a comprehensive "root" to a lot of resources -- but if there's
> a
> feature chart by Edition, it has eluded me so far.
>|||Thank you for a very timely and on-target reply.
I really appreciate it.
And... is "Infinite Click-through" the same thing as "Click through reports"?
Actually, I just did a search and found out that it is -- but please pass on
a vote for a little "blurb" of explanation on feature charts, rather than the
austere case of only one or two words to guess from, identifying a given
feature.
Again, thanks very much for the reply.
"Bruce L-C [MVP]" wrote:
> I googled: reporting services features
> First hit is this:
> http://www.microsoft.com/sql/technologies/reporting/default.mspx
> On this page is this link:
> http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dana Forsberg" <DanaForsberg@.discussions.microsoft.com> wrote in message
> news:4CE62965-65E6-41B6-9FE4-CF77EF49A7A2@.microsoft.com...
> >I will be grateful to anyone who can tell me where to find a clear,
> > comprehensive explanation of what features of Reporting Services are
> > available in which edition(s) of Reporting Services.
> >
> > I'm using Reporting Services 2005.
> > After much searching/experimenting, I now know 2 things:
> > --A "scale-out deployment" is not supported in the Standard version
> > (this also appears to mean that the encryption keys are useless on
> > any but the original machine -- so disaster recovery is problematic)
> >
> > --"Click through" reports, via Report Builder type reports, are not
> > available
> > in the Standard version.
> >
> > It certainly is a time-drain to discover and verify these things one at a
> > time.
> >
> > Assistance would be greatly appreciated (and anticipated from Microsoft).
> >
> > --Dana Forsberg
> >
> > P.S. Among other things, I have looked around quite a bit starting from:
> > ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/rptsrvr9/html/b8d18d3d-9db0-43e7-8286-7b46cc3a37ed.htm
> >
> > That seems a comprehensive "root" to a lot of resources -- but if there's
> > a
> > feature chart by Edition, it has eluded me so far.
> >
>
>