I don't remember...

Dear folks,
Could you please so kind to tell me where the fixed type data stored are? I
mean, in what system table are available these data?
"bigint, binary, float, decimal", and so on
Thanks in advance and regards,
Enricsystypes
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:0FEAE3E6-C6D8-400E-B210-F999DEBE6D17@.microsoft.com...
> Dear folks,
> Could you please so kind to tell me where the fixed type data stored are?
I
> mean, in what system table are available these data?
> "bigint, binary, float, decimal", and so on
> Thanks in advance and regards,
> Enric|||thanx
"Tibor Karaszi" wrote:

> systypes
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:0FEAE3E6-C6D8-400E-B210-F999DEBE6D17@.microsoft.com...
>
>

I don't remember my MSDE username

Hi,
I have my SAPWD="8letters" in setup file, but a can't do anything with
Command Prompt because my login name doesn't work. How can I find it, or
reset it ?
Regards,
J.Alberto
[ccs-ve]
Nota: no enviar mensajes a mi direccion e-mail,
solo spam. Avisar para asignarle un filtro y no sea
eliminado.
IF you forgot your SQL Server account PW, then try to login using Windows
Authentication.
"J.A." <josealbertoplus-nntp@.yahoo.com> wrote in message
news:Or7m8bMBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have my SAPWD="8letters" in setup file, but a can't do anything with
> Command Prompt because my login name doesn't work. How can I find it, or
> reset it ?
>
> Regards,
> --
> J.Alberto
> [ccs-ve]
> Nota: no enviar mensajes a mi direccion e-mail,
> solo spam. Avisar para asignarle un filtro y no sea
> eliminado.
>
sql

I don't remember how it was...

Using this system function (::fn_dblog(null,null)) you find out how many transactions are been confirmed in your .LDF. Although by means of another system function you can see further information, i mean statistical ones.

Any help would be very appreciated.

Hi,

how about this one here:

DBCC LOGINFO(db_id)

Select * from fn_dblog(null,null)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

I don't remember how it was...

Using this system function (::fn_log(null,null)) you can find out how many transactions have been confirmed in your .LDF. Although by means of another system function you can see further information, such as statitical.

Any help would be very appreciated.

Thanks

There isn't a function by that name. There's a similarly named undocumented and unsupported function (that I'm not going to discuss) for use during troubleshooting by Product Support and the product group.

What exactly are you trying to find out?

I don't remember how did I such thing...

Dear fellows,
I was wondering how it was for rename a database?
Thanks a lot for any input,
EnricOld way is sp_renamedb. As of SQL Server 2000, you can also (and preferred w
ay) ALTER DATABASE (see
Books Online for syntax).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:A10EAC4C-4AA0-4363-A17A-F62E8A66F0F3@.microsoft.com...
> Dear fellows,
> I was wondering how it was for rename a database?
>
> Thanks a lot for any input,
> Enric