Mapped drives

Hi,
Why new SS2005 doesn't see mapped drives anymore?
I use SS2005, SP1
Thanks in advance
Nikola MilicNikola Milic wrote:
> Hi,
> Why new SS2005 doesn't see mapped drives anymore?
> I use SS2005, SP1
> Thanks in advance
> Nikola Milic
>
>
Hi
I don't know if there're any difference in this compared to SS2000, but
the question is why do you want to see/use mapped drives? It's
recommenced to use UNC path rather than mapped drives.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator|||Steen Persson (DK) wrote:
> Nikola Milic wrote:
> > Hi,
> > Why new SS2005 doesn't see mapped drives anymore?
> >
> > I use SS2005, SP1
> >
> > Thanks in advance
> > Nikola Milic
> >
> >
> >
> Hi
> I don't know if there're any difference in this compared to SS2000, but
> the question is why do you want to see/use mapped drives? It's
> recommenced to use UNC path rather than mapped drives.
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator
If you mapp drives in SQL Server through xp_cmdshell using net use SQL
Server can see it.
Regards
Amish Shah|||Hi,
Take a look int below URL.
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
Thanks
Hari
SQL Server MVP
"Nikola Milic" <hotmnikola@.hotmail.com> wrote in message
news:OXpZooK0GHA.3440@.TK2MSFTNGP06.phx.gbl...
> Hi,
> Why new SS2005 doesn't see mapped drives anymore?
> I use SS2005, SP1
> Thanks in advance
> Nikola Milic
>|||Nikola Milic wrote:
> Hi,
> Why new SS2005 doesn't see mapped drives anymore?
> I use SS2005, SP1
> Thanks in advance
> Nikola Milic
>
The drive mappings must be created under within the profile of the user
that the SQL Server service is running under. In other words, if SQL is
running as "DOMAIN\SQLServiceUser", and you create the drive mappings
while logged in as "DOMAIN\MyPersonalUser", the mappings won't be usable
by SQL.
As Steen indicated, it is preferred and advised to use UNC path names,
and not drive mappings.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thank you all for help
And special thanks to Amish - that is what I wanted.
Nikola
"amish" <shahamishm@.gmail.com> wrote in message
news:1157450921.948672.98340@.h48g2000cwc.googlegroups.com...
If you mapp drives in SQL Server through xp_cmdshell using net use SQL
Server can see it.
Regards
Amish Shah

Many thanks in advance! - Simple Date function - Please Help!

Hi All,

Does anyone know how to return a date the sql query analyser like (Aug 2, 2004)

Right now, the following statement returns (Aug 2, 2004 8:40PM). This is now good because I need to do a specific date search that doesn't include the time.

Many thanks in advance!!
Brad

--------------
declare @.today DateTime
Select @.today = GetDate()
print @.todaylook at the Convert function...something like...

select convert(varchar, getdate(), 6)

|||Heres a tutorial that I thought was helpful
http://www.easerve.com/developer/tutorials/asp-net-tutorials-dates.aspx

Management Studio Settings?

I apologize in advance if these questions seem a bit simplistic, but I am
just starting out using the SQL 2005 Management Studio. Is there a way to
have windows that are opened up to restore back to their previous positions
and sizes? The Activity Monitor window is a good example - It always opens up
in the same size and position, no matter what I have done previously in it.
Are there sort order settings, too?
Jeff B (JeffB@.discussions.microsoft.com) writes:
> I apologize in advance if these questions seem a bit simplistic, but I
> am just starting out using the SQL 2005 Management Studio. Is there a
> way to have windows that are opened up to restore back to their previous
> positions and sizes? The Activity Monitor window is a good example - It
> always opens up in the same size and position, no matter what I have
> done previously in it. Are there sort order settings, too?
Not that I know. But it sounds like a good suggestion to submit on
http://lab.msdn.microsoft.com/produc.../default.aspx. Hey, I might
even vote for it!
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx