If I log out will SQL Server still run?

Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
in as another user, and then log out and back in as the original user. Will
doing this cause the SQL Server to stop running (taking requests from
applications)?No, assuming it is running as a service.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"HB" <replywithingroup@.notreal.com> wrote in message
news:Lws7g.6122$yM.3355@.tornado.socal.rr.com...
> Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
> in as another user, and then log out and back in as the original user.
> Will doing this cause the SQL Server to stop running (taking requests from
> applications)?
>

If I log out will SQL Server still run?

Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
in as another user, and then log out and back in as the original user. Will
doing this cause the SQL Server to stop running (taking requests from
applications)?No, assuming it is running as a service.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"HB" <replywithingroup@.notreal.com> wrote in message
news:Lws7g.6122$yM.3355@.tornado.socal.rr.com...
> Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
> in as another user, and then log out and back in as the original user.
> Will doing this cause the SQL Server to stop running (taking requests from
> applications)?
>

IdentifyTranscation log name

Hi friends
I am trying to make a query to display dinamically the name of the
database's log.
I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
but i cant get an unique column to identify what is the name of the log
can anyone help me?
Thanks in advance
Try,
select
fileid,
[name],
[filename]
from
sysfiles
where
fileproperty([name], 'IsLogFile') = 1
go
AMB
"Tinchos" wrote:

> Hi friends
> I am trying to make a query to display dinamically the name of the
> database's log.
> I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
> but i cant get an unique column to identify what is the name of the log
> can anyone help me?
> Thanks in advance
>

IdentifyTranscation log name

Hi friends
I am trying to make a query to display dinamically the name of the
database's log.
I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
but i cant get an unique column to identify what is the name of the log
can anyone help me?
Thanks in advanceTry,
select
fileid,
[name],
[filename]
from
sysfiles
where
fileproperty([name], 'IsLogFile') = 1
go
AMB
"Tinchos" wrote:

> Hi friends
> I am trying to make a query to display dinamically the name of the
> database's log.
> I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
> but i cant get an unique column to identify what is the name of the log
> can anyone help me?
> Thanks in advance
>

IdentifyTranscation log name

Hi friends
I am trying to make a query to display dinamically the name of the
database's log.
I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
but i cant get an unique column to identify what is the name of the log
can anyone help me?
Thanks in advanceTry,
select
fileid,
[name],
[filename]
from
sysfiles
where
fileproperty([name], 'IsLogFile') = 1
go
AMB
"Tinchos" wrote:
> Hi friends
> I am trying to make a query to display dinamically the name of the
> database's log.
> I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
> but i cant get an unique column to identify what is the name of the log
> can anyone help me?
> Thanks in advance
>

Identifying the logical files before restoring database

We have a requirement to restore the relational database from a .bak file.
This .bak file can contain more than one data file and log file. How do we
programatically determine the logical files within this bak file and restore
accordingly.
I tried using 'Restore Filelistonly', but then here i am not able to capture
the names and location of back up file and store them in a variable which ca
n
be used while restoring.
Pls adviceHi
Create a table with the same number of columns and execure RESTORE
FILELISTONLY.
"GS" <GS@.discussions.microsoft.com> wrote in message
news:523C5E6A-5E5B-493B-BBE2-73A140DB3F01@.microsoft.com...
> We have a requirement to restore the relational database from a .bak file.
> This .bak file can contain more than one data file and log file. How do we
> programatically determine the logical files within this bak file and
> restore
> accordingly.
> I tried using 'Restore Filelistonly', but then here i am not able to
> capture
> the names and location of back up file and store them in a variable which
> can
> be used while restoring.
> Pls advice
>|||Sorry, I should be more specify
CREATE TABLE #Test
(
LogicalName VARCHAR(100),
PhysicalName VARCHAR(100),
Type VARCHAR(2),
FileGroupName VARCHAR(20),
[Size]VARCHAR(100),
[MaxSize] VARCHAR(100),
)
INSERT INTO #Test EXEC('
RESTORE FILELISTONLY FROM DISK=N''c:\backupsql\dbname.bak''')
SELECT * FROM #Test
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uDOs$0z7FHA.3200@.TK2MSFTNGP11.phx.gbl...
> Hi
> Create a table with the same number of columns and execure RESTORE
> FILELISTONLY.
>
> "GS" <GS@.discussions.microsoft.com> wrote in message
> news:523C5E6A-5E5B-493B-BBE2-73A140DB3F01@.microsoft.com...
>